EPalco
SELECT tipos_entradas.* FROM tipos_entradas LEFT OUTER JOIN tipos_orden ON tipos_orden.id_tipo = tipos_entradas.id WHERE ( tipos_entradas.id_tipo = 4 AND activo = 1 ) AND ( JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%05/2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".titulo'),"one",LOWER("%%")) IS NOT NULL ) ORDER BY STR_TO_DATE(REPLACE(valores->'$."2".fecha','"',''), "%d/%m/%Y") DESC , tipos_orden.orden ASC LIMIT 0,6
SELECT tipos_entradas.* FROM tipos_entradas LEFT OUTER JOIN tipos_orden ON tipos_orden.id_tipo = tipos_entradas.id WHERE ( tipos_entradas.id_tipo = 4 AND activo = 1 ) AND ( JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%05/2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".titulo'),"one",LOWER("%%")) IS NOT NULL ) ORDER BY STR_TO_DATE(REPLACE(valores->'$."2".fecha','"',''), "%d/%m/%Y") DESC , tipos_orden.orden ASC LIMIT 0,6

- 28/05/2021
Experience 5G technology at the Conference Centre
Symposia
Our venue hosts V5G DAY
See more
- 17/05/2021
The 43rd UGT Confederal Congress, an eagerly awaited event
Congress
What does this large-scale congress mean for Valencia?
See more
- 13/05/2021
The emotion of graduation ceremonies returns to our building
Graduation ceremony
The Valencia Conference Centre hosts the graduation ceremonies of the Florida Universitària
See more
- 03/05/2021
Stay Homas will make you feel at home, at the Valencia Conference Centre
Shows
The band swaps the rooftop terrace of its apartment block for Auditorium
See more