Hello!
I guess changing a couple of INNER JOINS to LEFT JOINS (or making them subqueries) and removing the WHERE (dbo.analgroup.sys_analgroup IS NOT NULL) or moving it into a ON clause on a LEFT JOIN clause. Though by doing your INNER JOIN with dbo.analgroup you also make your where clause unneccessary (since the inner join will eliminat the rows with NULL in the joining field)...
//Hanslindgren