F1 Race resultaten van 16 september 2018 op Marina Bay Street Circuit

instantiate query log (1Q - total module time: 0.01722383s)

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

boot (1Q - total module time: 0.01317000s)

SELECT l0_.LanguageId AS LanguageId_0, l0_.Code AS Code_1, l0_.FlagCode AS FlagCode_2, l0_.LongName AS LongName_3, l0_.Visible AS Visible_4, l0_.Maintained AS Maintained_5, l0_.SortOrder AS SortOrder_6, l0_.SiteId AS SiteId_7 FROM Languages l0_ WHERE l0_.Visible = 1 AND l0_.SiteId IN (?) ORDER BY l0_.SortOrder ASC

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

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

controller::uitslagen/race/2018/09/16/grand-prix-van-singapore (2Q - total module time: 0.00772285s)

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 = 'nl') 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 = 'nl') 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 = 'nl') 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 20 rows (4Q - total module time: 0.00507784s)

/* 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` = 'nl' 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 (19633,19636,19626,19634,19625,19635,19631,19637,19639,19638,19640,19632,19642,19643,19630,20713,19641,19629,19644,20712)

/* 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` = 'nl' 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` = 'nl' 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` = 'nl' WHERE res.`RaceParticipantId` IN (19633,19636,19626,19634,19625,19635,19631,19637,19639,19638,19640,19632,19642,19643,19630,20713,19641,19629,19644,20712)

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 = 'nl') 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 (6Q - total module time: 0.02793312s)

/* 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` = 'nl' 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 (19633,19636,19626,19634,19625,19635,19631,19637,19639,19638,19640,19632,19642,19643,19630,20713,19641,19629,19644,20712)

/* 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` = 'nl' 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` = 'nl' 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` = 'nl' WHERE res.`RaceParticipantId` IN (19633,19636,19626,19634,19625,19635,19631,19637,19639,19638,19640,19632,19642,19643,19630,20713,19641,19629,19644,20712)

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 = 'nl') 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 = 'nl') 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

module:Sidebar (1Q - total module time: 0.01838088s)

SELECT p0_.PageContentItemId AS PageContentItemId_0, p0_.Enabled AS Enabled_1, p0_.SortOrder AS SortOrder_2, p1_.PageModuleId AS PageModuleId_3, p1_.Name AS Name_4, p1_.Description AS Description_5, p2_.PagePositionId AS PagePositionId_6, p2_.Name AS Name_7, p2_.Description AS Description_8, p3_.PageModuleConfigId AS PageModuleConfigId_9, p3_.ParamName AS ParamName_10, p3_.TableName AS TableName_11, p3_.DescField AS DescField_12, p3_.IdField AS IdField_13, p3_.FilterField AS FilterField_14, p3_.FilterOperator AS FilterOperator_15, p3_.FilterValue AS FilterValue_16, p3_.AllowMultiple AS AllowMultiple_17, p4_.PageContentItemConfigId AS PageContentItemConfigId_18, p4_.Parameter AS Parameter_19, p4_.Value AS Value_20, p0_.SiteId AS SiteId_21, p0_.PageModuleId AS PageModuleId_22, p0_.PagePositionId AS PagePositionId_23, p3_.PageModuleId AS PageModuleId_24, p4_.PageContentItemId AS PageContentItemId_25 FROM PageContentItems p0_ INNER JOIN PageModules p1_ ON p0_.PageModuleId = p1_.PageModuleId INNER JOIN PagePositions p2_ ON p0_.PagePositionId = p2_.PagePositionId LEFT JOIN PageModuleConfig p3_ ON p1_.PageModuleId = p3_.PageModuleId LEFT JOIN PageContentItemsConfig p4_ ON p0_.PageContentItemId = p4_.PageContentItemId WHERE (p0_.SiteId IN (?)) AND (p0_.SiteId IN ('1')) ORDER BY p0_.SortOrder ASC

sidebar:ads-header-just-before-closing-head-tag::ads (0Q - total module time: 0.00001788s)

module:Ads (1Q - total module time: 0.26740503s)

SELECT a0_.AdvertisementId AS AdvertisementId_0, a0_.Description AS Description_1, a0_.AdScript AS AdScript_2, a0_.Enabled AS Enabled_3, a0_.cntnlang AS cntnlang_4, a0_.SiteId AS SiteId_5 FROM Advertisements a0_ WHERE ((a0_.cntnlang = ? OR a0_.cntnlang IS NULL OR a0_.cntnlang = '') AND a0_.Enabled = ? AND a0_.SiteId IN (?)) AND (a0_.SiteId IN ('1'))

sidebar:ads-header-just-before-closing-head-tag::ads (0Q - total module time: 0.00001597s)

module:Ads (0Q - total module time: 0.00000596s)

sidebar:ads-header-just-before-closing-head-tag::ads (0Q - total module time: 0.00000191s)

module:Ads (0Q - total module time: 0.00000095s)

sidebar:ads-header-just-before-closing-head-tag::ads (0Q - total module time: 0.00000191s)

module:Ads (0Q - total module time: 0.00000095s)

sidebar:ads-header-just-before-closing-head-tag::ads (0Q - total module time: 0.00000191s)

module:Ads (0Q - total module time: 0.00002098s)

module:Sidebar (2Q - total module time: 0.24932694s)

SELECT l0_.LandingPageId AS LandingPageId_0, l0_.RewriteUrl AS RewriteUrl_1, l0_.Cntnlang AS Cntnlang_2, l0_.NewsYear AS NewsYear_3, l0_.MetaTitle AS MetaTitle_4, l0_.MetaDescription AS MetaDescription_5, l0_.MetaKeywords AS MetaKeywords_6, l0_.TitleH1 AS TitleH1_7, l0_.TopContent AS TopContent_8, l0_.BottomContent AS BottomContent_9, l0_.HideOnNews AS HideOnNews_10, l0_.SubMenuItem AS SubMenuItem_11, l0_.SubMenuItemLabel AS SubMenuItemLabel_12, l0_.SiteId AS SiteId_13, l0_.RacingSerieId AS RacingSerieId_14 FROM LandingPages l1_ INNER JOIN RacingSeries r2_ ON l1_.RacingSerieId = r2_.RacingSerieId AND (r2_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r3_ ON r2_.RacingSerieId = r3_.RacingSerieId AND (r3_.LanguageCode = 'nl'), LandingPages l0_ WHERE l0_.SubMenuItem = ? AND l0_.Cntnlang = ?

SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, d2_.iso AS iso_19, d2_.iso3 AS iso3_20, d2_.numcode AS numcode_21, p3_.PersonCareerId AS PersonCareerId_22, p3_.StartDate AS StartDate_23, p3_.EndDate AS EndDate_24, p3_.ProfilePhoto AS ProfilePhoto_25, p3_.StartNumber AS StartNumber_26, o4_.OrganisationHistoryId AS OrganisationHistoryId_27, o4_.Name AS Name_28, o4_.StartDate AS StartDate_29, o4_.EndDate AS EndDate_30, o4_.Photo AS Photo_31, o4_.SmallLogo AS SmallLogo_32, o4_.City AS City_33, o4_.Website AS Website_34, o5_.OrganisationId AS OrganisationId_35, o5_.Name AS Name_36, o5_.FoundingDate AS FoundingDate_37, o5_.Photo AS Photo_38, o6_.OrganisationId AS OrganisationId_39, o6_.Name AS Name_40, o6_.FoundingDate AS FoundingDate_41, o6_.Photo AS Photo_42, k7_.KeywordId AS KeywordId_43, k7_.Keyword AS Keyword_44, k7_.RewriteUrl AS RewriteUrl_45, k7_.Category AS Category_46, k7_.CommentCount AS CommentCount_47, p0_.Nationality AS Nationality_48, p0_.KeywordId AS KeywordId_49, p0_.PrimaryCareerId AS PrimaryCareerId_50, p0_.SiteId AS SiteId_51, k1_.ParentId AS ParentId_52, p3_.PersonRoleId AS PersonRoleId_53, p3_.OrganisationHistoryId AS OrganisationHistoryId_54, p3_.PersonId AS PersonId_55, o4_.OrganisationRoleId AS OrganisationRoleId_56, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_57, o4_.RacingSerieId AS RacingSerieId_58, o5_.KeywordId AS KeywordId_59, o5_.Nationality AS Nationality_60, o6_.KeywordId AS KeywordId_61, o6_.Nationality AS Nationality_62, k7_.ParentId AS ParentId_63 FROM Persons p0_ INNER JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId INNER JOIN db_countries d2_ ON p0_.Nationality = d2_.iso INNER JOIN db_countries_trnsl d8_ ON d2_.iso = d8_.ISO INNER JOIN PersonCareer p3_ ON p0_.PersonId = p3_.PersonId INNER JOIN OrganisationHistory o4_ ON p3_.OrganisationHistoryId = o4_.OrganisationHistoryId INNER JOIN OrganisationOrganisationHistory o9_ ON o4_.OrganisationHistoryId = o9_.OrganisationHistoryId INNER JOIN Organisations o5_ ON o5_.OrganisationId = o9_.OrganisationId INNER JOIN Organisations o6_ ON o4_.PrimaryOrganisationId = o6_.OrganisationId INNER JOIN Keywords k7_ ON o6_.KeywordId = k7_.KeywordId WHERE d8_.cntnlang = ? AND p0_.InHeaderList = 1 AND ((p3_.StartDate >= ? AND p3_.EndDate <= ?) AND p3_.PersonRoleId IN (?)) ORDER BY p0_.FirstName ASC, p0_.LastName ASC

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

sidebar:ads-header-leaderboard::ads (0Q - total module time: 0.00001097s)

module:Ads (0Q - total module time: 0.00000501s)

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

module:Ads (0Q - total module time: 0.00000119s)

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

module:Ads (0Q - total module time: 0.00000215s)

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

module:Ads (0Q - total module time: 0.00000191s)

sidebar:ads-header-leaderboard::ads (0Q - total module time: 0.00000215s)

module:Ads (0Q - total module time: 0.00000596s)

module:Sidebar (15Q - total module time: 0.00808716s)

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')))

SELECT t0.RacingSeriesTranslationId AS RacingSeriesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.ShortName AS ShortName_3, t0.LongName AS LongName_4, t0.RacingSerieId AS RacingSerieId_5 FROM RacingSeriesTranslations t0 WHERE t0.RacingSerieId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RaceSessionId AS RaceSessionId_1, t0.StartTime AS StartTime_2, t0.EndTime AS EndTime_3, t0.TrackTemperature AS TrackTemperature_4, t0.AirTemperature AS AirTemperature_5, t0.TrackFlag AS TrackFlag_6, t0.RacingSessionTypeId AS RacingSessionTypeId_7, t0.RaceCalendarId AS RaceCalendarId_8, t0.WeatherTypeId AS WeatherTypeId_9, t0.PhotoAlbumId AS PhotoAlbumId_10 FROM RaceSessions t0 WHERE t0.RaceCalendarId = ?

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

SELECT t0.RacingSessionTypeId AS RacingSessionTypeId_1, t0.RewriteUrl AS RewriteUrl_2, t0.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_3, t0.SortingOrder AS SortingOrder_4, t0.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_5, t0.MainEventAtBeginning AS MainEventAtBeginning_6, t0.DefaultDuration AS DefaultDuration_7, t0.ResultType AS ResultType_8, t0.DefaultAdd AS DefaultAdd_9, t0.RacingSerieId AS RacingSerieId_10, t0.RacingEventTypeId AS RacingEventTypeId_11 FROM RacingSessionTypes t0 WHERE t0.RacingSessionTypeId = ?

SELECT t0.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_1, t0.LanguageCode AS LanguageCode_2, t0.Name AS Name_3, t0.RacingSessionTypeId AS RacingSessionTypeId_4 FROM RacingSessionTypesTranslations t0 WHERE t0.RacingSessionTypeId = ? AND ((t0.LanguageCode = 'nl'))

module:Circuit (1Q - total module time: 0.04310894s)

SELECT r0_.RaceTrackId AS RaceTrackId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2, r0_.FoundingDate AS FoundingDate_3, r0_.Website AS Website_4, r0_.Description AS Description_5, c1_.CityId AS CityId_6, c1_.Latitude AS Latitude_7, c1_.Longitude AS Longitude_8, c1_.TimeOffsetFromUtc AS TimeOffsetFromUtc_9, c2_.CityTranslationId AS CityTranslationId_10, c2_.LanguageCode AS LanguageCode_11, c2_.Name AS Name_12, d3_.iso AS iso_13, d3_.iso3 AS iso3_14, d3_.numcode AS numcode_15, d4_.cntnlang AS cntnlang_16, d4_.printable_name AS printable_name_17, r0_.CityId AS CityId_18, c1_.Country AS Country_19, c2_.CityId AS CityId_20, d4_.ISO AS ISO_21 FROM RaceTracks r0_ INNER JOIN Cities c1_ ON r0_.CityId = c1_.CityId INNER JOIN CityTranslations c2_ ON c1_.CityId = c2_.CityId AND (c2_.LanguageCode = 'nl') INNER JOIN db_countries d3_ ON c1_.Country = d3_.iso INNER JOIN db_countries_trnsl d4_ ON d3_.iso = d4_.ISO WHERE r0_.RewriteUrl = ? AND d4_.cntnlang = ?

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

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

module:Ads (0Q - total module time: 0.00000811s)

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

module:Ads (0Q - total module time: 0.00000095s)

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

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

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

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

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 = 'nl') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'nl') 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 = 'nl') 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 0 rows (2Q - total module time: 0.00097704s)

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 = 'nl') 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 0 rows (2Q - total module time: 0.00065684s)

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 = 'nl') 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 0 rows (2Q - total module time: 0.00062799s)

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 = 'nl') 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 (2Q - total module time: 0.00061798s)

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 = 'nl') 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 (2Q - total module time: 0.00034690s)

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 = 'nl') 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 (2Q - total module time: 0.00058913s)

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 = 'nl') 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 (2Q - total module time: 0.00059104s)

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 = 'nl') 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 0 rows (3Q - total module time: 0.02353597s)

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 = 'nl') 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 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.00000978s)

module:TestCalendar (2Q - total module time: 0.04609609s)

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 = 'nl') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'nl') 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 = 'nl') 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 (RaceSeasonId = :param1) AND rst.ResultType = :param2 AND res.Position = :param3 ORDER BY rs.StartTime

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

/* 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` = 'nl' 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` = 'nl' 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` = 'nl' 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` = 'nl' 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 = 'nl') 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 = 'nl') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'nl') 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 = 'nl') 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 = 'nl') INNER JOIN RacingSessionTypes r6_ ON r1_.RacingSessionTypeId = r6_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r7_ ON r6_.RacingSessionTypeId = r7_.RacingSessionTypeId AND (r7_.LanguageCode = 'nl') 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 = 'nl') 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 = 'nl') 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.00001502s)

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

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 = 'nl') 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 = 'nl') 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 = 'nl') 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 = 'nl') INNER JOIN RacingSessionTypes r4_ ON r1_.RacingSessionTypeId = r4_.RacingSessionTypeId INNER JOIN RacingSessionTypesTranslations r5_ ON r4_.RacingSessionTypeId = r5_.RacingSessionTypeId AND (r5_.LanguageCode = 'nl') 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 = 'nl') 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 (3Q - total module time: 0.04829812s)

SELECT o0_.OrganisationId AS OrganisationId_0, o0_.Name AS Name_1, o0_.FoundingDate AS FoundingDate_2, o0_.Photo AS Photo_3, o1_.OrganisationHistoryId AS OrganisationHistoryId_4, o1_.Name AS Name_5, o1_.StartDate AS StartDate_6, o1_.EndDate AS EndDate_7, o1_.Photo AS Photo_8, o1_.SmallLogo AS SmallLogo_9, o1_.City AS City_10, o1_.Website AS Website_11, r2_.RacingSerieId AS RacingSerieId_12, r2_.RewriteUrl AS RewriteUrl_13, r2_.IsDefault AS IsDefault_14, k3_.KeywordId AS KeywordId_15, k3_.Keyword AS Keyword_16, k3_.RewriteUrl AS RewriteUrl_17, k3_.Category AS Category_18, k3_.CommentCount AS CommentCount_19, d4_.iso AS iso_20, d4_.iso3 AS iso3_21, d4_.numcode AS numcode_22, o0_.KeywordId AS KeywordId_23, o0_.Nationality AS Nationality_24, o1_.OrganisationRoleId AS OrganisationRoleId_25, o1_.PrimaryOrganisationId AS PrimaryOrganisationId_26, o1_.RacingSerieId AS RacingSerieId_27, r2_.SiteId AS SiteId_28, r2_.CountryIso AS CountryIso_29, k3_.ParentId AS ParentId_30 FROM Organisations o0_ INNER JOIN OrganisationOrganisationHistory o5_ ON o0_.OrganisationId = o5_.OrganisationId INNER JOIN OrganisationHistory o1_ ON o1_.OrganisationHistoryId = o5_.OrganisationHistoryId INNER JOIN RacingSeries r2_ ON o1_.RacingSerieId = r2_.RacingSerieId AND (r2_.SiteId IN ('1')) INNER JOIN Keywords k3_ ON o0_.KeywordId = k3_.KeywordId INNER JOIN db_countries d4_ ON o0_.Nationality = d4_.iso WHERE r2_.SiteId = ? AND o1_.PrimaryOrganisationId = o0_.OrganisationId AND o1_.OrganisationRoleId IN (?) ORDER BY o0_.Name ASC, o1_.EndDate DESC LIMIT 50

SELECT r0_.RaceTrackId AS RaceTrackId_0, r0_.Name AS Name_1, r0_.RewriteUrl AS RewriteUrl_2, r0_.FoundingDate AS FoundingDate_3, r0_.Website AS Website_4, r0_.Description AS Description_5, r0_.CityId AS CityId_6 FROM RaceTracks r0_ ORDER BY r0_.Name ASC LIMIT 25

SELECT p0_.PersonId AS PersonId_0, p0_.LastName AS LastName_1, p0_.FirstName AS FirstName_2, p0_.Birthdate AS Birthdate_3, p0_.DateOfDeath AS DateOfDeath_4, p0_.Residence AS Residence_5, p0_.BirthCity AS BirthCity_6, p0_.ProfilePhoto AS ProfilePhoto_7, p0_.Height AS Height_8, p0_.Website AS Website_9, p0_.Weight AS Weight_10, p0_.InternalNotes AS InternalNotes_11, p0_.InHeaderList AS InHeaderList_12, p0_.InFooterList AS InFooterList_13, k1_.KeywordId AS KeywordId_14, k1_.Keyword AS Keyword_15, k1_.RewriteUrl AS RewriteUrl_16, k1_.Category AS Category_17, k1_.CommentCount AS CommentCount_18, d2_.iso AS iso_19, d2_.iso3 AS iso3_20, d2_.numcode AS numcode_21, p3_.PersonCareerId AS PersonCareerId_22, p3_.StartDate AS StartDate_23, p3_.EndDate AS EndDate_24, p3_.ProfilePhoto AS ProfilePhoto_25, p3_.StartNumber AS StartNumber_26, o4_.OrganisationHistoryId AS OrganisationHistoryId_27, o4_.Name AS Name_28, o4_.StartDate AS StartDate_29, o4_.EndDate AS EndDate_30, o4_.Photo AS Photo_31, o4_.SmallLogo AS SmallLogo_32, o4_.City AS City_33, o4_.Website AS Website_34, o5_.OrganisationId AS OrganisationId_35, o5_.Name AS Name_36, o5_.FoundingDate AS FoundingDate_37, o5_.Photo AS Photo_38, o6_.OrganisationId AS OrganisationId_39, o6_.Name AS Name_40, o6_.FoundingDate AS FoundingDate_41, o6_.Photo AS Photo_42, k7_.KeywordId AS KeywordId_43, k7_.Keyword AS Keyword_44, k7_.RewriteUrl AS RewriteUrl_45, k7_.Category AS Category_46, k7_.CommentCount AS CommentCount_47, p0_.Nationality AS Nationality_48, p0_.KeywordId AS KeywordId_49, p0_.PrimaryCareerId AS PrimaryCareerId_50, p0_.SiteId AS SiteId_51, k1_.ParentId AS ParentId_52, p3_.PersonRoleId AS PersonRoleId_53, p3_.OrganisationHistoryId AS OrganisationHistoryId_54, p3_.PersonId AS PersonId_55, o4_.OrganisationRoleId AS OrganisationRoleId_56, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_57, o4_.RacingSerieId AS RacingSerieId_58, o5_.KeywordId AS KeywordId_59, o5_.Nationality AS Nationality_60, o6_.KeywordId AS KeywordId_61, o6_.Nationality AS Nationality_62, k7_.ParentId AS ParentId_63 FROM Persons p0_ INNER JOIN Keywords k1_ ON p0_.KeywordId = k1_.KeywordId INNER JOIN db_countries d2_ ON p0_.Nationality = d2_.iso INNER JOIN db_countries_trnsl d8_ ON d2_.iso = d8_.ISO INNER JOIN PersonCareer p3_ ON p0_.PersonId = p3_.PersonId INNER JOIN OrganisationHistory o4_ ON p3_.OrganisationHistoryId = o4_.OrganisationHistoryId INNER JOIN OrganisationOrganisationHistory o9_ ON o4_.OrganisationHistoryId = o9_.OrganisationHistoryId INNER JOIN Organisations o5_ ON o5_.OrganisationId = o9_.OrganisationId INNER JOIN Organisations o6_ ON o4_.PrimaryOrganisationId = o6_.OrganisationId INNER JOIN Keywords k7_ ON o6_.KeywordId = k7_.KeywordId WHERE d8_.cntnlang = ? AND p0_.InFooterList = 1 AND ((p3_.StartDate >= ? AND p3_.EndDate <= ?) AND p3_.PersonRoleId IN (?)) ORDER BY p0_.FirstName ASC, p0_.LastName ASC

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

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 = 'nl') 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