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("%2019%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%09/2019%")) 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("%2019%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%09/2019%")) 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
- 27/09/2019
We are supporting the ‘Valencia against Cancer’ charity initiative
Symposia
RunCáncer Circuit bib numbers to be handed out in our building on 18-19 October
See more
- 25/09/2019
Step into a blockbuster concert
Shows
On 22 November, the Film Symphony Orchestra is to perform the most iconic soundtracks in movie history
See more
- 16/09/2019
Gestionando Hijos (Managing Children) is calling in at Valencia for the first time
Symposia
The event, to be held on 5 October at the Valencia Conference Centre, will be attended by leading experts presenting educational guidelines and tools to the audience
See more
- 16/09/2019
How conference tourism impacts Valencia
Symposia
We have been invited to take part in the roundtable ‘The economic and social impact of conference tourism in cities’ hosted by AETE
See more
- 10/09/2019
The Conference Centre teams up with Valencia’s Casa Ronald
Corporate
We are hosting the 2nd Charity Zarzuelas for the Casa Ronald in Valencia
See more
- 03/09/2019
Valencia brings together the leading international experts in smart cities
Conventions
The 9th Green Standards Week is to be held at the Valencia Conference Centre from 1-4 October
See more