Page Comparison

and Factura_Belege.Recordid not in
(
Select fb.Recordid
from Factura_Belege fb
inner Join Factura_Beleg_Status_Zuordnung sz on fb.Recordid = sz.Ext_Recordid
inner Join Factura_Beleg_Status fbz on fbz.Recordid = sz.BelegStatus_Recordid
where
Factura_Belege.Recordid = fb.Recordid
and fbz.[Status] not in ('Storno','Abgeschrieben')
)

and Factura_Belege.Kundennummer not in ('1017821','1015957','1045993','1036967') and Factura_Belege.ChannelID not in ('40')