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=15 OR product_categories.idCategory=19 OR product_categories.idCategory=20 OR product_categories.idCategory=21 OR product_categories.idCategory=22 OR product_categories.idCategory=220) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10SELECT 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=16 OR product_categories.idCategory=23 OR product_categories.idCategory=24 OR product_categories.idCategory=25 OR product_categories.idCategory=26) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10SELECT 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=17 OR product_categories.idCategory=27 OR product_categories.idCategory=28 OR product_categories.idCategory=29) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10SELECT 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=18 OR product_categories.idCategory=32 OR product_categories.idCategory=33 OR product_categories.idCategory=34) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10SELECT 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=38 OR product_categories.idCategory=221 OR product_categories.idCategory=222 OR product_categories.idCategory=223 OR product_categories.idCategory=224) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10SELECT 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=128 OR product_categories.idCategory=225 OR product_categories.idCategory=226 OR product_categories.idCategory=227) and product.id=product_categories.idProduct group by product.id order by product.mainPageOrderNumber asc limit 0,10 Aşkın Kırtasiye| Kitap &Kırtasiye
Whatsapp Destek Hattı x İletişime geçmek için hemen tıklayınız Tıklayınız
ALIŞVERİŞ SEPETİ
Sepetinize ürün eklemediniz
Toplam:
0.00 TL

YENİ GELENLER

Sınavlar

Sözlük-Atlas

YUKARI ÇIK