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("%2020%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%10/2020%")) 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("%2020%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%10/2020%")) 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

- 30/10/2020
Technology and sustainability at the core of the strategic plan for the next three years
Corporate
The Conference Centre's Board of Directors approves the 2021 budget
See more
- 20/10/2020
Let us tell you how we are organising the next hybrid event
Congress
The Habitat 2020 Congress to be held on 22 October
See more
- 15/10/2020
Help us to set a new blood donor record!
Corporate
On 23rd October, in conjunction with the Valencian Region Blood Transfusion Centre
See more
- 07/10/2020
AECOC chooses our building once again to hold its yearly congress
Congress
The congress was a face-to-face event, with strict safety measures
See more
- 01/10/2020
Victor Küppers is back at our building, motivating his audience with his live talk 'Living life with Enthusiasm'
Shows
The protocol to guarantee the safety of the attendees, the speaker and the team has been implemented
See more