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_num AS pr
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 c.publ_ref = 'PR' AND c.publ_num<=52
ORDER BY a.nom, b.ann, b.tit, c.publ_ref, c.publ_num
1054: Unknown column 'lib_' in 'field list'
