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("%12/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("%12/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
- 28/12/2021
2021, the year of the comeback, in which the attendance at events has returned
Corporate
Will you join us on this 2021 tour?
See more
- 23/12/2021
The Valencia Conference Centre team stars in 'The much-deserving person of the month
Corporate
The upturn in activity this year has been the key to this recognition
See more
- 09/12/2021
Christmas is a time to listen
Corporate
The return of face-to-face events, progress towards achieving the Sustainable Development Goals and the architectural elements of the building are the main features of this year’s Christmas campaign
See more
- 02/12/2021
Magda Cervera, a much-deserving person of the month
Corporate
In a single year, or colleague from the marketing department has attended to the request of almost one hundred events.
See more