SELECT if(prodname.value is null,pr.product_name,prodname.value) products_name , if(proddesc.value is null,pr.product_desc,proddesc.value)  products_description 
,  if(prodname.language_id is null,proddesc.language_id,prodname.language_id)  languages_id FROM <@PREFIX>vm_product pr left join 
 <@PREFIX>jf_content prodname on prodname.reference_id = pr.product_id  and prodname.reference_table='vm_product' and prodname.reference_field = 'product_name' 
and prodname.reference_id = <@PRODUCTS_ID@> and prodname.language_id in (<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## )

left join <@PREFIX>jf_content proddesc on proddesc.reference_id = pr.product_id and proddesc.language_id = prodname.language_id and proddesc.reference_table='vm_product' and proddesc.reference_field = 'product_desc'  
and proddesc.reference_id = <@PRODUCTS_ID@> and proddesc.language_id in (<@PROCESS@>*SELECT substring(a.imp_EXTID from 6 for 10) a from IMP_LINK a
join IMP_SOURCE_LANGS b on b.WLANGID = a.WGROUPID and b.IMP_SOURCEID = <@SOURCEID@>
where a.imp_sourceid = <@SOURCEID@> and WGroupid is not null and IMP_EXTID like 'LANG:%' ## )
where  pr.product_id =<@PRODUCTS_ID@>


