CRS
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".etiquetas'),"one",LOWER("%4123%")) 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".etiquetas'),"one",LOWER("%4123%")) 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
- 08/05/2020
The Conference Centre joins forces with the Transfusion Centre to become a blood donation venue
Corporate
On 21st May we will be hosting a blood donation session
See more
- 27/04/2020
Thank you, ambassadors!
Corporate
The team at the Valencia Conference Centre thanks its ambassadors for their contribution to creating a better world
See more
- 27/09/2019
We are supporting the ‘Valencia against Cancer’ charity initiative
Symposia
RunCáncer Circuit bib numbers to be handed out in our building on 18-19 October
See more