SELECT a.ref AS ref_art,b.ref AS ref_tit,a.nom AS art,b.tit,LOWER(a.pay) AS pay,lib_ as lib_pay,publ_ref,publ_num FROM titres b LEFT JOIN artistes a ON a.ref = b.ref_art LEFT JOIN titres_publ c ON b.ref = c.ref_tit LEFT JOIN pays ON pay = alpha_2 WHERE a.nom LIKE 'A%' AND publ_ref='PR' AND c.inc_del='N' ORDER BY a.nom, b.ann, b.tit, c.publ_ref, c.publ_num 1054: Unknown column 'lib_' in 'field list'