Shows
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".categorias'),"one",LOWER("%2136%")) 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".categorias'),"one",LOWER("%2136%")) 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
- 25/11/2022
La Granja de Zenon, the children's phenomenon that has broken all records at the main theatres in the world arrives at the Valencia Conference Centre on 30 December
Shows
You will once again laugh, dance and sing with all your friends from La Granja. Enjoy your favourite characters in an unique spectacle.
See more
- 12/09/2022
The Film Symphony Orchestra returns to the Valencia Conference Centre on its KRYPTON tour
Shows
The Film Symphony Orchestra returns to the Valencia Conference Centre on its KRYPTON tour
See more
- 19/11/2021
Major musical shows await you at the Valencia Conference Centre
Shows
Our spaces play host to several stage shows and live music. Masterpieces and great staging that will make the visiting public vibrate in unison with the music. Which is why today we’d like to tell you all about the shows you can experience at the Conference Centre of Valencia over the following months.
See more
- 13/10/2021
Mentes Expertas once again chooses the Conference Centre to inspire its audiences in Valencia
Shows
It does so with the talks "You are greater than you think", by Mario Alonso Puig, and "Living life with enthusiasm", by Víctor Küppers
See more