SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'purplehaze67') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'buenodeoro') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'fatguyinalittlecoat') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'Fantasy Dog') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'Unlucky') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'General Malaise') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'cracKer') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'Cobalt Cruisin') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'shining path') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'Gatorman') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'BassNBrew') AND (round < 19)
ORDER BY dlname, rank
SELECT *, rank, dlname, round
FROM survivor
WHERE (dlname = 'Team Wade') AND (round < 19)
ORDER BY dlname, rank
