SELECT A.foo, E.bar
  FROM A join B using (ab) join D using (bd) join E using (de)
 WHERE D.abcd = ?