This query requests an outer join, but either the WHERE clause is missing in the query, or the conditions in the WHERE clause cause every row of the subordinate table to be selected for every row of the dominant table, resulting in a very large output.
Review the query, and check that at least one condition in the WHERE clause relates each dominant-subordinate pair of tables in the query.