string(1003) "SELECT c.codcamp, tc.codtcamp, c.titulo as titular, c.subtitulo, c.subtitulo1,c.optTitulo,c.optDesc,c.optKeywords, c.titulo as texto, CONCAT(CONCAT('',c.subtitulo), CONCAT('
', c.subtitulo1)) as texto1, c.descuentoPorcien, c.precioMin, c.optimizacion, c.ampliada, c.keyword, c.url, c.especial, c.bookingwIni, c.versiones, c.orden, c.travelwIni,c.bookingwFin, c.travelwFin, c.descripcion, c.byIdiomas, co.codclas, c.hideTextBox, c.activoLuxe , c.counter, c.hotelColor FROM MeliacubaDataLayerBundle:Campanas c JOIN c.codtcamp tc LEFT JOIN c.codclas co WHERE (tc.activo=1) AND (c.activoLuxe = 1 OR (tc = 50)) AND (c.bookingwIni <= CURRENT_DATE() AND c.bookingwFin >= CURRENT_DATE()) AND (c.activo=1) AND (c.versiones='all' OR c.versiones LIKE '%fr%') ORDER BY c.orden"