Home | Farmclearingsales.com.au

0001: SET sql_mode = ? 0.001s

0002: SHOW DATABASES LIKE 'uatfarmclea\_staging' 0.0007s

0003: SHOW FULL TABLES WHERE Table_Type != 'VIEW' 0.0014s

0004: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

0005: SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."MFARequired", "SiteConfig"."MFAGracePeriodExpires", "SiteConfig"."FooterContent", "SiteConfig"."FooterSupplementaryContent", "SiteConfig"."PrivateSaleAdProductId", "SiteConfig"."PrivateSaleAdPriceId", "SiteConfig"."PaymentEmailSubject", "SiteConfig"."SubscriptionEarlyReminderEmailSubject", "SiteConfig"."SubscriptionAfterReminderEmailSubject", "SiteConfig"."AssistanceRequestEmailEmailSubject", "SiteConfig"."PaymentEmailBody", "SiteConfig"."SubscriptionAfterReminderEmailBody", "SiteConfig"."SubscriptionEarlyReminderEmailBody", "SiteConfig"."AssistanceRequestEmailBody", "SiteConfig"."AssistanceRequestEmailRecipients", "SiteConfig"."NoReplyEmail", "SiteConfig"."AdminEmail", "SiteConfig"."StripeServiceFee", "SiteConfig"."AssistanceFee", "SiteConfig"."OfflinePaymentFee", "SiteConfig"."SenderID", "SiteConfig"."EFTDetailsForPaymentPage", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."ThankYouPageID", "SiteConfig"."FormFailedPageID", "SiteConfig"."TermsAndConditionsPageID", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SilverStripe\\SiteConfig\\SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0009s

0006: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0012s

0007: SELECT "Version" FROM "SiteTree" WHERE "ID" = ? 0.0006s

0008: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.001s

0009: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0005s

0010: SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "SiteTree"."Priority", "SiteTree"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Version", "SiteTree"."URLSegment", "SiteTree"."Title", "SiteTree"."MenuTitle", "SiteTree"."Content", "SiteTree"."MetaDescription", "SiteTree"."ExtraMeta", "SiteTree"."ShowInMenus", "SiteTree"."ShowInSearch", "SiteTree"."Sort", "SiteTree"."HasBrokenFile", "SiteTree"."HasBrokenLink", "SiteTree"."ReportClass", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0009s

0011: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0006s

0012: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s

0013: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0009s

0014: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0008s

0015: SELECT DISTINCT MAX("SocialLink"."LastEdited") FROM "SocialLink" 0.0005s

0016: SELECT DISTINCT count(DISTINCT "SocialLink"."ID") AS "Count" FROM "SocialLink" 0.0004s

0017: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0007s

0018: SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0006s

0019: SELECT DISTINCT MAX("SocialLink"."LastEdited") FROM "SocialLink" 0.0003s

0020: SELECT DISTINCT count(DISTINCT "SocialLink"."ID") AS "Count" FROM "SocialLink" 0.0002s

0021: SELECT DISTINCT MAX("SiteTree_Live"."LastEdited") FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) 0.0006s

0022: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0009s

0023: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName" FROM "Element_Live" WHERE ("Element_Live"."ParentID" = ?) ORDER BY "Element_Live"."Sort" ASC 0.0008s

0024: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0004s

0025: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0026: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."HeaderElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0027: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0004s

0028: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0002s

0029: SELECT CASE WHEN EXISTS(SELECT * FROM "BannerCarouselItem" INNER JOIN "BannerCarouselElement_CarouselItems" ON "BannerCarouselElement_CarouselItems"."BannerCarouselItemID" = "BannerCarouselItem"."ID" WHERE ("BannerCarouselElement_CarouselItems"."BannerCarouselElementID" = ?)) THEN 1 ELSE 0 END 0.0008s

0030: SELECT DISTINCT "BannerCarouselElement_CarouselItems"."SortOrder", "BannerCarouselItem"."ClassName", "BannerCarouselItem"."LastEdited", "BannerCarouselItem"."Created", "BannerCarouselItem"."Title", "BannerCarouselItem"."Subtitle", "BannerCarouselItem"."ImageID", "BannerCarouselItem"."CallToActionID", "BannerCarouselItem"."ID", CASE WHEN "BannerCarouselItem"."ClassName" IS NOT NULL THEN "BannerCarouselItem"."ClassName" ELSE 'BannerCarouselItem' END AS "RecordClassName" FROM "BannerCarouselItem" INNER JOIN "BannerCarouselElement_CarouselItems" ON "BannerCarouselElement_CarouselItems"."BannerCarouselItemID" = "BannerCarouselItem"."ID" WHERE ("BannerCarouselElement_CarouselItems"."BannerCarouselElementID" = ?) 0.0009s

0031: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0008s

0032: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0033: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0034: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0004s

0035: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "Element_Live"."Version", "Element_Live"."Title", "Element_Live"."ShowTitle", "Element_Live"."Sort", "Element_Live"."ExtraClass", "Element_Live"."Style", "Element_Live"."ParentID", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName" FROM "Element_Live" WHERE ("Element_Live"."ParentID" = ?) ORDER BY "Element_Live"."Sort" ASC 0.0004s

0036: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0007s

0037: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ElementalAreaID" = ?) AND ("SiteTree_Live"."ClassName" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0038: SELECT DISTINCT "ElementalArea_Live"."ClassName", "ElementalArea_Live"."LastEdited", "ElementalArea_Live"."Created", "ElementalArea_Live"."Version", "ElementalArea_Live"."OwnerClassName", "ElementalArea_Live"."ID", CASE WHEN "ElementalArea_Live"."ClassName" IS NOT NULL THEN "ElementalArea_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\ElementalArea' END AS "RecordClassName" FROM "ElementalArea_Live" WHERE ("ElementalArea_Live"."ID" = ?) LIMIT 1 0.0005s

0039: SELECT CASE WHEN EXISTS(SELECT * FROM "Link" INNER JOIN "BigButtonElement_BigButtonItems" ON "BigButtonElement_BigButtonItems"."LinkID" = "Link"."ID" WHERE ("BigButtonElement_BigButtonItems"."BigButtonElementID" = ?)) THEN 1 ELSE 0 END 0.0009s

0040: SELECT DISTINCT "BigButtonElement_BigButtonItems"."SortOrder", "Link"."ClassName", "Link"."LastEdited", "Link"."Created", "Link"."Anchor", "Link"."Title", "Link"."Type", "Link"."URL", "Link"."Email", "Link"."Phone", "Link"."OpenInNewWindow", "Link"."SelectedStyle", "Link"."SiteTreeID", "Link"."FileID", "Link"."ID", CASE WHEN "Link"."ClassName" IS NOT NULL THEN "Link"."ClassName" ELSE 'gorriecoe\\Link\\Models\\Link' END AS "RecordClassName" FROM "Link" INNER JOIN "BigButtonElement_BigButtonItems" ON "BigButtonElement_BigButtonItems"."LinkID" = "Link"."ID" WHERE ("BigButtonElement_BigButtonItems"."BigButtonElementID" = ?) ORDER BY "SortOrder" ASC 0.0018s

0041: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "BigButtonElement_Live"."DisplayAd", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "BigButtonElement_Live" ON "BigButtonElement_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0007s

0042: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."HTML", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0008s

0043: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "CategoryElement_Live"."SubTitle", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "CategoryElement_Live" ON "CategoryElement_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0006s

0044: SELECT DISTINCT "SaleAdCategory"."ClassName", "SaleAdCategory"."LastEdited", "SaleAdCategory"."Created", "SaleAdCategory"."Title", "SaleAdCategory"."SubCategory", "SaleAdCategory"."URLSegment", "SaleAdCategory"."Description", "SaleAdCategory"."SortOrder", "SaleAdCategory"."ID", CASE WHEN "SaleAdCategory"."ClassName" IS NOT NULL THEN "SaleAdCategory"."ClassName" ELSE 'App\\DataObjects\\SaleAdCategory' END AS "RecordClassName" FROM "SaleAdCategory" ORDER BY "SaleAdCategory"."SortOrder" ASC 0.0008s

0045: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0012s

0046: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0011s

0047: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0048: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0049: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0007s

0050: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0051: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0052: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0053: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0054: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0055: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0056: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0057: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0058: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0059: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0060: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0061: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0062: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0063: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0064: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0065: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0066: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0067: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0068: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0069: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0070: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0071: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0072: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0073: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0074: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0075: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0076: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0077: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0078: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0079: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0080: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0081: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0082: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0083: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0084: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0085: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0086: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0008s

0087: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0008s

0088: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0089: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0007s

0090: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0091: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0092: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0093: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0021s

0094: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0007s

0095: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0008s

0096: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0007s

0097: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0098: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0019s

0099: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0100: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0101: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0006s

0102: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0103: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.002s

0104: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0105: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0008s

0106: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0107: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0108: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0109: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0110: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0111: SELECT DISTINCT "SaleAd_Media"."SortPriority", "SaleAdMedia"."ClassName", "SaleAdMedia"."LastEdited", "SaleAdMedia"."Created", "SaleAdMedia"."Type", "SaleAdMedia"."VimeoVideoId", "SaleAdMedia"."YouTubeVideoId", "SaleAdMedia"."ImageID", "SaleAdMedia"."ID", CASE WHEN "SaleAdMedia"."ClassName" IS NOT NULL THEN "SaleAdMedia"."ClassName" ELSE 'SaleAdMedia' END AS "RecordClassName" FROM "SaleAdMedia" INNER JOIN "SaleAd_Media" ON "SaleAd_Media"."SaleAdMediaID" = "SaleAdMedia"."ID" WHERE ("SaleAd_Media"."SaleAdID" = ?) ORDER BY "SortPriority" ASC LIMIT 1 0.0008s

0112: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0003s

0113: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0015s

0114: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0115: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0116: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0004s

0117: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0006s

0118: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0119: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0120: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0121: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0004s

0122: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0123: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0124: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0125: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0126: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0004s

0127: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0128: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0023s

0129: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0008s

0130: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0131: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0008s

0132: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0133: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "CategoryCarouselElement_Live"."SubTitle", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "CategoryCarouselElement_Live" ON "CategoryCarouselElement_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0007s

0134: SELECT DISTINCT "SaleAdCategory"."ClassName", "SaleAdCategory"."LastEdited", "SaleAdCategory"."Created", "SaleAdCategory"."Title", "SaleAdCategory"."SubCategory", "SaleAdCategory"."URLSegment", "SaleAdCategory"."Description", "SaleAdCategory"."SortOrder", "SaleAdCategory"."ID", CASE WHEN "SaleAdCategory"."ClassName" IS NOT NULL THEN "SaleAdCategory"."ClassName" ELSE 'App\\DataObjects\\SaleAdCategory' END AS "RecordClassName" FROM "SaleAdCategory" ORDER BY "SaleAdCategory"."SortOrder" ASC 0.0004s

0135: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0016s

0136: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0008s

0137: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0138: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0139: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0003s

0140: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0141: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0142: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0143: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0144: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0145: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0003s

0146: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0147: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0148: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0149: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0150: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0151: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0003s

0152: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0153: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0003s

0154: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0155: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0156: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0157: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0158: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0159: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0160: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0161: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0162: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0163: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0164: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0165: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0166: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0167: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0168: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0169: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0004s

0170: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0171: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0172: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0173: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0003s

0174: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0004s

0175: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0176: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0024s

0177: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0011s

0178: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0007s

0179: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0180: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0015s

0181: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0007s

0182: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0007s

0183: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0184: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0185: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0014s

0186: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0187: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0188: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0004s

0189: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0190: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0191: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0192: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0193: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0006s

0194: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0005s

0195: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0196: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0007s

0197: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0198: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0199: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0003s

0200: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0013s

0201: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0202: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0008s

0203: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0204: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0205: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0016s

0206: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0207: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0005s

0208: SELECT DISTINCT "SaleAd_Media"."SortPriority", "SaleAdMedia"."ClassName", "SaleAdMedia"."LastEdited", "SaleAdMedia"."Created", "SaleAdMedia"."Type", "SaleAdMedia"."VimeoVideoId", "SaleAdMedia"."YouTubeVideoId", "SaleAdMedia"."ImageID", "SaleAdMedia"."ID", CASE WHEN "SaleAdMedia"."ClassName" IS NOT NULL THEN "SaleAdMedia"."ClassName" ELSE 'SaleAdMedia' END AS "RecordClassName" FROM "SaleAdMedia" INNER JOIN "SaleAd_Media" ON "SaleAd_Media"."SaleAdMediaID" = "SaleAdMedia"."ID" WHERE ("SaleAd_Media"."SaleAdID" = ?) ORDER BY "SortPriority" ASC LIMIT 1 0.0004s

0209: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0003s

0210: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0211: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0212: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0213: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0214: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0215: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0022s

0216: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0008s

0217: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0218: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0008s

0219: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0220: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0018s

0221: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0006s

0222: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0003s

0223: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0224: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0004s

0225: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "CategoryPage_Live"."ListingsPerAd", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "CategoryPage_Live" ON "CategoryPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0017s

0226: SELECT DISTINCT "AuctionLot"."ClassName", "AuctionLot"."LastEdited", "AuctionLot"."Created", "AuctionLot"."SubLotNumber", "AuctionLot"."ShowLotNumber", "AuctionLot"."Title", "AuctionLot"."Content", "AuctionLot"."Published", "AuctionLot"."SortOrder", "AuctionLot"."isGSTApplicable", "AuctionLot"."GSTApplicable", "AuctionLot"."ItemNumber", "AuctionLot"."Vendor", "AuctionLot"."Reserve", "AuctionLot"."BuyItNow", "AuctionLot"."HighLowEstimate", "AuctionLot"."AssetClass", "AuctionLot"."VideoLink", "AuctionLot"."BuyersPremiumDollars", "AuctionLot"."OverrideBiddingData", "AuctionLot"."StartingBid", "AuctionLot"."BuyersPremiumPercent", "AuctionLot"."BidIncrement", "AuctionLot"."AuctionPageID", "AuctionLot"."CategoryID", "AuctionLot"."ID", CASE WHEN "AuctionLot"."ClassName" IS NOT NULL THEN "AuctionLot"."ClassName" ELSE 'AuctionLot' END AS "RecordClassName" FROM "AuctionLot" WHERE ("AuctionLot"."CategoryID" = ?) ORDER BY "AuctionLot"."Created" DESC LIMIT 1 0.0005s

0227: SELECT DISTINCT "SaleAd"."ClassName", "SaleAd"."LastEdited", "SaleAd"."Created", "SaleAd"."IsPublished", "SaleAd"."FirstPublishedDate", "SaleAd"."PublishDate", "SaleAd"."ExpiryDate", "SaleAd"."Title", "SaleAd"."Description", "SaleAd"."Price", "SaleAd"."GSTApplicable", "SaleAd"."PriceReduced", "SaleAd"."PriceNegotiable", "SaleAd"."SoldDate", "SaleAd"."DeletionDate", "SaleAd"."ContactPhone", "SaleAd"."SecondaryPhone", "SaleAd"."Suburb", "SaleAd"."Postcode", "SaleAd"."State", "SaleAd"."Latitude", "SaleAd"."Longitude", "SaleAd"."LegacyID", "SaleAd"."IsReviewed", "SaleAd"."IsUserNotifiedOnCreate", "SaleAd"."ArchivedCategories", "SaleAd"."FeedToken", "SaleAd"."OwnerID", "SaleAd"."CategoryID", "SaleAd"."ArchivedMainCategoryID", "SaleAd"."UnitTypeID", "SaleAd"."ID", CASE WHEN "SaleAd"."ClassName" IS NOT NULL THEN "SaleAd"."ClassName" ELSE 'App\\DataObjects\\SaleAd' END AS "RecordClassName" FROM "SaleAd" WHERE ("SaleAd"."CategoryID" = ?) AND ("SaleAd"."IsPublished" = ?) ORDER BY "SaleAd"."Created" DESC LIMIT 1 0.0006s

0228: SELECT DISTINCT "AuctionLot_Images"."SortOrder", "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "File_Live"."Version", "File_Live"."UserFormUpload", "File_Live"."CanViewType", "File_Live"."CanEditType", "File_Live"."Name", "File_Live"."Title", "File_Live"."ShowInSearch", "File_Live"."ParentID", "File_Live"."OwnerID", "File_Live"."FileHash", "File_Live"."FileFilename", "File_Live"."FileVariant", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName" FROM "File_Live" INNER JOIN "AuctionLot_Images" ON "AuctionLot_Images"."FileID" = "File_Live"."ID" WHERE ("AuctionLot_Images"."AuctionLotID" = ?) ORDER BY "SortOrder" ASC LIMIT 1 0.0005s

0229: SELECT DISTINCT "File_Live"."ClassName", "File_Live"."LastEdited", "File_Live"."Created", "Image_Live"."FocusPointX", "Image_Live"."FocusPointY", "File_Live"."ID", CASE WHEN "File_Live"."ClassName" IS NOT NULL THEN "File_Live"."ClassName" ELSE 'SilverStripe\\Assets\\File' END AS "RecordClassName", "File_Live"."Name" FROM "File_Live" LEFT JOIN "Image_Live" ON "Image_Live"."ID" = "File_Live"."ID" WHERE ("File_Live"."ID" = ?) AND ("File_Live"."ClassName" IN (?)) ORDER BY "File_Live"."Name" ASC LIMIT 1 0.0003s

0230: SELECT DISTINCT "Element_Live"."ClassName", "Element_Live"."LastEdited", "Element_Live"."Created", "ElementContent_Live"."HTML", "Element_Live"."ID", CASE WHEN "Element_Live"."ClassName" IS NOT NULL THEN "Element_Live"."ClassName" ELSE 'DNADesign\\Elemental\\Models\\BaseElement' END AS "RecordClassName", "Element_Live"."Sort" FROM "Element_Live" LEFT JOIN "ElementContent_Live" ON "ElementContent_Live"."ID" = "Element_Live"."ID" WHERE ("Element_Live"."ID" = ?) AND ("Element_Live"."ClassName" IN (?)) ORDER BY "Element_Live"."Sort" ASC LIMIT 1 0.0003s

0231: SELECT CASE WHEN EXISTS(SELECT * FROM "SocialLink" INNER JOIN "SiteConfig_SocialLinks" ON "SiteConfig_SocialLinks"."SocialLinkID" = "SocialLink"."ID" WHERE ("SiteConfig_SocialLinks"."SiteConfigID" = ?)) THEN 1 ELSE 0 END 0.0006s

0232: SELECT DISTINCT "SocialLink"."ClassName", "SocialLink"."LastEdited", "SocialLink"."Created", "SocialLink"."Link", "SocialLink"."Type", "SocialLink"."ID", CASE WHEN "SocialLink"."ClassName" IS NOT NULL THEN "SocialLink"."ClassName" ELSE 'SocialLink' END AS "RecordClassName" FROM "SocialLink" INNER JOIN "SiteConfig_SocialLinks" ON "SiteConfig_SocialLinks"."SocialLinkID" = "SocialLink"."ID" WHERE ("SiteConfig_SocialLinks"."SiteConfigID" = ?) 0.0013s

0233: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ShowInFooterMenu" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0024s

0234: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "RedirectorPage_Live"."RedirectionType", "RedirectorPage_Live"."ExternalURL", "RedirectorPage_Live"."LinkToID", "RedirectorPage_Live"."LinkToFileID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "RedirectorPage_Live" ON "RedirectorPage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ID" = ?) AND ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0008s

0235: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ShowInLegalFooterMenu" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0026s

0236: SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "SiteTree_Live"."Priority", "SiteTree_Live"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Version", "SiteTree_Live"."URLSegment", "SiteTree_Live"."Title", "SiteTree_Live"."MenuTitle", "SiteTree_Live"."Content", "SiteTree_Live"."MetaDescription", "SiteTree_Live"."ExtraMeta", "SiteTree_Live"."ShowInMenus", "SiteTree_Live"."ShowInSearch", "SiteTree_Live"."Sort", "SiteTree_Live"."HasBrokenFile", "SiteTree_Live"."HasBrokenLink", "SiteTree_Live"."ReportClass", "SiteTree_Live"."ParentID", "Page_Live"."SearchContent", "Page_Live"."MetaTitle", "Page_Live"."ShowInMainMenu", "Page_Live"."ShowInHeaderMenu", "Page_Live"."ShowInFooterMenu", "Page_Live"."ShowInLegalFooterMenu", "Page_Live"."ShowInBusinessFooterMenu", "Page_Live"."OpenInNewTab", "Page_Live"."ElementalAreaID", "Page_Live"."HeaderElementalAreaID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SilverStripe\\CMS\\Model\\SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ShowInBusinessFooterMenu" = ?) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC 0.0023s