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 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("%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 0,6
- 18/01/2022
What does València expect from 2022?
Tourism
3 capital recognitions that our city will receive this yea
See more
- 19/02/2021
Valencia, a green city
Tourism
The Conference Centre contributes to the city's progress in sustainable tourism
See more
- 24/08/2020
Valencia, the first city in the world to calculate the carbon footprint of tourism
Tourism
The city is a world benchmark in sustainable tourism
See more
- 02/05/2019
Focus en Turismo
Tourism
EDEM is launching the second "Focus on Tourism" course and the Valencia Conference Centre will be the protagonist in the Business model: MICE tourism session
See more
- 08/03/2019
Things to do in Valencia
Tourism
Valencia hosts a wide range of activities throughout the year which makes it a city well worth visiting at any time from January to December
See more