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
- 01/10/2021
Our colleague from the Sales Department, Adelina Pedrós is our personality of the month
Corporate
She has won the bid for the 17th International Conference of the Metabolomics Society
See more
- 12/03/2021
Conclusions of the ‘Sustainable, Safe and Healthy Valencia’ event
Corporate
What we managed to achieve during the conference. First clue: we are pioneers in sustainable tourism.
See more
- 05/03/2021
Celebrating International Women's Day recalling our Equality Plan
Corporate
This ambitious project reinforces our commitment to society
See more
- 11/02/2021
We have renewed our Environmental and Quality Management System certifications!
Corporate
The Conference Centre continues to strive for quality in management and sustainable development.
See more
- 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
- 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