Untitled

SELECT * FROM articulos JOIN (SELECT idcoleccion, max(volumen) vol FROM articulos GROUP BY idcoleccion) a ON articulos.idcoleccion = a.idcoleccion AND (articulos.volumen = vol OR articulos.volumen IS NULL AND vol IS NULL) ORDER BY idarticulo DESC LIMIT 10;