gistfile1.txt

0.8:

SELECT a.id AS a_id, anon_1.c_id_1 AS anon_1_c_id_1, anon_1.c_base_id AS anon_1_c_base_id, 
   anon_1.c_c_id AS anon_1_c_c_id, anon_2.b_id AS anon_2_b_id, anon_2.b_base_id AS anon_2_b_base_id, 
   anon_2.b_a_id AS anon_2_b_a_id 
FROM a LEFT OUTER JOIN (SELECT b_base.id AS b_base_id, b.id AS b_id, b.a_id AS b_a_id 
FROM b_base JOIN b ON b_base.id = b.id) AS anon_2 ON a.id = anon_2.b_a_id 

LEFT OUTER JOIN (SELECT c_base.id AS c_base_id, c.id AS c_id_1, c.c_id AS c_c_id 
FROM c_base JOIN c ON c_base.id = c.id) AS anon_1 ON anon_2.b_id = anon_1.c_c_id

-------------------------------------------------------------------------------------------------------
0.9:

SELECT a.id AS a_id, c_1.id AS c_1_id, c_base_1.id AS c_base_1_id, c_1.c_id AS c_1_c_id, 
b_1.id AS b_1_id, b_base_1.id AS b_base_1_id, b_1.a_id AS b_1_a_id 
FROM a LEFT OUTER JOIN (b_base AS b_base_1 JOIN b AS b_1 ON b_base_1.id = b_1.id) ON a.id = b_1.a_id 

LEFT OUTER JOIN (c_base AS c_base_1 JOIN c AS c_1 ON c_base_1.id = c_1.id) ON b_1.id = c_1.c_id

-------------------------------------------------------------------------------------------------------
0.9 with sqlite:

SELECT a.id AS a_id, anon_1.c_1_id AS c_1_id, anon_1.c_base_1_id AS c_base_1_id, 
anon_1.c_1_c_id AS c_1_c_id, anon_2.b_1_id AS b_1_id, anon_2.b_base_1_id AS b_base_1_id, 
anon_2.b_1_a_id AS b_1_a_id 

FROM a LEFT OUTER JOIN (SELECT b_base_1.id AS b_base_1_id, b_1.id AS b_1_id, b_1.a_id AS b_1_a_id 
FROM b_base AS b_base_1 JOIN b AS b_1 ON b_base_1.id = b_1.id) AS anon_2 ON a.id = anon_2.b_1_a_id 

LEFT OUTER JOIN (SELECT c_base_1.id AS c_base_1_id, c_1.id AS c_1_id, c_1.c_id AS c_1_c_id 
FROM c_base AS c_base_1 JOIN c AS c_1 ON c_base_1.id = c_1.id) AS anon_1 
ON anon_2.b_1_id = anon_1.c_1_c_id