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("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%03/2021%")) 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("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%03/2021%")) 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/03/2021
The Conference Centre, a pioneer in certifying and verifying the footprint of its activities
Corporate
This post tells you how the Sustainable Tourism Smart Label we have implemented in our building works
See more
- 25/03/2021
Another sustainability milestone for the Valencia Conference Centre
Corporate
The aim is to convert the car park into a shuttle hub for sustainable public transport
See more
- 25/03/2021
We have received 'COVID-19 ready' certification through the Spanish Secretary of State for Tourism's SICTED Project
Corporate
This distinction recognises the efforts made by the Conference Centre in terms of health and safety.
See more
- 12/03/2021
Conclusions of the ‘Sustainable, Safe and Healthy Valencia’ event
Corporate
What we managed to achieve during the conference. First clue: we are pioneers in sustainable tourism.
See more
- 09/03/2021
For a Sustainable, Safe and Healthy Valencia
Meeting tourism
We have organised this in-person event with the Valencia Convention Bureau to promote the MICE industry and sustainable tourism in the city
See more
- 05/03/2021
Celebrating International Women's Day recalling our Equality Plan
Corporate
This ambitious project reinforces our commitment to society
See more