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