SELECT id, created_by, deleted, persnr, sb_nr, nachname, vorname, termin, prioritaet, grund, aktivitaet, status, bem FROM (SELECT id, created_by, deleted, persnr, sb_nr, nachname, vorname, termin, prioritaet, grund, aktivitaet, status, bem , ROW_NUMBER() OVER (O
RDER BY termin ASC) AS rownumber FROM (SELECT p.id, p.created_by, p.deleted, p.persnr, p.sb_nr, s.nachname, s.vorname, p.termin, pri.beschreibung as prioritaet, gru.beschreibung as grund, akt.beschreibung as aktivitaet, sta.beschreibung as status, CASE WHEN p.bemerkung<>'' THEN 'X' ELSE '' END as bem FROM KD0801.process p INNER JOIN KD0801.process_rights r ON
r.persnr=p.persnr INNER JOIN KD0801.satzart001 s ON p.persnr=s.persnr LEFT JOIN KD0801.process_grund gru ON p.grund=gru.id LEFT JOIN KD0801.process_prioritaet pri ON p.prioritaet=pri.id LEFT JOIN KD0801.process_status sta ON p.status=sta.id LEFT JOIN KD0801.process_aktivitaet akt ON p.aktivitaet=akt.id WHERE r.login IN ('XDEXL1','VBAWOEST') AND p.deleted = 0 A
ND (sta.beschreibung <> 'Neuzugang' OR sta.beschreibung is null) AND p.sb_nr IN ('9976','36') UNION SELECT p.id, p.created_by, p.deleted, p.persnr, p.sb_nr, COALESCE(neu.nachname, '-') as nachname, COALESCE(neu.vorname, '-') as vorname, p.termin, pri.beschreibung as prioritaet, gru.beschreibung as grund, akt.beschreibung as aktivitaet, sta.beschreibung as stat
us, CASE WHEN p.bemerkung<>'' THEN 'X' ELSE '' END as bem FROM KD0801.process p LEFT JOIN KD0801.process_neuzugang neu ON p.persnr=neu.persnr LEFT JOIN KD0801.process_grund gru ON p.grund=gru.id LEFT JOIN KD0801.process_prioritaet pri ON p.prioritaet=pri.id LEFT JOIN KD0801.process_status sta ON p.status=sta.id LEFT JOIN KD0801.process_aktivitaet akt ON p.akti
vitaet=akt.id WHERE upper(p.created_by) IN ('XDEXL1','VBAWOEST') AND (sta.beschreibung = 'Neuzugang' OR p.persnr='') AND p.deleted = 0 AND p.sb_nr IN ('9976','36') ORDER BY termin ASC) as innerSubselect) as outerSubselect WHERE rownumber BETWEEN 1 AND 20