Database

SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1741648627) AND ((`EndDate` > 1741648627) 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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` < 1741648627) AND (`bottomImage` <> '') AND ((`EndDate` > 1741648627) 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`='profile/90112?page=17') AND (`Parent`='1266')

SELECT * FROM `ut_users` WHERE `UserID`='90112'

SELECT `ut_user_favorite_teams`.`RelationID`, `ut_teams`.`TeamID`, `ut_teams`.`Name_rus`, `ut_teams`.`YoungID`, `ut_teams`.`CountryID`, `ut_teams`.`TypeID`, `ut_sections`.`ShortName` AS `Section`, `ut_teams`.`DivisionID` FROM `ut_user_favorite_teams` join `ut_teams` ON ut_teams.TeamID=ut_user_favorite_teams.TeamID LEFT JOIN `ut_sections` ON ut_sections.CountryID=ut_teams.CountryID WHERE `ut_user_favorite_teams`.`UserID`=90112 GROUP BY `ut_teams`.`TeamID` ORDER BY `ut_user_favorite_teams`.`RelationID` LIMIT 5

SELECT `nut_articles`.* FROM `nut_articles` LEFT JOIN `nut_articles_authors` ON `nut_articles`.`ArticleID` = `nut_articles_authors`.`ArticleID` LEFT JOIN `ut_users` ON `nut_articles_authors`.`UserID` = `ut_users`.`UserID` WHERE (`nut_articles`.`Active`=1) AND (`nut_articles_authors`.`UserID`=90112) ORDER BY `nut_articles`.`Date` DESC

SELECT * FROM `nut_posts` WHERE (`Status`=2) AND (`UserID`=90112) ORDER BY `Date` DESC

SELECT `ut_news_comments`.`Message`, `ut_news_comments`.`TypeID`, `ut_news_comments`.`MaterialID`, `ut_news_comments`.`MarkPlus`, `ut_news_comments`.`MarkMinus`, `ut_news_comments`.`Date`, case(ut_news_comments.TypeID) WHEN 0 THEN nut_articles.Name_rus WHEN 1 THEN nut_news.Name_rus WHEN 2 THEN CONCAT(ut1.Name_rus, " - ", ut2.Name_rus) WHEN 3 THEN nut_posts.Name_rus END AS `Name_rus`, case(ut_news_comments.TypeID) WHEN 0 THEN CONCAT("/articles/", IF(nut_articles.Slug<>"",CONCAT(MaterialID, "-", LOWER(nut_articles.Slug)), MaterialID)) WHEN 1 AND MaterialID=461914 THEN "/predictions#comments"WHEN 1 AND MaterialID=472663 THEN "/events/finaleuro2016#comments"WHEN 1 THEN CONCAT("/news/", IF(nut_news.Slug<>"",CONCAT(MaterialID, "-", LOWER(nut_news.Slug)), MaterialID)) WHEN 2 THEN CONCAT("/online/", MaterialID) WHEN 3 THEN CONCAT("/posts/", MaterialID) END AS `Url`, (select COUNT(*) from ut_news_comments as u where u.ReplyCommentID=ut_news_comments.CommentID) AS `Replies`, (select SUM(ucm.Mark) from ut_comment_marks as ucm where ucm.CommentID=ut_news_comments.CommentID) AS `Vote`, `ut_users`.`UserID`, `ut_users`.`Login` FROM `ut_news_comments` LEFT JOIN `ut_users` ON ut_news_comments.UserID = ut_users.UserID LEFT JOIN `nut_articles` ON ut_news_comments.MaterialID = nut_articles.ArticleID LEFT JOIN `nut_news` ON ut_news_comments.MaterialID = nut_news.NewsID LEFT JOIN `nut_posts` ON ut_news_comments.MaterialID = nut_posts.PostID LEFT JOIN `ut_matches` ON ut_news_comments.MaterialID = ut_matches.MatchID LEFT JOIN `ut_teams` `ut1` ON ut1.TeamID = ut_matches.TeamID1 LEFT JOIN `ut_teams` `ut2` ON ut2.TeamID = ut_matches.TeamID2 WHERE (`ut_news_comments`.`Actual`=1) AND (`ut_users`.`UserID`='90112') ORDER BY `Date` DESC LIMIT 10

SELECT COUNT(*) FROM `ut_news_comments` WHERE ((`UserID`='90112') AND (`Actual`=1)) AND (`Date` > '1435698000') AND ((`MaterialID` < '20000') OR (`MaterialID` > '434400') OR (`MatchID` != '0'))

SHOW FULL COLUMNS FROM `ut_ban_ip`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `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` = 'ut_ban_ip' AND `kcu`.`TABLE_NAME` = 'ut_ban_ip'

SELECT * FROM `ut_ban_ip` WHERE `IP`=316567616

SELECT * FROM `ut_users` WHERE `UserID`=90112

SELECT `ut_user_favorite_teams`.`RelationID`, `ut_teams`.`TeamID`, `ut_teams`.`Name_rus`, `ut_teams`.`YoungID`, `ut_teams`.`CountryID`, `ut_teams`.`TypeID`, `ut_sections`.`ShortName` AS `Section`, `ut_teams`.`DivisionID` FROM `ut_user_favorite_teams` join `ut_teams` ON ut_teams.TeamID=ut_user_favorite_teams.TeamID LEFT JOIN `ut_sections` ON ut_sections.CountryID=ut_teams.CountryID WHERE `ut_user_favorite_teams`.`UserID`=90112 GROUP BY `ut_teams`.`TeamID` ORDER BY `ut_user_favorite_teams`.`RelationID` LIMIT 5

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

SELECT * FROM `ut_ban_ip` WHERE `IP`=316567616

SELECT * FROM `nut_predictions_archive` WHERE (`UserID`=90112) AND (`Rating` < 4) ORDER BY `Date` DESC

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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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 `ut_polls` WHERE (`ut_polls`.`StartDate` < 1741648627) AND (`ut_polls`.`EndDate` > 1741648627)

SELECT * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'ads4', 'all_news', 'ads2', 'ads30', 'polls', 'ads')

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

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

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

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

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

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

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

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

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

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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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`=4

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

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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') 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:17:07') AND ((`end_date` >= '2025-03-11 02:17:07') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))