<--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 (164543,169628) AND ur.satis_durumu=1 AND ur.marka_id in (5,1163,1218) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='34823') 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 (48365,82349,148660,154087,154092,154091,153242,157697,158177,158146,158143,157419,159229,157983,159798,164197,164545,164555,165255,165257,166828,167194,167195,167204,167182,167401,167402,167403,167656,167660,167186,168807,168808,168809,168810,168811,169273,169279,170495,172103,172101,172502,172503,172758,174003,174004,174005,174425,174423,174422,174564,176996,176992,176994,177635,177636,177637,177639,177638,174427,174428,177000,174431,174430,178955,178961,178965,179103,179100,179114,172097,167404,182241,183036,183011,184101,184103,184125,176993,185454,184102) AND ur.satis_durumu=1 AND ur.marka_id in (5,1163,1218) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='34823') 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 (161619,164186,164201,166817,168895,168892,169130,170844,174001,181532,181903,181811,177853,180650) AND ur.satis_durumu=1 AND ur.marka_id in (5,1163,1218) AND ur.temin_edilemiyor = 0 and ur.stok > 0 AND (ur.bayi_id='0' or ur.bayi_id='34823') 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;-->