Query: 
		SELECT
		   
		   products.product_id
		  ,products.product_name
		  ,products.product_details
		  ,products.base_sell_price
		  ,products.base_list_price
		  ,products.base_package_price
		  ,products.base_trade_price
		  ,products.base_promotional_price
		  ,products.base_price_mode
		  ,products.base_clearance_price
		  ,products.product_prefix
		  ,products.product_root
		  ,products.product_suffix
	      ,images.image_title
		  ,assets.asset_name
		  ,assets.asset_id
		  ,products.product_message
		  ,content.content_id
		  ,content.flat_url
		  ,content.page_title AS heading
		  ,products.stock_message_id
		  ,products.catalog_mode

		 
		  ,GROUP_CONCAT(tags_related.tag_id) AS tag_ids 
		
		FROM
		
		products
			LEFT JOIN
		content
			ON products.product_id=content.product_id
			LEFT JOIN
		images
			ON products.image_id=images.image_id
			LEFT JOIN
		assets
			ON images.asset_id=assets.asset_id
			LEFT JOIN
		tags_related
			ON products.product_id=tags_related.product_id
		WHERE products.product_id IN () && content.site_id='1' && content.visibility='1' && content.content_type='2'
		GROUP BY products.product_id ORDER BY FIELD(products.product_id,) 
<br />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 ') && content.site_id='1' && content.visibility='1' && content.content_type='2'
' at line 44