SELECT COUNT(DISTINCT kod) FROM store_urun WHERE fiyat>0 AND tigNo LIKE '%%' AND sisNo LIKE '%%' AND metraj LIKE '%%' AND gramaj LIKE '%%' AND mevsim LIKE '%%' AND hammadde LIKE '%%' AND koleksiyonID LIKE '%%' AND markaID LIKE '%%' AND grupID = '2' AND indirim LIKE '%%' AND yeniler LIKE '%%' AND altkategoriID LIKE '%%' AND kategoriID LIKE '%%' AND durum='0' AND grupID<>''
SELECT COUNT(uid) FROM store_urun WHERE fiyat>0 AND tigNo LIKE '%%' AND sisNo LIKE '%%' AND metraj LIKE '%%' AND gramaj LIKE '%%' AND mevsim LIKE '%%' AND hammadde LIKE '%%' AND koleksiyonID LIKE '%%' AND markaID LIKE '%%' AND grupID = '2' AND indirim LIKE '%%' AND yeniler LIKE '%%' AND altkategoriID LIKE '%%' AND kategoriID LIKE '%%' AND durum='0' AND grupID<>''
SELECT store_urun.* FROM store_urun,store_altkategori WHERE store_urun.fiyat>0 AND store_urun.grupID LIKE '%2%' AND store_urun.altkategoriID LIKE '%%' AND store_urun.kategoriID LIKE '%%' AND store_urun.durum='0' AND store_urun.grupID<>'' AND store_urun.altkategoriID=store_altkategori.akid GROUP BY store_urun.kod ORDER BY store_altkategori.sira ASC, urunadi LIMIT 0,32
34<->32grup ID :<->2