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".titulo'),"one",LOWER("%%")) IS NOT NULL ) ORDER BY STR_TO_DATE(REPLACE(valores->'$."2".fecha','"',''), "%d/%m/%Y") DESC , tipos_orden.orden ASC LIMIT 42,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".titulo'),"one",LOWER("%%")) IS NOT NULL ) ORDER BY STR_TO_DATE(REPLACE(valores->'$."2".fecha','"',''), "%d/%m/%Y") DESC , tipos_orden.orden ASC LIMIT 42,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
- 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
- 24/02/2021
The 43rd UGT Confederal Congress, in person and in our building
Congress
The congress theme is ‘Redvolución6.0’ and will bring together 800 people
See more
- 24/02/2021
The Conference Centre and the Associació Valencia Capital del Disseny, working hand in hand to promote Valencia as World Design Capital
Corporate
The Conference Centre and the Associació Valencia Capital del Disseny, working hand in hand to promote Valencia as World Design Capital
See more