SELECT DISTINCT
	'products_image' as org,
	cpemg.value as image

FROM 
	catalog_product_entity_media_gallery cpemg,
	catalog_product_entity_media_gallery_value cpemgv,
	catalog_product_flat_<@PREFIX@> cpf

WHERE 
	cpemgv.value_id = cpemg.value_id
	AND cpemgv.disabled = 0
	AND cpemgv.position = 1
	AND cpemg.`entity_id` = cpf.entity_id 
	AND cpf.entity_id = <@PRODUCTS_ID@>

	union

SELECT DISTINCT
	'small_image' as org,
	cpemg.value as image

FROM 
	catalog_product_entity_media_gallery cpemg,
	catalog_product_entity_media_gallery_value cpemgv,
	catalog_product_flat_<@PREFIX@> cpf

WHERE 
	cpemgv.value_id = cpemg.value_id
	AND cpemgv.disabled = 0
	AND cpemgv.position = 1
	AND cpemg.`entity_id` = cpf.entity_id 
	AND cpf.entity_id = <@PRODUCTS_ID@>
	