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 = 4GROUP BY T1.F001 ORDER BY T1.F002,T2.F001 DESC LIMIT 0,10