SELECT * FROM store_urun WHERE hangidil LIKE '%tr%' and outlet=0 AND mevsim LIKE '%%' AND (hammadde LIKE '%%' ) AND grupID=3 AND indirim LIKE '%%' AND yeniler LIKE '%%' AND altkategoriID LIKE '%%' AND store_urun.kategoriID LIKE '%50%' AND durum='0' AND stokdurum>=0 AND grupID<>'' GROUP BY kod ORDER BY uid DESC, urunadi LIMIT 24,24