Could not execute SQL query:
SELECT p.*, pi.filename, pav.price, MIN(pav.price) AS min_price, c.category_title FROM ( ( stiva_sc_products AS p LEFT JOIN stiva_sc_product_images AS pi ON p.products_id = pi.products_id ) LEFT JOIN stiva_sc_product_attribute_values AS pav ON p.products_id = pav.products_id ) LEFT JOIN stiva_sc_categories AS c ON p.categories_id = c.categories_id WHERE p.status <> 0 AND p.products_id IN () GROUP BY p.products_id ORDER BY p.featured DESC, p.order_id ASC LIMIT 0, 8
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 ') GROUP BY p.products_id' at line 7