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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%11/2018%")) 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("%2018%")) IS NOT NULL AND JSON_SEARCH(LOWER(valores->'$."2".fecha'),"one",LOWER("%11/2018%")) 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
- 15/11/2018
Valencia becomes the meeting point for European airports and airlines
Tourism
From 3rd to 5th December, the AviaDev Europe forum will turn the city of Valencia into the hub of regional aviation
See more
- 12/11/2018
The MotoGP™ Awards return to Valencia
Next Sunday, 18th November, the Valencia Conference Centre will once again be hosting the 2018 FIM MotoGP™ Awards gala, coinciding with the last race of the MotoGP™ World Championship season at the Ricardo Tormo circuit in Cheste.
See more
- 05/11/2018
Valencia welcomes the 2018 SEPA Junior meeting
Congress
Young professionals from the world of periodontology will be showcasing the latest developments in this field at the Conference Centre
See more