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("%2019%")) 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("%2019%")) 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/12/2019
Check out our financial performance in 2019 in this video
Corporate
Want to know how our operations have impacted Valencia?
See more
- 23/12/2019
Ready to enter magician Nuel Galan’s other dimension?
Shows
The National Magic Award winner will make you part of his audiovisual show
See more
- 20/12/2019
Discover. Feel. Enjoy.
Corporate
Our customers’ experiences are at the heart of our Christmas campaign
See more
- 19/12/2019
2019, one of the best years in our history
Corporate
We have increased our operations and grown our international business
See more
- 11/12/2019
A year ago we were all dressed up to...
Corporate
Celebrate our 20th Anniversary Gala with our ambassadors
See more
- 25/11/2019
Here’s our most supportive side
Corporate
Check out our 2019 Corporate Social Responsibility initiatives
See more