skip to content | Accessibility Information

Daily notices for Monday, 25th May 2015

  • Why Fairies are Real and Art Matters

    Following throat cancer, Director of MIRIAD, John Hyatt will do a talk about his recent work.

    'Why Fairies are Real and Art Matters'

    Wednesday 27 May 5-6pm, in the open space on the
    first floor of the Righton building.

    Come and welcome John back.



     

More daily notices…

Go to a day in March:

or view full notices archive

(default) 17 queries took 107 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';111
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`221
10SHOW FULL COLUMNS FROM `news_tags`881
11SHOW FULL COLUMNS FROM `news_posts_news_tags`221
12SELECT `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_channel_id` = 1 AND `NewsPost`.`post_date` LIKE '2015-05-25%' AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-03-26 09:04:26' 1140
13SELECT `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`, `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` = 8386 AND `NewsCategoriesNewsPost`.`news_category_id` = `NewsCategory`.`id`) 111
14SELECT `NewsTag`.`id`, `NewsTag`.`name`, `NewsTag`.`slug`, `NewsTag`.`news_post_count`, `NewsTag`.`created`, `NewsTag`.`created_by`, `NewsTag`.`modified`, `NewsTag`.`modified_by`, `NewsPostsNewsTag`.`news_post_id`, `NewsPostsNewsTag`.`news_tag_id` FROM `news_tags` AS `NewsTag` JOIN `news_posts_news_tags` AS `NewsPostsNewsTag` ON (`NewsPostsNewsTag`.`news_post_id` = 8386 AND `NewsPostsNewsTag`.`news_tag_id` = `NewsTag`.`id`) 001
15SELECT 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`) = '03' AND YEAR(`NewsPost`.`post_date`) = '2017' AND `NewsPost`.`news_status_id` = 4 AND `NewsPost`.`post_date` <= '2017-03-26 09:04:26' GROUP BY YEAR(`NewsPost`.`post_date`), MONTH(`NewsPost`.`post_date`), DAYOFMONTH(`NewsPost`.`post_date`) ORDER BY `NewsPost`.`post_date` DESC 007
16SELECT `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
17SELECT 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-03-26 09:04:26' GROUP BY WEEKOFYEAR(`NewsPost`.`post_date`) , YEAR( `NewsPost`.`post_date` ) ORDER BY `NewsPost`.`post_date` DESC 22022046