SELECT 
<@PREFIX>products_description.products_name ,
<@PREFIX>products_description.products_description,
<@PREFIX>languages.name,
<@PREFIX>languages.languages_id
FROM <@PREFIX>products_description , 
<@PREFIX>languages where <@PREFIX>products_description.language_id = <@PREFIX>languages.languages_id 
and <@PREFIX>products_description.products_id = <@PRODUCTS_ID@>

