SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'nadratowski') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'rito') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'annunziata') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'luebke') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'dodds') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'geisler') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'stuart') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'wimer') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'harris') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'smith') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'holm') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'gray') AND (round < 19)
ORDER BY dlname, rank