SELECT b.ID AS BannerID, b.URL AS URL, b.NuevaVentana AS NuevaVentana, b.Title AS Title, b.Ancho AS Ancho, b.Alto AS Alto, dc.Contador AS Contador, dc.Paleta AS Paleta FROM banners b, dominios_campanyas dc, grupos_banners gb WHERE dc.Dominio=3 AND dc.Campanya=5 AND dc.ID = 0 AND b.ID = gb.Banner AND gb.Grupo = dc.Campanya AND b.Activo='Y' AND dc.Activo='Y' ORDER BY gb.Prioridad DESC