SELECT * FROM foo
 JOIN bar ON foo.a = bar.a 
JOIN (SELECT * FROM baz where something_or_other) as mysub1 ON foo.z = mysub1.z 
WHERE foo.b in (SELECT y+1 FROM quux)