Survivor Players

Results are filtered (clear)
24 players found

Ashlee Ashby

Little Red Riding Hood

Last Appearance: Palau

Best finish: 17th


Julie Berry

Little Red Riding Hood

Last Appearance: Vanuatu

Best finish: 5th


Jefra Bland

Little Red Riding Hood

Last Appearance: Cagayan: BBB1

Best finish: 7th


Amber Brkich

Little Red Riding Hood

Last Appearance: All-Stars

Best finish: 1st


Kelly Czarnecki

Little Red Riding Hood

Last Appearance: Gabon

Best finish: 13th


Jessica deBen

Little Red Riding Hood

Last Appearance: Fiji

Best finish: 19th


Neleh Dennis

Little Red Riding Hood

Last Appearance: Marquesas

Best finish: 2nd


Jaime Dugan

Little Red Riding Hood

Last Appearance: China

Best finish: 10th


Kat Edorsson

Little Red Riding Hood

Last Appearance: Blood vs. Water

Best finish: 7th



Filters

(default) 14 queries took 0 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Player`.`id`, `Player`.`fname`, `Player`.`lname`, `Player`.`image_url`, `Player`.`location`, (select ps.placement from players_seasons ps where ps.player_id = Player.id order by ps.placement limit 1) as best_finish FROM `caunce_types`.`players` AS `Player` WHERE (select count(*) from players_seasons ps where `ps`.`player_id` = `Player`.`id` and `ps`.`character_type_id` = 19) > 0 ORDER BY `Player`.`lname` asc, `Player`.`fname` asc LIMIT 1010100
2SELECT COUNT(*) AS `count` FROM `caunce_types`.`players` AS `Player` WHERE (select count(*) from players_seasons ps where `ps`.`player_id` = `Player`.`id` and `ps`.`character_type_id` = 19) > 0110
3SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 706 ORDER BY `Season`.`season_number` DESC LIMIT 1110
4SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 395 ORDER BY `Season`.`season_number` DESC LIMIT 1110
5SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 463 ORDER BY `Season`.`season_number` DESC LIMIT 1110
6SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 416 ORDER BY `Season`.`season_number` DESC LIMIT 1110
7SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 613 ORDER BY `Season`.`season_number` DESC LIMIT 1110
8SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 741 ORDER BY `Season`.`season_number` DESC LIMIT 1110
9SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 317 ORDER BY `Season`.`season_number` DESC LIMIT 1110
10SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 532 ORDER BY `Season`.`season_number` DESC LIMIT 1110
11SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 461 ORDER BY `Season`.`season_number` DESC LIMIT 1110
12SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` LEFT JOIN `caunce_types`.`seasons` AS `Season` ON (`Season`.`id` = `PlayersSeason`.`season_id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`player_id` = 794 ORDER BY `Season`.`season_number` DESC LIMIT 1110
13SELECT `CharacterType`.`id`, `CharacterType`.`order`, `CharacterType`.`character_type`, `CharacterType`.`sex`, `CharacterType`.`description`, `CharacterType`.`created_date` FROM `caunce_types`.`character_types` AS `CharacterType` WHERE 1 = 1 ORDER BY `character_type` ASC26260
14SELECT `Season`.`id`, `Season`.`season_number`, `Season`.`season_name`, `Season`.`premiere_date`, `Season`.`air_day`, `Season`.`finale_date`, `Season`.`starting_players`, `Season`.`starting_tribes`, `Season`.`tribe1`, `Season`.`tribe2`, `Season`.`tribe3`, `Season`.`tribe4`, `Season`.`swap_day1`, `Season`.`swap_day2`, `Season`.`merge_tribe`, `Season`.`merge_players`, `Season`.`ftc_count`, `Season`.`jury_count`, `Season`.`wikia_url` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 ORDER BY `season_number` ASC36360