SELECT a.nom AS art,tit,(select lib from dom_valeurs where dom='rub' and cle=b.rub) AS rub
,LOWER(pay) AS pay,lib_ as lib_pay,indisp
FROM titres b
INNER JOIN artistes a ON b.ref_art=a.ref
INNER JOIN titres_publ c ON c.ref_tit=b.ref
LEFT JOIN pays d ON d.alpha_2=a.pay
WHERE c.publ_ref = 'PR' AND c.publ_num=5
ORDER BY a.nom, b.ann, b.tit
1054: Unknown column 'lib_' in 'field list'