SELECT `name_en-US` products_name,
 `description_en-US` products_description, 
`name_en-US` name, b.id languages_id 
FROM <@PREFIX>jshopping_products join <@PREFIX>jshopping_languages b on b.language = 'en-US'
 where product_id = <@PRODUCTS_ID@>  and `name_en-US` <> ''
 union 

SELECT `name_nl-NL`   , 
 `description_nl-NL`  , 
`name_nl-NL`  , b.id   
FROM <@PREFIX>jshopping_products join <@PREFIX>jshopping_languages b on b.language = 'nl-NL'
 where product_id = <@PRODUCTS_ID@>  and `name_nl-NL` <> ''
 union 

SELECT `name_en-GB`   , 
 `description_en-GB` p , 
`name_en-GB`  , b.id   
FROM <@PREFIX>jshopping_products join <@PREFIX>jshopping_languages b on b.language = 'en-GB'
 where product_id = <@PRODUCTS_ID@>  and `name_en-GB` <> '' 