Newsletter Signup
Nominate

Submit a Nomination Request

Use the form below to submit nominations.

(default) 13 queries took 32 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `gallery_images`881
2DESCRIBE `users`551
3SELECT `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 1110
4SELECT `SiteLink`.`id`, `SiteLink`.`site_report_id`, `SiteLink`.`link_text`, `SiteLink`.`link_url` FROM `site_links` AS `SiteLink` WHERE `SiteLink`.`site_report_id` = (18) 000
5SELECT `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
6SELECT `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
7SELECT `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
8SELECT `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 440
9SELECT `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
10SELECT `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
11SELECT `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
12SELECT `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
13SELECT `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` = 'nominate' LIMIT 1001
(projects) 14 queries took 678 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `project_summary`272733
2DESCRIBE `status`33261
3DESCRIBE `reports`5532
4DESCRIBE `countries`3332
5DESCRIBE `regions`3332
6DESCRIBE `project_images`5532
7DESCRIBE `project_pollutant`3332
8DESCRIBE `pollutants`2232
9DESCRIBE `project_transpath`3332
10DESCRIBE `project_resource`4432
11DESCRIBE `project_industry`3332
12DESCRIBE `industries`2232
13DESCRIBE `project_program`3332
14DESCRIBE `programs`2232