skip to content | Accessibility Information

Friday 21st April – Thursday 27th April

What were YOUR favourite stories of 2015?

2015 WAS an incredibly busy year at Manchester Met and for the ManMetLife team – we publish...

Noticeboard

  • University Wide

    Foodbank hamper appeal: Dec 7 to 11

  • Art & Design

    Open Lectures This Week

  • Careers & Employability

    Careers & Employability – What’s on this week?

  • Careers & Employability

    Careers & Employability – What’s on this week?

  • Uncategorized

    Macmillan Cake Sale at Brooks Building

  • Uncategorized

    Bake Sale for Bi-Visibility Day

  • Hollings

    Macmillan Cake Bake for Charity

  • Research

    Funding and resources available to support Open Access

  • University Wide

    Staff Awards: Celebrating the best of Manchester Met

  • University Wide

    Final reminder! Book graduation robes and places today!

  • MIRIAD

    Why Fairies are Real and Art Matters

  • IT Services

    Possible disruption to Moodle, 7am - 9am Tuesday 19 May

  • IT Services

    Printing and web resources at risk

  • Careers & Employability

    Careers & Employability – What’s on this week?

  • Sport

    MMU Jogging Club run Morrisons Great Manchester Run

  • Notice (8): Undefined variable: date [APP/views/news_posts/index.ctp, line 60]
    view full notices archive

(default) 26 queries took 318 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SHOW FULL COLUMNS FROM `news_posts`15151
2SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';110
3SHOW FULL COLUMNS FROM `news_statuses`771
4SHOW FULL COLUMNS FROM `users`11111
5SHOW FULL COLUMNS FROM `news_channels`881
6SHOW FULL COLUMNS FROM `news_levels`881
7SHOW FULL COLUMNS FROM `news_attachments`13131
8SHOW FULL COLUMNS FROM `news_categories`11111
9SHOW FULL COLUMNS FROM `news_categories_news_posts`220
10SHOW FULL COLUMNS FROM `news_tags`881
11SHOW FULL COLUMNS FROM `news_posts_news_tags`220
12SELECT `NewsLevel`.`id` FROM `news_levels` AS `NewsLevel` WHERE `NewsLevel`.`slug` = 'level-0' LIMIT 1110
13SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by`, `NewsZeroImage`.`id`, `NewsZeroImage`.`basename` FROM `news_posts` AS `NewsPost` LEFT JOIN `news_attachments` AS `NewsZeroImage` ON (`NewsZeroImage`.`foreign_key` = `NewsPost`.`id` AND `NewsZeroImage`.`model` = 'NewsPost' AND `NewsZeroImage`.`group` = 'NewsZeroImage') WHERE `NewsPost`.`news_level_id` = 1 AND `NewsPost`.`news_channel_id` = 3 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY `NewsPost`.`post_date` DESC LIMIT 111154
14SELECT `NewsLevel`.`id` FROM `news_levels` AS `NewsLevel` WHERE `NewsLevel`.`slug` = 'level-1-1' LIMIT 1110
15SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by`, `NewsThumbnail`.`id`, `NewsThumbnail`.`basename` FROM `news_posts` AS `NewsPost` LEFT JOIN `news_attachments` AS `NewsThumbnail` ON (`NewsThumbnail`.`foreign_key` = `NewsPost`.`id` AND `NewsThumbnail`.`model` = 'NewsPost' AND `NewsThumbnail`.`group` = 'NewsThumbnail') WHERE `NewsPost`.`news_level_id` = 3 AND `NewsPost`.`news_channel_id` = 3 AND YEAR(`NewsPost`.`post_date`) = 2016 AND WEEKOFYEAR(`NewsPost`.`post_date`) = 26 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY ISNULL(`NewsPost`.`ordering`) ASC, `NewsPost`.`ordering` ASC LIMIT 10017
16SELECT `NewsLevel`.`id` FROM `news_levels` AS `NewsLevel` WHERE `NewsLevel`.`slug` = 'level-1-2' LIMIT 1110
17SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by`, `NewsThumbnail`.`id`, `NewsThumbnail`.`basename` FROM `news_posts` AS `NewsPost` LEFT JOIN `news_attachments` AS `NewsThumbnail` ON (`NewsThumbnail`.`foreign_key` = `NewsPost`.`id` AND `NewsThumbnail`.`model` = 'NewsPost' AND `NewsThumbnail`.`group` = 'NewsThumbnail') WHERE `NewsPost`.`news_level_id` = 4 AND `NewsPost`.`news_channel_id` = 3 AND YEAR(`NewsPost`.`post_date`) = 2016 AND WEEKOFYEAR(`NewsPost`.`post_date`) = 26 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY ISNULL(`NewsPost`.`ordering`) ASC, `NewsPost`.`ordering` ASC LIMIT 10011
18SELECT `NewsLevel`.`id` FROM `news_levels` AS `NewsLevel` WHERE `NewsLevel`.`slug` = 'level-1-3' LIMIT 1110
19SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by`, `NewsThumbnail`.`id`, `NewsThumbnail`.`basename` FROM `news_posts` AS `NewsPost` LEFT JOIN `news_attachments` AS `NewsThumbnail` ON (`NewsThumbnail`.`foreign_key` = `NewsPost`.`id` AND `NewsThumbnail`.`model` = 'NewsPost' AND `NewsThumbnail`.`group` = 'NewsThumbnail') WHERE `NewsPost`.`news_level_id` = 5 AND `NewsPost`.`news_channel_id` = 3 AND YEAR(`NewsPost`.`post_date`) = 2016 AND WEEKOFYEAR(`NewsPost`.`post_date`) = 26 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY ISNULL(`NewsPost`.`ordering`) ASC, `NewsPost`.`ordering` ASC LIMIT 10010
20SELECT `NewsLevel`.`id` FROM `news_levels` AS `NewsLevel` WHERE `NewsLevel`.`slug` = 'level-2' LIMIT 1110
21SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by` FROM `news_posts` AS `NewsPost` WHERE `NewsPost`.`news_level_id` = 6 AND `NewsPost`.`news_channel_id` = 3 AND YEAR(`NewsPost`.`post_date`) = 2016 AND WEEKOFYEAR(`NewsPost`.`post_date`) = 26 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY ISNULL(`NewsPost`.`ordering`) ASC, `NewsPost`.`ordering` ASC 0049
22SELECT `NewsPost`.`id`, `NewsPost`.`news_status_id`, `NewsPost`.`news_channel_id`, `NewsPost`.`news_level_id`, `NewsPost`.`ordering`, `NewsPost`.`title`, `NewsPost`.`slug`, `NewsPost`.`excerpt`, `NewsPost`.`content`, `NewsPost`.`post_date`, `NewsPost`.`show_author`, `NewsPost`.`created`, `NewsPost`.`created_by`, `NewsPost`.`modified`, `NewsPost`.`modified_by` FROM `news_posts` AS `NewsPost` WHERE `news_channel_id` = 1 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' ORDER BY `post_date` DESC LIMIT 15151533
23SELECT `NewsCategory`.`id`, `NewsCategory`.`name`, `NewsCategory`.`slug`, `NewsCategoriesNewsPost`.`news_category_id`, `NewsCategoriesNewsPost`.`news_post_id` FROM `news_categories` AS `NewsCategory` JOIN `news_categories_news_posts` AS `NewsCategoriesNewsPost` ON (`NewsCategoriesNewsPost`.`news_post_id` IN (9051, 8984, 8952, 8844, 8718, 8719, 8720, 8560, 8531, 8474, 8386, 8365, 8350, 8347, 8337) AND `NewsCategoriesNewsPost`.`news_category_id` = `NewsCategory`.`id`) 15151
24SELECT YEAR(`NewsPost`.`post_date`) AS `year`, MONTH(`NewsPost`.`post_date`) AS `month`, DAYOFMONTH(`NewsPost`.`post_date`) AS `dayofmonth`, count(id) as posts FROM `news_posts` AS `NewsPost` WHERE `NewsPost`.`news_channel_id` = 1 AND MONTH(`NewsPost`.`post_date`) = '01' AND YEAR(`NewsPost`.`post_date`) = '1970' AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' GROUP BY YEAR(`NewsPost`.`post_date`), MONTH(`NewsPost`.`post_date`), DAYOFMONTH(`NewsPost`.`post_date`) ORDER BY `NewsPost`.`post_date` DESC 002
25SELECT `NewsCategory`.`id`, `NewsCategory`.`parent_id`, `NewsCategory`.`lft`, `NewsCategory`.`rght`, `NewsCategory`.`name`, `NewsCategory`.`slug`, `NewsCategory`.`news_post_count`, `NewsCategory`.`created`, `NewsCategory`.`created_by`, `NewsCategory`.`modified`, `NewsCategory`.`modified_by` FROM `news_categories` AS `NewsCategory` WHERE `NewsCategory`.`news_post_count` > 0 ORDER BY `NewsCategory`.`lft` asc 1151151
26SELECT DISTINCT WEEKOFYEAR(`NewsPost`.`post_date`) AS `week`, YEAR(`NewsPost`.`post_date`) AS `yr`, DATE_FORMAT( `NewsPost`.`post_date` , '%Y-%m-%d' ) AS `yyyymmdd`, count(`NewsPost`.`id`) AS `posts` FROM `news_posts` AS `NewsPost` WHERE `NewsPost`.`news_channel_id` = 3 AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-04-27 01:21:09' GROUP BY WEEKOFYEAR(`NewsPost`.`post_date`) , YEAR( `NewsPost`.`post_date` ) ORDER BY `NewsPost`.`post_date` DESC 22022032