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("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%07/2021%")) 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("%2021%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%07/2021%")) 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/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
- 27/07/2021
We have a new 'android' in the office!
Corporate
His name is Cashu. And he is actually a social robot
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
- 08/07/2021
Our personality of the month is... José Manuel Sánchez, our Catering Director!
Corporate
José Manuel tells us how the food was prepared for the first international event since the pandemic broke out
See more
- 01/07/2021
We are celebrating our 23rd anniversary and are very excited about hosting international events once again
Corporate
Would you like to join our anniversary celebrations by making a wish? And what if we told you we were going to put it in a time capsule?
See more