instantiate query log (0Q - total module time: 0.00075006s)

boot (0Q - total module time: 0.00013804s)

translation-init (1Q - total module time: 0.00124121s)

SELECT redirects.id, redirects.origin, redirects.referer FROM redirects WHERE redirects.origin = :origin ORDER BY id

controller::drivers/logan-sargeant (11Q - total module time: 0.03549099s)

SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, p2_.PersonCareerId AS PersonCareerId_19, p2_.StartDate AS StartDate_20, p2_.EndDate AS EndDate_21, p2_.ProfilePhoto AS ProfilePhoto_22, p2_.StartNumber AS StartNumber_23, p3_.PersonRoleId AS PersonRoleId_24, o4_.OrganisationHistoryId AS OrganisationHistoryId_25, o4_.Name AS Name_26, o4_.StartDate AS StartDate_27, o4_.EndDate AS EndDate_28, o4_.Photo AS Photo_29, o4_.SmallLogo AS SmallLogo_30, o4_.City AS City_31, o4_.Website AS Website_32, r5_.RacingSerieId AS RacingSerieId_33, r5_.RewriteUrl AS RewriteUrl_34, r5_.IsDefault AS IsDefault_35, r6_.RacingSeriesTranslationId AS RacingSeriesTranslationId_36, r6_.LanguageCode AS LanguageCode_37, r6_.ShortName AS ShortName_38, r6_.LongName AS LongName_39, o7_.OrganisationId AS OrganisationId_40, o7_.Name AS Name_41, o7_.FoundingDate AS FoundingDate_42, o7_.Photo AS Photo_43, d8_.iso AS iso_44, d8_.iso3 AS iso3_45, d8_.numcode AS numcode_46, d9_.cntnlang AS cntnlang_47, d9_.printable_name AS printable_name_48, k10_.KeywordId AS KeywordId_49, k10_.Keyword AS Keyword_50, k10_.RewriteUrl AS RewriteUrl_51, k10_.Category AS Category_52, k10_.CommentCount AS CommentCount_53, p0_.Nationality AS Nationality_54, p0_.KeywordId AS KeywordId_55, p0_.PrimaryCareerId AS PrimaryCareerId_56, p0_.SiteId AS SiteId_57, k1_.ParentId AS ParentId_58, p2_.PersonRoleId AS PersonRoleId_59, p2_.OrganisationHistoryId AS OrganisationHistoryId_60, p2_.PersonId AS PersonId_61, o4_.OrganisationRoleId AS OrganisationRoleId_62, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_63, o4_.RacingSerieId AS RacingSerieId_64, r5_.SiteId AS SiteId_65, r5_.CountryIso AS CountryIso_66, r6_.RacingSerieId AS RacingSerieId_67, o7_.KeywordId AS KeywordId_68, o7_.Nationality AS Nationality_69, d9_.ISO AS ISO_70, k10_.ParentId AS ParentId_71 FROM Persons p0_ LEFT JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId LEFT JOIN PersonCareer p2_ ON p0_.PersonId = p2_.PersonId LEFT JOIN PersonRoles p3_ ON p2_.PersonRoleId = p3_.PersonRoleId LEFT JOIN OrganisationHistory o4_ ON p2_.OrganisationHistoryId = o4_.OrganisationHistoryId LEFT JOIN RacingSeries r5_ ON o4_.RacingSerieId = r5_.RacingSerieId AND (r5_.SiteId IN ('1')) LEFT JOIN RacingSeriesTranslations r6_ ON r5_.RacingSerieId = r6_.RacingSerieId AND (r6_.LanguageCode = 'en') LEFT JOIN OrganisationOrganisationHistory o11_ ON o4_.OrganisationHistoryId = o11_.OrganisationHistoryId LEFT JOIN Organisations o7_ ON o7_.OrganisationId = o11_.OrganisationId LEFT JOIN db_countries d8_ ON o7_.Nationality = d8_.iso LEFT JOIN db_countries_trnsl d9_ ON d8_.iso = d9_.ISO LEFT JOIN Keywords k10_ ON o7_.KeywordId = k10_.KeywordId WHERE k1_.RewriteUrl = ? AND p0_.SiteId = ? ORDER BY p2_.EndDate DESC

SELECT COUNT(1) AS sclr_0 FROM Users u0_ WHERE u0_.FavouriteDriverId = ?

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ WHERE k0_.KeywordId IN (?)

SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))

SELECT a0_.ArticleId AS ArticleId_0, a0_.RewriteUrl AS RewriteUrl_1, a0_.Title AS Title_2, a0_.SeoDescription AS SeoDescription_3, a0_.SeoTitle AS SeoTitle_4, a0_.coAuthor AS coAuthor_5, a0_.Icon AS Icon_6, a0_.Category AS Category_7, a0_.Content AS Content_8, a0_.PublishDate AS PublishDate_9, a0_.CreateDate AS CreateDate_10, a0_.CreateTime AS CreateTime_11, a0_.CommentType AS CommentType_12, a0_.AllowNewComments AS AllowNewComments_13, a0_.cntnlang AS cntnlang_14, a0_.LastUpdateDate AS LastUpdateDate_15, a0_.ArticleType AS ArticleType_16, a0_.CommentCount AS CommentCount_17, a0_.Activated AS Activated_18, a0_.StickyUntil AS StickyUntil_19, a0_.ViewCount AS ViewCount_20, a0_.PushEnabled AS PushEnabled_21, a0_.PushTitle AS PushTitle_22, a0_.PushMessage AS PushMessage_23, a0_.breaking AS breaking_24, a0_.breaking_title AS breaking_title_25, a0_.TestMode AS TestMode_26, r1_.RacingSerieId AS RacingSerieId_27, r1_.RewriteUrl AS RewriteUrl_28, r1_.IsDefault AS IsDefault_29, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_30, r2_.LanguageCode AS LanguageCode_31, r2_.ShortName AS ShortName_32, r2_.LongName AS LongName_33, a0_.SiteId AS SiteId_34, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_35, a0_.RacingSerieId AS RacingSerieId_36, a0_.PhotoAlbumId AS PhotoAlbumId_37, a0_.CmsAccountId AS CmsAccountId_38, a0_.PollId AS PollId_39, a0_.RaceSessionId AS RaceSessionId_40, r1_.SiteId AS SiteId_41, r1_.CountryIso AS CountryIso_42, r2_.RacingSerieId AS RacingSerieId_43 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') INNER JOIN keyword_combinations k3_ ON (k3_.nieuwsID = a0_.ArticleId) WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND k3_.keywordID IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 70

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ WHERE k0_.KeywordId IN (?)

SELECT c0_.ContentLanguage AS ContentLanguage_0 FROM ContentLanguageMapping c0_ WHERE (c0_.ContentType = ? AND c0_.ContentSubType IN (?) AND c0_.SiteLanguage = ?) AND (c0_.SiteId IN ('1'))

SELECT a0_.ArticleId AS ArticleId_0, a0_.RewriteUrl AS RewriteUrl_1, a0_.Title AS Title_2, a0_.SeoDescription AS SeoDescription_3, a0_.SeoTitle AS SeoTitle_4, a0_.coAuthor AS coAuthor_5, a0_.Icon AS Icon_6, a0_.Category AS Category_7, a0_.Content AS Content_8, a0_.PublishDate AS PublishDate_9, a0_.CreateDate AS CreateDate_10, a0_.CreateTime AS CreateTime_11, a0_.CommentType AS CommentType_12, a0_.AllowNewComments AS AllowNewComments_13, a0_.cntnlang AS cntnlang_14, a0_.LastUpdateDate AS LastUpdateDate_15, a0_.ArticleType AS ArticleType_16, a0_.CommentCount AS CommentCount_17, a0_.Activated AS Activated_18, a0_.StickyUntil AS StickyUntil_19, a0_.ViewCount AS ViewCount_20, a0_.PushEnabled AS PushEnabled_21, a0_.PushTitle AS PushTitle_22, a0_.PushMessage AS PushMessage_23, a0_.breaking AS breaking_24, a0_.breaking_title AS breaking_title_25, a0_.TestMode AS TestMode_26, r1_.RacingSerieId AS RacingSerieId_27, r1_.RewriteUrl AS RewriteUrl_28, r1_.IsDefault AS IsDefault_29, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_30, r2_.LanguageCode AS LanguageCode_31, r2_.ShortName AS ShortName_32, r2_.LongName AS LongName_33, a0_.SiteId AS SiteId_34, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_35, a0_.RacingSerieId AS RacingSerieId_36, a0_.PhotoAlbumId AS PhotoAlbumId_37, a0_.CmsAccountId AS CmsAccountId_38, a0_.PollId AS PollId_39, a0_.RaceSessionId AS RaceSessionId_40, r1_.SiteId AS SiteId_41, r1_.CountryIso AS CountryIso_42, r2_.RacingSerieId AS RacingSerieId_43 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') INNER JOIN keyword_combinations k3_ ON (k3_.nieuwsID = a0_.ArticleId) WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND k3_.keywordID IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 70

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.UploadDate AS UploadDate_2, p0_.title AS title_3, p0_.fotoDatum AS fotoDatum_4, p0_.FileSize AS FileSize_5, p0_.Height AS Height_6, p0_.Width AS Width_7, p0_.ImageFormat AS ImageFormat_8, p0_.album_id AS album_id_9 FROM photos p0_ INNER JOIN photo_keyword_combi p1_ ON (p1_.photoID = p0_.id) WHERE p1_.keywordID = ? ORDER BY p0_.fotoDatum DESC LIMIT 25

SELECT t0.iso AS iso_1, t0.iso3 AS iso3_2, t0.numcode AS numcode_3 FROM db_countries t0 WHERE t0.iso = ?

SELECT t0.id AS id_1, t0.year AS year_2, t0.uservisible AS uservisible_3, t0.PhotoCount AS PhotoCount_4, t0.SiteId AS SiteId_5 FROM photoalbums t0 WHERE t0.id = ? AND ((t0.SiteId IN ('1')))

module:StaticView (2Q - total module time: 0.00909805s)

SELECT t0.CmsAccountId AS CmsAccountId_1, t0.CreateDate AS CreateDate_2, t0.AccountName AS AccountName_3, t0.Password AS Password_4, t0.LastName AS LastName_5, t0.FirstName AS FirstName_6, t0.PrivateMail AS PrivateMail_7, t0.F1TodayMail AS F1TodayMail_8, t0.PhoneNumber AS PhoneNumber_9, t0.Address AS Address_10, t0.PostalCode AS PostalCode_11, t0.City AS City_12, t0.BirthDate AS BirthDate_13, t0.JobTitle AS JobTitle_14, t0.FavouriteDriver AS FavouriteDriver_15, t0.FavouriteTeam AS FavouriteTeam_16, t0.Interests AS Interests_17, t0.WorkStartDate AS WorkStartDate_18, t0.WorkingHours AS WorkingHours_19, t0.Disabled AS Disabled_20, t0.LastOnline AS LastOnline_21, t0.RetrievalId AS RetrievalId_22, t0.Notes AS Notes_23 FROM CmsAccounts t0 WHERE t0.CmsAccountId = ?

SELECT t0.SiteId AS SiteId_1, t0.Name AS Name_2 FROM Sites t0 WHERE t0.SiteId = ?

module:Sidebar (0Q - total module time: 0.00033903s)

sidebar:sidebar-driver-specific::ads (0Q - total module time: 0.00000811s)

sidebar:sidebar-driver-specific::driver_GpResults (0Q - total module time: 0.00000286s)

module:Driver\GpResults (1Q - total module time: 0.00244689s)

/* findByCriteria01 */ SELECT CASE WHEN res.`LapTime` <= 0.0 THEN 1 ELSE -1 END AS `SortOne`, CASE WHEN res.`LapCount` <= 0 THEN 1 ELSE -1 END AS `SortTwo`, CASE WHEN res.`Position` <= 0 THEN 9999 ELSE res.`Position` END AS `SortThree`, res.`RaceResultId`, res.`RaceParticipantId`, res.`LapTime`, res.`LapCount`, res.`Position`, res.`Result`, res.`DidNotFinish`, res.`DidNotStart`, res.`Points`, res.`Pitted`, res.`MaxSpeed`, res.`AverageSpeed`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, perc.`PersonId` AS `PersonId`, orgh.`PrimaryOrganisationId` AS `OrganisationId`, rs.`RaceSessionId` AS `RaceSessionId`, rst.`ResultType` AS `SessionTypeResultType`, rc.`Name` AS `RacingClassName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, eng.`Name` AS `EngineName`, eng.`ReleaseDate` AS `EngineReleaseDate`, eng.`CylinderCount` AS `EngineCylinderCount`, eng.`EngineType` AS `EngineType`, eng.`Volume` AS `EngineVolume`, eman.`Name` AS `EngineManufacturerName`, chas.`Name` AS `ChassisName`, chas.`ReleaseDate` AS `ChassisReleaseDate` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `Engines` eng ON eng.`EngineId` = par.`EngineId` JOIN `Chassis` chas ON par.`ChassisId` = chas.`ChassisId` JOIN `OrganisationHistory` eman ON eng.`ManufacturerOrganisationHistoryId` = eman.`OrganisationHistoryId` JOIN `OrganisationHistory` cman ON chas.`ManufacturerOrganisationHistoryId` = cman.`OrganisationHistoryId` JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` WHERE 1 = 1 AND perc.PersonId = :param1 AND (rst.ResultType = :param2 OR rst.ResultType = :param3 OR rst.ResultType = :param4 OR rst.ResultType = :param5) ORDER BY `rs`.`StartTime` DESC

query01 returned 51 rows (25Q - total module time: 0.02178001s)

/* findByCriteria02 */ SELECT res.`RaceResultId`, perc.`PersonCareerId` AS `PersonCareerId`, perc.`StartDate` AS `CareerStartDate`, perc.`EndDate` AS `CareerEndDate`, perc.`ProfilePhoto` AS `CareerPhoto`, perc.`StartNumber` AS `CareerStartNumber`, prt.`Name` AS `CareerRoleName`, per.`PersonId` AS `PersonId`, per.`Nationality` AS `PersonNationality`, per.`LastName` AS `PersonLastName`, per.`FirstName` AS `PersonFirstName`, per.`BirthDate` AS `PersonBirthDate`, per.`DateOfDeath` AS `PersonDateOfDeath`, per.`Residence` AS `PersonResidence`, per.`ProfilePhoto` AS `PersonPhoto`, per.`Height` AS `PersonHeight`, per.`Website` AS `PersonWebsite`, per.`Weight` AS `PersonWeight`, per.`BirthCity` AS `PersonBirthCity`, orgh.`OrganisationHistoryId` AS `OrganisationHistoryId`, orgh.`Name` AS `OrghName`, orgh.`StartDate` AS `OrghStartDate`, orgh.`EndDate` AS `OrghEndDate`, orgh.`Photo` AS `OrghPhoto`, orgh.`City` AS `OrghCity`, orgh.Website AS `OrghWebsite`, orgh.`SmallLogo` AS `OrghSmallLogo`, org.`OrganisationId`, org.`Nationality` AS `OrgNationality`, org.`Name` AS `OrgName`, org.`FoundingDate` AS `OrgFoundingDate`, org.`Photo` AS `OrgPhoto`, kw1.`Keyword` AS `OrgKeyword`, kw1.`RewriteUrl` AS `OrgRewriteUrl`, kw2.`Keyword` AS `PersonKeyword`, kw2.`RewriteUrl` AS `PersonRewriteUrl` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `PersonRoles` pr ON perc.`PersonRoleId` = pr.`PersonRoleId` JOIN `PersonRolesTranslations` prt ON pr.`PersonRoleId` = prt.`PersonRoleId` AND prt.`LanguageCode` = 'en' JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `Organisations` org ON org.OrganisationId = orgh.PrimaryOrganisationId JOIN `db_countries` co1 ON co1.`iso` = org.`Nationality` JOIN `db_countries` co2 ON co2.`iso` = per.`Nationality` JOIN `Keywords` kw1 ON org.`KeywordId` = kw1.`KeywordId` JOIN `Keywords` kw2 ON per.`KeywordId` = kw2.`KeywordId` WHERE res.`RaceParticipantId` IN (36865,36885,36705,36725,36565,36585,36545,36425,36445,36285,36305,36265,37136,36145,36165,36125,36005,36025,35865,35885,35745,35725,35585,35605,35445,35465,35425,35305,35325,35165,35185,35025,35045,35005,36945,34885,34905,34745,34765,34605,34625,34325,34345,34205,34165,34045,34065,33905,33925,33765,33785)

/* findByCriteria03 */ SELECT res.`RaceParticipantId`, res.`RaceResultId`, rs.`RaceSessionId` AS `RaceSessionId`, rs.`StartTime` AS `SessionStartTime`, rs.`EndTime` AS `SessionEndTime`, rs.`TrackTemperature` AS `TrackTemperature`, rs.`AirTemperature` AS `AirTemperature`, rs.`TrackFlag` AS `TrackFlag`, cal.`RaceCalendarId` AS `RaceCalendarId`, cal.`RaceSeasonId` AS `RaceSeasonId`, cal.`GridPosition` AS `GridPosition`, rs.`PhotoAlbumId` AS `SessionPhotoAlbumId`, rst.`RewriteUrl` AS `SessionTypeRewriteUrl`, rst.`ResultType` AS `SessionTypeResultType`, re.`RewriteUrl` AS `RaceEventRewriteUrl`, re.`CountryIso` AS `RaceEventIso`, ret.`Name` AS `RaceEventName`, rt.`Name` AS `TireName`, rt.`Colour` AS `TireColour`, rse.`RewriteUrl` AS `RacingSerieRewriteUrl`, rset.`ShortName` AS `RacingSerieShortName`, rset.`LongName` AS `RacingSeriesLongName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `RaceSessions` rs ON par.`RaceSessionId` = rs.`RaceSessionId` JOIN `RacingSessionTypes` rst ON rst.`RacingSessionTypeId` = rs.`RacingSessionTypeId` JOIN `RacingSessionTypesTranslations` rstt ON rst.`RacingSessionTypeId` = rstt.`RacingSessionTypeId` AND rstt.`LanguageCode` = 'en' JOIN `RaceCalendar` cal ON cal.`RaceCalendarId` = rs.`RaceCalendarId` JOIN `RacingEvents` re ON re.`RacingEventId` = cal.`RacingEventId` JOIN `RacingEventsTranslations` ret ON re.`RacingEventId` = ret.`RacingEventId` AND ret.`LanguageCode` = 'en' JOIN `RacingTires` rt ON par.`RacingTireId` = rt.`RacingTireId` JOIN `RacingClasses` rc ON par.`RacingClassId` = rc.`RacingClassId` JOIN `RacingSeries` rse ON rc.`RacingSerieId` = rse.`RacingSerieId` JOIN `RacingSeriesTranslations` rset ON rse.`RacingSerieId` = rset.`RacingSerieId` AND rset.`LanguageCode` = 'en' WHERE res.`RaceParticipantId` IN (36865,36885,36705,36725,36565,36585,36545,36425,36445,36285,36305,36265,37136,36145,36165,36125,36005,36025,35865,35885,35745,35725,35585,35605,35445,35465,35425,35305,35325,35165,35185,35025,35045,35005,36945,34885,34905,34745,34765,34605,34625,34325,34345,34205,34165,34045,34065,33905,33925,33765,33785)

SELECT r0_.RaceSessionIncidentId AS RaceSessionIncidentId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.LapNumber AS LapNumber_3, r1_.RacingIncidentId AS RacingIncidentId_4, r1_.IncidentType AS IncidentType_5, r1_.PenaltyPoints AS PenaltyPoints_6, r1_.PenaltyPositions AS PenaltyPositions_7, r2_.RacingIncidentsTranslationId AS RacingIncidentsTranslationId_8, r2_.LanguageCode AS LanguageCode_9, r2_.Description AS Description_10, r3_.RaceParticipantId AS RaceParticipantId_11, p4_.PersonCareerId AS PersonCareerId_12, p4_.StartDate AS StartDate_13, p4_.EndDate AS EndDate_14, p4_.ProfilePhoto AS ProfilePhoto_15, p4_.StartNumber AS StartNumber_16, p5_.PersonId AS PersonId_17, p5_.LastName AS LastName_18, p5_.FirstName AS FirstName_19, p5_.Birthdate AS Birthdate_20, p5_.DateOfDeath AS DateOfDeath_21, p5_.Residence AS Residence_22, p5_.BirthCity AS BirthCity_23, p5_.ProfilePhoto AS ProfilePhoto_24, p5_.Height AS Height_25, p5_.Website AS Website_26, p5_.Weight AS Weight_27, p5_.InternalNotes AS InternalNotes_28, p5_.InHeaderList AS InHeaderList_29, p5_.InFooterList AS InFooterList_30, d6_.iso AS iso_31, d6_.iso3 AS iso3_32, d6_.numcode AS numcode_33, d7_.cntnlang AS cntnlang_34, d7_.printable_name AS printable_name_35, r0_.RacingIncidentId AS RacingIncidentId_36, r0_.RaceParticipantId AS RaceParticipantId_37, r0_.RacingIncidentLocationId AS RacingIncidentLocationId_38, r2_.RacingIncidentId AS RacingIncidentId_39, r3_.RaceSessionId AS RaceSessionId_40, r3_.PersonCareerId AS PersonCareerId_41, r3_.RacingClassId AS RacingClassId_42, r3_.EngineId AS EngineId_43, r3_.RacingTireId AS RacingTireId_44, r3_.ChassisId AS ChassisId_45, p4_.PersonRoleId AS PersonRoleId_46, p4_.OrganisationHistoryId AS OrganisationHistoryId_47, p4_.PersonId AS PersonId_48, p5_.Nationality AS Nationality_49, p5_.KeywordId AS KeywordId_50, p5_.PrimaryCareerId AS PrimaryCareerId_51, p5_.SiteId AS SiteId_52, d7_.ISO AS ISO_53 FROM RaceSessionIncidents r0_ INNER JOIN RacingIncidents r1_ ON r0_.RacingIncidentId = r1_.RacingIncidentId INNER JOIN RacingIncidentsTranslations r2_ ON r1_.RacingIncidentId = r2_.RacingIncidentId AND (r2_.LanguageCode = 'en') INNER JOIN RaceParticipants r3_ ON r0_.RaceParticipantId = r3_.RaceParticipantId INNER JOIN PersonCareer p4_ ON r3_.PersonCareerId = p4_.PersonCareerId INNER JOIN Persons p5_ ON p4_.PersonId = p5_.PersonId INNER JOIN db_countries d6_ ON p5_.Nationality = d6_.iso INNER JOIN db_countries_trnsl d7_ ON d6_.iso = d7_.ISO WHERE r0_.RaceParticipantId IN (?)

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

SELECT r0_.RaceCalendarId AS RaceCalendarId_0, r0_.GridPosition AS GridPosition_1, r1_.RaceSessionId AS RaceSessionId_2, r1_.StartTime AS StartTime_3, r1_.EndTime AS EndTime_4, r1_.TrackTemperature AS TrackTemperature_5, r1_.AirTemperature AS AirTemperature_6, r1_.TrackFlag AS TrackFlag_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RaceSeasonId AS RaceSeasonId_11, r3_.Year AS Year_12, r4_.RacingSerieId AS RacingSerieId_13, r4_.RewriteUrl AS RewriteUrl_14, r4_.IsDefault AS IsDefault_15, r5_.RacingEventsTranslationId AS RacingEventsTranslationId_16, r5_.LanguageCode AS LanguageCode_17, r5_.Name AS Name_18, r6_.RacingSessionTypeId AS RacingSessionTypeId_19, r6_.RewriteUrl AS RewriteUrl_20, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_21, r6_.SortingOrder AS SortingOrder_22, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_23, r6_.MainEventAtBeginning AS MainEventAtBeginning_24, r6_.DefaultDuration AS DefaultDuration_25, r6_.ResultType AS ResultType_26, r6_.DefaultAdd AS DefaultAdd_27, r7_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_28, r7_.LanguageCode AS LanguageCode_29, r7_.Name AS Name_30, r8_.RaceTrackHistoryId AS RaceTrackHistoryId_31, r8_.LapLength AS LapLength_32, r8_.LapCount AS LapCount_33, r8_.Map AS Map_34, r8_.Impression AS Impression_35, r8_.StartDate AS StartDate_36, r8_.EndDate AS EndDate_37, r9_.RaceTrackId AS RaceTrackId_38, r9_.Name AS Name_39, r9_.RewriteUrl AS RewriteUrl_40, r9_.FoundingDate AS FoundingDate_41, r9_.Website AS Website_42, r9_.Description AS Description_43, c10_.CityId AS CityId_44, c10_.Latitude AS Latitude_45, c10_.Longitude AS Longitude_46, c10_.TimeOffsetFromUtc AS TimeOffsetFromUtc_47, c11_.CityTranslationId AS CityTranslationId_48, c11_.LanguageCode AS LanguageCode_49, c11_.Name AS Name_50, d12_.iso AS iso_51, d12_.iso3 AS iso3_52, d12_.numcode AS numcode_53, d13_.cntnlang AS cntnlang_54, d13_.printable_name AS printable_name_55, p14_.id AS id_56, p14_.year AS year_57, p14_.uservisible AS uservisible_58, p14_.PhotoCount AS PhotoCount_59, r0_.RaceSeasonId AS RaceSeasonId_60, r0_.RacingEventId AS RacingEventId_61, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_62, r1_.RacingSessionTypeId AS RacingSessionTypeId_63, r1_.RaceCalendarId AS RaceCalendarId_64, r1_.WeatherTypeId AS WeatherTypeId_65, r1_.PhotoAlbumId AS PhotoAlbumId_66, r2_.CircuitId AS CircuitId_67, r2_.WinnerId AS WinnerId_68, r2_.RacingSerieId AS RacingSerieId_69, r2_.RacingEventTypeId AS RacingEventTypeId_70, r2_.CountryIso AS CountryIso_71, r3_.SiteId AS SiteId_72, r3_.RacingSerieId AS RacingSerieId_73, r4_.SiteId AS SiteId_74, r4_.CountryIso AS CountryIso_75, r5_.RacingEventId AS RacingEventId_76, r6_.RacingSerieId AS RacingSerieId_77, r6_.RacingEventTypeId AS RacingEventTypeId_78, r7_.RacingSessionTypeId AS RacingSessionTypeId_79, r8_.RaceTrackId AS RaceTrackId_80, r9_.CityId AS CityId_81, c10_.Country AS Country_82, c11_.CityId AS CityId_83, d13_.ISO AS ISO_84, p14_.SiteId AS SiteId_85 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RaceSeasons r3_ ON r0_.RaceSeasonId = r3_.RaceSeasonId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSeries r4_ ON r3_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN RacingEventsTranslations r5_ ON r2_.RacingEventId = r5_.RacingEventId AND (r5_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r8_ ON r0_.RaceTrackHistoryId = r8_.RaceTrackHistoryId INNER JOIN RaceTracks r9_ ON r8_.RaceTrackId = r9_.RaceTrackId INNER JOIN Cities c10_ ON r9_.CityId = c10_.CityId INNER JOIN CityTranslations c11_ ON c10_.CityId = c11_.CityId AND (c11_.LanguageCode = 'en') INNER JOIN db_countries d12_ ON c10_.Country = d12_.iso INNER JOIN db_countries_trnsl d13_ ON d12_.iso = d13_.ISO LEFT JOIN photoalbums p14_ ON r1_.PhotoAlbumId = p14_.id AND (p14_.SiteId IN ('1')) WHERE d13_.cntnlang = ? AND c11_.LanguageCode = ? AND r0_.RaceCalendarId IN (?) ORDER BY r1_.StartTime ASC, r6_.SortingOrder ASC

sidebar:sidebar-driver-specific::driver_TestResults (0Q - total module time: 0.00000691s)

sidebar:sidebar-driver-specific::team_Info (0Q - total module time: 0.00000501s)

module:Team\Info (0Q - total module time: 0.00002408s)

sidebar:sidebar-driver-specific::poll (0Q - total module time: 0.00000191s)

module:Poll (0Q - total module time: 0.00193501s)

sidebar:sidebar-driver-specific::driver_characteristics (0Q - total module time: 0.00000882s)

module:Driver\Characteristics (1Q - total module time: 0.00372219s)

SELECT COUNT(1) AS sclr_0 FROM Users u0_ WHERE u0_.FavouriteDriverId = ?

module:Layout\Footer (0Q - total module time: 0.00012803s)

module:News\Breaking (0Q - total module time: 0.00030804s)