SELECT
  r1.USER
FROM
  rankings AS r1,
  rankings AS r2,
  rankings AS r3,
  rankings AS r4,
  rankings AS r5,
  rankings AS r6,
  rankings AS r7,
  rankings AS r8,
  rankings AS r9
WHERE
  r1.member = '{rankedList[0]}' AND
  r2.member = '{rankedList[1]}' AND
  r3.member = '{rankedList[2]}' AND
  r4.member = '{rankedList[3]}' AND
  r5.member = '{rankedList[4]}' AND
  r6.member = '{rankedList[5]}' AND
  r7.member = '{rankedList[6]}' AND
  r8.member = '{rankedList[7]}' AND
  r9.member = '{rankedList[8]}' AND
  r1.ranking = 1 AND
  r2.ranking = 2 AND
  r3.ranking = 3 AND
  r4.ranking = 4 AND
  r5.ranking = 5 AND
  r6.ranking = 6 AND
  r7.ranking = 7 AND
  r8.ranking = 8 AND
  r9.ranking = 9 AND
  r1.USER = r2.USER AND
  r1.USER = r3.USER AND
  r1.USER = r4.USER AND
  r1.USER = r5.USER AND
  r1.USER = r6.USER AND
  r1.USER = r7.USER AND
  r1.USER = r8.USER AND
  r1.USER = r9.USER;