Drivers and teams line-up for Losail International Circuit

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

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

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

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

controller::results/sprintshootout/2024/11/30/qatar-grand-prix (2Q - total module time: 0.00211000s)

SELECT r0_.RaceSessionId AS RaceSessionId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.TrackTemperature AS TrackTemperature_3, r0_.AirTemperature AS AirTemperature_4, r0_.TrackFlag AS TrackFlag_5, r1_.RaceCalendarId AS RaceCalendarId_6, r1_.GridPosition AS GridPosition_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingSessionTypeId AS RacingSessionTypeId_11, r3_.RewriteUrl AS RewriteUrl_12, r3_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_13, r3_.SortingOrder AS SortingOrder_14, r3_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_15, r3_.MainEventAtBeginning AS MainEventAtBeginning_16, r3_.DefaultDuration AS DefaultDuration_17, r3_.ResultType AS ResultType_18, r3_.DefaultAdd AS DefaultAdd_19, r4_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_20, r4_.LanguageCode AS LanguageCode_21, r4_.Name AS Name_22, r5_.RaceSeasonId AS RaceSeasonId_23, r5_.Year AS Year_24, r6_.RaceTrackHistoryId AS RaceTrackHistoryId_25, r6_.LapLength AS LapLength_26, r6_.LapCount AS LapCount_27, r6_.Map AS Map_28, r6_.Impression AS Impression_29, r6_.StartDate AS StartDate_30, r6_.EndDate AS EndDate_31, r7_.RaceTrackId AS RaceTrackId_32, r7_.Name AS Name_33, r7_.RewriteUrl AS RewriteUrl_34, r7_.FoundingDate AS FoundingDate_35, r7_.Website AS Website_36, r7_.Description AS Description_37, c8_.CityId AS CityId_38, c8_.Latitude AS Latitude_39, c8_.Longitude AS Longitude_40, c8_.TimeOffsetFromUtc AS TimeOffsetFromUtc_41, c9_.CityTranslationId AS CityTranslationId_42, c9_.LanguageCode AS LanguageCode_43, c9_.Name AS Name_44, d10_.iso AS iso_45, d10_.iso3 AS iso3_46, d10_.numcode AS numcode_47, d11_.cntnlang AS cntnlang_48, d11_.printable_name AS printable_name_49, r12_.RacingEventsTranslationId AS RacingEventsTranslationId_50, r12_.LanguageCode AS LanguageCode_51, r12_.Name AS Name_52, r0_.RacingSessionTypeId AS RacingSessionTypeId_53, r0_.RaceCalendarId AS RaceCalendarId_54, r0_.WeatherTypeId AS WeatherTypeId_55, r0_.PhotoAlbumId AS PhotoAlbumId_56, r1_.RaceSeasonId AS RaceSeasonId_57, r1_.RacingEventId AS RacingEventId_58, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_59, r2_.CircuitId AS CircuitId_60, r2_.WinnerId AS WinnerId_61, r2_.RacingSerieId AS RacingSerieId_62, r2_.RacingEventTypeId AS RacingEventTypeId_63, r2_.CountryIso AS CountryIso_64, r3_.RacingSerieId AS RacingSerieId_65, r3_.RacingEventTypeId AS RacingEventTypeId_66, r4_.RacingSessionTypeId AS RacingSessionTypeId_67, r5_.SiteId AS SiteId_68, r5_.RacingSerieId AS RacingSerieId_69, r6_.RaceTrackId AS RaceTrackId_70, r7_.CityId AS CityId_71, c8_.Country AS Country_72, c9_.CityId AS CityId_73, d11_.ISO AS ISO_74, r12_.RacingEventId AS RacingEventId_75 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r1_.RacingEventId = r2_.RacingEventId INNER JOIN RacingSessionTypes r3_ ON r0_.RacingSessionTypeId = r3_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r4_ ON r3_.RacingSessionTypeId = r4_.RacingSessionTypeId AND (r4_.LanguageCode = 'en') INNER JOIN RaceSeasons r5_ ON r1_.RaceSeasonId = r5_.RaceSeasonId AND (r5_.SiteId IN ('1')) INNER JOIN RaceTrackHistory r6_ ON r1_.RaceTrackHistoryId = r6_.RaceTrackHistoryId INNER JOIN RaceTracks r7_ ON r6_.RaceTrackId = r7_.RaceTrackId INNER JOIN Cities c8_ ON r7_.CityId = c8_.CityId INNER JOIN CityTranslations c9_ ON c8_.CityId = c9_.CityId AND (c9_.LanguageCode = 'en') INNER JOIN db_countries d10_ ON c8_.Country = d10_.iso INNER JOIN db_countries_trnsl d11_ ON d10_.iso = d11_.ISO INNER JOIN RacingEventsTranslations r12_ ON r2_.RacingEventId = r12_.RacingEventId AND (r12_.LanguageCode = 'en') WHERE DATE(r0_.StartTime) = ? AND r3_.RewriteUrl = ? AND c9_.LanguageCode = ? AND d11_.cntnlang = ?

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 0 rows (2Q - total module time: 0.00056696s)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 0 rows (5Q - total module time: 0.05706501s)

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 1 AS `SortOne`, 1 AS `SortTwo`, 9999 AS `SortThree`, CONCAT(per.FirstName, ' ', per.LastName) AS `FullDriverName`, per.`PersonId` AS `PersonId`, per.`LastName` AS `DriverLastName`, per.`Nationality` AS `DriverNationality`, orgh.`Name` AS `TeamName`, orgh.`SmallLogo` AS `SmallTeamLogo`, par.`RaceParticipantId`, par.`PersonCareerId`, par.`ChassisId`, par.`EngineId`, par.`RacingClassId`, par.`RacingTireId`, orgh.`OrganisationHistoryId`, 0 AS `LapTime`, 0 AS `LapCount`, 0 AS `RacePosition`, 0 AS `RacePoints`, '' AS `RaceResult`, FALSE AS `DidNotFinish`, FALSE AS `DidNotStart`, FALSE AS `Pitted`, 0 AS `MaxSpeed`, 0 AS `AverageSpeed`, NULL AS `RacingIncident`, 1 AS `HasResults`, chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`, ch.`Name` AS `ChassisName` FROM `RaceParticipants` par JOIN `PersonCareer` perc ON perc.PersonCareerId = par.PersonCareerId JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId` LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId` LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId` WHERE par.`RaceSessionId` = :raceSessionId UNION 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`, CONCAT(per.`FirstName`, ' ', per.`LastName`) AS `FullDriverName`, per.`PersonId` AS `PersonId`, per.`LastName` AS `DriverLastName`, per.`Nationality` AS `DriverNationality`, orgh.`Name` AS `TeamName`, orgh.`SmallLogo` AS `SmallTeamLogo`, par.`RaceParticipantId`, par.`PersonCareerId`, par.`ChassisId`, par.`EngineId`, par.`RacingClassId`, par.`RacingTireId`, orgh.`OrganisationHistoryId`, 0 + `LapTime` AS `LapTime`, 0 + `LapCount` AS `LapCount`, 0 + `Position` AS `RacePosition`, 0 + `Points` AS `RacePoints`, `Result` AS `RaceResult`, `DidNotFinish` AS `DidNotFinish`, `DidNotStart` AS `DidNotStart`, `Pitted` AS `Pitted`, 0 + `MaxSpeed` AS `MaxSpeed`, 0 + `AverageSpeed` AS `AverageSpeed`, `RacingIncidentId` AS `RacingIncident`, 2 AS `HasResults`, chasmanorgh.`SmallLogo` AS `ChassisManufacturerLogo`, ch.`Name` AS `ChassisName` FROM `RaceResults` res JOIN `RaceParticipants` par ON par.`RaceParticipantId` = res.`RaceParticipantId` JOIN `PersonCareer` perc ON perc.`PersonCareerId` = par.`PersonCareerId` JOIN `Persons` per ON per.PersonId = perc.PersonId JOIN `OrganisationHistory` orgh ON orgh.OrganisationHistoryId = perc.OrganisationHistoryId JOIN `OrganisationOrganisationHistory` orglnk ON orglnk.`OrganisationHistoryId` = orgh.`OrganisationHistoryId` LEFT JOIN `Chassis` ch ON ch.`ChassisId` = par.`ChassisId` LEFT JOIN `OrganisationHistory` chasmanorgh ON chasmanorgh.`OrganisationHistoryId` = perc.`OrganisationHistoryId` WHERE `RaceSessionId` = :raceSessionId ORDER BY `HasResults` DESC, SortThree ASC, SortTwo ASC, LapCount DESC,`OrganisationHistoryId`, `PersonCareerId`

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') WHERE ((((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.Category = ?) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

SELECT t0.RacingSerieId AS RacingSerieId_1, t0.RewriteUrl AS RewriteUrl_2, t0.IsDefault AS IsDefault_3, t0.SiteId AS SiteId_4, t0.CountryIso AS CountryIso_5 FROM RacingSeries t0 WHERE t0.RacingSerieId = ? AND ((t0.SiteId IN ('1')))

module:Circuit (0Q - total module time: 0.00022507s)

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

sidebar:sidebar-resultgridpage::ads (0Q - total module time: 0.00001287s)

sidebar:sidebar-resultgridpage::ads (0Q - total module time: 0.00000191s)

sidebar:sidebar-resultgridpage::gpsidebarnavigation (0Q - total module time: 0.00000215s)

module:GpSidebarNavigation (0Q - total module time: 0.00044799s)

sidebar:sidebar-resultgridpage::gpschedule (0Q - total module time: 0.00000405s)

module:GpSchedule (4Q - total module time: 0.00161791s)

SELECT t0.frontpageID AS frontpageID_1, t0.cntnlang AS cntnlang_2, t0.picofweek AS picofweek_3, t0.SiteId AS SiteId_4, t0.RaceCalendarId AS RaceCalendarId_5, t0.hottopic AS hottopic_6, t0.substory1 AS substory1_7, t0.substory2 AS substory2_8, t0.substory3 AS substory3_9, t0.presentatie_seizoen AS presentatie_seizoen_10, t0.PermantChatArticleId AS PermantChatArticleId_11 FROM frontpage t0 WHERE t0.cntnlang = ? AND t0.SiteId IN (?) AND ((t0.SiteId IN ('1'))) LIMIT 1

SELECT t0.RaceCalendarId AS RaceCalendarId_1, t0.GridPosition AS GridPosition_2, t0.RaceSeasonId AS RaceSeasonId_3, t0.RacingEventId AS RacingEventId_4, t0.RaceTrackHistoryId AS RaceTrackHistoryId_5 FROM RaceCalendar t0 WHERE t0.RaceCalendarId = ?

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

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortOne` ASC, `res`.`LapTime` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00077295s)

/* 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 (25077,25076,25081,25079,25078,25080,25083,25074,25082,25075,25068,25069,25067,25070,25071,25085,25084,25073,25066,25072)

/* 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 (25077,25076,25081,25079,25078,25080,25083,25074,25082,25075,25068,25069,25067,25070,25071,25085,25084,25073,25066,25072)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortOne` ASC, `res`.`LapTime` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00065994s)

/* 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 (25101,25102,25096,25100,25099,25097,25095,25103,25094,25089,25098,25088,25086,25087,25090,25104,25091,25105,25093,25092)

/* 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 (25101,25102,25096,25100,25099,25097,25095,25103,25094,25089,25098,25088,25086,25087,25090,25104,25091,25105,25093,25092)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortOne` ASC, `res`.`LapTime` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00063896s)

/* 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 (25116,25123,25115,25120,25117,25121,25122,25118,25114,25119,25109,25108,25125,25112,25113,25107,25110,25124,25106,25111)

/* 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 (25116,25123,25115,25120,25117,25121,25122,25118,25114,25119,25109,25108,25125,25112,25113,25107,25110,25124,25106,25111)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00064087s)

/* 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 (25136,25137,25141,25142,25140,25143,25134,25139,25138,25135,25128,25129,25130,25131,25144,25127,25133,25126,25145,25132)

/* 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 (25136,25137,25141,25142,25140,25143,25134,25139,25138,25135,25128,25129,25130,25131,25144,25127,25133,25126,25145,25132)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00066090s)

/* 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 (25156,25157,25161,25162,25160,25163,25154,25159,25158,25155,25148,25149,25150,25151,25164,25147,25153,25146,25165,25152)

/* 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 (25156,25157,25161,25162,25160,25163,25154,25159,25158,25155,25148,25149,25150,25151,25164,25147,25153,25146,25165,25152)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortThree` ASC, `SortTwo` ASC, `res`.`LapCount` DESC

query01 returned 20 rows (4Q - total module time: 0.00061703s)

/* 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 (25176,25177,25181,25182,25183,25180,25175,25169,25178,25179,25168,25167,25171,25170,25173,25185,25172,25166,25184,25174)

/* 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 (25176,25177,25181,25182,25183,25180,25175,25169,25178,25179,25168,25167,25171,25170,25173,25185,25172,25166,25184,25174)

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 (?)

/* 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 rs.RaceSessionId = :param1 ORDER BY `SortOne` ASC, `res`.`LapTime` ASC, `res`.`LapCount` DESC

query01 returned 1 rows (20Q - total module time: 0.01050496s)

/* 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 (25202)

/* 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 (25202)

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 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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

SELECT t0.WeatherTypeId AS WeatherTypeId_1, t0.Weather AS Weather_2, t0.Icon AS Icon_3 FROM WeatherTypes t0 WHERE t0.WeatherTypeId = ?

SELECT t0.WeatherTypeId AS WeatherTypeId_1, t0.Weather AS Weather_2, t0.Icon AS Icon_3 FROM WeatherTypes t0 WHERE t0.WeatherTypeId = ?

SELECT t0.WeatherTypeId AS WeatherTypeId_1, t0.Weather AS Weather_2, t0.Icon AS Icon_3 FROM WeatherTypes t0 WHERE t0.WeatherTypeId = ?

sidebar:sidebar-resultgridpage::testcalendar (0Q - total module time: 0.00000501s)

module:TestCalendar (1Q - total module time: 0.00054002s)

/* 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 (RaceSeasonId = :param1) AND rst.ResultType = :param2 AND res.Position = :param3 ORDER BY rs.StartTime

query01 returned 5 rows (7Q - total module time: 0.00548506s)

/* 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 (29664,29706,29676,30366,30380)

/* 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 (29664,29706,29676,30366,30380)

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 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') WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.RaceSessionId IN (?)) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100

sidebar:sidebar-resultgridpage::gpcalendar (0Q - total module time: 0.00000715s)

module:GpCalendar (6Q - total module time: 0.01573992s)

SELECT t0.RacingSerieId AS RacingSerieId_1, t0.RewriteUrl AS RewriteUrl_2, t0.IsDefault AS IsDefault_3, t0.SiteId AS SiteId_4, t0.CountryIso AS CountryIso_5 FROM RacingSeries t0 WHERE t0.RewriteUrl = ? AND t0.SiteId IN (?) AND ((t0.SiteId IN ('1'))) LIMIT 1

SELECT r0_.RaceSessionId AS RaceSessionId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.TrackTemperature AS TrackTemperature_3, r0_.AirTemperature AS AirTemperature_4, r0_.TrackFlag AS TrackFlag_5, r1_.RaceCalendarId AS RaceCalendarId_6, r1_.GridPosition AS GridPosition_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingEventsTranslationId AS RacingEventsTranslationId_11, r3_.LanguageCode AS LanguageCode_12, r3_.Name AS Name_13, r4_.RacingSerieId AS RacingSerieId_14, r4_.RewriteUrl AS RewriteUrl_15, r4_.IsDefault AS IsDefault_16, d5_.iso AS iso_17, d5_.iso3 AS iso3_18, d5_.numcode AS numcode_19, r6_.RacingSessionTypeId AS RacingSessionTypeId_20, r6_.RewriteUrl AS RewriteUrl_21, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_22, r6_.SortingOrder AS SortingOrder_23, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_24, r6_.MainEventAtBeginning AS MainEventAtBeginning_25, r6_.DefaultDuration AS DefaultDuration_26, r6_.ResultType AS ResultType_27, r6_.DefaultAdd AS DefaultAdd_28, r0_.RacingSessionTypeId AS RacingSessionTypeId_29, r0_.RaceCalendarId AS RaceCalendarId_30, r0_.WeatherTypeId AS WeatherTypeId_31, r0_.PhotoAlbumId AS PhotoAlbumId_32, r1_.RaceSeasonId AS RaceSeasonId_33, r1_.RacingEventId AS RacingEventId_34, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_35, r2_.CircuitId AS CircuitId_36, r2_.WinnerId AS WinnerId_37, r2_.RacingSerieId AS RacingSerieId_38, r2_.RacingEventTypeId AS RacingEventTypeId_39, r2_.CountryIso AS CountryIso_40, r3_.RacingEventId AS RacingEventId_41, r4_.SiteId AS SiteId_42, r4_.CountryIso AS CountryIso_43, r6_.RacingSerieId AS RacingSerieId_44, r6_.RacingEventTypeId AS RacingEventTypeId_45 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r1_.RacingEventId = r2_.RacingEventId INNER JOIN RacingEventsTranslations r3_ ON r2_.RacingEventId = r3_.RacingEventId AND (r3_.LanguageCode = 'en') INNER JOIN RacingEventTypes r7_ ON r2_.RacingEventTypeId = r7_.RacingEventTypeId INNER JOIN RacingSeries r4_ ON r2_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN db_countries d5_ ON r2_.CountryIso = d5_.iso INNER JOIN RacingSessionTypes r6_ ON r0_.RacingSessionTypeId = r6_.RacingSessionTypeId WHERE r4_.RacingSerieId = ? AND r0_.StartTime > ? AND r7_.RewriteUrl = ? AND r6_.ResultType = ? ORDER BY r0_.StartTime ASC LIMIT 1

SELECT r0_.RaceSessionId AS RaceSessionId_0, r0_.StartTime AS StartTime_1, r0_.EndTime AS EndTime_2, r0_.TrackTemperature AS TrackTemperature_3, r0_.AirTemperature AS AirTemperature_4, r0_.TrackFlag AS TrackFlag_5, r1_.RaceCalendarId AS RaceCalendarId_6, r1_.GridPosition AS GridPosition_7, r2_.RacingEventId AS RacingEventId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.Content AS Content_10, r3_.RacingEventsTranslationId AS RacingEventsTranslationId_11, r3_.LanguageCode AS LanguageCode_12, r3_.Name AS Name_13, r4_.RacingSerieId AS RacingSerieId_14, r4_.RewriteUrl AS RewriteUrl_15, r4_.IsDefault AS IsDefault_16, d5_.iso AS iso_17, d5_.iso3 AS iso3_18, d5_.numcode AS numcode_19, r6_.RacingSessionTypeId AS RacingSessionTypeId_20, r6_.RewriteUrl AS RewriteUrl_21, r6_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_22, r6_.SortingOrder AS SortingOrder_23, r6_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_24, r6_.MainEventAtBeginning AS MainEventAtBeginning_25, r6_.DefaultDuration AS DefaultDuration_26, r6_.ResultType AS ResultType_27, r6_.DefaultAdd AS DefaultAdd_28, r0_.RacingSessionTypeId AS RacingSessionTypeId_29, r0_.RaceCalendarId AS RaceCalendarId_30, r0_.WeatherTypeId AS WeatherTypeId_31, r0_.PhotoAlbumId AS PhotoAlbumId_32, r1_.RaceSeasonId AS RaceSeasonId_33, r1_.RacingEventId AS RacingEventId_34, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_35, r2_.CircuitId AS CircuitId_36, r2_.WinnerId AS WinnerId_37, r2_.RacingSerieId AS RacingSerieId_38, r2_.RacingEventTypeId AS RacingEventTypeId_39, r2_.CountryIso AS CountryIso_40, r3_.RacingEventId AS RacingEventId_41, r4_.SiteId AS SiteId_42, r4_.CountryIso AS CountryIso_43, r6_.RacingSerieId AS RacingSerieId_44, r6_.RacingEventTypeId AS RacingEventTypeId_45 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r1_.RacingEventId = r2_.RacingEventId INNER JOIN RacingEventsTranslations r3_ ON r2_.RacingEventId = r3_.RacingEventId AND (r3_.LanguageCode = 'en') INNER JOIN RacingEventTypes r7_ ON r2_.RacingEventTypeId = r7_.RacingEventTypeId INNER JOIN RacingSeries r4_ ON r2_.RacingSerieId = r4_.RacingSerieId AND (r4_.SiteId IN ('1')) INNER JOIN db_countries d5_ ON r2_.CountryIso = d5_.iso INNER JOIN RacingSessionTypes r6_ ON r0_.RacingSessionTypeId = r6_.RacingSessionTypeId WHERE r4_.RacingSerieId = ? AND r0_.StartTime <= ? AND r7_.RewriteUrl = ? AND r6_.ResultType = ? ORDER BY r0_.StartTime DESC LIMIT 1

SELECT r0_.RaceSeasonId AS RaceSeasonId_0, r0_.Year AS Year_1, r1_.RacingSerieId AS RacingSerieId_2, r1_.RewriteUrl AS RewriteUrl_3, r1_.IsDefault AS IsDefault_4, r2_.RacingSeriesTranslationId AS RacingSeriesTranslationId_5, r2_.LanguageCode AS LanguageCode_6, r2_.ShortName AS ShortName_7, r2_.LongName AS LongName_8, r0_.SiteId AS SiteId_9, r0_.RacingSerieId AS RacingSerieId_10, r1_.SiteId AS SiteId_11, r1_.CountryIso AS CountryIso_12, r2_.RacingSerieId AS RacingSerieId_13 FROM RaceSeasons r0_ INNER JOIN RacingSeries r1_ ON r0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') WHERE (r1_.RewriteUrl = ? AND r1_.SiteId IN (?)) AND (r0_.SiteId IN ('1')) ORDER BY r0_.Year DESC LIMIT 1

SELECT r0_.RacingEventTypeId AS RacingEventTypeId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2 FROM RacingEventTypes r0_ WHERE r0_.RewriteUrl = ?

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_.RacingEventsTranslationId AS RacingEventsTranslationId_11, r3_.LanguageCode AS LanguageCode_12, r3_.Name AS Name_13, r4_.RacingSessionTypeId AS RacingSessionTypeId_14, r4_.RewriteUrl AS RewriteUrl_15, r4_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_16, r4_.SortingOrder AS SortingOrder_17, r4_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_18, r4_.MainEventAtBeginning AS MainEventAtBeginning_19, r4_.DefaultDuration AS DefaultDuration_20, r4_.ResultType AS ResultType_21, r4_.DefaultAdd AS DefaultAdd_22, r5_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_23, r5_.LanguageCode AS LanguageCode_24, r5_.Name AS Name_25, r6_.RaceTrackHistoryId AS RaceTrackHistoryId_26, r6_.LapLength AS LapLength_27, r6_.LapCount AS LapCount_28, r6_.Map AS Map_29, r6_.Impression AS Impression_30, r6_.StartDate AS StartDate_31, r6_.EndDate AS EndDate_32, r7_.RaceTrackId AS RaceTrackId_33, r7_.Name AS Name_34, r7_.RewriteUrl AS RewriteUrl_35, r7_.FoundingDate AS FoundingDate_36, r7_.Website AS Website_37, r7_.Description AS Description_38, c8_.CityId AS CityId_39, c8_.Latitude AS Latitude_40, c8_.Longitude AS Longitude_41, c8_.TimeOffsetFromUtc AS TimeOffsetFromUtc_42, c9_.CityTranslationId AS CityTranslationId_43, c9_.LanguageCode AS LanguageCode_44, c9_.Name AS Name_45, d10_.iso AS iso_46, d10_.iso3 AS iso3_47, d10_.numcode AS numcode_48, d11_.cntnlang AS cntnlang_49, d11_.printable_name AS printable_name_50, r0_.RaceSeasonId AS RaceSeasonId_51, r0_.RacingEventId AS RacingEventId_52, r0_.RaceTrackHistoryId AS RaceTrackHistoryId_53, r1_.RacingSessionTypeId AS RacingSessionTypeId_54, r1_.RaceCalendarId AS RaceCalendarId_55, r1_.WeatherTypeId AS WeatherTypeId_56, r1_.PhotoAlbumId AS PhotoAlbumId_57, r2_.CircuitId AS CircuitId_58, r2_.WinnerId AS WinnerId_59, r2_.RacingSerieId AS RacingSerieId_60, r2_.RacingEventTypeId AS RacingEventTypeId_61, r2_.CountryIso AS CountryIso_62, r3_.RacingEventId AS RacingEventId_63, r4_.RacingSerieId AS RacingSerieId_64, r4_.RacingEventTypeId AS RacingEventTypeId_65, r5_.RacingSessionTypeId AS RacingSessionTypeId_66, r6_.RaceTrackId AS RaceTrackId_67, r7_.CityId AS CityId_68, c8_.Country AS Country_69, c9_.CityId AS CityId_70, d11_.ISO AS ISO_71 FROM RaceCalendar r0_ INNER JOIN RaceSessions r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingEvents r2_ ON r0_.RacingEventId = r2_.RacingEventId INNER JOIN RacingEventsTranslations r3_ ON r2_.RacingEventId = r3_.RacingEventId AND (r3_.LanguageCode = 'en') INNER JOIN RacingSessionTypes r4_ ON r1_.RacingSessionTypeId = r4_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r5_ ON r4_.RacingSessionTypeId = r5_.RacingSessionTypeId AND (r5_.LanguageCode = 'en') INNER JOIN RaceTrackHistory r6_ ON r0_.RaceTrackHistoryId = r6_.RaceTrackHistoryId INNER JOIN RaceTracks r7_ ON r6_.RaceTrackId = r7_.RaceTrackId INNER JOIN Cities c8_ ON r7_.CityId = c8_.CityId INNER JOIN CityTranslations c9_ ON c8_.CityId = c9_.CityId AND (c9_.LanguageCode = 'en') INNER JOIN db_countries d10_ ON c8_.Country = d10_.iso INNER JOIN db_countries_trnsl d11_ ON d10_.iso = d11_.ISO WHERE r0_.RaceSeasonId = ? AND d11_.cntnlang = ? AND c9_.LanguageCode = ? ORDER BY r1_.StartTime ASC, r4_.SortingOrder ASC

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

module:News\Breaking (2Q - total module time: 0.00128198s)

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') WHERE ((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.breaking = ?) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 100