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 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` = '4' 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` = '5' 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` = '6' 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` = '7' 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` = '8' 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` = '9' 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` = '10' 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` = '11' 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` = '12' 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` = '13' AND `PlayersSeason`.`placement` = 1 ORDER BY `PlayersSeason`.`placement` ASC LIMIT 1 | | 1 | 1 | 0 |