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("%01/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("%01/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
- 28/01/2020
Breakthroughs in diabetes in the spotlight
Congress
Our building is the venue for the 14th Meeting on Diabetes, Obesity and Nutrition
See more
- 28/01/2020
Reforcem l'oferta d'audiovisuals d'última generació
Corporate
Enguany oferim als nostres clients una nova pantalla Leds
See more
- 22/01/2020
New APCE Executive Committee on the association’s 25th anniversary
Corporate
Our director, Sylvia Andrés, has been appointed as a committee member after today’s elections
See more
- 16/01/2020
Our building, a world of experiences
Corporate
Our customers’ share their valuable testimonials after their visit to our venue
See more
- 09/01/2020
2020, a promising year
Corporate
We are kicking it off with 33 confirmed congresses and conventions which will generate around 66,000 overnight stays in Valencia
See more