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("%11/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("%11/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/11/2021
On-site events return in earnest to the Valencia Conference Centre
Congress
Human interaction in face-to face events is, once more, one of the top priorities of professional congress organisers.
See more
- 19/11/2021
Major musical shows await you at the Valencia Conference Centre
Shows
Our spaces play host to several stage shows and live music. Masterpieces and great staging that will make the visiting public vibrate in unison with the music. Which is why today we’d like to tell you all about the shows you can experience at the Conference Centre of Valencia over the following months.
See more
- 11/11/2021
When the bell rings at our offices...
Corporate
We’ve got a new event! This post is about the sales actions undertaken by the Valencia Conference Centre team from January to the present
See more
- 05/11/2021
The III Interdisciplinary Conference on Human Genetics generated over 1,200 overnight stays in Valencia
Congress
We talked about the results of this event with the Chairman of the Spanish Association for Prenatal Diagnosis, Javier García Planells
See more