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".fecha'),"one",LOWER("%02/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".fecha'),"one",LOWER("%02/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
- 25/02/2019
Valencia hosts the 35th AEAS National Congress
Congress
Coinciding with the celebration of World Water Day on 22nd March, the Spanish Water and Wastewater Association (AEAS) will be meeting at the Valencia Conference Centre from 27th to 29th March in its 35th National Congress.
See more
- 19/02/2019
The 9th FEDEM Congress addresses the future challenges of the removals business
Congress
From 9th to 12th May, the Spanish Movers Federation (FEDEM) will be holding its 9th Congress in the Valencia Conference Centre
See more
- 14/02/2019
Valencia brings together experts in paediatric allergies
Congress
The SEICAP will hold the annual congress at the Valencia Conference Centre from the 16th to the 18th of May
See more
- 06/02/2019
Intelligent solutions for sustainable urban tourism
Symposia
The Valencia Conference Centre, together with other local actors involved in tourism, has been taking part in an innovative international project whose main objective is to assess the social and environmental impact of visitors and identify solutions to reduce it.
See more