This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision | ||
| wiki:disk_reservation [2016/11/29 22:16] – [Admission rules] neyron | wiki:disk_reservation [2016/11/29 23:01] – [Server prologue/epilogue] neyron | ||
|---|---|---|---|
| Line 64: | Line 64: | ||
| FROM resources r | FROM resources r | ||
| LEFT JOIN assigned_resources a ON a.resource_id = r.resource_id | LEFT JOIN assigned_resources a ON a.resource_id = r.resource_id | ||
| - | LEFT JOIN jobs j ON j.assigned_moldable_job = a.moldable_job_id AND j.state | + | LEFT JOIN jobs j ON j.assigned_moldable_job = a.moldable_job_id AND j.state |
| WHERE | WHERE | ||
| r.type = ' | r.type = ' | ||
| Line 77: | Line 77: | ||
| ) | ) | ||
| GROUP BY r.host, j.job_user | GROUP BY r.host, j.job_user | ||
| - | ORDER BY r.host ASC | + | ORDER BY r.host ASC, j.job_user DESC |
| EOF | EOF | ||
| } | } | ||