SELECT
rank1.ts, rank1.foo_1, rank1.foo_2, rank1.bar_1, rank1.bar_2, rank2.bar_1, rank2.bar_2 AS d2_lng, rank3.bar_1, rank3.bar_2, rank4.bar_1, rank4.bar_2, rank5.bar_1, rank5.bar_2 FROM
(SELECT * FROM sample2 WHERE rank = 1) AS rank1 JOIN
(SELECT * FROM sample2 WHERE rank = 2) AS rank2 ON rank1.ts = rank2.ts JOIN
(SELECT * FROM sample2 WHERE rank = 3) AS rank3 ON rank2.ts = rank3.ts JOIN
(SELECT * FROM sample2 WHERE rank = 4) AS rank4 ON rank3.ts = rank4.ts JOIN
(SELECT * FROM sample2 WHERE rank = 5) AS rank5 ON rank4.ts = rank5.ts
WHERE rank1.foo_1 = rank2.foo_1 AND rank1.foo_2 = rank2.foo_2;