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("%2011%")) 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 24,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("%2011%")) 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 24,6
- 30/05/2011
Debating Liver Transplant future in the Valencia Conference Centre
From 22-25th june, the Valencia Conference Centre will hold the 17th Annual International Congress of the International Liver Transplant Society (ILTS), the biggest meeting in this area which will bring to Valencia more than 1,200 professionales from 40 different...
See more
- 12/04/2011
The Valencia Conference Centre increases its economic impact to over 90 million euros in 2010
The results of the 2010 management report have beeb presented today to the Valencia Conference Centre´s Board of Directors.The report, which was approved by the Consortium´s executives, endorses a busy year for the Centre with a total of 114 events being attended by...
See more