SELECT
  T1.F002 AS 'PRODUCTNAME',
  T1.F003 AS 'PRODUCTLINK',
  T2.F001 AS 'ID',
  T2.F003 AS 'MAJOR',
  T2.F004 AS 'MINOR',
  T2.F005 AS 'RELEASE',
  T2.F006 AS 'BUILD',
  T2.F007 AS 'OPTION',
  T2.F010 AS 'BRIEFING',
  T3.F002 AS 'PRODUCERNAME',
  T3.F003 AS 'PRODUCERLINK' 
FROM
  product_products AS T1, 
  product_products_versions AS T2, 
  product_producers AS T3, 
  product_categories_map AS T4 
WHERE 
  T2.F002 = T1.F001 
  AND 
  T1.F007 = T3.F001 
  AND 
  T1.F004 = 1 
  AND 
  T2.F001 = T4.F003 
  AND 
  T4.F002 = 4 
GROUP BY T1.F001 
ORDER BY T1.F002,T2.F001 
DESC LIMIT 0,10