SHARE
TWEET

Untitled

a guest Oct 21st, 2019 72 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT `tournament`.`id` AS `tournament_id`, `tournament`.`gameId` AS `tournament_gameId`, `tournament`.`name` AS `tournament_name`, `tournament`.`description` AS `tournament_description`, `tournament`.`startDate` AS `tournament_startDate`, `tournament`.`endDate` AS `tournament_endDate`, `tournament`.`startSubscriptionDate` AS `tournament_startSubscriptionDate`, `tournament`.`endSubscriptionDate` AS `tournament_endSubscriptionDate`, `tournament`.`status` AS `tournament_status`, `tournament`.`slots` AS `tournament_slots`, `tournament`.`gameMode` AS `tournament_gameMode`, `tournament`.`createdAt` AS `tournament_createdAt`, `tournament`.`updatedAt` AS `tournament_updatedAt`, `tournament`.`ruleId` AS `tournament_ruleId`, `tournament`.`prize` AS `tournament_prize`, `tournament`.`metadata` AS `tournament_metadata`, `tournament`.`type` AS `tournament_type`, `tournament`.`stage` AS `tournament_stage`, `groups`.`id` AS `groups_id`, `groups`.`label` AS `groups_label`, `groups`.`tournamentId` AS `groups_tournamentId`, `groups`.`status` AS `groups_status`, `groups`.`champions` AS `groups_champions`, `groups`.`createdAt` AS `groups_createdAt`, `groups`.`updatedAt` AS `groups_updatedAt`, `teams`.`id` AS `teams_id`, `teams`.`ownerId` AS `teams_ownerId`, `teams`.`gameId` AS `teams_gameId`, `teams`.`active` AS `teams_active`, `teams`.`name` AS `teams_name`, `teams`.`description` AS `teams_description`, `teams`.`tag` AS `teams_tag`, `teams`.`createdAt` AS `teams_createdAt`, `teams`.`updatedAt` AS `teams_updatedAt`, `groupMatches`.`id` AS `groupMatches_id`, `groupMatches`.`tournamentGroupId` AS `groupMatches_tournamentGroupId`, `match`.`id` AS `match_id`, `match`.`tournamentId` AS `match_tournamentId`, `match`.`teamAId` AS `match_teamAId`, `match`.`teamBId` AS `match_teamBId`, `match`.`teamAScore` AS `match_teamAScore`, `match`.`teamBScore` AS `match_teamBScore`, `match`.`winnerId` AS `match_winnerId`, `match`.`startDate` AS `match_startDate`, `match`.`matchFormat` AS `match_matchFormat`, `match`.`finished` AS `match_finished`, `match`.`metadata` AS `match_metadata`, `match`.`matchType` AS `match_matchType`, `match`.`createdAt` AS `match_createdAt`, `match`.`updatedAt` AS `match_updatedAt`, `match`.`bracketMatchId` AS `match_bracketMatchId`, `match`.`groupMatchId` AS `match_groupMatchId` FROM `Tournament` `tournament` LEFT JOIN `TournamentGroup` `groups` ON `groups`.`tournamentId`=`tournament`.`id`  LEFT JOIN `TeamGroup` `groups_teams` ON `groups_teams`.`tournamentGroupId`=`groups`.`id` LEFT JOIN `Team` `teams` ON `teams`.`id`=`groups_teams`.`teamId`  LEFT JOIN `TournamentGroupMatch` `groupMatches` ON `groupMatches`.`tournamentGroupId`=`groups`.`id`  LEFT JOIN `TournamentMatch` `match` ON `match`.`groupMatchId`=`groupMatches`.`id` WHERE `tournament`.`id` = ? -- PARAMETERS: ["1"]
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top