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
,demand_range_content.visibility AS collection_visibility
,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
,vi.file_name AS variant_file_name -- << here
FROM
products
LEFT JOIN content
ON products.product_id=content.product_id
AND content.site_id='6'
AND content.visibility='1'
AND 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
LEFT JOIN content AS demand_range_content
ON products.main_demand_range_id=demand_range_content.range_id
AND demand_range_content.site_id='6'
LEFT JOIN (
SELECT
variant_id,
SUBSTRING_INDEX(
GROUP_CONCAT(file_name ORDER BY sort_order ASC, file_name ASC),
',', 1
) AS file_name
FROM variant_images
WHERE deleted_at IS NULL
GROUP BY variant_id
) vi ON products.default_variant_id = vi.variant_id
WHERE products.product_id IN ()
AND products.product_status > '0'
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 ')
AND products.product_status > '0'
GROUP BY products.product_id
' at line 62
