USD: 41,5850 TL
Tüm Ürünler
Üye Girişi
Üye Ol
Sepetim 0 Sepetiniz Boş

Sepetinizde Ürün Bulunamadı

<--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 (82145,176877,177857,178701,177249,182446,182447,182519,182520,180915,180938,185164,185165,184117) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,247) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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 (23433,23787,25469,25470,25473,25481,25483,49580,26974,27050,28808,30063,30817,30891,31740,31741,31894,32083,32082,32076,32174,33269,34516,34517,31700,31594,31592,31593,33586,32133,30030,30029,30028,34674,30998,33592,34514,34667,32228,33272,30040,34945,35050,35799,33596,49105,48387,77480,50342,48569,48870,77732,30092,81386,148229,78578,151747,152089,34947,34946,77736,22433,33270,25155,158772,157076,157055,156041,155570,155510,155509,155475,150063,156887,154517,159063,159060,155881,156040,161248,160175,161743,160891,158033,35850,150821,162334,162084,162083,161990,161988,161933,161200,161149,160213,158488,158447,157494,157320,156470,156469,155926,155925,154688,152103,152556,32551,155560,163567,157970,163827,164289,164231,164460,164830,165748,164232,161506,155792,167206,168189,168313,168405,168406,155497,169437,169084,170092,170091,168744,169047,169085,172265,173756,173927,173932,173957,157981,175378,175377,176304,176126,176523,177138,173100,178158,172299,169086,178302,180829,180828,181780,181782,181686,178170,180953,184916,185557,181390,178698,181391) AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,247) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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 () AND ur.satis_durumu=1 AND ur.marka_id in (5,256,578,247) AND (ur.bayi_id='0' or ur.bayi_id='4631') 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;-->