MUSIC IN UK *
🇬🇧INFORMACIÓN GENERAL | |
| Nombre del país: | REINO UNIDO |
|---|---|
| Capital: | Londres |
| Contiente: | Europa |
| Lenguaje: | Inglés (*IDIOMA del titulo) |
MÚSICA EN REINO UNIDO
A continuación un especial recorrido musical a través de conciertos, bandas y festivales de REINO UNIDO 🇬🇧
Error en la base de datos de WordPress: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<?php echo city_es; ?> ASC,
e.date ASC,
e.id_event ASC' at line 46]
SELECT
e.id_concert,
e.id_bandtour,
e.date,
e.date_text_ES,
e.date_text_EN,
e.venue_name,
e.city AS concert_city,
e.id_city AS concert_city_id,
e.id_country AS concert_country_id,
/* band */
p.band,
p.genre,
p.logo,
p.color AS band_color,
p.id_country AS band_country_id,
/* PAÍS DE PROCEDENCIA DEL band */
c.name_es AS band_country_name,
c.flag AS band_country_flag,
/* CIUDAD DEL concert */
ci.city_es AS concert_city_name
FROM concertz AS e
/* band relacionado con el concert */
INNER JOIN bandz_tourz AS p
ON p.id_bandtour = e.id_bandtour
/* País DE PROCEDENCIA DEL band */
LEFT JOIN countriez AS c
ON c.id_country = p.id_country
/* CIUDAD DEL concert:
IMPORTANTE: sale de concerts.id_city */
LEFT JOIN citiez AS ci
ON ci.id_city = e.id_city
WHERE
e.id_country = 3
AND DATE(e.date) = '2026-08-31'
ORDER BY
ci.<?php echo city_es; ?> ASC,
e.date ASC,
e.id_event ASC