SELECT t1.name, GROUP_CONCAT(t1.value SEPARATOR ',') as 'elems', (SELECT t2.header FROM additionalfields as t2 WHERE t2.name=t1.name AND t2.mid=t1.mid ORDER BY id DESC LIMIT 1) as 'fname' FROM productsmeta as t1 WHERE t1.id>0 AND t1.finaid IN (SELECT t11.finaid FROM products as t11 LEFT JOIN subcodes as t7 ON(t11.finaid=t7.pid AND t11.mid=t7.mid) WHERE t11.id>0 AND t11.active=1 AND t11.instock>0 AND t11.mid=t1.mid AND FIND_IN_SET(category,'34,94,95,96,98,99,102,127,174') AND !(t11.brand=23 AND t11.category='147') AND !(t11.brand=32 AND t11.category='141') AND t11.brand<>29 GROUP BY t11.groupid) AND finaid IN(SELECT t12.finaid FROM products as t12 WHERE t12.id>0 AND t12.active=1 AND t12.instock>0 AND t12.mid=t1.mid AND FIND_IN_SET(category,'34,94,95,96,98,99,102,127,174')) AND t1.active='1' AND t1.mid=0 GROUP BY t1.field