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("%09/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("%09/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
- 27/09/2021
Enter our time capsule and travel to 2030
Corporate
The Conference Centre celebrates World Tourism Day with the sustainable event 'The Time Capsule
See more
- 16/09/2021
Next stop - The Valencia Conference Centre
Corporate
We have renewed our cooperation agreement with Renfe
See more
- 13/09/2021
Face-to-face networking, the strong point of the 23rd AECOC Fruit and Vegetable Congress
Congress
AECOC chooses the Conference Centre once again, and it’s the 19th time!
See more
- 10/09/2021
Our schedule gains momentum over the next three months
Congress
There are 11 national and international congresses and conventions lined up
See more
- 09/09/2021
The Conference Centre participates in Childhood Cancer Awareness Month
Corporate
We will be taking part in several initiatives to pay tribute to the kids and teenagers who are fighting this illness.
See more.jpg)
- 02/09/2021
Our cuisine moves forward on the SDGs
Corporate
The sustainability of our food contributes to meeting the UN's SDGs
See more