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("%01/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("%01/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/01/2021
The Conference Centre turns red to mark the International Day of Education
Corporate
Thanks to this initiative, we are making progress in complying with the UN SDGs
See more
- 18/01/2021
Thanks to the success of the recent face-to-face and hybrid events, we are optimistic about 2021
Corporate
We turned the 35th AECOC Consumer Congress into a success story
See more
- 13/01/2021
We start the year by stepping up our commitment to society
Corporate
The Conference Centre and the Valencia Province Blood Donor Association join forces for a good cause
See more
- 07/01/2021
The Valencia Conference Centre, a safe building
Corporate
Introducing our Safe Event Guide
See more