37 total queries| (query time) (total time) (query) |
|---|
| 0.0001 0.0001 (SET NAMES 'utf8') |
| 0.0006 0.0007 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page='project-flow' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)] |
| 0.0001 0.0008 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)] |
| 0.0001 0.0009 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)] |
| 0.0003 0.0012 (SELECT * FROM page_details
LEFT JOIN page_content
USING (page_id)
WHERE page_details.page_id='42' AND lang_id='1' AND page_details.live='yes') [1 row(s)] |
| 0.0004 0.0016 (SELECT * FROM cms76_modules
LEFT JOIN page_includes
USING (module_id)
WHERE page_id=42 ORDER BY page_order) [4 row(s)] |
| 0.0002 0.0018 (SELECT * FROM page_details WHERE page_id='42') [1 row(s)] |
| 0.0002 0.002 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='17'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [6 row(s)] |
| 0.0001 0.0021 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='32'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0022 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='18'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0023 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='22'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0024 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='19'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0025 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='20'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0026 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='21'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [0 row(s)] |
| 0.0001 0.0027 (
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.0029 (
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.0001 0.003 (
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
) [17 row(s)] |
| 0.0002 0.0032 (
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.0001 0.0033 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='1'
ORDER BY issues_sub_themes_content.title ASC
) [6 row(s)] |
| 0.0002 0.0035 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='13'
ORDER BY issues_sub_themes_content.title ASC
) [7 row(s)] |
| 0.0001 0.0036 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='7'
ORDER BY issues_sub_themes_content.title ASC
) [5 row(s)] |
| 0.0001 0.0037 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='4'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0.0002 0.0039 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='5'
ORDER BY issues_sub_themes_content.title ASC
) [4 row(s)] |
| 0.0001 0.004 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='2'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0.0001 0.0041 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='3'
ORDER BY issues_sub_themes_content.title ASC
) [5 row(s)] |
| 0.0001 0.0042 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='12'
ORDER BY issues_sub_themes_content.title ASC
) [9 row(s)] |
| 0.0001 0.0043 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='10'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0.0001 0.0044 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='11'
ORDER BY issues_sub_themes_content.title ASC
) [3 row(s)] |
| 0.0001 0.0045 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='6'
ORDER BY issues_sub_themes_content.title ASC
) [10 row(s)] |
| 0.0001 0.0046 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='15'
ORDER BY issues_sub_themes_content.title ASC
) [3 row(s)] |
| 0.0001 0.0047 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='8'
ORDER BY issues_sub_themes_content.title ASC
) [8 row(s)] |
| 0.0001 0.0048 (
SELECT
issues_sub_themes.theme_id as id,
issues_sub_themes_content.title as name
FROM issues_sub_themes
LEFT JOIN issues_sub_themes_content USING(theme_id)
WHERE
issues_sub_themes_content.lang_id='1'
AND issues_sub_themes.issue_id='9'
ORDER BY issues_sub_themes_content.title ASC
) [8 row(s)] |
| 0.0008 0.0056 (
SELECT
resource_supplier.supplier_id as id,
resource_supplier_content.organization as name,
COUNT(DISTINCT resource_id) as resource_count
FROM resource_supplier
LEFT JOIN resource_supplier_content USING(supplier_id)
LEFT JOIN resources USING(supplier_id)
WHERE
resource_supplier_content.lang_id='1'
AND resource_supplier_content.organization != ''
GROUP BY resource_supplier.supplier_id
HAVING resource_count > 0
ORDER BY resource_supplier_content.organization ASC
) [223 row(s)] |
| 0.0012 0.0068 (
SELECT
page_details.*,
page_content.title,
if(menu_order=0,0,1) as map_order
FROM page_details
LEFT JOIN page_content USING (page_id)
WHERE
lang_id='1'
AND parent_page='42'
AND page_details.live='yes'
AND page_details.page_id!=1
ORDER BY map_order DESC,menu_order ASC
) [5 row(s)] |
| 0.0197 0.0265 (
SELECT
*
FROM resources
LEFT JOIN resource_content USING(resource_id)
LEFT JOIN resource_compilation USING(resource_id)
LEFT JOIN resource_curriculum USING(resource_id)
LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id
WHERE
resources.language_id='1'
AND resource_compilation.compilation_id = 197
AND resource_curriculum.weight>0
AND resources.live='yes'
GROUP BY resource_content.resource_id
) [3 row(s)] |
| 0.0479 0.0744 (
SELECT
resources.resource_id,
resources.slug,
resources.url,
resource_content.title,
resource_content.sub_title,
resource_content.description,
resources.downloadable_immediately,
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_compilation USING(resource_id)
LEFT JOIN resource_curriculum USING(resource_id)
LEFT JOIN curriculum_units ON curriculum_units.curriculum_id=resource_curriculum.curriculum_id
WHERE
resources.language_id='1'
AND resource_compilation.compilation_id = 197
AND resource_curriculum.weight>0
AND resources.live='yes'
GROUP BY resource_content.resource_id
ORDER BY rank DESC
LIMIT 0,100
) [3 row(s)] |
| 0.0488 0.1232 (
SELECT
n.resource_id,
nc.content
FROM resource_compilation_notes as n
LEFT JOIN resource_compilation_note_content as nc USING(note_id)
WHERE
nc.lang_id = 1
AND n.compilation_id = 197
AND n.resource_id IN (293, 574, 1302)
) [0 row(s)] |
Loading...
