Не могу выполнить запрос!
Запрос: 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 MariaDB 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 stock desc, 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 MariaDB 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 Блоки питания для планшетов HUAWEI
+38 (044) 338 60 01 +38 (050) 418 19 20 +38 (093) 533 23 91
перезвоните мне
Корзина
пустая
г. Киев, 04073,
ул. Семена Скляренко, 9
Пн—Пт: 9:00—18:00
Сб--Вс: Выходной