SELECT p.id, p.akc, p.timeakc, p.url, p.brand_id, p.name, p.annotation, p.body, p.position, p.galochka, p.available, p.created as created, p.visible, p.featured, p.meta_title, p.meta_keywords, p.meta_description, b.name as brand, b.url as brand_url FROM __products p INNER JOIN s_products_categories pc ON pc.product_id = p.id AND pc.category_id in('24','22','25','38') LEFT JOIN __brands b ON p.brand_id = b.id WHERE 1 AND p.visible=1 GROUP BY p.id ORDER BY p.position DESC LIMIT 0, 24 Текстиль
+7 499 967-78-67
Заказать обратный звонок
Нет покупок :(

Текстиль

Хиты продаж Новинки
SELECT p.id, p.akc, p.timeakc, p.url, p.brand_id, p.name, p.annotation, p.body, p.position, p.galochka, p.available, p.created as created, p.visible, p.featured, p.meta_title, p.meta_keywords, p.meta_description, b.name as brand, b.url as brand_url FROM __products p INNER JOIN s_products_categories pc ON pc.product_id = p.id AND pc.category_id in('24,22,25') LEFT JOIN __brands b ON p.brand_id = b.id WHERE 1 AND p.featured=1 AND (SELECT count(*)>0 FROM s_variants pv WHERE pv.product_id=p.id AND pv.price>0 AND (pv.stock IS NULL OR pv.stock>0) LIMIT 1) = 1 AND p.visible=1 GROUP BY p.id ORDER BY p.position DESC LIMIT 0, 10
Warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ORDER BY f.position' at line 4 in /home/donson/donson.su/www/api/Database.php on line 136

Товары которые Вы смотрели