| 1 | SELECT `Discipline`.`id`, `Discipline`.`discipline_name` FROM `buddyleague`.`disciplines` AS `Discipline` WHERE `Discipline`.`discipline_popular` = '1' ORDER BY `discipline_popular` DESC, `discipline_name` ASC | | 21 | 21 | 0 |
| 2 | SELECT `Competition`.`id`, `Competition`.`competition_name`, `Competition`.`player_id`, `Competition`.`competition_public`, `Competition`.`competition_images_public`, `Competition`.`competition_slug`, `Competition`.`created`, `Competition`.`diploma_line1`, `Competition`.`diploma_line2`, `Competition`.`diploma_line3`, `Competition`.`diploma_line4`, `Competition`.`diploma_line5`, `Competition`.`diploma_line6`, `Competition`.`diploma_comp_sub`, `Competition`.`competition_counting`, `Competition`.`competition_group_id`, `Competition`.`competition_num`, `Competition`.`competition_finished`, `Competition`.`event_count`, `PlayerCreatedBy`.`id`, `PlayerCreatedBy`.`player_name`, `PlayerCreatedBy`.`username`, `PlayerCreatedBy`.`password`, `PlayerCreatedBy`.`role`, `PlayerCreatedBy`.`created`, `PlayerCreatedBy`.`modified`, `PlayerCreatedBy`.`player_fullName`, `PlayerCreatedBy`.`player_newPwdCode`, `CompetitionGroup`.`id`, `CompetitionGroup`.`competition_group_name`, `CompetitionGroup`.`competition_group_desc`, `CompetitionGroup`.`created`, `CompetitionGroup`.`competition_group_slug` FROM `buddyleague`.`competitions` AS `Competition` LEFT JOIN `buddyleague`.`players` AS `PlayerCreatedBy` ON (`Competition`.`player_id` = `PlayerCreatedBy`.`id`) LEFT JOIN `buddyleague`.`competition_groups` AS `CompetitionGroup` ON (`Competition`.`competition_group_id` = `CompetitionGroup`.`id`) WHERE `Competition`.`competition_public` = '1' ORDER BY `Competition`.`competition_name` ASC | | 37 | 37 | 1 |
| 3 | SELECT `Event`.`id`, `Event`.`competition_id`, `Event`.`event_num`, `Event`.`event_name`, `Event`.`discipline_id`, `Event`.`event_date`, `Event`.`event_location`, `Event`.`event_slug`, `Event`.`event_type_id`, `Event`.`event_finished` FROM `buddyleague`.`events` AS `Event` WHERE `Event`.`competition_id` IN (170, 169, 177, 181, 182, 186, 185, 192, 193, 191, 189, 194, 1, 128, 134, 139, 150, 165, 158, 159, 160, 164, 172, 175, 178, 180, 184, 188, 197, 198, 144, 190, 195, 196, 162, 146, 145) ORDER BY `event_num` asc | | 267 | 267 | 1 |
| 4 | SELECT `CompetitionImage`.`id`, `CompetitionImage`.`image_name`, `CompetitionImage`.`image_mimeType`, `CompetitionImage`.`image_fileSize`, `CompetitionImage`.`image_width`, `CompetitionImage`.`image_height`, `CompetitionImage`.`image_caption`, `CompetitionImage`.`competition_id`, `CompetitionImage`.`image_path`, `CompetitionImage`.`image_pathSmall`, `CompetitionImage`.`image_pathMedium`, `CompetitionImage`.`image_pathLarge` FROM `buddyleague`.`competition_images` AS `CompetitionImage` WHERE `CompetitionImage`.`competition_id` IN (170, 169, 177, 181, 182, 186, 185, 192, 193, 191, 189, 194, 1, 128, 134, 139, 150, 165, 158, 159, 160, 164, 172, 175, 178, 180, 184, 188, 197, 198, 144, 190, 195, 196, 162, 146, 145) | | 5 | 5 | 0 |
| 5 | SELECT `CompetitionsPlayer`.`id`, `CompetitionsPlayer`.`competition_id`, `CompetitionsPlayer`.`player_id`, `CompetitionsPlayer`.`cp_pos`, `CompetitionsPlayer`.`player_active` FROM `buddyleague`.`competitions_players` AS `CompetitionsPlayer` WHERE `CompetitionsPlayer`.`competition_id` IN (170, 169, 177, 181, 182, 186, 185, 192, 193, 191, 189, 194, 1, 128, 134, 139, 150, 165, 158, 159, 160, 164, 172, 175, 178, 180, 184, 188, 197, 198, 144, 190, 195, 196, 162, 146, 145) | | 502 | 502 | 0 |
| 6 | SELECT `Player`.`id`, `Player`.`player_name`, `Player`.`username`, `Player`.`password`, `Player`.`role`, `Player`.`created`, `Player`.`modified`, `Player`.`player_fullName`, `Player`.`player_newPwdCode`, `CompetitionsPlayer`.`id`, `CompetitionsPlayer`.`competition_id`, `CompetitionsPlayer`.`player_id`, `CompetitionsPlayer`.`cp_pos`, `CompetitionsPlayer`.`player_active` FROM `buddyleague`.`players` AS `Player` JOIN `buddyleague`.`competitions_players` AS `CompetitionsPlayer` ON (`CompetitionsPlayer`.`competition_id` IN (170, 169, 177, 181, 182, 186, 185, 192, 193, 191, 189, 194, 1, 128, 134, 139, 150, 165, 158, 159, 160, 164, 172, 175, 178, 180, 184, 188, 197, 198, 144, 190, 195, 196, 162, 146, 145) AND `CompetitionsPlayer`.`player_id` = `Player`.`id`) | | 502 | 502 | 2 |