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
- 08/05/2020
FSO cancela definitivamente el concierto del 29 de mayo.
Shows
Las entradas serán reembolsadas automáticamente desde los mismos canales de venta.
See more
- 03/02/2020
Let your dreams fly at the Valencia Conference Centre
Shows
‘Dromo, a Flying Dream’, the charity show by the Sorolla Education Group, lands on 13 February
See more
- 23/12/2019
Ready to enter magician Nuel Galan’s other dimension?
Shows
The National Magic Award winner will make you part of his audiovisual show
See more
- 25/11/2019
Knock, knock… Come on in through our magic door!
Shows
You’ll listen to cellos, travel to imperial St Petersburg and dance to the finest epic music from Game of Thrones
See more
- 29/10/2019
Manolo Garcia is back at the Valencia Conference Centre
Shows
He will be there on 6, 8 and 9 November in Auditorium 1
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