SELECT F001 AS 'ID', F002 AS 'NAME', F003 AS 'LINK' FROM `product_categories` WHERE F004 = 1 AND F003 = 'kategori-1' LIMIT 11 SELECT T98.F002 AS 'PRODUCTNAME', T98.F003 AS 'PRODUCTLINK', T99.F001 AS 'ID', T99.F003 AS 'MAJOR', T99.F004 AS 'MINOR', T99.F005 AS 'RELEASE', T99.F006 AS 'BUILD', T99.F007 AS 'OPTION', T99.F010 AS 'BRIEFING', T97.F002 AS 'PRODUCERNAME', T97.F003 AS 'PRODUCERLINK', T97.F004 AS 'PRODUCERHOME', (SELECT GROUP_CONCAT(T1.F002) FROM product_categories AS T1, product_categories_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS CATEGORIES, (SELECT GROUP_CONCAT(T1.F003) FROM product_categories AS T1, product_categories_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS CATEGORIESURL, (SELECT GROUP_CONCAT(T1.F002) FROM product_compatibility AS T1, product_compatibility_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS COMPATIBILITIES, (SELECT GROUP_CONCAT(T1.F003) FROM product_compatibility AS T1, product_compatibility_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS COMPATIBILITIESURL, (SELECT GROUP_CONCAT(T1.F002) FROM product_licencetypes AS T1, product_compatibility_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS LICENCETYPES, (SELECT GROUP_CONCAT(T1.F003) FROM product_licencetypes AS T1, product_compatibility_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS LICENCETYPESURL, (SELECT GROUP_CONCAT(T1.F002) FROM product_sourcetypes AS T1, product_sourcetypes_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS SOURCETYPES, (SELECT GROUP_CONCAT(T1.F003) FROM product_sourcetypes AS T1, product_sourcetypes_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS SOURCETYPESURL, (SELECT GROUP_CONCAT(T1.F002) FROM product_tags AS T1, product_tags_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS TAGS, (SELECT GROUP_CONCAT(T1.F003) FROM product_tags AS T1, product_tags_map AS T2 WHERE T1.F001 = T2.F002 AND T99.F001 = T2.F003) AS TAGSURL FROM product_producers AS T97, product_products AS T98, (SELECT * FROM product_products_versions ORDER BY F001 DESC) AS T99, `product_categories_map` AS T96 WHERE T99.F002 = T98.F001 AND T98.F007 = T97.F001 AND T98.F004 = 1 AND T99.F001 = T96.F003 AND T96.F002 = 1 GROUP BY T98.F001 ORDER BY T98.F006 DESC LIMIT 0,10