Database

SELECT * FROM `ut_coaches` WHERE `slug`='2301-sergej-filippenkov'

SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1741648415) AND ((`EndDate` > 1741648415) OR (`EndDate`=0))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:35') AND ((`end_date` >= '2025-03-11 02:13:35') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

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

SELECT * FROM `ad_photos` WHERE `ad_id`=5

SELECT * FROM `ad_logos` WHERE `ad_id`=5

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:35') AND ((`end_date` >= '2025-03-11 02:13:35') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

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

SELECT * FROM `ad_photos` WHERE `ad_id`=598

SELECT * FROM `ad_logos` WHERE `ad_id`=598

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1'

SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1741648415) AND (`bottomImage` <> '') AND ((`EndDate` > 1741648415) OR (`EndDate`=0)) AND (`useBottom`=1)

SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `SectionID`=1

SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE `MenuID`='1'

SELECT `MenuID`, `Parent` FROM `en_menu_new` WHERE (`Url`='coaches/2301-sergej-filippenkov') AND (`Parent`='1266')

SELECT * FROM `ut_coaches` WHERE `slug`=2301

SELECT * FROM `nut_news_persons` WHERE (`PersonID`=2301) AND (`Type`='c')

SELECT COUNT(*) FROM `nut_news` WHERE `NewsID` IN (445486, 445560, 445618)

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT id, Date FROM ( (SELECT CONCAT('a',nut_articles.ArticleID) AS id, Date FROM `nut_articles` INNER JOIN nut_articles_persons ON nut_articles_persons.ArticleID = nut_articles.ArticleID WHERE (`Active`=1) AND nut_articles_persons.PersonID = 2301 AND nut_articles_persons.`Type`='c' GROUP BY nut_articles.`ArticleID` ORDER BY `Pinned` DESC, nut_articles.`Date` DESC LIMIT 1000) UNION ALL (SELECT CONCAT('p',nut_posts.PostID) AS id, Date FROM `nut_posts` INNER JOIN nut_posts_persons ON nut_posts_persons.PostID = nut_posts.PostID WHERE (`status`=2) AND nut_posts_persons.PersonID = 2301 AND nut_posts_persons.`Type`='c' GROUP BY nut_posts.`PostID` ORDER BY nut_posts.`Date` DESC LIMIT 1000) ) material

SELECT `ut_matches`.* FROM `ut_matches` LEFT JOIN `ut_teams` `t1` ON `ut_matches`.`TeamID1` = `t1`.`TeamID` LEFT JOIN `ut_teams` `t2` ON `ut_matches`.`TeamID2` = `t2`.`TeamID` LEFT JOIN `ut_tournaments` ON `ut_matches`.`TournamentID` = `ut_tournaments`.`TournamentID` LEFT JOIN `ut_tours` ON `ut_matches`.`Tour` = `ut_tours`.`TourID` WHERE ((ut_matches.CoachID1 = 2301) OR (ut_matches.CoachID2 = 2301)) AND ((ut_matches.Date>unix_timestamp()-30*86400) AND (ut_matches.Date<unix_timestamp()))

select distinct m.TournamentID,concat(t.Name_rus,' ',if(StartYear=EndYear,StartYear,concat(StartYear,'/',EndYear))) as Name from ut_matches m inner join ut_tournaments t on m.TournamentID=t.TournamentID inner join ut_seasons s on t.SeasonID=s.SeasonID where 2301 in (m.CoachID1,m.CoachID2) order by s.StartYear desc,t.Name_rus asc

select t.Name_rus as Team, t.TeamID as TeamID, count(m.MatchID) as Games, sum(if( (m.TeamID1=t.TeamID and m.Goals1 > m.Goals2) or (m.TeamID2=t.TeamID and m.Goals2 > m.Goals1) , 1, 0)) as Wins, sum(if( (m.TeamID1=t.TeamID and m.Goals1 < m.Goals2) or (m.TeamID2=t.TeamID and m.Goals2 < m.Goals1) , 1, 0)) as Lose, sum(if( (m.TeamID1=t.TeamID and m.Goals1 = m.Goals2) or (m.TeamID2=t.TeamID and m.Goals2 = m.Goals1) , 1, 0)) as Draw from ut_matches m inner join ut_teams t on t.TeamID=if(m.CoachID1=2301, m.TeamID1, m.TeamID2) where m.TournamentID='825' and 2301 in (m.CoachID1, m.CoachID2) group by t.TeamID order by t.Name_rus

SELECT `ut_matches`.* FROM `ut_matches` LEFT JOIN `ut_teams` `t1` ON `ut_matches`.`TeamID1` = `t1`.`TeamID` LEFT JOIN `ut_teams` `t2` ON `ut_matches`.`TeamID2` = `t2`.`TeamID` WHERE (`TournamentID`='825') AND ((`CoachID1`=2301) OR (`CoachID2`=2301))

SELECT * FROM `ut_teams` `t1` WHERE `TeamID` IN (1468, 1104, 2771, 99, 391, 2889, 1097)

SELECT * FROM `ut_teams` `t2` WHERE `TeamID` IN (1100, 1468, 9, 3085, 2898, 1469, 77, 433)

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `ut_teams` WHERE `CoachID`=2301

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `ut_teams` WHERE (`TypeID`=0) AND (`CoachID`=2301)

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `ut_banners` WHERE ((`TypeID`=6) AND (`OnAllSite`=1)) AND (`StartDate` < 1741648416) AND ((`EndDate` > 1741648416) OR (`EndDate`=0))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_7') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ut_teams` WHERE (`TypeID`=0) AND (`CoachID`=2301)

SELECT * FROM `ut_teams` WHERE (`TypeID`=1) AND (`CoachID`=2301)

SELECT * FROM `ut_countries` WHERE `CountryID`=129

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=49

SELECT * FROM `ad_photos` WHERE `ad_id`=165

SELECT * FROM `ad_logos` WHERE `ad_id`=165

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_49') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_49'

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT `nut_news`.* FROM `nut_news` LEFT JOIN `nut_news_persons` ON `nut_news`.`NewsID` = `nut_news_persons`.`NewsID` WHERE (`nut_news_persons`.`PersonID`=2301) AND (`Type`='c') AND (`Active`=1) ORDER BY `Date` DESC LIMIT 30

SELECT * FROM `nut_news_persons` WHERE `NewsID` IN (445618, 445560, 445486)

SELECT * FROM `nut_content_type` WHERE 0=1

SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=445618)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=825

SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=7)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0

SELECT * FROM `ut_news_categories` WHERE `CategoryID`=217

SELECT * FROM `nut_news_teams` WHERE `NewsID`=445618

SELECT * FROM `ut_teams` WHERE `TeamID`=1468

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `nut_content_type` WHERE 0=1

SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=445560)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=825

SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=7)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0

SELECT * FROM `ut_news_categories` WHERE `CategoryID`=217

SELECT * FROM `nut_news_teams` WHERE `NewsID`=445560

SELECT * FROM `ut_teams` WHERE `TeamID`=1468

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT * FROM `nut_content_type` WHERE 0=1

SELECT * FROM `ut_news_comments` WHERE ((`ut_news_comments`.`Actual`=1) AND (`ut_news_comments`.`TypeID`=1)) AND (`MaterialID`=445486)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=825

SELECT * FROM `ut_sections` WHERE (NOT (`SectionID`=1)) AND (`DivisionID`=7)

SELECT * FROM `ut_tournaments` WHERE `TournamentID`=0

SELECT * FROM `ut_news_categories` WHERE `CategoryID`=217

SELECT * FROM `nut_news_teams` WHERE `NewsID`=445486

SELECT * FROM `ut_teams` WHERE `TeamID`=1468

SELECT * FROM `ut_coaches` WHERE `CoachID`=2301

SELECT COUNT(*) FROM `nut_news` LEFT JOIN `nut_news_persons` ON `nut_news`.`NewsID` = `nut_news_persons`.`NewsID` WHERE (`nut_news_persons`.`PersonID`=2301) AND (`Type`='c') AND (`Active`=1)

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=57

SELECT * FROM `ad_photos` WHERE `ad_id`=300

SELECT * FROM `ad_logos` WHERE `ad_id`=300

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_57') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_30') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_35') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=17

SELECT * FROM `ad_photos` WHERE `ad_id`=303

SELECT * FROM `ad_logos` WHERE `ad_id`=303

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_17') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT * FROM `ad_places` WHERE `id`=17

SELECT * FROM `ad_photos` WHERE `ad_id`=599

SELECT * FROM `ad_logos` WHERE `ad_id`=599

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_17'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

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

SELECT * FROM `ad_photos` WHERE `ad_id`=5

SELECT * FROM `ad_logos` WHERE `ad_id`=5

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_1') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

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

SELECT * FROM `ad_photos` WHERE `ad_id`=598

SELECT * FROM `ad_logos` WHERE `ad_id`=598

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_1'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=16

SELECT * FROM `ad_photos` WHERE `ad_id`=159

SELECT * FROM `ad_logos` WHERE `ad_id`=159

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_16') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT * FROM `ad_places` WHERE `id`=16

SELECT * FROM `ad_photos` WHERE `ad_id`=597

SELECT * FROM `ad_logos` WHERE `ad_id`=597

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_16'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=48

SELECT * FROM `ad_photos` WHERE `ad_id`=305

SELECT * FROM `ad_logos` WHERE `ad_id`=305

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_48') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_48'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_61') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `blocks_in_column` WHERE `desktop_column_order`=3 ORDER BY `desktop_block_order`

SELECT * FROM `blocks_in_column` WHERE `name`='main_news'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_34') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ad_places` WHERE `id`=11

SELECT * FROM `ad_photos` WHERE `ad_id`=207

SELECT * FROM `ad_logos` WHERE `ad_id`=207

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_11') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=TRUE))

SELECT * FROM `blocks_in_column` WHERE `name`='ad_place_11'

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_25') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_55') AND (`start_date` <= '2025-03-11 02:13:36') AND ((`end_date` >= '2025-03-11 02:13:36') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))