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

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.01397991s)

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.00074410s)

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

controller::news/f1/231872/raikkonen-ends-final-practice-on-top-as-mercedes-continue-to-struggle (16Q - total module time: 1.90547585s)

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, p3_.id AS id_34, p3_.year AS year_35, p3_.uservisible AS uservisible_36, p3_.PhotoCount AS PhotoCount_37, p4_.photoalbumNameID AS photoalbumNameID_38, p4_.name AS name_39, p4_.event AS event_40, p4_.cntnlang AS cntnlang_41, c5_.CmsAccountId AS CmsAccountId_42, c5_.CreateDate AS CreateDate_43, c5_.AccountName AS AccountName_44, c5_.Password AS Password_45, c5_.LastName AS LastName_46, c5_.FirstName AS FirstName_47, c5_.PrivateMail AS PrivateMail_48, c5_.F1TodayMail AS F1TodayMail_49, c5_.PhoneNumber AS PhoneNumber_50, c5_.Address AS Address_51, c5_.PostalCode AS PostalCode_52, c5_.City AS City_53, c5_.BirthDate AS BirthDate_54, c5_.JobTitle AS JobTitle_55, c5_.FavouriteDriver AS FavouriteDriver_56, c5_.FavouriteTeam AS FavouriteTeam_57, c5_.Interests AS Interests_58, c5_.WorkStartDate AS WorkStartDate_59, c5_.WorkingHours AS WorkingHours_60, c5_.Disabled AS Disabled_61, c5_.LastOnline AS LastOnline_62, c5_.RetrievalId AS RetrievalId_63, c5_.Notes AS Notes_64, a0_.SiteId AS SiteId_65, a0_.RaceTrackHistoryId AS RaceTrackHistoryId_66, a0_.RacingSerieId AS RacingSerieId_67, a0_.PhotoAlbumId AS PhotoAlbumId_68, a0_.CmsAccountId AS CmsAccountId_69, a0_.PollId AS PollId_70, a0_.RaceSessionId AS RaceSessionId_71, r1_.SiteId AS SiteId_72, r1_.CountryIso AS CountryIso_73, r2_.RacingSerieId AS RacingSerieId_74, p3_.SiteId AS SiteId_75, p4_.photoalbumID AS photoalbumID_76 FROM Articles a0_ INNER JOIN RacingSeries r1_ ON a0_.RacingSerieId = r1_.RacingSerieId AND (r1_.SiteId IN ('1')) INNER JOIN RacingSeriesTranslations r2_ ON r1_.RacingSerieId = r2_.RacingSerieId AND (r2_.LanguageCode = 'en') LEFT JOIN photoalbums p3_ ON a0_.PhotoAlbumId = p3_.id AND (p3_.SiteId IN ('1')) LEFT JOIN photoalbum_names p4_ ON p3_.id = p4_.photoalbumID AND (p4_.cntnlang IN (?)) INNER JOIN CmsAccounts c5_ ON a0_.CmsAccountId = c5_.CmsAccountId WHERE (((((a0_.cntnlang IN (?) AND a0_.SiteId IN (?)) AND a0_.Activated = ?) AND a0_.PublishDate < ?) AND a0_.ArticleType IN (?)) AND a0_.ArticleId = ?) AND (a0_.SiteId IN ('1')) ORDER BY a0_.PublishDate DESC LIMIT 1

SELECT `ArticleId`, `Articles`.`CommentCount` as 'CommentCount' FROM `Articles` WHERE `Articles`.`ArticleId` = :article_id LIMIT 0, 1

SELECT k0_.KeywordId AS KeywordId_0, k0_.Keyword AS Keyword_1, k0_.RewriteUrl AS RewriteUrl_2, k0_.Category AS Category_3, k0_.CommentCount AS CommentCount_4, k0_.ParentId AS ParentId_5 FROM Keywords k0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = k0_.KeywordId) WHERE k1_.nieuwsID = ?

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId > :articleId ORDER BY Articles.ArticleId ASC LIMIT 1

SELECT Articles.ArticleId AS ArticleId, Articles.RewriteUrl AS RewriteUrl, Articles.ArticleType as ArticleType, Articles.Category as Category, Articles.cntnlang AS cntnlang, RacingSeries.RewriteUrl AS RacingSeriesRewriteUrl FROM Articles INNER JOIN RacingSeries ON Articles.RacingSerieId = RacingSeries.RacingSerieId WHERE Articles.cntnlang = :siteLang AND Articles.SiteId = :siteId AND Articles.Activated = 1 AND Articles.PublishDate < :publishDate AND Articles.ArticleType IN (:param0, :param1, :param2) AND Articles.ArticleId < :articleId ORDER BY Articles.ArticleId DESC LIMIT 1

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.UploadDate AS UploadDate_2, p0_.title AS title_3, p0_.fotoDatum AS fotoDatum_4, p0_.FileSize AS FileSize_5, p0_.Height AS Height_6, p0_.Width AS Width_7, p0_.ImageFormat AS ImageFormat_8, p0_.album_id AS album_id_9 FROM photos p0_ WHERE p0_.name = ?

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_.keyword_combinationID AS keyword_combinationID_14, p2_.PersonCareerId AS PersonCareerId_15, p2_.StartDate AS StartDate_16, p2_.EndDate AS EndDate_17, p2_.ProfilePhoto AS ProfilePhoto_18, p2_.StartNumber AS StartNumber_19, d3_.iso AS iso_20, d3_.iso3 AS iso3_21, d3_.numcode AS numcode_22, o4_.OrganisationHistoryId AS OrganisationHistoryId_23, o4_.Name AS Name_24, o4_.StartDate AS StartDate_25, o4_.EndDate AS EndDate_26, o4_.Photo AS Photo_27, o4_.SmallLogo AS SmallLogo_28, o4_.City AS City_29, o4_.Website AS Website_30, p5_.PersonRoleId AS PersonRoleId_31, p6_.PersonRolesTranslationId AS PersonRolesTranslationId_32, p6_.LanguageCode AS LanguageCode_33, p6_.Name AS Name_34, r7_.RacingSerieId AS RacingSerieId_35, r7_.RewriteUrl AS RewriteUrl_36, r7_.IsDefault AS IsDefault_37, r8_.RacingSeriesTranslationId AS RacingSeriesTranslationId_38, r8_.LanguageCode AS LanguageCode_39, r8_.ShortName AS ShortName_40, r8_.LongName AS LongName_41, p0_.Nationality AS Nationality_42, p0_.KeywordId AS KeywordId_43, p0_.PrimaryCareerId AS PrimaryCareerId_44, p0_.SiteId AS SiteId_45, k1_.keywordID AS keywordID_46, k1_.nieuwsID AS nieuwsID_47, p2_.PersonRoleId AS PersonRoleId_48, p2_.OrganisationHistoryId AS OrganisationHistoryId_49, p2_.PersonId AS PersonId_50, o4_.OrganisationRoleId AS OrganisationRoleId_51, o4_.PrimaryOrganisationId AS PrimaryOrganisationId_52, o4_.RacingSerieId AS RacingSerieId_53, p6_.PersonRoleId AS PersonRoleId_54, r7_.SiteId AS SiteId_55, r7_.CountryIso AS CountryIso_56, r8_.RacingSerieId AS RacingSerieId_57 FROM Persons p0_ INNER JOIN keyword_combinations k1_ ON (k1_.keywordID = p0_.KeywordId) LEFT JOIN PersonCareer p2_ ON p0_.PrimaryCareerId = p2_.PersonCareerId INNER JOIN db_countries d3_ ON p0_.Nationality = d3_.iso INNER JOIN db_countries_trnsl d9_ ON d3_.iso = d9_.ISO LEFT JOIN OrganisationHistory o4_ ON p2_.OrganisationHistoryId = o4_.OrganisationHistoryId LEFT JOIN PersonRoles p5_ ON p2_.PersonRoleId = p5_.PersonRoleId LEFT JOIN PersonRolesTranslations p6_ ON p5_.PersonRoleId = p6_.PersonRoleId AND (p6_.LanguageCode = 'en') LEFT JOIN RacingSeries r7_ ON o4_.RacingSerieId = r7_.RacingSerieId AND (r7_.SiteId IN ('1')) LEFT JOIN RacingSeriesTranslations r8_ ON r7_.RacingSerieId = r8_.RacingSerieId AND (r8_.LanguageCode = 'en') WHERE k1_.nieuwsID = ? AND d9_.cntnlang = ?

SELECT o0_.OrganisationId AS OrganisationId_0, o0_.Name AS Name_1, o0_.FoundingDate AS FoundingDate_2, o0_.Photo AS Photo_3, k1_.KeywordId AS KeywordId_4, k1_.Keyword AS Keyword_5, k1_.RewriteUrl AS RewriteUrl_6, k1_.Category AS Category_7, k1_.CommentCount AS CommentCount_8, o2_.OrganisationHistoryId AS OrganisationHistoryId_9, o2_.Name AS Name_10, o2_.StartDate AS StartDate_11, o2_.EndDate AS EndDate_12, o2_.Photo AS Photo_13, o2_.SmallLogo AS SmallLogo_14, o2_.City AS City_15, o2_.Website AS Website_16, d3_.iso AS iso_17, d3_.iso3 AS iso3_18, d3_.numcode AS numcode_19, d4_.cntnlang AS cntnlang_20, d4_.printable_name AS printable_name_21, o0_.KeywordId AS KeywordId_22, o0_.Nationality AS Nationality_23, k1_.ParentId AS ParentId_24, o2_.OrganisationRoleId AS OrganisationRoleId_25, o2_.PrimaryOrganisationId AS PrimaryOrganisationId_26, o2_.RacingSerieId AS RacingSerieId_27, d4_.ISO AS ISO_28 FROM Organisations o0_ INNER JOIN keyword_combinations k5_ ON (k5_.keywordID = o0_.KeywordId) INNER JOIN Keywords k1_ ON o0_.KeywordId = k1_.KeywordId INNER JOIN OrganisationOrganisationHistory o6_ ON o0_.OrganisationId = o6_.OrganisationId INNER JOIN OrganisationHistory o2_ ON o2_.OrganisationHistoryId = o6_.OrganisationHistoryId INNER JOIN db_countries d3_ ON o0_.Nationality = d3_.iso INNER JOIN db_countries_trnsl d4_ ON d3_.iso = d4_.ISO WHERE k5_.nieuwsID = ? AND d4_.cntnlang = ? ORDER BY o2_.EndDate DESC

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.RaceSessionId = ?

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_.RacingSessionTypeId AS RacingSessionTypeId_8, r2_.RewriteUrl AS RewriteUrl_9, r2_.SuccessorToRacingSessionTypeId AS SuccessorToRacingSessionTypeId_10, r2_.SortingOrder AS SortingOrder_11, r2_.DefaultTimeOffsetFromRaceEvent AS DefaultTimeOffsetFromRaceEvent_12, r2_.MainEventAtBeginning AS MainEventAtBeginning_13, r2_.DefaultDuration AS DefaultDuration_14, r2_.ResultType AS ResultType_15, r2_.DefaultAdd AS DefaultAdd_16, r3_.RacingSerieId AS RacingSerieId_17, r3_.RewriteUrl AS RewriteUrl_18, r3_.IsDefault AS IsDefault_19, r4_.RacingSessionTypesTranslationId AS RacingSessionTypesTranslationId_20, r4_.LanguageCode AS LanguageCode_21, r4_.Name AS Name_22, r5_.RacingSeriesTranslationId AS RacingSeriesTranslationId_23, r5_.LanguageCode AS LanguageCode_24, r5_.ShortName AS ShortName_25, r5_.LongName AS LongName_26, r6_.RacingEventId AS RacingEventId_27, r6_.RewriteUrl AS RewriteUrl_28, r6_.Content AS Content_29, r7_.RacingEventsTranslationId AS RacingEventsTranslationId_30, r7_.LanguageCode AS LanguageCode_31, r7_.Name AS Name_32, r0_.RacingSessionTypeId AS RacingSessionTypeId_33, r0_.RaceCalendarId AS RaceCalendarId_34, r0_.WeatherTypeId AS WeatherTypeId_35, r0_.PhotoAlbumId AS PhotoAlbumId_36, r1_.RaceSeasonId AS RaceSeasonId_37, r1_.RacingEventId AS RacingEventId_38, r1_.RaceTrackHistoryId AS RaceTrackHistoryId_39, r2_.RacingSerieId AS RacingSerieId_40, r2_.RacingEventTypeId AS RacingEventTypeId_41, r3_.SiteId AS SiteId_42, r3_.CountryIso AS CountryIso_43, r4_.RacingSessionTypeId AS RacingSessionTypeId_44, r5_.RacingSerieId AS RacingSerieId_45, r6_.CircuitId AS CircuitId_46, r6_.WinnerId AS WinnerId_47, r6_.RacingSerieId AS RacingSerieId_48, r6_.RacingEventTypeId AS RacingEventTypeId_49, r6_.CountryIso AS CountryIso_50, r7_.RacingEventId AS RacingEventId_51 FROM RaceSessions r0_ INNER JOIN RaceCalendar r1_ ON r0_.RaceCalendarId = r1_.RaceCalendarId INNER JOIN RacingSessionTypes r2_ ON r0_.RacingSessionTypeId = r2_.RacingSessionTypeId INNER JOIN RacingSeries r3_ ON r2_.RacingSerieId = r3_.RacingSerieId AND (r3_.SiteId IN ('1')) INNER JOIN RacingSessionTypesTranslations r4_ ON r2_.RacingSessionTypeId = r4_.RacingSessionTypeId AND (r4_.LanguageCode = 'en') INNER JOIN RacingSeriesTranslations r5_ ON r3_.RacingSerieId = r5_.RacingSerieId AND (r5_.LanguageCode = 'en') INNER JOIN RacingEvents r6_ ON r1_.RacingEventId = r6_.RacingEventId INNER JOIN RacingEventsTranslations r7_ ON r6_.RacingEventId = r7_.RacingEventId AND (r7_.LanguageCode = 'en') WHERE r0_.RaceSessionId = ?

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

SELECT r0_.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 = 'en') INNER JOIN db_countries d3_ ON c1_.Country = d3_.iso INNER JOIN db_countries_trnsl d4_ ON d3_.iso = d4_.ISO WHERE r0_.RaceTrackId = ? AND d4_.cntnlang = ?

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.UploadDate AS UploadDate_2, p0_.title AS title_3, p0_.fotoDatum AS fotoDatum_4, p0_.FileSize AS FileSize_5, p0_.Height AS Height_6, p0_.Width AS Width_7, p0_.ImageFormat AS ImageFormat_8, p1_.id AS id_9, p1_.year AS year_10, p1_.uservisible AS uservisible_11, p1_.PhotoCount AS PhotoCount_12, p0_.album_id AS album_id_13, p1_.SiteId AS SiteId_14 FROM photos p0_ INNER JOIN photoalbums p1_ ON p0_.album_id = p1_.id AND (p1_.SiteId IN ('1')) WHERE p1_.id = ? ORDER BY p0_.fotoDatum DESC

SELECT c0_.CommentId AS CommentId_0, c0_.Date AS Date_1, c0_.Content AS Content_2, c0_.BlockReason AS BlockReason_3, c0_.cntnlang AS cntnlang_4, c0_.PosterIp AS PosterIp_5, u1_.UserId AS UserId_6, u1_.RegistrationDate AS RegistrationDate_7, u1_.Username AS Username_8, u1_.RewriteUrl AS RewriteUrl_9, u1_.EmailAddress AS EmailAddress_10, u1_.FirstName AS FirstName_11, u1_.LastName AS LastName_12, u1_.Birthdate AS Birthdate_13, u1_.Gender AS Gender_14, u1_.Website AS Website_15, u1_.Twitter AS Twitter_16, u1_.CurrentCar AS CurrentCar_17, u1_.DreamCar AS DreamCar_18, u1_.Facebook AS Facebook_19, u1_.Occupation AS Occupation_20, u1_.Interests AS Interests_21, u1_.Activated AS Activated_22, u1_.Banned AS Banned_23, u1_.Subscribed AS Subscribed_24, u1_.RegistrationIp AS RegistrationIp_25, u1_.LastUpdated AS LastUpdated_26, u1_.AllowCommentModeration AS AllowCommentModeration_27, u1_.CommentsCount AS CommentsCount_28, u1_.NotificationCount AS NotificationCount_29, u1_.TotalCommentVoteSum AS TotalCommentVoteSum_30, u1_.Residence AS Residence_31, u1_.Icon AS Icon_32, u1_.ModerateAllComments AS ModerateAllComments_33, u1_.PremiumUser AS PremiumUser_34, u1_.CrewNotes AS CrewNotes_35, u1_.PwdHash AS PwdHash_36, u1_.ActivationId AS ActivationId_37, u1_.RetrievalId AS RetrievalId_38, u1_.ProfileLastUpdated AS ProfileLastUpdated_39, u1_.LastOnline AS LastOnline_40, d2_.iso AS iso_41, d2_.iso3 AS iso3_42, d2_.numcode AS numcode_43, c0_.SiteId AS SiteId_44, c0_.ArticleId AS ArticleId_45, c0_.ParentId AS ParentId_46, c0_.UserId AS UserId_47, u1_.RegisteringSiteId AS RegisteringSiteId_48, u1_.FavouriteDriverId AS FavouriteDriverId_49, u1_.FavouriteTeamId AS FavouriteTeamId_50, u1_.Country AS Country_51 FROM Comments c0_ INNER JOIN Users u1_ ON c0_.UserId = u1_.UserId INNER JOIN db_countries d2_ ON u1_.Country = d2_.iso WHERE c0_.ArticleId = ? AND c0_.BlockReason = ? ORDER BY c0_.Date ASC LIMIT 100

SELECT c0_.CommentId AS CommentId_0, c0_.Date AS Date_1, c0_.Content AS Content_2, c0_.BlockReason AS BlockReason_3, c0_.cntnlang AS cntnlang_4, c0_.PosterIp AS PosterIp_5, u1_.UserId AS UserId_6, u1_.RegistrationDate AS RegistrationDate_7, u1_.Username AS Username_8, u1_.RewriteUrl AS RewriteUrl_9, u1_.EmailAddress AS EmailAddress_10, u1_.FirstName AS FirstName_11, u1_.LastName AS LastName_12, u1_.Birthdate AS Birthdate_13, u1_.Gender AS Gender_14, u1_.Website AS Website_15, u1_.Twitter AS Twitter_16, u1_.CurrentCar AS CurrentCar_17, u1_.DreamCar AS DreamCar_18, u1_.Facebook AS Facebook_19, u1_.Occupation AS Occupation_20, u1_.Interests AS Interests_21, u1_.Activated AS Activated_22, u1_.Banned AS Banned_23, u1_.Subscribed AS Subscribed_24, u1_.RegistrationIp AS RegistrationIp_25, u1_.LastUpdated AS LastUpdated_26, u1_.AllowCommentModeration AS AllowCommentModeration_27, u1_.CommentsCount AS CommentsCount_28, u1_.NotificationCount AS NotificationCount_29, u1_.TotalCommentVoteSum AS TotalCommentVoteSum_30, u1_.Residence AS Residence_31, u1_.Icon AS Icon_32, u1_.ModerateAllComments AS ModerateAllComments_33, u1_.PremiumUser AS PremiumUser_34, u1_.CrewNotes AS CrewNotes_35, u1_.PwdHash AS PwdHash_36, u1_.ActivationId AS ActivationId_37, u1_.RetrievalId AS RetrievalId_38, u1_.ProfileLastUpdated AS ProfileLastUpdated_39, u1_.LastOnline AS LastOnline_40, d2_.iso AS iso_41, d2_.iso3 AS iso3_42, d2_.numcode AS numcode_43, c0_.SiteId AS SiteId_44, c0_.ArticleId AS ArticleId_45, c0_.ParentId AS ParentId_46, c0_.UserId AS UserId_47, u1_.RegisteringSiteId AS RegisteringSiteId_48, u1_.FavouriteDriverId AS FavouriteDriverId_49, u1_.FavouriteTeamId AS FavouriteTeamId_50, u1_.Country AS Country_51 FROM Comments c0_ INNER JOIN Users u1_ ON c0_.UserId = u1_.UserId INNER JOIN db_countries d2_ ON u1_.Country = d2_.iso WHERE c0_.ArticleId = ? AND c0_.BlockReason = ? ORDER BY c0_.Date ASC LIMIT 100