Database Queries

SELECT `post`.`post_id`, `post`.`type`, `post`.`title`, `post`.`title_en`, `post`.`lead`, `post`.`lead_en`, `post`.`marker`, `post`.`translite`, `post`.`image`, `post`.`author`, `post`.`author_en`, `post`.`position_id`, `post`.`position_en_id`, `post`.`published_dt`, `post`.`in_ru`, `post`.`in_en`, `post`.`super_title`, `post`.`super_title_en`, `post`.`super_lead`, `post`.`super_lead_en`, `post`.`super_image` FROM `post` WHERE (`post`.`type`='article') AND (`post`.`is_public`=1) AND (`post`.`in_ru`=1) AND (`position_id`=1) ORDER BY `published_dt` DESC

SELECT `post`.`post_id`, `post`.`type`, `post`.`title`, `post`.`title_en`, `post`.`lead`, `post`.`lead_en`, `post`.`marker`, `post`.`translite`, `post`.`image`, `post`.`author`, `post`.`author_en`, `post`.`position_id`, `post`.`position_en_id`, `post`.`published_dt`, `post`.`in_ru`, `post`.`in_en`, `post`.`top_title`, `post`.`top_title_en` FROM `post` WHERE (`post`.`type`='article') AND (`post`.`is_public`=1) AND (`post`.`in_ru`=1) AND (`position_id` IN (2, 3)) ORDER BY `position_id`, `published_dt` DESC

SELECT * FROM `post_tag_assn` WHERE `post_id` IN (13330, 13336)

SELECT * FROM `tag` WHERE `tag_id` IN ('1536', '1953', '2035', '520', '522', '1823')

SELECT `post`.`post_id`, `post`.`type`, `post`.`title`, `post`.`title_en`, `post`.`lead`, `post`.`lead_en`, `post`.`marker`, `post`.`translite`, `post`.`image`, `post`.`author`, `post`.`author_en`, `post`.`position_id`, `post`.`position_en_id`, `post`.`published_dt`, `post`.`in_ru`, `post`.`in_en` FROM `post` WHERE (`post`.`type`='article') AND (`post`.`is_public`=1) AND (`post`.`in_ru`=1) AND (`position_id` IN (4, 5, 6, 7, 8, 9, 10, 11)) ORDER BY `position_id`, `published_dt` DESC

SELECT * FROM `post_tag_assn` WHERE `post_id` IN (13325, 13327, 13316, 13314, 13305, 13300, 13293, 13292)

SELECT * FROM `tag` WHERE `tag_id` IN ('517', '539', '1604', '1612', '1614', '1953', '1954', '2033', '1661', '587', '1975', '1641', '737', '1988', '523', '520', '571', '1888')

SELECT * FROM `settings`

SELECT * FROM `tag` WHERE `module`='competition'

SELECT `video`.* FROM `video` INNER JOIN `video_tag_assn` ON video_tag_assn.video_id = video.video_id WHERE (`video`.`is_public`=1) AND (`video`.`on_main`=TRUE) AND (`video_tag_assn`.`tag_id` IN (1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1587, 1588, 1589, 1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1598, 1599, 1600, 1601, 1602, 1642, 1706, 1714, 1762, 1811, 1860, 1868, 1873, 1897, 1945, 2027)) AND (`video`.`in_ru`=1) ORDER BY `published_dt` DESC LIMIT 10

SHOW FULL COLUMNS FROM `video`

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

SELECT * FROM `video_tag_assn` WHERE `video_id` IN (1003, 1001, 1000, 999, 998, 997, 991, 996, 995, 994)

SELECT * FROM `tag` WHERE `tag_id` IN ('674', '1568', '1993', '2010', '517', '539', '556', '867', '1992', '838', '842', '112', '702', '1552', '1625', '1953', '1975', '1551')

SELECT * FROM `tag` WHERE `module`='competition'

SELECT `album`.* FROM `album` INNER JOIN `album_tag_assn` ON album_tag_assn.album_id = album.album_id WHERE (`album`.`is_public`=1) AND (`album`.`on_main`=TRUE) AND (`album_tag_assn`.`tag_id` IN (1535, 1536, 1537, 1538, 1539, 1540, 1541, 1542, 1543, 1544, 1545, 1546, 1547, 1548, 1549, 1550, 1551, 1552, 1553, 1554, 1555, 1556, 1557, 1558, 1559, 1560, 1561, 1562, 1563, 1564, 1565, 1566, 1567, 1568, 1569, 1570, 1571, 1572, 1573, 1574, 1575, 1576, 1577, 1578, 1579, 1580, 1581, 1582, 1583, 1584, 1585, 1586, 1587, 1588, 1589, 1590, 1591, 1592, 1593, 1594, 1595, 1596, 1597, 1598, 1599, 1600, 1601, 1602, 1642, 1706, 1714, 1762, 1811, 1860, 1868, 1873, 1897, 1945, 2027)) AND (DATE_FORMAT(published_dt, "%Y-%m-%d") > '2024-07-17') AND (`album`.`in_ru`=1) ORDER BY `published_dt` DESC LIMIT 10

SELECT COUNT(*) FROM (SELECT `vote`.* FROM `vote` INNER JOIN `vote_option` ON `vote`.`vote_id` = `vote_option`.`vote_id` WHERE (`status`='published') AND (UNIX_TIMESTAMP(vote.published_dt) <= 1737074520) AND (`vote`.`in_ru`=1) AND (`on_main`=1) GROUP BY `vote`.`vote_id` ORDER BY `vote`.`published_dt` DESC, `place`, `option_id`) `c`

SELECT `vote`.* FROM `vote` INNER JOIN `vote_option` ON `vote`.`vote_id` = `vote_option`.`vote_id` WHERE (`status`='published') AND (UNIX_TIMESTAMP(vote.published_dt) <= 1737074520) AND (`vote`.`in_ru`=1) AND (`on_main`=1) GROUP BY `vote`.`vote_id` ORDER BY `vote`.`published_dt` DESC, `place`, `option_id` LIMIT 5

SELECT * FROM `brand` WHERE (`is_public`=1) AND ((`position`='main') AND (`lang`='ru')) ORDER BY `created_at` DESC

SHOW FULL COLUMNS FROM `brand`

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

SELECT `match`.`start_dt` FROM `match` INNER JOIN `tournament` ON `match`.`tournament_id` = `tournament`.`tournament_id` WHERE (`match`.`start_dt` < '2025-01-16 05:00:00') AND (`tournament`.`in_schedule`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_ru`=1) ORDER BY `match`.`start_dt` DESC LIMIT 1

SELECT `match`.`start_dt` FROM `match` INNER JOIN `tournament` ON `match`.`tournament_id` = `tournament`.`tournament_id` WHERE (`match`.`start_dt` > '2025-01-17 05:00:00') AND (`tournament`.`in_schedule`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_ru`=1) ORDER BY `match`.`start_dt` LIMIT 1

SELECT `tournament`.* FROM `tournament` INNER JOIN `match` ON `tournament`.`tournament_id` = `match`.`tournament_id` WHERE (`tournament`.`in_ru`=1) AND (`tournament`.`is_published`=1) AND (`tournament`.`in_schedule`=1) AND ((NOT (`match`.`start_dt` IS NULL)) AND ((NOT (`team1_id` IS NULL)) OR (NOT (`team1_placeholder` IS NULL))) AND ((NOT (`team2_id` IS NULL)) OR (NOT (`team2_placeholder` IS NULL))) AND (`match`.`start_dt` BETWEEN '2022-04-08 05:00:00' AND '2025-01-17 05:00:00')) ORDER BY `tournament`.`order`, `tournament`.`full_name`

SELECT * FROM `hdbk_category` WHERE `category_id`=3

SELECT * FROM `match` WHERE (NOT (`match`.`start_dt` IS NULL)) AND ((NOT (`team1_id` IS NULL)) OR (NOT (`team1_placeholder` IS NULL))) AND ((NOT (`team2_id` IS NULL)) OR (NOT (`team2_placeholder` IS NULL))) AND (`match`.`start_dt` BETWEEN '2022-04-08 05:00:00' AND '2025-01-17 05:00:00') AND (`tournament_id`=587)

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

SELECT * FROM `team` WHERE `team_id`=682

SELECT * FROM `post_match_assn` WHERE (`main`=1) AND (`match_id`=9850)

SELECT * FROM `album_match_assn` WHERE (`main`=1) AND (`match_id`=9850)

SELECT * FROM `video_match_assn` WHERE (`main`=1) AND (`match_id`=9850)

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

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

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

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='scoreboard') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-main-events') ORDER BY `number`, `banner_id` DESC

SHOW FULL COLUMNS FROM `banner`

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

SELECT * FROM `post` WHERE (`post`.`type`='news') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) AND (NOT (`position_id` IS NULL)) ORDER BY `position_id`

SELECT * FROM `post_tag_assn` WHERE `post_id` IN (13333, 13335, 13328, 13323, 13317)

SELECT * FROM `tag` WHERE `tag_id` IN ('737', '1988', '520', '522', '1823', '539', '2033', '1953', '826', '1724')

SELECT * FROM `post` WHERE `post_id`=13333

SELECT * FROM `post` WHERE `post_id`=13335

SELECT * FROM `post` WHERE `post_id`=13328

SELECT * FROM `post` WHERE `post_id`=13323

SELECT * FROM `post` WHERE `post_id`=13317

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-main-events') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-main-tournament') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `settings`

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-main-tournament') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-world-rating') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `world_rating` WHERE `type`='men' ORDER BY `year` DESC, `month` DESC

SHOW FULL COLUMNS FROM `world_rating`

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

SELECT * FROM `world_rating_team` WHERE `rating_id`=24 ORDER BY `place`, `points` DESC

SELECT * FROM `settings`

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-world-rating') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-before-news') ORDER BY `number`, `banner_id` DESC

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

SELECT `post`.`post_id`, `post`.`type`, `post`.`title`, `post`.`title_en`, `post`.`lead`, `post`.`lead_en`, `post`.`marker`, `post`.`translite`, `post`.`image`, `post`.`author`, `post`.`author_en`, `post`.`position_id`, `post`.`position_en_id`, `post`.`published_dt`, `post`.`in_ru`, `post`.`in_en`, `post`.`top_title`, `post`.`top_title_en` FROM `post` WHERE (`post`.`type`='news') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) ORDER BY `published_dt` DESC LIMIT 10

SELECT * FROM `post_tag_assn` WHERE `post_id` IN (13347, 13343, 13345, 13342, 13341, 13340, 13335, 13333, 13331, 13329)

SELECT * FROM `tag` WHERE `tag_id` IN ('523', '1661', '539', '1612', '2033', '1953', '826', '1724', '1601', '1770', '1771', '454', '1597')

SELECT `post`.`post_id`, `post`.`type`, `post`.`title`, `post`.`title_en`, `post`.`lead`, `post`.`lead_en`, `post`.`marker`, `post`.`translite`, `post`.`image`, `post`.`author`, `post`.`author_en`, `post`.`position_id`, `post`.`position_en_id`, `post`.`published_dt`, `post`.`in_ru`, `post`.`in_en`, `post`.`top_title`, `post`.`top_title_en` FROM `post` WHERE (`post`.`type`='article') AND (`post`.`in_ru`=1) AND (`post`.`is_public`=1) ORDER BY `published_dt` DESC LIMIT 0

SELECT * FROM `post` WHERE `post_id`=13347

SELECT * FROM `post` WHERE `post_id`=13343

SELECT * FROM `post` WHERE `post_id`=13345

SELECT * FROM `post` WHERE `post_id`=13342

SELECT * FROM `post` WHERE `post_id`=13341

SELECT * FROM `post` WHERE `post_id`=13340

SELECT * FROM `post` WHERE `post_id`=13335

SELECT * FROM `post` WHERE `post_id`=13333

SELECT * FROM `post` WHERE `post_id`=13331

SELECT * FROM `post` WHERE `post_id`=13329

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='sb-after-news') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `post` WHERE `post_id`=13330

SELECT * FROM `post` WHERE `post_id`=13330

SELECT * FROM `post` WHERE `post_id`=13336

SELECT * FROM `post` WHERE `post_id`=13336

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='main-before-news') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `post` WHERE `post_id`=13325

SELECT * FROM `post` WHERE `post_id`=13327

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='main-after-news') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `post` WHERE `post_id`=13316

SELECT * FROM `post` WHERE `post_id`=13314

SELECT * FROM `banner` WHERE (`is_public`=1) AND (`position`='main-before-articles') ORDER BY `number`, `banner_id` DESC

SELECT * FROM `post` WHERE `post_id`=13305

SELECT * FROM `post` WHERE `post_id`=13300

SELECT * FROM `post` WHERE `post_id`=13293

SELECT * FROM `post` WHERE `post_id`=13292

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

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`