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