Database

SELECT * FROM `ut_players` WHERE `slug`='10146-zan-edes-mauris'

SELECT * FROM `ad_brandings` WHERE (`StatusID`=1) AND (`image` <> '') AND (`StartDate` < 1740447130) AND ((`EndDate` > 1740447130) 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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` < 1740447130) AND (`bottomImage` <> '') AND ((`EndDate` > 1740447130) 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/10146-zan-edes-mauris/stats') AND (`Parent`='1266')

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

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

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

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

SELECT * FROM `ut_sections` WHERE `DivisionID`=165 ORDER BY `SectionID` DESC

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

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

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

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

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

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

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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))

SELECT * FROM `ut_countries` `country1` WHERE `CountryID`=64

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

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

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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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 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=10146 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='879'

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<='1466985600' and tn.YearOn>='1466985600' where r.TournamentID='879' and r.PlayerID=10146 and r.Games<>0 group by r.TeamID order by r.Games desc

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

(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<='1466985600' and tn1.YearOn>='1466985600' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1466985600' and tn2.YearOn>='1466985600' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='879' and mrk.PlayerID=10146 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<='1466985600' and tn1.YearOn>='1466985600' left join ut_teams t2 on m.TeamID2=t2.TeamID left join ut_teams_names tn2 on t2.TeamID=tn2.TeamID and tn2.YearSince<='1466985600' and tn2.YearOn>='1466985600' left join ut_subs subs ON subs.PlayerID2=mrk.PlayerID AND subs.MatchID = mrk.MatchID where m.TournamentID='879' and mrk.PlayerID=10146 AND m.StatusID != 0 group by m.MatchID ) order by Date desc

SELECT Minute FROM ut_subs WHERE PlayerID1=10146 AND MatchID='90483' ORDER BY Minute LIMIT 1

SELECT Minute FROM ut_subs WHERE PlayerID2=10146 AND MatchID='90483' ORDER BY Minute LIMIT 1

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

SELECT * FROM ut_goals WHERE PlayerID=10146 AND MatchID='90483' ORDER BY MINUTE ASC

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

SELECT * FROM ut_cards WHERE PlayerID=10146 AND MatchID='90483' ORDER BY MINUTE ASC

SELECT * FROM ut_injury WHERE PlayerID=10146 AND MatchID='90483' ORDER BY MINUTE ASC

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

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

SELECT Minute FROM ut_subs WHERE PlayerID1=10146 AND MatchID='90475' ORDER BY Minute LIMIT 1

SELECT Minute FROM ut_subs WHERE PlayerID2=10146 AND MatchID='90475' ORDER BY Minute LIMIT 1

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

SELECT * FROM ut_goals WHERE PlayerID=10146 AND MatchID='90475' ORDER BY MINUTE ASC

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

SELECT * FROM ut_cards WHERE PlayerID=10146 AND MatchID='90475' ORDER BY MINUTE ASC

SELECT * FROM ut_injury WHERE PlayerID=10146 AND MatchID='90475' ORDER BY MINUTE ASC

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

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

SELECT Minute FROM ut_subs WHERE PlayerID1=10146 AND MatchID='90467' ORDER BY Minute LIMIT 1

SELECT Minute FROM ut_subs WHERE PlayerID2=10146 AND MatchID='90467' ORDER BY Minute LIMIT 1

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

SELECT * FROM ut_goals WHERE PlayerID=10146 AND MatchID='90467' ORDER BY MINUTE ASC

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

SELECT * FROM ut_cards WHERE PlayerID=10146 AND MatchID='90467' ORDER BY MINUTE ASC

SELECT * FROM ut_injury WHERE PlayerID=10146 AND MatchID='90467' ORDER BY MINUTE ASC

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

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

SELECT `ut_marks`.* FROM `ut_marks` LEFT JOIN `ut_matches` ON `ut_marks`.`MatchID` = `ut_matches`.`MatchID` WHERE (`PlayerID`=10146) AND (`ut_matches`.`Date` >= 1737855130) 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`=10146) AND ((`ut_matches`.`TournamentID`=879) 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`=10146

SELECT * FROM `ut_matches` WHERE `MatchID` IN (90483, 90475, 90467)

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

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

SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90483))

SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90483))

SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((10146, 90483))

SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((10146, 90483))

SELECT * FROM `ut_subs` WHERE (`PlayerID2`, `MatchID`) IN ((10146, 90483))

SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90483))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90475))

SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90475))

SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((10146, 90475))

SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((10146, 90475))

SELECT * FROM `ut_subs` WHERE (`PlayerID2`, `MatchID`) IN ((10146, 90475))

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

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

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

SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90475))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT * FROM `ut_cards` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90467))

SELECT * FROM `ut_goals` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90467))

SELECT * FROM `ut_goals` WHERE (`PasPlayerID`, `MatchID`) IN ((10146, 90467))

SELECT * FROM `ut_subs` WHERE (`PlayerID1`, `MatchID`) IN ((10146, 90467))

SELECT * FROM `ut_subs` WHERE (`PlayerID2`, `MatchID`) IN ((10146, 90467))

SELECT * FROM `ut_injury` WHERE (`PlayerID`, `MatchID`) IN ((10146, 90467))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') 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-02-25 04:32:10') AND ((`end_date` >= '2025-02-25 04:32:10') OR (`end_date` IS NULL)) AND (`is_active`=TRUE) AND ((`is_deleted`=FALSE) AND (`is_placeholder`=FALSE))