<--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 (23787,25152,25154,25497,26096,28809,27986,26142,25479,25468,25004,19387,29463,30747,25483,30800,30886,30887,30891,31740,31894,32083,32082,32714,33010,33011,33014,33354,34510,34517,33585,32000,33592,34667,33660,32647,33659,29847,29886,29952,29945,29944,33661,33663,33662,49106,44578,26083,48568,45812,50249,50951,51049,50553,77480,50342,48999,48569,48564,45701,48091,33568,78496,77729,50793,48057,49512,78844,78845,79486,77945,79965,80046,80011,80139,147979,148024,148452,150276,148023,151816,152088,78472,82143,150343,32077,77719,78595,152086,152090,82144,22433,33270,77724,151236,150240,152748,150563,148376,80713,80138,25155,30778,156473,78234,157076,154494,152904,81625,50325,31999,24337,150063,156887,154517,157513,157180,157054,152745,82145,163252,162084,161990,157430,157138,156468,155927,155926,155925,154691,154690,154689,152103,150547,150546,148380,148378,77481,47931,47878,45180,32551,155558,150239,152828,163573,164290,164291,150238,164292,156472,165748,165787,166023,163250,167415,168189,49099,169535,155496,169047,172249,172238,168459,156471,179999,180633) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,247,254) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='52473') 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 (171843,171844,171888,172135,173966,173717,177955,168227) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,247,254) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='52473') 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;-->