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('</br>', 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 '%en%')
                 ORDER BY c.orden"