- SELECT DISTINCT q.quota, l.gid, q.phys_id, n.device, n.mach_id, n.status
- FROM quota q, list l, nfsphys n
- WHERE l.list_id = q.entity_id AND n.nfsphys_id = q.phys_id AND
- q.phys_id != 0 AND n.status > 15 AND q.type = "GROUP"
- ORDER BY mach_id, phys_id, gid;
+ SELECT DISTINCT q.quota, q.entity_id, q.phys_id, n.device, n.mach_id,
+ n.status
+ FROM quota q, nfsphys n
+ WHERE n.nfsphys_id = q.phys_id AND q.phys_id != 0 AND
+ n.status > 15 AND q.type = 'GROUP'
+ ORDER BY mach_id, phys_id, entity_id;