gistfile1.txt

SELECT sch.id, sch.title, shift.id, shift.begin, shift.end, shift.unwanted as w, u.username
FROM shiftmanager_schedule sc
    JOIN shiftmanager_schedule_shifts sh ON (sc.id = sh.schedule_id)
    JOIN shiftmanager_shift shift ON (shift.id IN (SELECT temp.shift_id FROM shiftmanager_schedule_shifts temp WHERE temp.schedule_id = sh.id)
    JOIN aktive_verv ON (av.medlem_id = shift.owner_id)
    JOIN auth_user u ON (av.medlem_id = u.id)
WHERE av.medlem_id = 1012912;