SELECT 
cpf.name products_name,
(SELECT DISTINCT 
	cpet.value AS products_description  
	FROM 
		catalog_product_entity_text cpet,
		eav_attribute ea
	WHERE 
		cpet.attribute_id = ea.attribute_id
		AND ea.attribute_code='description'
		AND cpet.entity_type_id = 4
		AND (cpet.store_id = <@PREFIX> OR cpet.store_id = 0)
		AND entity_id = <@PRODUCTS_ID@>) AS products_description,
'std' name,
1 languages_id

FROM 
catalog_product_flat_<@PREFIX> cpf

where 
cpf.entity_id = <@PRODUCTS_ID@>
