Newsletter Signup
Top Ten Toxic Threats 2013

Top Ten Toxic Threats 2013

2011 Report

Download the Report PDF 2.8 MB

Top 10 of Toxic 20 Report 2011

Blacksmith Institute
2014 Fifth Avenue. New York, NY 10035 USA
Phone: (212)647-8330 Fax: +1 (212)647-8334
Email:

Media Inquiries
Media inquiries should be directed to Magdalene Sim at: +1 212-647-8330
Media inquiries in Europe should be directed to Nathalie Gysi at:


(default) 18 queries took 39 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `dynpages`19191
2DESCRIBE `dynpage_categories`551
3DESCRIBE `site_reports`12121
4DESCRIBE `site_links`441
5DESCRIBE `projects_reports`771
6DESCRIBE `gallery_images`881
7DESCRIBE `users`551
8SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC LIMIT 1111
9SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` = (18) 000
10SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` = (18) ORDER BY `ProjectsReports`.`weight` ASC 10103
11SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` = (18) ORDER BY weight ASC 17171
12SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`title` = '2013' ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC LIMIT 1110
13SELECT `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `ParentCategory`.`id`, `ParentCategory`.`parent_category`, `ParentCategory`.`title`, `ParentCategory`.`url`, `ParentCategory`.`weight` FROM `dynpage_categories` AS `DynpageCategory` LEFT JOIN `dynpage_categories` AS `ParentCategory` ON (`DynpageCategory`.`parent_category` = `ParentCategory`.`id`) WHERE `DynpageCategory`.`parent_category` = 61 ORDER BY `DynpageCategory`.`weight` ASC, `ParentCategory`.`weight` ASC 441
14SELECT `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `site_reports` AS `SiteReport` WHERE `active` = 1 ORDER BY `report_year` DESC 771
15SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) 000
16SELECT `ProjectsReports`.`id`, `ProjectsReports`.`site_report_id`, `ProjectsReports`.`weight`, `ProjectsReports`.`title`, `ProjectsReports`.`subtitle`, `ProjectsReports`.`image`, `ProjectsReports`.`description` FROM `projects_reports` AS `ProjectsReports` WHERE `ProjectsReports`.`site_report_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY `ProjectsReports`.`weight` ASC 707021
17SELECT `GalleryImage`.`id`, `GalleryImage`.`gallery_id`, `GalleryImage`.`image`, `GalleryImage`.`title`, `GalleryImage`.`description`, `GalleryImage`.`weight`, `GalleryImage`.`mime`, `GalleryImage`.`is_title` FROM `gallery_images` AS `GalleryImage` WHERE `GalleryImage`.`gallery_id` IN (18, 17, 16, 15, 14, 13, 1) ORDER BY weight ASC 3483483
18SELECT `Dynpage`.`id`, `Dynpage`.`site_report_id`, `Dynpage`.`dynpage_category_id`, `Dynpage`.`weight`, `Dynpage`.`title`, `Dynpage`.`seo_title`, `Dynpage`.`content`, `Dynpage`.`side_content`, `Dynpage`.`access`, `Dynpage`.`modified`, `Dynpage`.`lang`, `Dynpage`.`ip`, `Dynpage`.`revision`, `Dynpage`.`accessed`, `Dynpage`.`window_title`, `Dynpage`.`keywords`, `Dynpage`.`description`, `Dynpage`.`image`, `Dynpage`.`image_legend`, `DynpageCategory`.`id`, `DynpageCategory`.`parent_category`, `DynpageCategory`.`title`, `DynpageCategory`.`url`, `DynpageCategory`.`weight`, `SiteReport`.`id`, `SiteReport`.`name`, `SiteReport`.`report_year`, `SiteReport`.`intro_text`, `SiteReport`.`image`, `SiteReport`.`map`, `SiteReport`.`short_title`, `SiteReport`.`thumbnail`, `SiteReport`.`attachment`, `SiteReport`.`attachment_filename`, `SiteReport`.`attachment_mime`, `SiteReport`.`active` FROM `dynpages` AS `Dynpage` LEFT JOIN `dynpage_categories` AS `DynpageCategory` ON (`Dynpage`.`dynpage_category_id` = `DynpageCategory`.`id`) LEFT JOIN `site_reports` AS `SiteReport` ON (`Dynpage`.`site_report_id` = `SiteReport`.`id`) WHERE `Dynpage`.`seo_title` = '2011-report' LIMIT 1111
(projects) 14 queries took 413 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `project_summary`272731
2DESCRIBE `status`3329
3DESCRIBE `reports`5529
4DESCRIBE `countries`3329
5DESCRIBE `regions`3329
6DESCRIBE `project_images`5529
7DESCRIBE `project_pollutant`3330
8DESCRIBE `pollutants`2229
9DESCRIBE `project_transpath`3329
10DESCRIBE `project_resource`4433
11DESCRIBE `project_industry`3329
12DESCRIBE `industries`2229
13DESCRIBE `project_program`3329
14DESCRIBE `programs`2229