TABLE1: id (Foreign key)
TABLE2: id (primary key), idx (foreign key)
TABLE3: id (primary key), idx (primary key)
TABLE4: id (primary key), idx (primary key)`

SELECT *
FROM (((TABLE1 JOIN
        TABLE2
        ON TABLE1.id = TABLE2.id
       ) AS NEW_TABLE JOIN
       TABLE3
       ON NEW_TABLE.id = TABLE3.id AND NEW_TABLE.idx = TABLE3.idx
      ) AS NEW_TABLE JOIN
      TABLE4
      ON NEW_TABLE.id = TABLE4.id AND
         NEW_TABLE.idx = TABLE4.idx
     );