Tourism
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("%3389%")) 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 6,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("%3389%")) 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 6,6
- 14/01/2019
Getting to Valencia
Tourism
The Conference Centre is less than 30 minutes away from all the city's main transport hubs, thus facilitating the organisation of conferences and events in the city.
See more
- 15/11/2018
Valencia becomes the meeting point for European airports and airlines
Tourism
From 3rd to 5th December, the AviaDev Europe forum will turn the city of Valencia into the hub of regional aviation
See more
- 04/09/2018
Unique moments in Valencia
Tourism
Valencia is one of the most enchanting cities in Spain and features a wide variety of options at any time of year.
See more