Sportrix - интернет магазин спортивного питания в Ярославле

Статьи


Наши партнеры


Ошибка при получении информации!

Запрос:
SELECT cms_shop_groups.name as group_name,cms_shop_groups.alias as group_alias, cms_shop_products.price, cms_shop_products.full_price, cms_shop_products.name as product_name,cms_shop_products.alias as product_alias, cms_shop_products.publish as publish, cms_shop_products.nalichie as nalichie FROM cms_shop_products_manufacturer INNER JOIN cms_shop_products ON cms_shop_products_manufacturer.child_id = cms_shop_products.id INNER JOIN cms_shop_products_groups ON cms_shop_products_groups.child_id = cms_shop_products.id INNER JOIN cms_shop_groups ON cms_shop_products_groups.parent_id = cms_shop_groups.id WHERE cms_shop_products.deleted=0 and cms_shop_groups.deleted=0 and cms_shop_products_manufacturer.parent_id= and cms_shop_products.nalichie>0 ORDER BY cms_shop_products_manufacturer.parent_id, cms_shop_products.name
Сообщение об ошибке:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'and cms_shop_products.nalichie>0 ORDER BY cms_shop_products_manufacturer.parent_' at line 1