SELECT big2.*
FROM small_table s1
       INNER JOIN small_table s2 ON s1.id = s2.parent_id
       INNER JOIN big_table1 big1 ON s2.id = big1.id
       INNER JOIN big_table2 big2 ON big1.matchresult_id = big2.matchresult_id
ORDER BY big2.matchresult_id