SELECT 	  p.product_id
	, p.product_sku
	, p.product_desc
	, p.product_full_image
	, p.product_weight
	, p.product_in_stock
	, p.product_discount_id
	, p.product_name AS product_name_ru
	, p.attribute
	, l.language_id
	, l.reference_table
	, l.reference_field
	, l.value AS value_lv
	, a.file_url
	, c.product_price
	, d.amount AS discount
	, d.start_date
	, d.end_date
	, ci.category_id
	, ci.category_name AS category_name_ru
	, ci.category_description AS category_description_ru
	, ci.category_full_image
FROM `jos_vm_product` p 

LEFT JOIN `jos_jf_content` l ON p.product_id = l.reference_id AND l.reference_table = 'vm_product' 
LEFT JOIN `jos_vm_product_files` a ON p.product_id = a.file_product_id 
--  (ТУТ ID не уникален и может быть выбрано 2 и более записи, 
--   ВОПРОС КАК мне сделать чтоб он их слепил в одну строку все, а не плодил новый ROW)

LEFT JOIN `jos_vm_product_price` c ON p.product_id = c.product_id AND c.product_currency = 'EUR' 
LEFT JOIN `jos_vm_product_discount` d ON p.product_discount_id = d.discount_id 
LEFT JOIN `jos_vm_product_category_xref` ch ON p.product_id = ch.product_id 
LEFT JOIN `jos_vm_category` ci ON ch.category_id = ci.category_id