SELECT proddesc.value products_description , proddesc.language_id languages_id FROM <@PREFIX@>vm_product pr 
left join <@PREFIX@>jf_content proddesc on proddesc.reference_id = pr.product_id and proddesc.reference_table='vm_product' and proddesc.reference_field = 'product_s_desc'  
where proddesc.reference_id = <@KEY@> 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:%' ## )
and pr.product_id =<@KEY@>


