SELECT t1.id,t1.groupid,t1.slug,t1.sale,t1.namege,t1.code,t1.price,t1.sprice,t1.brand,min(t1.price) as 'min',max(t1.price) as 'max',t5.namege as 'gname',
(SELECT img FROM brands as t3 WHERE t3.id=t1.brand) as 'bran',
(SELECT slug FROM productgroups as t5 WHERE t5.id=t1.groupid) as 'groupslug',
(SELECT enddate FROM sale as t4 WHERE t4.code=t1.code) as 'enddate',
(SELECT AVG(star) FROM reviews as t2 WHERE t1.id=t2.pid) as 'star'
FROM products as t1
LEFT JOIN productgroups as t5 ON(t1.groupid=t5.id)
LEFT JOIN subcodes as t7 ON(t1.finaid=t7.pid)
WHERE t1.id>0 AND t1.active=1 AND t1.instock>0 AND (style='3') AND !(t1.brand=23 AND t1.category='147') AND !(t1.brand=32 AND t1.category='141') AND t1.brand<>29 GROUP BY t1.groupid ORDER BY t1.id DESC LIMIT 20 OFFSET 0