SELECT product.*,(select categoryName from category where category.id=product.idProductCategory) as categoryName, (select permalink from category where category.id=product.idProductCategory) as categoryPermalink,(select brandName from brands where brands.id=product.idBrand) as brandName FROM product,product_categories where active=1 and (product_categories.idCategory=9 OR product_categories.idCategory=14 OR product_categories.idCategory=16 OR product_categories.idCategory=18 OR product_categories.idCategory=19 OR product_categories.idCategory=20 OR product_categories.idCategory=21 OR product_categories.idCategory=28 OR product_categories.idCategory=29 OR product_categories.idCategory=30 OR product_categories.idCategory=31 OR product_categories.idCategory=32 OR product_categories.idCategory=33 OR product_categories.idCategory=34 OR product_categories.idCategory=35 OR product_categories.idCategory=36 OR product_categories.idCategory=37 OR product_categories.idCategory=38 OR product_categories.idCategory=41 OR product_categories.idCategory=44 OR product_categories.idCategory=46 OR product_categories.idCategory=50 OR product_categories.idCategory=51 OR product_categories.idCategory=52 OR product_categories.idCategory=54 OR product_categories.idCategory=55 OR product_categories.idCategory=60 OR product_categories.idCategory=63 OR product_categories.idCategory=64 OR product_categories.idCategory=65 OR product_categories.idCategory=66 OR product_categories.idCategory=67 OR product_categories.idCategory=68 OR product_categories.idCategory=70 OR product_categories.idCategory=72 OR product_categories.idCategory=92 OR product_categories.idCategory=93 OR product_categories.idCategory=94 OR product_categories.idCategory=96 OR product_categories.idCategory=97 OR product_categories.idCategory=102 OR product_categories.idCategory=103 OR product_categories.idCategory=104 OR product_categories.idCategory=106 OR product_categories.idCategory=107 OR product_categories.idCategory=110 OR product_categories.idCategory=111 OR product_categories.idCategory=112 OR product_categories.idCategory=113 OR product_categories.idCategory=114 OR product_categories.idCategory=116 OR product_categories.idCategory=117 OR product_categories.idCategory=118 OR product_categories.idCategory=119 OR product_categories.idCategory=120 OR product_categories.idCategory=121 OR product_categories.idCategory=122 OR product_categories.idCategory=123 OR product_categories.idCategory=125 OR product_categories.idCategory=71 OR product_categories.idCategory=73 OR product_categories.idCategory=75 OR product_categories.idCategory=76 OR product_categories.idCategory=77 OR product_categories.idCategory=78 OR product_categories.idCategory=79 OR product_categories.idCategory=80 OR product_categories.idCategory=81 OR product_categories.idCategory=82 OR product_categories.idCategory=83 OR product_categories.idCategory=84 OR product_categories.idCategory=85 OR product_categories.idCategory=86 OR product_categories.idCategory=87 OR product_categories.idCategory=88 OR product_categories.idCategory=89 OR product_categories.idCategory=90 OR product_categories.idCategory=91 OR product_categories.idCategory=95) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10 gercekcopycevdet
Whatsapp Destek Hattı x İletişime geçmek için hemen tıklayınız Tıklayınız

ÇOK SATANLAR

YENİ GELENLER

YUKARI ÇIK