News
Can't connect to MySQL server on 'database.ncl.ac.uk' (4)Can't connect to MySQL server on 'database.ncl.ac.uk' (4)
SELECT DISTINCT i.staffbox,i.body,i.keywords,i.myprofiles,f.username,f.news_home,f.news_item,f.title AS accountname,i.title,i.title AS name,
i.url_id AS id,i.id AS auto_id,i.description,i.subtitle,i.venue,i.plasma
,i.status,i.thumbnail_filename,i.thumbnail_width,i.thumbnail_height,i.image_width,i.image_height,i.image_filename
,i.resized_filename,f.thumbnail_height AS resized_height,f.thumbnail_width AS resized_width
,DATE_FORMAT(i.publish_from,'%H:%i') AS time
,DATE_FORMAT(i.updated,'%H:%i') AS updatedtime
,i.event_from,DATE_FORMAT(i.event_from,'%H:%i') AS eventtime
,i.event_to,DATE_FORMAT(i.event_to,'%H:%i') AS eventtotime
,DATE_FORMAT(i.publish_from,'%D %M %Y') AS date
,DATE_FORMAT(i.updated,'%D %M %Y') AS updateddate
,DATE_FORMAT(i.event_from,'%D %M %Y') AS eventdate
,DATE_FORMAT(i.event_from,'%D %M %Y') AS eventfromdate
,DATE_FORMAT(i.event_from,'%H:%i') AS eventfromtime
,DATE_FORMAT(i.event_to,'%D %M %Y') AS eventtodate,
UNIX_TIMESTAMP(publish_from) AS updated,
IF(i.event_from>0,i.event_from,i.publish_from) AS orderdate,
SUBSTRING_INDEX(LTRIM(i.body),'
',2) AS firstpara
FROM news_global.item AS i
LEFT JOIN news_global.feed AS f ON f.username = i.feed_username LEFT JOIN news_global.item_theme AS thl ON thl.item_id = i.id LEFT JOIN news_global.theme AS th ON th.id = thl.theme_id WHERE i.feed_username IN ('biomedicine','pressreleases') AND
i.publish_from <= NOW() AND
( i.publish_to >= NOW() || i.publish_to = '0000-00-00 00:00:00' ) AND
i.publish_from != '0000-00-00 00:00:00' AND
th.title IN ('Faculty of Medical Sciences') AND
GREATEST(i.publish_from,i.publish_from) >= '2011-05-09 22:06:40' AND i.status = 'show' ORDER BY publish_from DESC LIMIT 5
Can't connect to MySQL server on 'database.ncl.ac.uk' (4)
