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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%12/2018%")) 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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%12/2018%")) 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

- 17/12/2018
Merry Christmas and a Happy 2019
Corporate
20 Years of enthusiasm, dreams, new challenges and progress hand in hand.
See more
- 04/12/2018
The Valencia Conference Centre celebrates its 20th anniversary gala with its ambassadors
The Valencia Conference Centre was opened in 1998, and has since become one of the most important conference and business meeting points in the world, thanks to a group of Valencian professionals and their tireless dedication.
See more
- 04/12/2018
“Blind” breakfast at the Valencia Conference Centre
Corporate
The Spanish National Organisation for the Blind (ONCE) is holding a "blind" breakfast to present the lottery ticket commemorating the Valencia Conference Centre's 20th anniversary, the draw for which will be held on 11th December.
See more