SELECT column1, column2, column3
FROM table7,
table8,
(SELECT column1, column2, column3
FROM (SELECT column1, column2, column3
FROM table1,
table2,
table3
WHERE table1.column1 = table2.column2
AND table3.column3 = 123456) subquery1,
(SELECT column4, column5, column6
FROM table4,
table5,
table6
WHERE table4.column4 = table5.column5
AND table6.column6 = 'asdfgh') subquery2
WHERE subquery1.column2 = subquery2.column5
) subquery3
WHERE subquery3.column4 = 34567