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.options_id = AND p.status <> 0 AND c.categories_id like '%8047%' 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 'AND p.status <> 0 AND c.categories_id like '%8047%' GROUP BY p.products_id' at line 7