MySQL error Unknown column 'shop.php' in 'where clause': Unknown column 'shop.php' in 'where clause'
When executing:
SELECT * FROM ( stiva_sc_products AS p LEFT JOIN stiva_sc_product_images AS pi ON p.products_id = pi.products_id AND `pi`.`is_main_image` = 1 ) LEFT JOIN stiva_sc_categories AS c ON p.categories_id = c.categories_id WHERE p.status <> 0 AND p.categories_id IN(shop.php,1,2,3,4,5,6,7) GROUP BY p.products_id