Survivor Players

Results are filtered (clear)
22 players found

Coby Archa

Ponyboy

Last Appearance: Palau

Best finish: 9th


Dirk Been

Ponyboy

Last Appearance: Borneo

Best finish: 12th


Matt Bischoff

Ponyboy

Last Appearance: Caramoan: Fans vs Favourites 2

Best finish: 14th


Mike Borassi

Ponyboy

Last Appearance: Samoa

Best finish: 19th


G.C. Brown

Ponyboy

Last Appearance: Gabon

Best finish: 14th


Chad Crittenden

Ponyboy

Last Appearance: Vanuatu

Best finish: 8th


Matthew Elrod

Ponyboy

Last Appearance: Redemption Island

Best finish: 7th


Billy Garcia

Ponyboy

Last Appearance: Cook Islands

Best finish: 19th


Neal Gottlieb

Ponyboy

Last Appearance: Kaoh Rong: BBB2

Best finish: 11th


Brandon Hantz

Ponyboy

Last Appearance: Caramoan: Fans vs Favourites 2

Best finish: 6th


Filters

(default) 14 queries took 8 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` = 14) > 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` = 14) > 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` = 502 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` = 571 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` = 649 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` = 743 ORDER BY `Season`.`season_number` DESC LIMIT 1118
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` = 641 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` = 473 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` = 459 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` = 740 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` = 757 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` = 435 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