Search for Resources

World Fisheries Day:
November 21st, 2021

World Fisheries Day was established in 1997 to draw attention to overfishing, habitat destruction and other serious threats to the sustainability of our marine and freshwater resources. Observing World Fisheries Day can help bring awareness of the importance of aquatic environments in sustaining life both in and out of water. Each World Fisheries Day also provides us with an opportunity to reflect on the ever-increasing challenge of sustaining our fish stocks and the livelihoods of those who depend on the industry. This year’s event will focus special international attention on the need to improve conditions for many of the the men and women who work as in the fishing sector.

Through participation in engaging classroom activities, young people can be encouraged to help make a difference in the health of our aquatic ecosystems, the variety of species they support and all those employed in the fishing industry.

 

Why Care about Fisheries?

• The human population consumes over 100 million metric tons of fish annually (Fisheries & Oceans Canada 2018)

• More than 25% of the world’s dietary protein is provided by fish. (gov.za 2020)

• Each year the Canadian fishery lands over 1 million metric tons of fish valued in excess of 2 billion dollars. (Fisheries & Oceans Canada 2018)

• The global fish market is valued at over 160 billion dollars (statista.com 2020)

• Fisheries and aquaculture employ more than 43 million individuals worldwide. (FA0 2018)

• With 60% of the volume of the world’s fish trade coming from developing counties, there exists a real need for international efforts to ensure decent working conditions.

• Fishing is one of the world’s most dangerous professions. It often lacks adequate labour regulation, and vessels have been associated with forced labour, trafficking, and other abuses of workers.(FAO 2021)

• A recent United Nations study reported that more than two-thirds of the world's fisheries have collapsed or are currently being overfished. Much of the remaining one third is in a state of decline because of habitat degradation from pollution and climate change.

• The largest Northern Cod fishery in the world was located off the coast of Newfoundland. This engine of the Newfoundland economy collapsed in the early 1990’s due to overfishing and poor fisheries management. Thirty years later Newfoundland’s commercial cod fishery remains closed.

• All natural fish stocks today contain at least trace amounts of mercury.

Resources 4 Rethinking encourages students and teachers to participate in World Fisheries Day.  Top R4R Picks will connect you to some excellent resources to support these efforts.

Other Classroom Resources from Learning for a Sustainable Future

Click here for more information about World Fisheries Day


125 total queries
(query time) (total time) (query)
0.0013 0.0013 (SET NAMES 'utf8')
0.0003 0.0016 ( 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.002 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='theme' AND parent_page=1 AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0007 0.0027 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page='fisheries-day-2021' AND parent_page=125 AND lang_id='1' AND page_details.live='yes') [0 row(s)]
0.0002 0.0029 (SELECT * FROM cms76_languages WHERE lang_id=1) [1 row(s)]
0.0012 0.0041 (SELECT * FROM cms76_languages WHERE lang_id!=1) [1 row(s)]
0.0003 0.0044 (SELECT * FROM page_details LEFT JOIN page_content USING (page_id) WHERE page_details.page_id='125' AND lang_id='1' AND page_details.live='yes') [1 row(s)]
0.0003 0.0047 (SELECT * FROM cms76_modules LEFT JOIN page_includes USING (module_id) WHERE page_id=125 ORDER BY page_order) [2 row(s)]
0.0003 0.005 (SELECT * FROM page_details WHERE page_id='125') [1 row(s)]
0.0004 0.0054 ( 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 ) [7 row(s)]
0.0003 0.0057 ( 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.0003 0.006 ( 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='195' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [5 row(s)]
0.0003 0.0063 ( 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='225' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0066 ( 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='223' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 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='245' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 0.007 ( 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='253' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 0.0072 ( 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='282' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0002 0.0074 ( 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.0002 0.0076 ( 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.0003 0.0079 ( 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.0002 0.0081 ( 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.0003 0.0084 ( 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.0003 0.0087 ( 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='28' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [6 row(s)]
0.0003 0.009 ( 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='178' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0093 ( 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='179' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0096 ( 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='180' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0099 ( 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='181' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0102 ( 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='182' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0003 0.0105 ( 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='183' AND page_details.live='yes' AND page_details.page_id!=1 ORDER BY map_order DESC,menu_order ASC ) [0 row(s)]
0.0005 0.011 ( 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.0113 ( 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.0006 0.0119 ( 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.0003 0.0122 ( 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.0126 ( 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.0003 0.0129 ( 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.0003 0.0132 ( 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.0004 0.0136 ( 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.0101 0.0237 (SELECT b.resource_id, c.compilation_id, c.title, c.description FROM compilation_content AS c inner join resource_compilation as b on c.compilation_id = b.compilation_id WHERE c.lang_id = 1 and c.slug = 'fisheries-day-2021' and c.slug <> '') [24 row(s)]
0.0015 0.0252 ( SELECT resource_compilation.resource_id, resources.slug, resources.date_published, resource_content.title FROM resources LEFT JOIN resource_compilation USING (resource_id) LEFT JOIN resource_content USING (resource_id) WHERE resource_compilation.compilation_id = 452 AND resources.language_id = 1 ) [17 row(s)]
0.0006 0.0258 ( 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 = 452 AND n.resource_id IN (759, 1369, 1542, 1736, 1740, 1999, 2121, 2196, 2411, 2543, 2601, 2776, 2916, 3032, 3180, 3222, 3233) ) [0 row(s)]
0.0003 0.0261 ( 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.0003 0.0264 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='759' ) [1 row(s)]
0.0003 0.0267 ( 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.0003 0.027 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1369' ) [1 row(s)]
0.0004 0.0274 ( 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.0004 0.0278 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1542' ) [1 row(s)]
0.0003 0.0281 ( 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.0003 0.0284 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1736' ) [1 row(s)]
0.0003 0.0287 ( 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.0289 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1740' ) [1 row(s)]
0.0003 0.0292 ( 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.0294 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1999' ) [1 row(s)]
0.0002 0.0296 ( 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.0003 0.0299 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2121' ) [1 row(s)]
0.0003 0.0302 ( 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.0304 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2196' ) [1 row(s)]
0.0003 0.0307 ( 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.0003 0.031 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2411' ) [1 row(s)]
0.0003 0.0313 ( 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.0003 0.0316 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2543' ) [1 row(s)]
0.0006 0.0322 ( 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.0324 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2601' ) [1 row(s)]
0.0002 0.0326 ( 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.0328 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2776' ) [1 row(s)]
0.0003 0.0331 ( 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.0333 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2916' ) [1 row(s)]
0.0002 0.0335 ( 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.0003 0.0338 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3032' ) [1 row(s)]
0.0002 0.034 ( 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.0342 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3180' ) [1 row(s)]
0.0003 0.0345 ( 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.0347 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3222' ) [1 row(s)]
0.0003 0.035 ( 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.0352 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3233' ) [1 row(s)]
0.0003 0.0355 ( 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.0357 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3032' ) [1 row(s)]
0.0008 0.0365 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3032 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0368 ( 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.0003 0.0371 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3222' ) [1 row(s)]
0.0008 0.0379 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3222 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [3 row(s)]
0.0003 0.0382 ( 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.0384 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3180' ) [1 row(s)]
0.0009 0.0393 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3180 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0396 ( 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.0003 0.0399 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='3233' ) [1 row(s)]
0.0009 0.0408 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 3233 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0411 ( 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.0413 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2776' ) [1 row(s)]
0.0006 0.0419 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2776 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [3 row(s)]
0.0003 0.0422 ( 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.0003 0.0425 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2916' ) [1 row(s)]
0.0011 0.0436 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2916 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0002 0.0438 ( 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.044 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2543' ) [1 row(s)]
0.0009 0.0449 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2543 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0452 ( 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.0454 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1369' ) [1 row(s)]
0.0017 0.0471 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1369 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [8 row(s)]
0.0004 0.0475 ( 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.0003 0.0478 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1542' ) [1 row(s)]
0.0014 0.0492 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1542 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [3 row(s)]
0.0003 0.0495 ( 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.0497 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1736' ) [1 row(s)]
0.0005 0.0502 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1736 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0505 ( 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.0507 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1740' ) [1 row(s)]
0.0007 0.0514 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1740 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0517 ( 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.001 0.0527 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='759' ) [1 row(s)]
0.0014 0.0541 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 759 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [6 row(s)]
0.0003 0.0544 ( 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.0546 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2601' ) [1 row(s)]
0.0008 0.0554 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2601 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0557 ( 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.0004 0.0561 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2121' ) [1 row(s)]
0.0017 0.0578 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2121 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0581 ( 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.0583 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2196' ) [1 row(s)]
0.0007 0.059 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2196 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]
0.0003 0.0593 ( 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.0003 0.0596 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='2411' ) [1 row(s)]
0.0007 0.0603 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 2411 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [3 row(s)]
0.0003 0.0606 ( 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.0003 0.0609 ( SELECT resource_resource_types.type_id as icon FROM resources LEFT JOIN resource_resource_types USING (resource_id) WHERE resource_id='1999' ) [1 row(s)]
0.0007 0.0616 (SELECT * FROM resource_curriculum LEFT JOIN curriculum_units ON resource_curriculum.curriculum_id = curriculum_units.curriculum_id LEFT JOIN curriculum_audience_content ON curriculum_audience_content.audience_id = curriculum_units.audience_id WHERE resource_curriculum.resource_id = 1999 AND curriculum_audience_content.lang_id = 1 GROUP BY curriculum_audience_content.name ) [4 row(s)]