Ressources
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='2' AND t9.compilation_id=644 group by t1.resource_id LIMIT 0,20) Failed: Unknown column 't9.compilation_id' in 'where clause' (1054)
Modify Search
Vos paramètres de recherche sont:
- Compilation : Unicef Global Classroom x
- Effacer