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("%2022%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%04/2022%")) 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("%2022%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%04/2022%")) 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
- 28/04/2022
Digitalisation in dentistry and sustainability, key topics at Spanish Society of Digital Dentistry and New Technologies Valencia 2022
Congress
The national conference, which will attract over 800 people, firmly commits to sustainability for its organisation
See more
- 22/04/2022
Would you like to exhibit on a 100% sustainable stand?
Corporate
We encourage you to organise your display with minimal environmental impac
See more
- 04/04/2022
Valencia Conference Centre, setting for the 11th Conference of the Framework Program for Research and Innovation of the European Union in Spain
Symposia
Organised by the Centre for the Development of Industrial Technology (CDTI) in collaboration with the Ministry for Science and Innovation and the European Commission, to analyse the first year of Horizon Europe
See more
- 01/04/2022
Would you like to meet the protagonist of our ‘Person of the Month’ section
Corporate
This month is dedicated to Mónica Lull, employee of the Valencia Conference Centre, for her performance in 2021
See more