MySQL Error: 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 'as special LEFT JOIN products as prd ON prd.ID = special.PROD' at line 2
Query: SELECT COUNT(*) FROM as special LEFT JOIN products as prd ON prd.ID = special.PRODUCT_ID LEFT JOIN store_categories as cat ON substring_index(prd.CATS, ',', 1) = cat.ID WHERE prd.DISPLAY_NAME!=''