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 like concat('%', 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,
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