41 total queries
(query time) (total time) (query)
0.0004 0.0004 (SET NAMES 'utf8')
0.0003 0.0007 ( 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.0003 0.001 (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.0002 0.0012 (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.0014 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0002 0.0016 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0003 0.0019 (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.0021 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=4 ORDER BY page_order) [2 row(s)]
0.0002 0.0023 (SELECT * FROM page_details WHERE page_id='4') [1 row(s)]
0.0002 0.0025 ( 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.0003 0.0028 ( 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='1' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0.0002 0.003 ( 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='1' ORDER BY curriculum_audience.number ASC ) [13 row(s)]
0.0002 0.0032 ( 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='1' AND resources.live='yes' ) [6 row(s)]
0.0002 0.0034 ( SELECT sdg_content.sdg_id as id, sdg_content.title FROM sdg_content WHERE sdg_content.lang_id='1' ORDER BY sdg_content.sdg_id ASC ) [18 row(s)]
0.0002 0.0036 ( 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='1' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0.0003 0.0039 ( 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='1' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0.0002 0.0041 ( 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='1' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0.0002 0.0043 ( 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='1' ORDER BY curriculum_subject_group_content.name ASC ) [14 row(s)]
0.0002 0.0045 ( 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='1' ORDER BY curriculum_province_content.name ASC ) [13 row(s)]
0.001 0.0055 ( 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='1' WHERE resources.language_id='1' AND resources.live='yes' GROUP BY resource_content.resource_id ORDER BY rank DESC LIMIT 300,20 ) [20 row(s)]
0.0008 0.0063 ( SELECT FOUND_ROWS(); ) [1 row(s)]
0.0002 0.0065 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2417' ) [1 row(s)]
0.0002 0.0067 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2811' ) [1 row(s)]
0.0002 0.0069 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2335' ) [1 row(s)]
0.0002 0.0071 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2648' ) [1 row(s)]
0.0002 0.0073 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1887' ) [1 row(s)]
0.0002 0.0075 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2941' ) [1 row(s)]
0.0002 0.0077 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1663' ) [1 row(s)]
0.0002 0.0079 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2948' ) [1 row(s)]
0.0002 0.0081 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1421' ) [1 row(s)]
0.0002 0.0083 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2546' ) [1 row(s)]
0.0002 0.0085 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2888' ) [1 row(s)]
0.0002 0.0087 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1633' ) [1 row(s)]
0.0002 0.0089 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1390' ) [1 row(s)]
0.0002 0.0091 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2218' ) [1 row(s)]
0.0002 0.0093 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1454' ) [1 row(s)]
0.0002 0.0095 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2250' ) [1 row(s)]
0.0002 0.0097 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1523' ) [1 row(s)]
0.0002 0.0099 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2866' ) [1 row(s)]
0.0002 0.0101 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2812' ) [1 row(s)]
0.0002 0.0103 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2947' ) [1 row(s)]