44 total queries
(query time) (total time) (query)
0.001 0.001 (SET NAMES 'utf8')
0.0003 0.0013 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='1' ORDER BY issue_content.title ASC ) [14 row(s)]
0.0004 0.0017 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='search' AND parent_page=1 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0003 0.002 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='search' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0023 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='' AND parent_page=4 AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0.0003 0.0026 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='' AND parent_page=4 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0002 0.0028 (SELECT * FROM cms76_languages WHERE lang_id=2) [1 row(s)]
0,0003 0,0031 (SELECT * FROM cms76_languages WHERE lang_id!=2) [1 row(s)]
0,0003 0,0034 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='4' AND lang_id='2' AND page_details.live='yes') [0 row(s)]
0,0003 0,0037 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='4' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0,0002 0,0039 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=4 ORDER BY page_order) [2 row(s)]
0,0003 0,0042 (SELECT * FROM page_details WHERE page_id='4') [1 row(s)]
0,0003 0,0045 ( SELECT issues.issue_id as id, issue_content.title as name FROM issues LEFT JOIN issue_content USING (issue_id) WHERE issue_content.lang_id='2' ORDER BY issue_content.title ASC ) [14 row(s)]
0,0003 0,0048 ( SELECT curriculum_subject_group_content.subject_group_id as id, curriculum_subject_group_content.name FROM curriculum_subject_group_content WHERE curriculum_subject_group_content.lang_id='2' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0,0002 0,005 ( SELECT curriculum_audience.audience_id as id, curriculum_audience_content.name FROM curriculum_audience LEFT JOIN curriculum_audience_content USING (audience_id) WHERE curriculum_audience_content.lang_id='2' ORDER BY curriculum_audience.number ASC ) [13 row(s)]
0,0002 0,0052 ( SELECT DISTINCT resource_types.type_id, resource_types_content.type_name FROM resource_types LEFT JOIN resource_types_content USING (type_id) LEFT JOIN resource_resource_types USING (type_id) LEFT JOIN resources USING (resource_id) WHERE resource_types_content.lang_id='2' AND resources.live='yes' ) [6 row(s)]
0,0002 0,0054 ( SELECT sdg_content.sdg_id as id, sdg_content.title FROM sdg_content WHERE sdg_content.lang_id='2' ORDER BY sdg_content.sdg_id ASC ) [18 row(s)]
0,0002 0,0056 ( SELECT curriculum_province.province_id as id, curriculum_province_content.name FROM curriculum_province LEFT JOIN curriculum_province_content USING (province_id) WHERE curriculum_province_content.lang_id='2' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0,0002 0,0058 ( SELECT curriculum_subject_group_content.subject_group_id as id, curriculum_subject_group_content.name FROM curriculum_subject_group_content WHERE curriculum_subject_group_content.lang_id='2' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0,0002 0,006 ( SELECT curriculum_province.province_id as id, curriculum_province_content.name FROM curriculum_province LEFT JOIN curriculum_province_content USING (province_id) WHERE curriculum_province_content.lang_id='2' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0,0002 0,0062 ( SELECT curriculum_subject_group_content.subject_group_id as id, curriculum_subject_group_content.name FROM curriculum_subject_group_content WHERE curriculum_subject_group_content.lang_id='2' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0,0003 0,0065 ( SELECT curriculum_province.province_id as id, curriculum_province_content.name FROM curriculum_province LEFT JOIN curriculum_province_content USING (province_id) WHERE curriculum_province_content.lang_id='2' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0,0022 0,0087 ( SELECT SQL_CALC_FOUND_ROWS resources.resource_id, resources.review_type, resources.curriculum_match_type, resources.slug, resources.url, IF (resources.language_id=1,'English','Français') as language, resource_content.title, resource_content.sub_title, resource_content.description, resources.downloadable_immediately, resource_curriculum.curriculum_id, resource_curriculum.weight, IF (MAX(resource_curriculum.weight)=1,'easy',IF (MAX(resource_curriculum.weight)=0.5,'challenging',0)) as fit_order, resource_assessment.recommended, IF (resource_assessment.recommended='yes',1,IF (resource_assessment.recommended='yes with qualifications',0.5,0)) as recommended_order, ( 0 + 2 * ((ORD(biases_rating)=118)*5 + (ORD(biases_rating)=103)*4 + (ORD(biases_rating)=109)*3 + (ORD(biases_rating)=112)*2 ) + 2 * ((ORD(multiple_dimensions_of_problems_and_solutions_rating)=118)*5 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=103)*4 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=109)*3 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=112)*2 ) + 2 * ((ORD(respects_complexity_rating)=118)*5 + (ORD(respects_complexity_rating)=103)*4 + (ORD(respects_complexity_rating)=109)*3 + (ORD(respects_complexity_rating)=112)*2 ) + 2 * ((ORD(action_experience_rating)=118)*5 + (ORD(action_experience_rating)=103)*4 + (ORD(action_experience_rating)=109)*3 + (ORD(action_experience_rating)=112)*2 ) + 2 * ((ORD(action_skills_rating)=118)*5 + (ORD(action_skills_rating)=103)*4 + (ORD(action_skills_rating)=109)*3 + (ORD(action_skills_rating)=112)*2 ) + 2 * ((ORD(empathy_and_respect_rating)=118)*5 + (ORD(empathy_and_respect_rating)=103)*4 + (ORD(empathy_and_respect_rating)=109)*3 + (ORD(empathy_and_respect_rating)=112)*2 ) + 2 * ((ORD(personal_affinity_with_earth_rating)=118)*5 + (ORD(personal_affinity_with_earth_rating)=103)*4 + (ORD(personal_affinity_with_earth_rating)=109)*3 + (ORD(personal_affinity_with_earth_rating)=112)*2 ) + 1 * ((ORD(locally_focused_rating)=118)*5 + (ORD(locally_focused_rating)=103)*4 + (ORD(locally_focused_rating)=109)*3 + (ORD(locally_focused_rating)=112)*2 ) + 1 * ((ORD(past_and_present_and_future_rating)=118)*5 + (ORD(past_and_present_and_future_rating)=103)*4 + (ORD(past_and_present_and_future_rating)=109)*3 + (ORD(past_and_present_and_future_rating)=112)*2 ) + 2 * ((ORD(open_ended_instruction_rating)=118)*5 + (ORD(open_ended_instruction_rating)=103)*4 + (ORD(open_ended_instruction_rating)=109)*3 + (ORD(open_ended_instruction_rating)=112)*2 ) + 2 * ((ORD(integrated_learning_rating)=118)*5 + (ORD(integrated_learning_rating)=103)*4 + (ORD(integrated_learning_rating)=109)*3 + (ORD(integrated_learning_rating)=112)*2 ) + 2 * ((ORD(inquiry_learning_rating)=118)*5 + (ORD(inquiry_learning_rating)=103)*4 + (ORD(inquiry_learning_rating)=109)*3 + (ORD(inquiry_learning_rating)=112)*2 ) + 2 * ((ORD(values_education_methodology_rating)=118)*5 + (ORD(values_education_methodology_rating)=103)*4 + (ORD(values_education_methodology_rating)=109)*3 + (ORD(values_education_methodology_rating)=112)*2 ) + 2 * ((ORD(accommodate_diverse_learners_rating)=118)*5 + (ORD(accommodate_diverse_learners_rating)=103)*4 + (ORD(accommodate_diverse_learners_rating)=109)*3 + (ORD(accommodate_diverse_learners_rating)=112)*2 ) + 1 * ((ORD(experiential_learning_rating)=118)*5 + (ORD(experiential_learning_rating)=103)*4 + (ORD(experiential_learning_rating)=109)*3 + (ORD(experiential_learning_rating)=112)*2 ) + 1 * ((ORD(student_directed_learning_rating)=118)*5 + (ORD(student_directed_learning_rating)=103)*4 + (ORD(student_directed_learning_rating)=109)*3 + (ORD(student_directed_learning_rating)=112)*2 ) + 1 * ((ORD(assessment_and_evaluation_of_student_learning_rating)=118)*5 + (ORD(assessment_and_evaluation_of_student_learning_rating)=103)*4 + (ORD(assessment_and_evaluation_of_student_learning_rating)=109)*3 + (ORD(assessment_and_evaluation_of_student_learning_rating)=112)*2 ) + 1 * ((ORD(peer_teaching_rating)=118)*5 + (ORD(peer_teaching_rating)=103)*4 + (ORD(peer_teaching_rating)=109)*3 + (ORD(peer_teaching_rating)=112)*2 ) + 1 * ((ORD(case_studies_rating)=118)*5 + (ORD(case_studies_rating)=103)*4 + (ORD(case_studies_rating)=109)*3 + (ORD(case_studies_rating)=112)*2 ) + 1 * ((ORD(locus_of_control_rating)=118)*5 + (ORD(locus_of_control_rating)=103)*4 + (ORD(locus_of_control_rating)=109)*3 + (ORD(locus_of_control_rating)=112)*2 ) + IF (recommended='yes', 40, IF (recommended='yes with qualifications', 20, IF (recommended='no but very close',10,0) ) ) ) as rank_2, ( 0 + 2 * ((ORD(biases_rating)!=110)*5) + 2 * ((ORD(multiple_dimensions_of_problems_and_solutions_rating)!=110)*5) + 2 * ((ORD(respects_complexity_rating)!=110)*5) + 2 * ((ORD(action_experience_rating)!=110)*5) + 2 * ((ORD(action_skills_rating)!=110)*5) + 2 * ((ORD(empathy_and_respect_rating)!=110)*5) + 2 * ((ORD(personal_affinity_with_earth_rating)!=110)*5) + 1 * ((ORD(locally_focused_rating)!=110)*5) + 1 * ((ORD(past_and_present_and_future_rating)!=110)*5) + 2 * ((ORD(open_ended_instruction_rating)!=110)*5) + 2 * ((ORD(integrated_learning_rating)!=110)*5) + 2 * ((ORD(inquiry_learning_rating)!=110)*5) + 2 * ((ORD(values_education_methodology_rating)!=110)*5) + 2 * ((ORD(accommodate_diverse_learners_rating)!=110)*5) + 1 * ((ORD(experiential_learning_rating)!=110)*5) + 1 * ((ORD(student_directed_learning_rating)!=110)*5) + 1 * ((ORD(assessment_and_evaluation_of_student_learning_rating)!=110)*5) + 1 * ((ORD(peer_teaching_rating)!=110)*5) + 1 * ((ORD(case_studies_rating)!=110)*5) + 1 * ((ORD(locus_of_control_rating)!=110)*5) + 40 ) as rank_3, ( 0 + 2 * ((ORD(biases_rating)=118)*5 + (ORD(biases_rating)=103)*4 + (ORD(biases_rating)=109)*3 + (ORD(biases_rating)=112)*2 ) + 2 * ((ORD(multiple_dimensions_of_problems_and_solutions_rating)=118)*5 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=103)*4 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=109)*3 + (ORD(multiple_dimensions_of_problems_and_solutions_rating)=112)*2 ) + 2 * ((ORD(respects_complexity_rating)=118)*5 + (ORD(respects_complexity_rating)=103)*4 + (ORD(respects_complexity_rating)=109)*3 + (ORD(respects_complexity_rating)=112)*2 ) + 2 * ((ORD(action_experience_rating)=118)*5 + (ORD(action_experience_rating)=103)*4 + (ORD(action_experience_rating)=109)*3 + (ORD(action_experience_rating)=112)*2 ) + 2 * ((ORD(action_skills_rating)=118)*5 + (ORD(action_skills_rating)=103)*4 + (ORD(action_skills_rating)=109)*3 + (ORD(action_skills_rating)=112)*2 ) + 2 * ((ORD(empathy_and_respect_rating)=118)*5 + (ORD(empathy_and_respect_rating)=103)*4 + (ORD(empathy_and_respect_rating)=109)*3 + (ORD(empathy_and_respect_rating)=112)*2 ) + 2 * ((ORD(personal_affinity_with_earth_rating)=118)*5 + (ORD(personal_affinity_with_earth_rating)=103)*4 + (ORD(personal_affinity_with_earth_rating)=109)*3 + (ORD(personal_affinity_with_earth_rating)=112)*2 ) + 1 * ((ORD(locally_focused_rating)=118)*5 + (ORD(locally_focused_rating)=103)*4 + (ORD(locally_focused_rating)=109)*3 + (ORD(locally_focused_rating)=112)*2 ) + 1 * ((ORD(past_and_present_and_future_rating)=118)*5 + (ORD(past_and_present_and_future_rating)=103)*4 + (ORD(past_and_present_and_future_rating)=109)*3 + (ORD(past_and_present_and_future_rating)=112)*2 ) + 2 * ((ORD(open_ended_instruction_rating)=118)*5 + (ORD(open_ended_instruction_rating)=103)*4 + (ORD(open_ended_instruction_rating)=109)*3 + (ORD(open_ended_instruction_rating)=112)*2 ) + 2 * ((ORD(integrated_learning_rating)=118)*5 + (ORD(integrated_learning_rating)=103)*4 + (ORD(integrated_learning_rating)=109)*3 + (ORD(integrated_learning_rating)=112)*2 ) + 2 * ((ORD(inquiry_learning_rating)=118)*5 + (ORD(inquiry_learning_rating)=103)*4 + (ORD(inquiry_learning_rating)=109)*3 + (ORD(inquiry_learning_rating)=112)*2 ) + 2 * ((ORD(values_education_methodology_rating)=118)*5 + (ORD(values_education_methodology_rating)=103)*4 + (ORD(values_education_methodology_rating)=109)*3 + (ORD(values_education_methodology_rating)=112)*2 ) + 2 * ((ORD(accommodate_diverse_learners_rating)=118)*5 + (ORD(accommodate_diverse_learners_rating)=103)*4 + (ORD(accommodate_diverse_learners_rating)=109)*3 + (ORD(accommodate_diverse_learners_rating)=112)*2 ) + 1 * ((ORD(experiential_learning_rating)=118)*5 + (ORD(experiential_learning_rating)=103)*4 + (ORD(experiential_learning_rating)=109)*3 + (ORD(experiential_learning_rating)=112)*2 ) + 1 * ((ORD(student_directed_learning_rating)=118)*5 + (ORD(student_directed_learning_rating)=103)*4 + (ORD(student_directed_learning_rating)=109)*3 + (ORD(student_directed_learning_rating)=112)*2 ) + 1 * ((ORD(assessment_and_evaluation_of_student_learning_rating)=118)*5 + (ORD(assessment_and_evaluation_of_student_learning_rating)=103)*4 + (ORD(assessment_and_evaluation_of_student_learning_rating)=109)*3 + (ORD(assessment_and_evaluation_of_student_learning_rating)=112)*2 ) + 1 * ((ORD(peer_teaching_rating)=118)*5 + (ORD(peer_teaching_rating)=103)*4 + (ORD(peer_teaching_rating)=109)*3 + (ORD(peer_teaching_rating)=112)*2 ) + 1 * ((ORD(case_studies_rating)=118)*5 + (ORD(case_studies_rating)=103)*4 + (ORD(case_studies_rating)=109)*3 + (ORD(case_studies_rating)=112)*2 ) + 1 * ((ORD(locus_of_control_rating)=118)*5 + (ORD(locus_of_control_rating)=103)*4 + (ORD(locus_of_control_rating)=109)*3 + (ORD(locus_of_control_rating)=112)*2 ) + IF (recommended='yes', 40, IF (recommended='yes with qualifications', 20, IF (recommended='no but very close',10,0) ) ) )/( 0 + 2 * ((ORD(biases_rating)!=110)*5) + 2 * ((ORD(multiple_dimensions_of_problems_and_solutions_rating)!=110)*5) + 2 * ((ORD(respects_complexity_rating)!=110)*5) + 2 * ((ORD(action_experience_rating)!=110)*5) + 2 * ((ORD(action_skills_rating)!=110)*5) + 2 * ((ORD(empathy_and_respect_rating)!=110)*5) + 2 * ((ORD(personal_affinity_with_earth_rating)!=110)*5) + 1 * ((ORD(locally_focused_rating)!=110)*5) + 1 * ((ORD(past_and_present_and_future_rating)!=110)*5) + 2 * ((ORD(open_ended_instruction_rating)!=110)*5) + 2 * ((ORD(integrated_learning_rating)!=110)*5) + 2 * ((ORD(inquiry_learning_rating)!=110)*5) + 2 * ((ORD(values_education_methodology_rating)!=110)*5) + 2 * ((ORD(accommodate_diverse_learners_rating)!=110)*5) + 1 * ((ORD(experiential_learning_rating)!=110)*5) + 1 * ((ORD(student_directed_learning_rating)!=110)*5) + 1 * ((ORD(assessment_and_evaluation_of_student_learning_rating)!=110)*5) + 1 * ((ORD(peer_teaching_rating)!=110)*5) + 1 * ((ORD(case_studies_rating)!=110)*5) + 1 * ((ORD(locus_of_control_rating)!=110)*5) + 40 ) as rank FROM resources LEFT JOIN resource_content USING (resource_id) LEFT JOIN resource_assessment USING (resource_id) LEFT JOIN resource_assessment_sustainability USING (resource_id) LEFT JOIN resource_assessment_pedagogical USING (resource_id) LEFT JOIN resource_curriculum USING (resource_id) LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id LEFT JOIN resource_resource_types USING (resource_id) LEFT JOIN resource_types_content ON resource_types_content.type_id=resource_resource_types.type_id LEFT JOIN resource_sdg USING (resource_id) LEFT JOIN sdg ON sdg.sdg_id=resource_sdg.sdg_id LEFT JOIN resource_standalone USING (resource_id) LEFT JOIN resource_theme ON resource_theme.resource_id=resources.resource_id LEFT JOIN issues_sub_themes ON issues_sub_themes.theme_id=resource_theme.theme_id LEFT JOIN issues_sub_themes_content ON issues_sub_themes_content.theme_id=issues_sub_themes.theme_id AND issues_sub_themes_content.lang_id='2' WHERE resources.language_id='2' AND resources.live='yes' GROUP BY resource_content.resource_id ORDER BY rank DESC LIMIT 140,20 ) [20 row(s)]
0,0003 0,009 ( SELECT FOUND_ROWS(); ) [1 row(s)]
0,0003 0,0093 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2258' ) [1 row(s)]
0,0003 0,0096 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='326' ) [1 row(s)]
0,0002 0,0098 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2647' ) [2 row(s)]
0,0002 0,01 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1741' ) [1 row(s)]
0,0002 0,0102 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1705' ) [1 row(s)]
0,0002 0,0104 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2643' ) [1 row(s)]
0,0003 0,0107 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3332' ) [1 row(s)]
0,0002 0,0109 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2942' ) [1 row(s)]
0,0002 0,0111 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2949' ) [1 row(s)]
0,0003 0,0114 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2657' ) [1 row(s)]
0,0002 0,0116 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1858' ) [1 row(s)]
0,0002 0,0118 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2468' ) [1 row(s)]
0,0003 0,0121 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1660' ) [1 row(s)]
0,0003 0,0124 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1664' ) [1 row(s)]
0,0002 0,0126 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='417' ) [1 row(s)]
0,0002 0,0128 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3328' ) [1 row(s)]
0,0005 0,0133 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2879' ) [3 row(s)]
0,0003 0,0136 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2884' ) [1 row(s)]
0,0002 0,0138 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='327' ) [1 row(s)]
0,0003 0,0141 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='330' ) [1 row(s)]