Survivor Players

Results are filtered (clear)

536 players found

Tijuana Bradley

Oh No You Didn't!

Last Appearance: Pearl Islands

Best finish: 7th

Michaela Bradshaw

G.I. Jane

Last Appearance: Game Changers

Best finish: 7th

Jane Bright

Tough Old Broad

Last Appearance: Nicaragua

Best finish: 6th

Amber Brkich

Little Red Riding Hood

Last Appearance: All-Stars

Best finish: 1st

Nick Brown

Know-It-All

Last Appearance: The Australian Outback

Best finish: 7th

Jenn Brown

Lady Gaga

Last Appearance: Worlds Apart

Best finish: 9th

G.C. Brown

Ponyboy

Last Appearance: Gabon

Best finish: 14th

Ben Browning

Good Ol' Boy

Last Appearance: Samoa

Best finish: 17th

Kelly Bruno

Secretly Smart Bikini Babe

Last Appearance: Nicaragua

Best finish: 15th

Tom Buchanan

Good Ol' Boy

Last Appearance: All-Stars

Best finish: 4th

(default) 14 queries took 0 ms
Nr	Query	Affected	Num. rows
1	SELECT `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 1 = 1 ORDER BY `Player`.`lname` asc LIMIT 60, 10	10	10
2	SELECT COUNT(*) AS `count` FROM `caunce_types`.`players` AS `Player` WHERE 1 = 1	1	1
3	SELECT `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` = 447 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
4	SELECT `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` = 775 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
5	SELECT `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` = 433 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
6	SELECT `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 1	1	1
7	SELECT `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` = 442 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
8	SELECT `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` = 518 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
9	SELECT `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 1	1	1
10	SELECT `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` = 712 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
11	SELECT `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` = 670 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
12	SELECT `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` = 364 ORDER BY `Season`.`season_number` DESC LIMIT 1	1	1
13	SELECT `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` ASC	26	26
14	SELECT `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` ASC	36	36

(default) 14 queries took 0 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `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 1 = 1 ORDER BY `Player`.`lname` asc LIMIT 60, 10

SELECT COUNT(*) AS `count` FROM `caunce_types`.`players` AS `Player` WHERE 1 = 1

SELECT `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` = 447 ORDER BY `Season`.`season_number` DESC LIMIT 1

SELECT `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` ASC

SELECT `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` ASC

Survivor Players

Filters