Completly re-write it

SELECT

....

FROM

....

INNER JOIN --=

.....

ON ..... = .....

LEFT OUTER JOIN --*=

ON ..... = .....

RIGHT OUTER JOIN --=*

ON ..... = .....

WHERE

.....

As you have only provided half of the query, it is hard to do it for you.