(SELECT a.*, b.nom AS nom_plc2, b.loc AS loc_plc2, LOWER(b.pay) AS pay_plc2, b.email AS email_plc, c.nom AS nom_org, c.email AS email_org, lib_ as lib_pay, 0 AS nmb_dat
FROM concerts a
LEFT JOIN concerts_plc b ON (a.ref_plc = b.ref)
LEFT JOIN concerts_plc c ON (a.ref_org=c.ref)
LEFT JOIN pays d ON (b.pay = d.alpha_2)
WHERE (dat_fin IS NOT NULL OR fest IS NULL) AND dat_dbt >= DATE(NOW())
ORDER BY dat_dbt, art)
UNION
(SELECT MIN(a.dat_dbt) AS dat_dbt, NULL, a.fest, a.email_fest, a.cmm_fest, a.art, a.ref_plc, a.nom_plc, a.pay_plc, a.loc_plc, a.ref_org, a.tbc_org, a.inc_sold_out, a.inc_cancelled, b.nom AS nom_plc2, b.loc AS loc_plc2, LOWER(b.pay) AS pay_plc2, b.email AS email_plc, c.nom AS nom_org, c.email AS email_org, lib_ as lib_pay, COUNT(*) AS nmb_dat
FROM concerts a
LEFT JOIN concerts_plc b ON (a.ref_plc = b.ref)
LEFT JOIN concerts_plc c ON (a.ref_org=c.ref)
LEFT JOIN pays d ON (b.pay = d.alpha_2)
WHERE dat_fin IS NULL AND fest IS NOT NULL
GROUP BY fest
HAVING MIN(a.dat_dbt) >= DATE(NOW())
ORDER BY dat_dbt) ORDER BY 1,18
1054: Unknown column 'lib_' in 'field list'
