select products.*, product_language.* from products
inner join applications on applications.cod = products.cod_application
inner join product_language on products.id = product_language.id_product
where product_language.id_language = ID_LANGUAGE
and applications.id_language = ID_LANGUAGE