Database

SELECT * FROM `ut_players` WHERE `slug`='34563-roman-hodunov'

SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') 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_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 * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`StartDate` < 1741648416) AND (`bottomImage` <> '') AND ((`EndDate` > 1741648416) 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`='player/34563-roman-hodunov/stats') AND (`Parent`='1266')

SELECT * FROM `ut_players` WHERE `PlayerID`=34563

SELECT * FROM `ut_position_types` WHERE `PositionID`=3

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

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

SELECT * FROM `ut_sections` WHERE `SectionID`=22

SELECT * FROM `ut_players` WHERE `PlayerID`=34563

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

SELECT * FROM `ut_divisions` WHERE `DivisionID`=1

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

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

SELECT * FROM `ut_players` WHERE `PlayerID`=34563

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_countries` `country1` WHERE `CountryID`=129

SELECT * FROM `ut_countries` `country2` WHERE `CountryID`=0

SELECT * FROM `nut_transfer_players` WHERE `PlayerID`=34563

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') 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`=50

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

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

SELECT `ads`.* FROM `ads` LEFT JOIN `ad_places` ON `ads`.`place_id` = `ad_places`.`id` WHERE (`ad_places`.`name`='place_50') 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_50'

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 `nut_news_persons` WHERE (`PersonID`=34563) AND (`Type`='p')

SELECT COUNT(*) FROM `nut_news` WHERE 0=1

SELECT * FROM `nut_articles_persons` WHERE (`PersonID`=34563) AND (`Type`='p')

SELECT COUNT(*) FROM `nut_articles` WHERE (0=1) AND (`Active`=1)

SELECT * FROM `nut_posts_persons` WHERE (`PersonID`=34563) AND (`Type`='p')

SELECT COUNT(*) FROM `nut_posts` WHERE 0=1

select t1.Name_rus as TeamName1, t2.Name_rus as TeamName2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.TeamID1, m.TeamID2, m.MatchID, t.TournamentID, t.Name_rus as Tournament, if(StartYear=EndYear,StartYear,concat(StartYear,'/',EndYear)) as Season, concat(t.TournamentID,'|',m.Tour), concat_ws(', ',t.Name_rus, if(r.Name_rus='',null,r.Name_rus), tr.Name, case m.Game when 1 then 'первый матч' when 2 then 'ответный матч' when 3 then 'повторный матч' else null end ) as TourName, m.MatchID as MatchID, m.Date as Date, max(mr.MarkType) MarkType, m.Duration Duration, subs.Minute as SubMinute from ut_marks as mr left join ut_matches as m using(MatchID) left join ut_teams t1 on t1.TeamID=m.TeamID1 left join ut_teams t2 on t2.TeamID=m.TeamID2 left join ut_tournaments t on m.TournamentID=t.TournamentID left join ut_seasons s on t.SeasonID=s.SeasonID left join ut_reglaments r on r.ReglamentID = m.ReglamentID left join ut_tours tr on m.Tour = tr.TourID and tr.IsDeleted = 0 left join ut_players p ON p.PlayerID=mr.PlayerID left join ut_subs subs ON subs.PlayerID2=mr.PlayerID AND subs.MatchID = mr.MatchID where mr.PlayerID=34563 and m.Date>unix_timestamp()-30*86400 AND m.StatusID != 0 group by MatchID order by m.Date desc,mr.MarkType desc

select t.TournamentID,concat(t.Name_rus,' ',if(StartYear=EndYear,StartYear,concat(StartYear,'/',EndYear))) Name,coalesce(group_concat(distinct if(rg.ShowStats>0,1,null)),0) ShowStats from ut_tournaments t join ut_seasons s on t.SeasonID=s.SeasonID join ut_roster r on t.TournamentID=r.TournamentID join ut_reglaments rg on t.TournamentID=rg.TournamentID where r.PlayerID=34563 and r.Games>0 group by t.TournamentID order by StartYear desc,t.Name_rus asc

select max(Date) as Date from ut_matches where TournamentID='893'

select coalesce(tn.Name,t.Name_rus) as TeamName, r.TeamID, r.Games Games, if(p.Position=1,if(r.Missed>0 and r.Goals>0,concat(-(r.Missed),'/',r.Goals),-(r.Missed)),if(r.Missed>0 and r.Goals>0,concat(r.Goals,'/',-(r.Missed)),r.Goals)) Goals, (r.YellowCards - r.YellowRedCards) YellowCards, (r.RedCards + r.YellowRedCards) RedCards, COALESCE(r.Passes,0) Passes from ut_roster r join ut_players p on r.PlayerID=p.PlayerID join ut_teams t on r.TeamID=t.TeamID left join ut_teams_names tn on t.TeamID=tn.TeamID and tn.YearSince<='1493739900' and tn.YearOn>='1493739900' where r.TournamentID='893' and r.PlayerID=34563 and r.Games<>0 group by r.TeamID order by r.Games desc

SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='14'

(select coalesce(tn1.Name,t1.Name_rus) as Team1, coalesce(tn2.Name,t2.Name_rus) as Team2, t1.TeamID as TeamID1, t2.TeamID as TeamID2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.Date,m.MatchID,max(mrk.MarkType) MarkType,m.Duration Duration, subs.Minute as SubMinute from ut_marks mrk join ut_matches m on m.MatchID=mrk.MatchID left join ut_teams t1 on m.TeamID1=t1.TeamID left join ut_teams_names tn1 on t1.TeamID=tn1.TeamID and tn1.YearSince<='1493739900' and tn1.YearOn>='1493739900' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1493739900' and tn2.YearOn>='1493739900' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='893' and mrk.PlayerID=34563 AND m.StatusID != 0 group by m.MatchID) union (select coalesce(tn1.Name,t1.Name_rus) as Team1, coalesce(tn2.Name,t2.Name_rus) as Team2, t1.TeamID as TeamID1, t2.TeamID as TeamID2, t1.City_rus as Team1City, t2.City_rus as Team2City, m.Goals1, m.Goals2, m.Penalty1, m.Penalty2, m.Date,m.MatchID,max(mrk.MarkType) MarkType,m.Duration Duration, subs.Minute as SubMinute from ut_marks_archive mrk join ut_matches m on m.MatchID=mrk.MatchID left join ut_teams t1 on m.TeamID1=t1.TeamID left join ut_teams_names tn1 on t1.TeamID=tn1.TeamID and tn1.YearSince<='1493739900' and tn1.YearOn>='1493739900' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1493739900' and tn2.YearOn>='1493739900' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='893' and mrk.PlayerID=34563 AND m.StatusID != 0 group by m.MatchID ) order by Date desc

SELECT Minute FROM ut_subs WHERE PlayerID1=34563 AND MatchID='97491' ORDER BY Minute LIMIT 1

SELECT Minute FROM ut_subs WHERE PlayerID2=34563 AND MatchID='97491' ORDER BY Minute LIMIT 1

SELECT Minute FROM ut_cards WHERE PlayerID=34563 AND MatchID='97491' AND CardType IN (1,3) ORDER BY Minute LIMIT 1

SELECT * FROM ut_goals WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC

SELECT * FROM ut_goals WHERE PasPlayerID <> PlayerID AND PasPlayerID=34563 AND GoalType<7 AND MatchID='97491' ORDER BY MINUTE ASC

SELECT * FROM ut_cards WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC

SELECT * FROM ut_injury WHERE PlayerID=34563 AND MatchID='97491' ORDER BY MINUTE ASC

SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='1'

SELECT `ShortName` FROM `ut_teams` WHERE `TeamID`='14'

SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=34563) AND (`ut_matches`.`Date` >= 1739056416) AND (NOT (`ut_matches`.`StatusID`=0)) AND (`ut_marks`.`MarkType` IN (1, 2)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC

SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=34563) AND ((`ut_matches`.`TournamentID`=893) AND (`ut_marks`.`MarkType` IN (1, 2))) AND (NOT (`ut_matches`.`StatusID`=0)) ORDER BY `ut_matches`.`Date` DESC, `ut_marks`.`MarkType` DESC

SELECT * FROM `ut_players` WHERE `PlayerID`=34563

SELECT * FROM `ut_matches` WHERE `MatchID`=97491

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

SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491))

SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491))

SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((34563, 97491))

SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((34563, 97491))

SELECT * FROM `ut_marks` WHERE (`MarkType`=2) AND ((`PlayerID`, `MatchID`) IN ((28843, 97491)))

SELECT * FROM `ut_players` WHERE `PlayerID`=28843

SELECT * FROM `ut_players` WHERE `PlayerID`=28843

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

SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((34563, 97491))

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

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

SELECT * FROM `ut_section_photos` WHERE `section_id`=32

SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1

SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=14

SELECT * FROM `ut_match_statuses` WHERE `StatusID`=4

SELECT * FROM `ut_tours` WHERE `TourID`=105

SELECT * FROM `ut_matches` WHERE `MatchID`=97491

SELECT * FROM `ut_teams` `t1` WHERE `TeamID`=1

SELECT * FROM `ut_teams` `t2` WHERE `TeamID`=14

SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1) AND (`TeamID2`=14)) OR ((`TeamID1`=14) AND (`TeamID2`=1))) AND (`StatusID` IN (4, 10, 11)) ORDER BY `Date` DESC

SELECT * FROM `ut_matches` WHERE (((`TeamID1`=1) AND (`TeamID2`=14)) OR ((`TeamID1`=14) AND (`TeamID2`=1))) AND (NOT (`StatusID` IN (4, 10, 11, 9, 8))) ORDER BY `Date`

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

SELECT * FROM `ut_reglaments` WHERE `ReglamentID`=1251

SELECT * FROM `ut_match_bookmaker_links` WHERE (`match_id`=97491) AND (`bookmaker_id`=6) ORDER BY `type`

SELECT COUNT(*) FROM `ut_matches` WHERE (`ReglamentID`=1251) AND (NOT (`PlayoffPosition` IS NULL))

SELECT * FROM `ut_judges` WHERE `JudgeID`=398

SELECT * FROM `ut_seasons` WHERE `SeasonID`=47

SELECT * FROM `ut_stadiums` WHERE `StadiumID`=232

SELECT * FROM `ut_stadiums_names` WHERE (`0`, `1`) IN ((232, 232))

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 `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: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`=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: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`=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 * FROM `blocks_in_column` WHERE `name` IN ('main_news', 'ads3', 'ads4', 'ads2', 'ads30', 'ads', 'ads62', 'ads63')

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: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`=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: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`=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: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`=307

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

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