Resources

Query (SELECT SQL_CALC_FOUND_ROWS t1.resource_id, t1.review_type, t1.curriculum_match_type, t1.slug, t1.url, t1.downloadable_immediately, IF (t1.language_id=1,'English','Français') as language, rc.title, rc.sub_title, rc.description, t3.curriculum_id, t3.weight, IF (MAX(t3.weight)=1,'easy',IF (MAX(t3.weight)=0.5,'challenging',0)) as fit_order, ra.recommended, IF (ra.recommended='yes',1,IF (ra.recommended='yes with qualifications',0.5,0)) as recommended_order FROM resources t1 LEFT JOIN resource_content rc USING (resource_id) LEFT JOIN resource_assessment ra USING (resource_id) LEFT JOIN resource_assessment_sustainability USING (resource_id) LEFT JOIN resource_assessment_pedagogical USING (resource_id) LEFT JOIN resource_curriculum t3 USING (resource_id) LEFT JOIN resource_standalone t4 USING (resource_id) INNER JOIN resource_indigenous t9 USING (resource_id) WHERE t1.live='yes' AND (t3.curriculum_id > 0 or t4.audience_id > 0) AND t1.language_id='1' AND t9.compilation_id=723 group by t1.resource_id LIMIT 0,20) Failed: Unknown column 't9.compilation_id' in 'where clause' (1054)

Modify Search