<--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 (158141,158140,159797,164549,166091,166268,169274,169272,168588,170905,170924,170923,170922,172759,177086,177196,174432,177003,177001,179101,170925,184104) AND ur.satis_durumu=1 AND ur.marka_id in (5,1182,821,147549,432,1381604) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='62646') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1750 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 (11607,1226,22018,22225,22264,22266,3493,3492,3490,22818,22819,22820,22821,21052,30332,30903,30904,31789,31998,31997,32434,33694,33693,11104,49328,50699,77178,77388,78086,78201,35802,49331,49330,48863,49326,48861,48960,30750,11105,11432,26831,79854,49597,48395,148281,148478,80410,28413,22429,26167,12380,81779,150879,28412,148803,26169,77385,22037,148804,78877,149917,49324,35806,78202,78885,78886,150781,150782,151727,151728,151729,150790,152970,153095,150766,153501,153646,153647,14928,154927,154922,153173,155738,155773,155772,156110,156112,158138,158136,158130,158075,153523,79548,150783,81374,52732,158630,159044,159043,159827,159828,159165,159457,159164,159458,161076,161165,161285,161473,161472,161772,161164,162542,162546,162549,162550,162676,163205,164172,164173,80992,164188,164195,164203,164186,164185,164201,164190,48862,78605,165049,165610,148805,166805,166806,166807,166808,166809,166799,168151,77181,168895,168896,168897,169130,150788,170768,170916,170917,172228,173133,174001,174003,174004,173132,169766,174584,174583,174585,174586,176437,158162,177058,177059,177851,177848,177849,178957,178956,177852,181154,181153,179796,181532,181534,181903,181809,181902,181807,181814,177853,176436,180651,180652,180649,180650,183332,30755,183712,186728,187057,187223,186437,187602,187796,187795) AND ur.satis_durumu=1 AND ur.marka_id in (5,1182,821,147549,432,1381604) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='62646') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 1750 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;-->