SET sql_mode = ? 0.0002s

SHOW DATABASES LIKE 'directtrs' 0.0004s

SHOW TABLES 0.0007s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."URLSegment" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "SiteConfig"."ClassName", "SiteConfig"."LastEdited", "SiteConfig"."Created", "SiteConfig"."Title", "SiteConfig"."Tagline", "SiteConfig"."Theme", "SiteConfig"."CanViewType", "SiteConfig"."CanEditType", "SiteConfig"."CanCreateTopLevelType", "SiteConfig"."FacebookURL", "SiteConfig"."TwitterURL", "SiteConfig"."GooglePlusURL", "SiteConfig"."LinkedInURL", "SiteConfig"."SidebarTitle", "SiteConfig"."SidebarContent", "SiteConfig"."ID", CASE WHEN "SiteConfig"."ClassName" IS NOT NULL THEN "SiteConfig"."ClassName" ELSE 'SiteConfig' END AS "RecordClassName" FROM "SiteConfig" LIMIT 1 0.0001s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."FeaturedImageID", "Job_Live"."JobOrderID", "Job_Live"."Position", "Job_Live"."Country", "Job_Live"."ProvinceState", "Job_Live"."City", "Job_Live"."EmploymentType", "Job_Live"."Payment", "Job_Live"."MaxPayment", "Job_Live"."CandidateRate", "Job_Live"."NumberOfPositions", "Job_Live"."Schedule", "Job_Live"."BriefDescription", "Job_Live"."EnglishDescriptionNote", "Job_Live"."FunctionNote", "Job_Live"."RequirementNote", "Job_Live"."ContactDetailNote", "Job_Live"."WebPublicationDate", "Job_Live"."MSEnteredDate", "Job_Live"."MSModifiedDate", "Job_Live"."RecruiterID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Job_Live" ON "Job_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "WebPublicationDate" DESC LIMIT 10 0.0005s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Job_Live" ON "Job_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) 0.0002s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Job_Live" ON "Job_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) 0.0002s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Job_Live" ON "Job_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) 0.0002s

SELECT DISTINCT "MindscopeCountry"."ClassName", "MindscopeCountry"."LastEdited", "MindscopeCountry"."Created", "MindscopeCountry"."Name", "MindscopeCountry"."MindscopeID", "MindscopeCountry"."ID", CASE WHEN "MindscopeCountry"."ClassName" IS NOT NULL THEN "MindscopeCountry"."ClassName" ELSE 'MindscopeCountry' END AS "RecordClassName" FROM "MindscopeCountry" INNER JOIN "Job" ON `Job`.`Country` = `MindscopeCountry`.`Name` ORDER BY "MindscopeCountry"."Name" ASC 0.0001s

SELECT DISTINCT count(DISTINCT "SiteTree_Live"."ID") AS "Count" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "Job_Live" ON "Job_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) 0.0002s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0003s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "Page_Live"."FeaturedImageID", "MemberProfilePage_Live"."ProfileTitle", "MemberProfilePage_Live"."RegistrationTitle", "MemberProfilePage_Live"."AfterRegistrationTitle", "MemberProfilePage_Live"."ProfileContent", "MemberProfilePage_Live"."RegistrationContent", "MemberProfilePage_Live"."AfterRegistrationContent", "MemberProfilePage_Live"."AllowRegistration", "MemberProfilePage_Live"."AllowProfileViewing", "MemberProfilePage_Live"."AllowProfileEditing", "MemberProfilePage_Live"."AllowAdding", "MemberProfilePage_Live"."RegistrationRedirect", "MemberProfilePage_Live"."RequireApproval", "MemberProfilePage_Live"."EmailType", "MemberProfilePage_Live"."EmailFrom", "MemberProfilePage_Live"."EmailSubject", "MemberProfilePage_Live"."EmailTemplate", "MemberProfilePage_Live"."ConfirmationTitle", "MemberProfilePage_Live"."ConfirmationContent", "MemberProfilePage_Live"."PostRegistrationTargetID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "MemberProfilePage_Live" ON "MemberProfilePage_Live"."ID" = "SiteTree_Live"."ID" WHERE ("SiteTree_Live"."ClassName" IN (?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0004s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", CASE WHEN "SiteTree_Live"."ClassName" IN ('Page', 'Calendar', 'CalendarEvent', 'CustomCalendarEvent', 'MemberProfilePage', 'Job', 'HomePage', 'JobHolder', 'MultiSectionPage', 'Section', 'Blog', 'BlogPost', 'BlogEntry', 'ErrorPage', 'RedirectorPage', 'VirtualPage', 'UserDefinedForm', 'BlogTree', 'BlogHolder') THEN "Page_Live"."FeaturedImageID" WHEN "SiteTree_Live"."ClassName" IN ('BlogPost', 'BlogEntry') THEN "BlogPost_Live"."FeaturedImageID" ELSE NULL END AS "FeaturedImageID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName", "SiteTree_Live"."Sort" FROM "SiteTree_Live" LEFT JOIN "Page_Live" ON "Page_Live"."ID" = "SiteTree_Live"."ID" LEFT JOIN "BlogPost_Live" ON "BlogPost_Live"."ID" = "SiteTree_Live"."ID" WHERE ("Page_Live"."ID" = 6) AND ("SiteTree_Live"."ClassName" IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) AND ("File"."ClassName" IN (?, ?)) ORDER BY "File"."Name" ASC LIMIT 1 0.0002s

SELECT DISTINCT "File"."ClassName", "File"."LastEdited", "File"."Created", "File"."Name", "File"."Title", "File"."Filename", "File"."Content", "File"."ShowInSearch", "File"."CanViewType", "File"."ParentID", "File"."OwnerID", "File"."ID", CASE WHEN "File"."ClassName" IS NOT NULL THEN "File"."ClassName" ELSE 'File' END AS "RecordClassName" FROM "File" WHERE ("File"."ID" = ?) ORDER BY "File"."Name" ASC LIMIT 1 0.0002s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ShowInMenus" = ?) AND ("SiteTree_Live"."ParentID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC 0.0003s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "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"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."Version", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0003s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0003s

SELECT DISTINCT "SiteTree"."ClassName", "SiteTree"."LastEdited", "SiteTree"."Created", "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"."CanViewType", "SiteTree"."CanEditType", "SiteTree"."Priority", "SiteTree"."Version", "SiteTree"."ParentID", "SiteTree"."ID", CASE WHEN "SiteTree"."ClassName" IS NOT NULL THEN "SiteTree"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree" WHERE ("SiteTree"."ID" = ?) ORDER BY "SiteTree"."Sort" ASC LIMIT 1 0.0002s

SELECT DISTINCT "SiteTree_Live"."ClassName", "SiteTree_Live"."LastEdited", "SiteTree_Live"."Created", "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"."CanViewType", "SiteTree_Live"."CanEditType", "SiteTree_Live"."Priority", "SiteTree_Live"."Version", "SiteTree_Live"."ParentID", "SiteTree_Live"."ID", CASE WHEN "SiteTree_Live"."ClassName" IS NOT NULL THEN "SiteTree_Live"."ClassName" ELSE 'SiteTree' END AS "RecordClassName" FROM "SiteTree_Live" WHERE ("SiteTree_Live"."ID" = ?) ORDER BY "SiteTree_Live"."Sort" ASC LIMIT 1 0.0002s

» Direct Teacher Recruitment Specialists