如何使这个长SQL查询成为完整的连接？

I have the following sql query. It is used to get stats on users who only logged in once this week. My problem is that I am missing some data. When I run a simple query to see how many users only logged in once this week I get five rows but this query only returns four rows. I assume this is because the tables are only left joined. As I am creating tables in the query I am having trouble and keep getting errors when trying to add in the union statement to make it a full join. Here is the query any help appreciated.I have the following sql query. It is used to g