SELECT inov.zona AS localidad, col.nombre AS color, inov.volanta, inov.id AS id, inov.fecha AS fecha, inov.hora AS hora, inov.titulo AS titulo, inov.texto AS texto, inov.copete AS copete, inov.autor AS autor, aut.nombre AS autnom, inov.seourl AS seourl, secc.nombre AS seccion, secc.seourl AS secseo FROM novedades AS inov INNER JOIN secciones AS secc ON inov.seccion = secc.id LEFT JOIN colores AS col ON col.id = secc.color LEFT JOIN autores AS aut ON aut.id = inov.autor INNER JOIN novedades_tags nt ON nt.novedad = inov.id INNER JOIN tags ON tags.id = nt.tag WHERE 1 AND tags.seourl = 'rol' AND inov.del = 0 AND estado = 2 GROUP BY inov.id ORDER BY inov.fecha DESC, hora DESC, id DESC LIMIT 0, 12