You might want to try this method and compare the query plans and times of the LEFT OUTER JOIN with the previous ones and see which are more efficient. ...
Just something to consider. Try forgetting for a minute about tuning the query or getting the best possible results. Instead let's take some time and go back to...