Survivor Seasons
Results are filtered (clear)
36 seasons found
Caramoan: Fans vs Favourites 2
Aired: February 13, 2013
Finale: May 12, 2013
20 players
8 jury members
Aired: February 13, 2013
Finale: May 12, 2013
20 players
8 jury members
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Season`.`starting_players` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 GROUP BY `Season`.`starting_players` ORDER BY `Season`.`starting_players` ASC | 4 | 4 | 0 | |
| 2 | SELECT `Season`.`ftc_count` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 GROUP BY `Season`.`ftc_count` ORDER BY `Season`.`ftc_count` ASC | 3 | 3 | 0 | |
| 3 | SELECT `Season`.`jury_count` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 GROUP BY `Season`.`jury_count` ORDER BY `Season`.`jury_count` ASC | 5 | 5 | 0 | |
| 4 | SELECT `Season`.`id`, `Season`.`season_name`, `Season`.`premiere_date`, `Season`.`finale_date`, `Season`.`starting_players`, `Season`.`jury_count` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 ORDER BY `Season`.`season_number` asc LIMIT 20, 10 | 10 | 10 | 0 | |
| 5 | SELECT COUNT(*) AS `count` FROM `caunce_types`.`seasons` AS `Season` WHERE 1 = 1 | 1 | 1 | 0 | |
| 6 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '24' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 7 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '25' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 8 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '26' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 9 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '27' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 10 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '28' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '29' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 12 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '30' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 13 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '31' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 14 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '32' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 | |
| 15 | SELECT `Player`.`id`, `Player`.`image_url`, `Player`.`fname`, `Player`.`lname`, `CharacterType`.`id`, `CharacterType`.`character_type` FROM `caunce_types`.`players` AS `Player` INNER JOIN `caunce_types`.`players_seasons` AS `PlayersSeason` ON (`PlayersSeason`.`player_id` = `Player`.`id`) LEFT JOIN `caunce_types`.`character_types` AS `CharacterType` ON (`CharacterType`.`id` = `PlayersSeason`.`character_type_id`) WHERE `PlayersSeason`.`season_id` = '33' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | 1 | 1 | 0 |
