Database Queries

SHOW FULL COLUMNS FROM `hdbk_referee`

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 = 'hdbk_referee' AND kcu.table_name = 'hdbk_referee'

SELECT * FROM `hdbk_referee` WHERE `referee_id`=4139

SELECT `hdbk_season`.* FROM `hdbk_season` INNER JOIN `tournament` `t` ON t.season_id = hdbk_season.season_id INNER JOIN `tournament_referee` `tr` ON tr.tournament_id = t.tournament_id WHERE `tr`.`referee_id`=4139 ORDER BY `hdbk_season`.`start_dt` DESC, `hdbk_season`.`season_id` DESC

SHOW FULL COLUMNS FROM `hdbk_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 = 'hdbk_season' AND kcu.table_name = 'hdbk_season'

SELECT * FROM `tournament_referee` `tr` WHERE `referee_id`=4139

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`tournament_id` IN ('159', '239', '241', '245', '279', '282', '288', '346', '348', '364', '378', '379', '404', '417', '431', '437', '449', '461', '481', '491', '502', '547', '558')) ORDER BY `start_dt` 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 referee_id, season_id, tournament_id, sum(games) as games, sum(games_second) as games_second, sum(games_third) as games_third, sum(games_chron) as games_chron FROM stats_referee as sr WHERE referee_id = 4139 GROUP BY season_id

SHOW FULL COLUMNS FROM `stats_referee`

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 = 'stats_referee' AND kcu.table_name = 'stats_referee'

SELECT referee_id, season_id, tournament_id, sum(games) as games, sum(games_second) as games_second, sum(games_third) as games_third, sum(games_chron) as games_chron FROM stats_referee as sr WHERE referee_id = 4139

SELECT * FROM `tag` WHERE (`module`='referee') AND (`item_id`=4139)

SELECT * FROM `hdbk_country` WHERE `country_id`=219

SHOW FULL COLUMNS FROM `hdbk_country`

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 = 'hdbk_country' AND kcu.table_name = 'hdbk_country'

SELECT * FROM `hdbk_referee_category` WHERE `category_id`=''

SHOW FULL COLUMNS FROM `settings`

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 = 'settings' AND kcu.table_name = 'settings'

SELECT * FROM `settings` WHERE `id`=1

SELECT * FROM `tournament` WHERE (`in_competition_nav`=1) AND (`tournament`.`in_ru`=1) AND (`tournament`.`is_published`=1) ORDER BY `order`

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

SELECT * FROM `tournament` WHERE `parent_tournament_id`=1 ORDER BY `start_dt` DESC

SELECT `hdbk_competition`.* FROM `hdbk_competition` INNER JOIN `tournament` ON `hdbk_competition`.`competition_id` = `tournament`.`competition_id` WHERE (`hdbk_competition`.`in_ru`=1) AND (NOT (`in_main_menu_position` IS NULL)) AND (`is_published`=1) ORDER BY `in_main_menu_position`, `rank`, isnull(`order`), `order`, `start_dt` DESC

SHOW FULL COLUMNS FROM `hdbk_competition`

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 = 'hdbk_competition' AND kcu.table_name = 'hdbk_competition'

SELECT * FROM `tournament` WHERE `competition_id`=36 ORDER BY isnull(`order`), `order`, `start_dt` DESC

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=36) ORDER BY isnull(`order`), `order`, `start_dt` DESC

SELECT `tournament`.* FROM `tournament` INNER JOIN `round` ON `tournament`.`tournament_id` = `round`.`tournament_id` WHERE (`tournament`.`in_ru`=1) AND ((`parent_tournament_id` IS NULL) AND (`competition_id`=36) AND (`is_published`=1)) ORDER BY `tournament`.`order`, `tournament`.`start_dt`, `round`.`order`

SELECT * FROM `round` WHERE `tournament_id` IN (565, 567, 376, 180, 568, 569, 570) ORDER BY `round`.`order`

SHOW FULL COLUMNS FROM `round`

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 = 'round' AND kcu.table_name = 'round'

SELECT `parent`.* FROM `tournament` `parent` INNER JOIN `tournament` `child` ON `parent`.`tournament_id` = `child`.`parent_tournament_id` INNER JOIN `round` ON `child`.`tournament_id` = `round`.`tournament_id` WHERE ((`parent`.`competition_id`=36) AND (`parent`.`is_published`=1) AND (`child`.`is_published`=1)) AND (`parent`.`in_ru`=1) AND (`child`.`in_ru`=1) ORDER BY `parent`.`order`, `child`.`order`, `child`.`start_dt`, `round`.`order`

SELECT `hdbk_competition`.* FROM `hdbk_competition` INNER JOIN `tournament` ON `hdbk_competition`.`competition_id` = `tournament`.`competition_id` WHERE (`hdbk_competition`.`in_ru`=1) AND (NOT (`hdbk_competition`.`competition_id`=36)) AND (`is_published`=1) ORDER BY `rank`, isnull(`order`), `order`, `start_dt` DESC

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id` IN (53, 70, 48, 68, 67, 10, 65, 64, 33, 41, 40, 62, 66, 60, 61, 59, 54, 50, 47, 58, 8, 20, 51, 57, 32, 56, 37, 14, 55, 13, 52, 49, 46, 45, 44, 18, 39, 30, 22, 35, 34, 24, 29, 28, 27, 26, 25, 21, 23, 19, 17, 15, 11, 9, 4, 12, 74, 6, 5, 2, 63, 31, 7, 79, 78, 81, 72, 75, 73, 77, 76)) ORDER BY isnull(`order`), `order`, `start_dt` DESC

SELECT * FROM `tournament` WHERE `tournament_id`=587

SELECT * FROM `hdbk_competition` WHERE `competition_id`=21

SELECT * FROM `tournament` WHERE `tournament_id`=588

SELECT * FROM `hdbk_competition` WHERE `competition_id`=61

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

SELECT * FROM `hdbk_competition` WHERE `competition_id`=2

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=36) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=565

SELECT * FROM `hdbk_competition` WHERE `competition_id`=36

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=565 ORDER BY `start_dt` DESC) `c`

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=567 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=567

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=376 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=376

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=180 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=180

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=568 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=568

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=569 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=569

SELECT COUNT(*) FROM (SELECT * FROM `tournament` WHERE `parent_tournament_id`=570 ORDER BY `start_dt` DESC) `c`

SELECT * FROM `tournament` WHERE `tournament_id`=570

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=53) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=481

SELECT * FROM `hdbk_competition` WHERE `competition_id`=53

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=70) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=458

SELECT * FROM `hdbk_competition` WHERE `competition_id`=70

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=48) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=586

SELECT * FROM `hdbk_competition` WHERE `competition_id`=48

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=68) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=451

SELECT * FROM `hdbk_competition` WHERE `competition_id`=68

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=67) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=445

SELECT * FROM `hdbk_competition` WHERE `competition_id`=67

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=10) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=549

SELECT * FROM `hdbk_competition` WHERE `competition_id`=10

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=65) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=435

SELECT * FROM `hdbk_competition` WHERE `competition_id`=65

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=64) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=433

SELECT * FROM `hdbk_competition` WHERE `competition_id`=64

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=33) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=426

SELECT * FROM `hdbk_competition` WHERE `competition_id`=33

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=41) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=544

SELECT * FROM `hdbk_competition` WHERE `competition_id`=41

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=40) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=501

SELECT * FROM `hdbk_competition` WHERE `competition_id`=40

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=62) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=502

SELECT * FROM `hdbk_competition` WHERE `competition_id`=62

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=66) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=441

SELECT * FROM `hdbk_competition` WHERE `competition_id`=66

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=60) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=408

SELECT * FROM `hdbk_competition` WHERE `competition_id`=60

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=61) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=59) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=406

SELECT * FROM `hdbk_competition` WHERE `competition_id`=59

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=54) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=383

SELECT * FROM `hdbk_competition` WHERE `competition_id`=54

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=50) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=391

SELECT * FROM `hdbk_competition` WHERE `competition_id`=50

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=47) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=389

SELECT * FROM `hdbk_competition` WHERE `competition_id`=47

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=58) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=385

SELECT * FROM `hdbk_competition` WHERE `competition_id`=58

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=8) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=461

SELECT * FROM `hdbk_competition` WHERE `competition_id`=8

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=20) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=564

SELECT * FROM `hdbk_competition` WHERE `competition_id`=20

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=51) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=372

SELECT * FROM `hdbk_competition` WHERE `competition_id`=51

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=57) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=370

SELECT * FROM `hdbk_competition` WHERE `competition_id`=57

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=32) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=362

SELECT * FROM `hdbk_competition` WHERE `competition_id`=32

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=56) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=353

SELECT * FROM `hdbk_competition` WHERE `competition_id`=56

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=37) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=306

SELECT * FROM `hdbk_competition` WHERE `competition_id`=37

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=14) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=346

SELECT * FROM `hdbk_competition` WHERE `competition_id`=14

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=55) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=344

SELECT * FROM `hdbk_competition` WHERE `competition_id`=55

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=13) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=342

SELECT * FROM `hdbk_competition` WHERE `competition_id`=13

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=52) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=310

SELECT * FROM `hdbk_competition` WHERE `competition_id`=52

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=49) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=300

SELECT * FROM `hdbk_competition` WHERE `competition_id`=49

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=46) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=294

SELECT * FROM `hdbk_competition` WHERE `competition_id`=46

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=45) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=290

SELECT * FROM `hdbk_competition` WHERE `competition_id`=45

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=44) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=285

SELECT * FROM `hdbk_competition` WHERE `competition_id`=44

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=18) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=214

SELECT * FROM `hdbk_competition` WHERE `competition_id`=18

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=39) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=245

SELECT * FROM `hdbk_competition` WHERE `competition_id`=39

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=30) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=241

SELECT * FROM `hdbk_competition` WHERE `competition_id`=30

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=22) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=186

SELECT * FROM `hdbk_competition` WHERE `competition_id`=22

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=35) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=170

SELECT * FROM `hdbk_competition` WHERE `competition_id`=35

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=34) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=165

SELECT * FROM `hdbk_competition` WHERE `competition_id`=34

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=24) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=142

SELECT * FROM `hdbk_competition` WHERE `competition_id`=24

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=29) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=140

SELECT * FROM `hdbk_competition` WHERE `competition_id`=29

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=28) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=138

SELECT * FROM `hdbk_competition` WHERE `competition_id`=28

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=27) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=136

SELECT * FROM `hdbk_competition` WHERE `competition_id`=27

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=26) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=128

SELECT * FROM `hdbk_competition` WHERE `competition_id`=26

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=25) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=126

SELECT * FROM `hdbk_competition` WHERE `competition_id`=25

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=21) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=23) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=122

SELECT * FROM `hdbk_competition` WHERE `competition_id`=23

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=19) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=114

SELECT * FROM `hdbk_competition` WHERE `competition_id`=19

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=17) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=100

SELECT * FROM `hdbk_competition` WHERE `competition_id`=17

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=15) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=94

SELECT * FROM `hdbk_competition` WHERE `competition_id`=15

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=11) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=32

SELECT * FROM `hdbk_competition` WHERE `competition_id`=11

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=9) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=28

SELECT * FROM `hdbk_competition` WHERE `competition_id`=9

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=4) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=541

SELECT * FROM `hdbk_competition` WHERE `competition_id`=4

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=12) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=560

SELECT * FROM `hdbk_competition` WHERE `competition_id`=12

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=74) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=545

SELECT * FROM `hdbk_competition` WHERE `competition_id`=74

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=6) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=558

SELECT * FROM `hdbk_competition` WHERE `competition_id`=6

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=5) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=532

SELECT * FROM `hdbk_competition` WHERE `competition_id`=5

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=2) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=589

SELECT * FROM `hdbk_competition` WHERE `competition_id`=2

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=63) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=535

SELECT * FROM `hdbk_competition` WHERE `competition_id`=63

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=31) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=485

SELECT * FROM `hdbk_competition` WHERE `competition_id`=31

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=7) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=495

SELECT * FROM `hdbk_competition` WHERE `competition_id`=7

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=79) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=542

SELECT * FROM `hdbk_competition` WHERE `competition_id`=79

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=78) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=534

SELECT * FROM `hdbk_competition` WHERE `competition_id`=78

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=81) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=585

SELECT * FROM `hdbk_competition` WHERE `competition_id`=81

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=72) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=561

SELECT * FROM `hdbk_competition` WHERE `competition_id`=72

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=75) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=498

SELECT * FROM `hdbk_competition` WHERE `competition_id`=75

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=73) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=478

SELECT * FROM `hdbk_competition` WHERE `competition_id`=73

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=77) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=530

SELECT * FROM `hdbk_competition` WHERE `competition_id`=77

SELECT * FROM `tournament` WHERE (`is_published`=1) AND (`competition_id`=76) ORDER BY `start_dt` DESC, isnull(parent_tournament_id)

SELECT * FROM `tournament` WHERE `tournament_id`=523

SELECT * FROM `hdbk_competition` WHERE `competition_id`=76

SELECT COUNT(*) FROM hdbk_competition AS c INNER JOIN tournament AS t ON t.competition_id = c.competition_id INNER JOIN round AS r ON r.tournament_id = t.tournament_id

SELECT * FROM `page` WHERE `page`.`alias`='confidentiality'

SHOW FULL COLUMNS FROM `page`

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 = 'page' AND kcu.table_name = 'page'

SELECT * FROM `page` WHERE `page`.`alias`='use_info'

SELECT COUNT(*) FROM `partner`