Survivor Players

Results are filtered (clear)

536 players found

Fabio Birza

Surfer Dude

Last Appearance: Nicaragua

Best finish: 1st

Matt Bischoff

Ponyboy

Last Appearance: Caramoan: Fans vs Favourites 2

Best finish: 14th

Clarence Black

Surfer Dude

Last Appearance: Africa

Best finish: 10th

Jefra Bland

Little Red Riding Hood

Last Appearance: Cagayan: BBB1

Best finish: 7th

Spencer Bledsoe

Know-It-All

Last Appearance: Cambodia: Second Chance

Best finish: 2nd

Danni Boatwright

Erin Brockovich

Last Appearance: Guatemala

Best finish: 1st

Margaret Bobonich

I Can See Your Periscope

Last Appearance: Guatemala

Best finish: 13th

Andrea Boehlke

G.I. Jane

Last Appearance: Game Changers

Best finish: 5th

Rudy Boesch

True Grit

Last Appearance: All-Stars

Best finish: 3rd

Cao Boi Bui

The Specialist

Last Appearance: Cook Islands

Best finish: 15th

(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 40, 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` = 307 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` = 649 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` = 521 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` = 463 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` = 385 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` = 299 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` = 607 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` = 407 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` = 339 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` = 664 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 40, 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` = 307 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