<--SELECT urun_ozellik_degerleri.sema_ozellik_id, urun_ozellik_degerleri.ozellik_adi, urun_ozellik_degerleri.degeri, urun_ozellik_degerleri.deger_id, COUNT(DISTINCT ur.id) AS adet FROM urun_ozellik_degerleri JOIN urunler ur ON ur.id = urun_ozellik_degerleri.urun_id and ur.id in (28966,28671,32951,48180,32097,23941,78523,78524,78526,78573,78527,78571,49509,30672,30628,50684,50683,50682,50681,50680,34141,34136,50858,49637,148150,149877,149880,149879,149878,46321,28204,28471,155173,155175,155172,156858,156852,157406,157405,157836,158520,159126,157802,159921,159920,159919,154892,78015,161432,162857,162858,165484,165788,166709,161417,151295,151294,151298,151303,151301,151302,172057,173712,177155,177153,177154,176964,180352,180077,180080,181424,181427,173496,184669,184660,151304,186504,186506,186507,186508,186509,186510,186515) AND ur.satis_durumu=1 AND ur.marka_id in (5,57,67) AND (ur.bayi_id='0' or ur.bayi_id='52473') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1819 where urun_ozellik_degerleri.tur = 2 and urun_ozellik_degerleri.ozellik_durum = 1 and urun_ozellik_degerleri.deger_durum = 1 GROUP BY urun_ozellik_degerleri.deger_id ORDER BY urun_ozellik_degerleri.ozellik_sira ASC , urun_ozellik_degerleri.deger_sira ASC;--> <--SELECT urun_ozellik_degerleri.sema_ozellik_id, urun_ozellik_degerleri.ozellik_adi, urun_ozellik_degerleri.degeri, urun_ozellik_degerleri.deger_id, COUNT(DISTINCT ur.id) AS adet FROM urun_ozellik_degerleri JOIN urunler ur ON ur.id = urun_ozellik_degerleri.urun_id and ur.id in (22493,9887,29366,29367,29368,49113,49111,23941,18914,10208,10217,31037,30634,30633,46631,58712,149877,149884,149883,149882,149881,149880,149879,149878,155944,155946,155947,155948,155952,155985,156796,156799,157406,157405,158520,159919,157407,157414,150070,155951,155950,155949,163056,163055,163057,151297,151299,151296,151300,174367,175406,175549,175407,175405,175404,175403,175402,175401,177155,177153,177154,175903,177487,177939,180076,180954,182116,185023,186510) AND ur.satis_durumu=1 AND ur.marka_id in (5,57,67) AND (ur.bayi_id='0' or ur.bayi_id='52473') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1819 where urun_ozellik_degerleri.tur = 2 and urun_ozellik_degerleri.ozellik_durum = 1 and urun_ozellik_degerleri.deger_durum = 1 GROUP BY urun_ozellik_degerleri.deger_id ORDER BY urun_ozellik_degerleri.ozellik_sira ASC , urun_ozellik_degerleri.deger_sira ASC;-->