select *
from xproc.FileRow fr with (nolock)
join xproc.[File] f with (nolock) on f.ID = fr.FileID
where 1=1
and fr.ProcessStatus not in ('Processed','Maintenance','Exported','Duplicate','equal','new','MODIFIED','ERRORSENTBACK','IGNORED','LOAD')
and (fr.ErrorDescription not like 'IP:%' or fr.ErrorDescription is null)
and not (fr.client in ('PayPalEMoney182','PayPalEMoney590')
and (fr.ErrorDescription like 'no matching dp%' or fr.ErrorDescription like 'Cannot find an unacknowledged payment for DRP%')
)
and not (fr.client ='PayPalEMoneyGE' and fr.country='ES'
and (fr.ErrorDescription like 'no matching dp%'
or fr.ErrorDescription like 'Cannot find an unacknowledged payment for DRP%'
)
)
and not (fr.client='1AND1' and country='ES'
and (fr.ErrorDescription like 'no matching dp%'
or fr.ErrorDescription like 'Cannot find an unacknowledged payment for DRP%'
or fr.ErrorDescription like 'multiple events%'
)
)
--and f.id not in ()
order by fr.id desc

explain the above query