Query:
SELECT
products.product_id
,products.product_name
,products.base_sell_price
,products.base_list_price
,products.base_price_mode
,products.product_prefix
,products.product_root
,products.product_suffix
,products.product_status
,products.main_demand_range_id
,ranges.range_name AS collection_name
,ranges.range_prefix AS collection_prefix
,ranges.range_root AS collection_root
,ranges.range_suffix AS collection_suffix
,demand_range_content.flat_url AS collection_link
,assets.asset_name
,assets.asset_id
,products.product_message
,content.content_id
,content.flat_url
,products.stock_message_id
,products.default_variant_id
,products.colours_json
,product_range.range_ids
,products.revenue
FROM
products
LEFT JOIN
content
ON products.product_id=content.product_id && content.site_id='6' && content.visibility='1' && content.content_type='2'
LEFT JOIN
images
ON products.image_id=images.image_id
LEFT JOIN
assets
ON images.asset_id=assets.asset_id
LEFT JOIN
(SELECT product_id,GROUP_CONCAT(range_id) AS range_ids FROM product_range GROUP BY product_id) AS product_range
ON products.product_id=product_range.product_id
LEFT JOIN
ranges
ON products.main_demand_range_id=ranges.range_id && content.site_id='6' && content.visibility='1'
LEFT JOIN
content AS demand_range_content
ON products.main_demand_range_id=demand_range_content.range_id && demand_range_content.site_id='6'
WHERE products.product_id IN () && products.product_status='1'
GROUP BY products.product_id ORDER BY FIELD(products.product_id,)
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 ') && products.product_status='1'
GROUP BY products.product_id ORDER BY FIELD' at line 52
