| 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 (select count(*) from players_seasons ps where `ps`.`player_id` = `Player`.`id`
and `ps`.`character_type_id` = 22) > 0 ORDER BY `Player`.`lname` asc, `Player`.`fname` asc LIMIT 10 | | 10 | 10 | 0 |
| 2 | SELECT COUNT(*) AS `count` FROM `caunce_types`.`players` AS `Player` WHERE (select count(*) from players_seasons ps where `ps`.`player_id` = `Player`.`id`
and `ps`.`character_type_id` = 22) > 0 | | 1 | 1 | 0 |
| 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` = 701 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 471 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 655 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 12 |
| 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` = 720 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 575 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 322 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 636 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 665 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 598 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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` = 530 ORDER BY `Season`.`season_number` DESC LIMIT 1 | | 1 | 1 | 0 |
| 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 | 0 |
| 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 | 0 |
