SELECT pl.name as product_name, ...... LEFT JOIN w5kn_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang = so.id_lang)
SELECT pl.name as product_name, ...... LEFT JOIN w5kn_product_lang pl ON (pl.id_product = p.id_product AND pl.id_lang = so.id_lang)
LEFT JOIN w5kn_product_lang pl ON ( pl.id_product = p.id_product AND pl.id_lang = so.id_lang)