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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%03/2018%")) 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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%03/2018%")) 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
- 27/03/2018
Valencia brings together 1,200 European professionals from the fields of Surgery and Traumatology
Congress
From 6th to 8th May, the Valencia Conference Centre will be bringing together around 1,200 medical professionals at the Annual European Congress of Trauma and Emergency Surgery (ECTES), which is being held in Spain for the first time in its history.
See more
- 13/03/2018
Earth Hour
Corporate
On 24th March the Centre will be turning off its lights from 8.30 pm to 9.30 pm in support of Earth Hour, in line with its commitment to fighting climate change.
See more
- 09/03/2018
The latest in meeting technology at the MIS
Corporate
Our venue is off to Madrid to attend one of the leading corporate event tourism events: the Meeting & Incentive Summit (MIS) organised by Grupo Eventoplus.
See more
- 05/03/2018
Ismael Serrano and the musical “Michael Legend” hit the high notes at the Conference Centre in April
Shows
The Valencian venue has managed to slot two great shows in between the busy conference and congress schedule planned for this spring.
See more