| 1 | SELECT `Player`.`id`, `Player`.`fname`, `Player`.`lname`, `Player`.`nickname`, `Player`.`twitter`, `Player`.`occupation`, `Player`.`boot_circumstances`, `Player`.`additional_comments`, `Player`.`location`, `Player`.`sex`, `Player`.`image_url`, `Player`.`wikia_url`, `Player`.`created_date` FROM `caunce_types`.`players` AS `Player` WHERE `Player`.`id` = 822 LIMIT 1 | | 1 | 1 | 0 |
| 2 | 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 | 0 |
| 3 | 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 | 0 |
| 4 | SELECT `Season`.`id`, `Season`.`season_name`, `CharacterType`.`id`, `CharacterType`.`character_type`, `PlayersSeason`.`id`, `PlayersSeason`.`age_show`, `PlayersSeason`.`placement`, `PlayersSeason`.`day_voted_out`, `PlayersSeason`.`votes_against`, `PlayersSeason`.`starting_tribe`, `PlayersSeason`.`swapped_tribe`, `PlayersSeason`.`med_evac`, `PlayersSeason`.`quit`, `PlayersSeason`.`boot_circumstances`, `PlayersSeason`.`additional_comments`, `PlayersSeason`.`tribe_wins`, `PlayersSeason`.`individual_wins` FROM `caunce_types`.`players_seasons` AS `PlayersSeason` INNER 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` = 822 ORDER BY `Season`.`season_number` DESC | | 1 | 1 | 0 |
