Не могу выполнить запрос!
Запрос: select min(price) as min_price, max(price) as max_price from ucms_store_products where id in (select prod_id from ucms_store_products_at_categories where cat_id in ()) and visible=1 and archived=0 and id in (select prod_id from ucms_store_products_at_domains where domain_id='2') and parent_id=0
Ошибка: 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 ')) and visible=1 and archived=0 and id in (select prod_id from ucms_store_' at line 1
Error in dbSmall query: select count(*) from ucms_store_products where id in (select prod_id from ucms_store_products_at_categories where cat_id in ()) and visible=1 and archived=0 and id in (select prod_id from ucms_store_products_at_domains where domain_id='2') and parent_id=0

Не могу выполнить запрос!
Запрос: select id, name, code, seo_name, short, is_exclusive, is_sale, is_new, img0, price, pricewholesale, pricepartner, old_price, stock, available, stock_supplier from ucms_store_products where id in (select prod_id from ucms_store_products_at_categories where cat_id in ()) and visible=1 and archived=0 and id in (select prod_id from ucms_store_products_at_domains where domain_id='2') and parent_id=0 order by available desc, stock_supplier desc, price, sorter limit 0, 30
Ошибка: 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 ')) and visible=1 and archived=0 and id in (select prod_id from ucms_store_p' at line 2 Аксесcуары для электроинструментов
+38 (093) 920 2799 +38 (050) 315 5305 +38 (097) 394 4548
перезвоните мне
г. Киев, 04112,
ул. Оранжерейная, 1
Пн—чт: 9:00—18:00
Пт: 9:00—18:00
Корзина
пустая