hermansc

:1,2s/\(.*\)\(","HOVED ORD"$\)/\1 & \2/

hermansc

SELECT sc.id, sc.title, sh.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 = sh.id)
    JOIN auth_user u ON (shift.owner_id = u.id)
WHERE sc.owned_by_id IN(
    SELECT sch.owned_by_id
    FROM aktive_verv av 
    JOIN shiftmanager_schedule sch ON (sch.owned_by_id = av.gruppe_id) 
    WHERE av.medlem_id = 1012912) OR sc.owned_by_id IN (SELECT sc.owned_by_id FROM shiftmanager_shift shift

hermansc

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;