Database Queries

SHOW FULL COLUMNS FROM `league`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'league' AND kcu.table_name = 'league'

SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1

SELECT * FROM `league` WHERE `league`.`isPositionEnabled`=1

SELECT * FROM `season` ORDER BY `createdAt` DESC

SHOW FULL COLUMNS FROM `season`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'season' AND kcu.table_name = 'season'

SELECT `tournament`.* FROM `tournament` LEFT JOIN `league` ON `tournament`.`leagueId` = `league`.`leagueId` WHERE (`tournament`.`leagueId`=1) AND (`tournament`.`type`=1) AND (`tournament`.`seasonId`=10) ORDER BY `tournamentId` DESC

SHOW FULL COLUMNS FROM `tournament`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tournament' AND kcu.table_name = 'tournament'

SELECT * FROM `league` WHERE `leagueId`=1

SELECT DISTINCT * FROM `tournamentTeamPosition` WHERE `tournamentTeamPosition`.`tournamentId`=43 ORDER BY `tournamentTeamPosition`.`winCount` DESC, `tournamentTeamPosition`.`scores` DESC, `tournamentTeamPosition`.`kf1` DESC, `tournamentTeamPosition`.`kf2` DESC

SHOW FULL COLUMNS FROM `tournamentTeamPosition`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'tournamentTeamPosition' AND kcu.table_name = 'tournamentTeamPosition'

SELECT * FROM `league`

SELECT * FROM `tournament` WHERE `leagueId`=1

SELECT * FROM `tournament` WHERE `leagueId`=2

SELECT * FROM `tournament` WHERE `leagueId`=3

SELECT * FROM `tournament` WHERE `leagueId`=4

SELECT * FROM `season` ORDER BY `createdAt` DESC

SHOW FULL COLUMNS FROM `team`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'team' AND kcu.table_name = 'team'

SELECT * FROM `team` WHERE `teamId`=5

SELECT * FROM `team` WHERE `teamId`=10

SELECT * FROM `team` WHERE `teamId`=6

SELECT * FROM `team` WHERE `teamId`=38

SELECT * FROM `team` WHERE `teamId`=14

SELECT * FROM `team` WHERE `teamId`=17

SELECT * FROM `team` WHERE `teamId`=8

SELECT * FROM `team` WHERE `teamId`=9

SELECT * FROM `team` WHERE `teamId`=1

SELECT * FROM `team` WHERE `teamId`=13

SELECT * FROM `team` WHERE `teamId`=43

SELECT * FROM `team` WHERE `teamId`=12

SELECT * FROM `team` WHERE `teamId`=11

SELECT * FROM `team` WHERE `teamId`=15

SELECT * FROM `team` WHERE `teamId`=7

SELECT * FROM `team` WHERE `teamId`=57