<--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 (28728,32722,34510,35825,35819,48561,77394,77480,48091,47604,78268,50793,77414,148452,149011,151747,32077,150563,81625,160250,154911,163252,163072,162333,156994,156322,155561,155558,154778,154777,154774,154425,154424,154423,153601,153600,153599,153598,152314,152313,152312,150652,149578,148604,148231,148230,82552,77586,163497,163556,163827,164231,164229,164228,164309,164459,164830,164831,164232,166135,166340,166341,166288,166299,163071,167850,164227,168189,169084,169085,176434,176433,172299,182265,182266,182264,160598,180953,184589,184583,185173,176438) AND ur.satis_durumu=1 AND ur.marka_id in (5,118365,578,254) AND (ur.bayi_id='0' or ur.bayi_id='53060') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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 (156043,164230,163283,161506,155792,155108,162287,155502,168313,168405,167143,168899,169166,173927,173932,156042,174980,173754,163845,176523,167144,173100,178158,174902,181390,178698,181391) AND ur.satis_durumu=1 AND ur.marka_id in (5,118365,578,254) AND (ur.bayi_id='0' or ur.bayi_id='53060') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1810 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;-->