Help needed to tidy up deprecated (and mal-functioning) SQL code
First attempt at 1. (re-writing the Oracle (+) Operators as LEFT OUTER JOIN's); the subquery-part still isn't good though I guess; this is very-much draft-stage...

SELECT
    *
FROM
    a1

LEFT JOIN ( select * from b3 where col4 in
        (select col5 from b6 where col7 = '007')
  ) c ON a1.col8 = c.col9

LEFT JOIN a2 ON c.col4 = a2.col5

INNER JOIN a3 ON a2.bla = a3.bla

LEFT JOIN a7 ON a2.id = a7.id