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 WHERE 1 AND inov.seccion = 10 AND inov.estado = 2 AND inov.del = 0 GROUP BY inov.id ORDER BY inov.fecha DESC, hora DESC, id DESC LIMIT 0, 12