filter werkt onvolledig

SELECT     TOP (100) PERCENT MAX(dbo.orkrg.afl_week) AS KW, MAX(dbo.orkrg.refer1) AS Lieferdatum, MAX(dbo.orkrg.refer3) AS Montagepartner, MAX(dbo.orkrg.levwijze) 
                      AS Lieferart, MAX(dbo.orkrg.ordernr) AS Auftrag, MAX(dbo.orkrg.del_debtor_name) AS Salon, MAX(dbo.orkrg.del_PostCode) AS Plz, MAX(dbo.orkrg.del_City) AS Ort, 
                      MAX(dbo.orkrg.del_AddressLine1) AS Lieferadresse, MAX(dbo.orkrg.del_Phone) AS Telephone, MAX(dbo.humres.usr_id) AS usr_id, AVG(orsrg.brutto) AS Brutto, 
                      MAX(dbo.orkrg.fiattering) AS Genehmigt, dbo.orkrg.refer
FROM         dbo.orkrg WITH (nolock) INNER JOIN
                      dbo.humres WITH (nolock) ON dbo.orkrg.represent_id = dbo.humres.res_id INNER JOIN
                      dbo.orsrg AS os2 WITH (nolock) ON os2.ordernr = dbo.orkrg.ordernr INNER JOIN
                      dbo.cicmpy WITH (nolock) ON dbo.cicmpy.debnr = dbo.orkrg.verzdebnr LEFT OUTER JOIN
                          (SELECT     orsrg_2.ordernr, SUM(orsrg_2.esr_aantal * orsrg_2.prijs83) AS brutto
                            FROM          dbo.orsrg AS orsrg_2 WITH (nolock) INNER JOIN
                                                   dbo.Items WITH (nolock) ON orsrg_2.artcode = dbo.Items.ItemCode
                            WHERE      (orsrg_2.ar_soort <> 'P') AND (dbo.Items.Assortment <> '1700')
                            GROUP BY orsrg_2.ordernr) AS orsrg ON orsrg.ordernr = dbo.orkrg.ordernr LEFT OUTER JOIN
                          (SELECT     MAX(orsrg_1.ordernr) AS ordernr, MIN(orsrg_1.afldat) AS afldat
                            FROM          dbo.orsrg AS orsrg_1 WITH (nolock) INNER JOIN
                                                   dbo.orkrg AS orkrg_1 WITH (nolock) ON orsrg_1.ordernr = orkrg_1.ordernr
                            WHERE      (orsrg_1.ar_soort <> 'P') AND (orkrg_1.status = 'V')
                            GROUP BY orsrg_1.ordernr) AS afldat ON afldat.ordernr = dbo.orkrg.ordernr
WHERE     (dbo.orkrg.ord_soort = 'V') AND (dbo.orkrg.status = 'V')
GROUP BY dbo.orkrg.afl_week, dbo.orkrg.refer1, dbo.orkrg.refer2, dbo.orkrg.ex_artcode, dbo.orkrg.refer3, dbo.orkrg.levwijze, dbo.orkrg.fiattering, dbo.orkrg.ordernr, 
                      dbo.orkrg.del_debtor_name, dbo.orkrg.del_PostCode, dbo.orkrg.del_City, dbo.orkrg.del_AddressLine1, dbo.orkrg.del_Phone, dbo.orkrg.afgehandld, dbo.humres.usr_id, 
                      - orsrg.brutto, dbo.orkrg.refer
HAVING      (NOT (dbo.orkrg.refer LIKE '%80%'))
ORDER BY KW DESC

HAVING (NOT dbo.orkrg.refer LIKE '%80%' And dbo.orkrg.refer Is NULL)