Database Queries

SELECT * FROM `hdbk_competition` WHERE `alias`='profiles'

SELECT * FROM `tournament` WHERE `alias`='persons'

SHOW FULL COLUMNS FROM `player`

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

SELECT * FROM `player` WHERE `player_id`=3362

SELECT * FROM `team_player` WHERE (`player_id`=3362) AND (`team_id`=9) ORDER BY `in`

SHOW FULL COLUMNS FROM `team_player`

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

SELECT sp.player_id, sp.season_id, sp.competition_id, sp.team_id, sp.tournament_id, sum(games) as games, sum(goals) as goals, sum(freekick_goals) as freekick_goals, sum(penalties) as penalties, sum(assists) as assists, sum(second_assists) as second_assists, sum(shoots) as shoots, sum(shoots_target) as shoots_target, sum(biciclets) as biciclets, sum(freekicks) as freekicks, sum(plus_minus) as plus_minus, sum(fouls) as fouls, sum(corners) as corners, sum(shoots_block) as shoots_block, sum(yellow_cards) as yellow_cards, sum(red_cards) as red_cards, sum(saves) as saves, sum(gk_shoots_target) as gk_shoots_target, sum(gk_shoots_postbar) as gk_shoots_postbar, sum(missed_goals) as missed_goals FROM stats_player as sp INNER JOIN hdbk_season as s ON s.season_id = sp.season_id INNER JOIN tournament as t ON t.tournament_id = sp.tournament_id WHERE sp.player_id = 3362 AND t.is_unofficial = 0 ORDER BY s.start_dt DESC, s.season_id DESC

SHOW FULL COLUMNS FROM `stats_player`

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

SELECT * FROM `tag` WHERE (`module`='player') AND (`item_id`=3362)

SELECT `hdbk_season`.* FROM `hdbk_season` INNER JOIN `tournament` `t` ON t.season_id = hdbk_season.season_id INNER JOIN `tournament_team_player` `ttp` ON ttp.tournament_id = t.tournament_id WHERE (`ttp`.`player_id`=3362) AND (`ttp`.`status`='approved') 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 sp.player_id, sp.season_id, sp.competition_id, sp.team_id, sp.tournament_id, sum(games) as games, sum(goals) as goals, sum(freekick_goals) as freekick_goals, sum(penalties) as penalties, sum(assists) as assists, sum(second_assists) as second_assists, sum(shoots) as shoots, sum(shoots_target) as shoots_target, sum(biciclets) as biciclets, sum(freekicks) as freekicks, sum(plus_minus) as plus_minus, sum(fouls) as fouls, sum(corners) as corners, sum(shoots_block) as shoots_block, sum(yellow_cards) as yellow_cards, sum(red_cards) as red_cards, sum(saves) as saves, sum(gk_shoots_target) as gk_shoots_target, sum(gk_shoots_postbar) as gk_shoots_postbar, sum(missed_goals) as missed_goals FROM stats_player as sp INNER JOIN hdbk_season as s ON s.season_id = sp.season_id INNER JOIN tournament as t ON t.tournament_id = sp.tournament_id WHERE sp.player_id = 3362 AND t.is_unofficial = 0 GROUP BY sp.season_id ORDER BY s.start_dt DESC, s.season_id DESC

SELECT * FROM `team_player` WHERE (`team_player`.`status`='accepted') AND (`player_id`=3362) ORDER BY `team_player`.`in` DESC

SELECT * FROM `team` WHERE `team_id` IN (4, 49, 432, 608, 495, 531) ORDER BY `team`.`is_national` DESC

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

SELECT * FROM `hdbk_country` WHERE 0=1

SELECT * FROM `team_player` WHERE (`player_id`=3362) AND (`team_id`=9) ORDER BY `in`

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'

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

SELECT COUNT(*) FROM `partner`