The Belgian magazine of Progressive Rock

Gigs Agenda

(SELECT a.dat_dbt, a.dat_fin, a.fest, a.email_fest, a.cmm_fest, concat(a.art,a.art2) AS art, a.rub, 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, 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, concat(a.art,a.art2) AS art, a.rub, 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 7,1,20 1054: Unknown column 'lib_' in 'field list'