medical
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("%3794%")) 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("%3794%")) 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
- 10/05/2022
Dr. Mercedes Hurtado is our
Corporate
Medical congresses account for approximately 70% of the total number of congresses held in the building.
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
- 21/10/2021
The Conference Centre gears up for the 24th National Congress of Psychiatry
Congress
A thousand mental health experts from all over Spain will be meeting up in a face-to-face event from 28 to 30 October
See more
- 09/09/2021
The Conference Centre participates in Childhood Cancer Awareness Month
Corporate
We will be taking part in several initiatives to pay tribute to the kids and teenagers who are fighting this illness.
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