<--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 (21304,19661,19658,19653,19401,19400,19399,19398,19397,19395,19396,19392,17943,14842,13123,22890,22895,22961,22970,22973,22974,22975,23025,24674,27476,30487,30488,30491,32572,32668,34261,30490,30480,15346,35732,18884,18885,28287,20376,30492,35733,30486,22695,48417,21622,32573,30481,30482,45259,148798,148797,48158,149652,149653,153291,153292,149499,154340,154339,154373,154460,155134,52714,155518,155519,153734,153733,153572,158854,158855,158857,158858,160593,161457,161456,162778,162779,163835,163836,163837,163839,186745,186747,186753,186751,186748,186749,186750,186754) AND ur.satis_durumu=1 AND ur.marka_id in (5,16,57,147549,88) AND (ur.bayi_id='0' or ur.bayi_id='52473') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2162 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 (19399,19396,17943,13123,22878,22890,22973,22974,23025,23707,29776,30487,32667,32668,34261,30480,35732,18884,32569,50556,23137,20376,30492,24306,35783,50555,28973,32573,30483,33903,81656,149652,149654,150530,153349,149499,154340,52714,155518,155908,161294,163835,186745,186755,186750) AND ur.satis_durumu=1 AND ur.marka_id in (5,16,57,147549,88) AND (ur.bayi_id='0' or ur.bayi_id='52473') JOIN urun_kategorileri uk ON ur.id = uk.urun_id and uk.kategori_id = 2162 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;-->