Congress
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".categorias'),"one",LOWER("%2132%")) 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".categorias'),"one",LOWER("%2132%")) 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
- 21/10/2021
El Palacio de Congresos se prepara para la llegada del XXIV Congreso Nacional de Psiquiatría
Congress
See more
- 13/09/2021
Face-to-face networking, the strong point of the 23rd AECOC Fruit and Vegetable Congress
Congress
AECOC chooses the Conference Centre once again, and it’s the 19th time!
See more
- 10/09/2021
Our schedule gains momentum over the next three months
Congress
There are 11 national and international congresses and conventions lined up
See more
- 27/07/2021
Our building, home to the 3rd National Housing Congress
Congress
The congress is expected to bring together 400 experts, town planners, researchers and businesspeople
See more
- 20/07/2021
Around 600 experts to meet at the 3rd Interdisciplinary Congress on Human Genetics
Congress
The main topics at this face-to-face congress include new advances in hereditary cancer, bioinformatics and digital health.
See more
- 13/07/2021
Our building brings almost a thousand executives together on site
Congress
The 4th National CFO Congress discusses the new financial environment that has emerged during the pandemic
See more