SELECT * FROM (SELECT TOP 10 * FROM ( SELECT DISTINCT Top 10 a.ArticleID, IsNULL(a.DatePublished, '9999-12-31T23:59:59') as DatePublished FROM Newsroom.dbo.Article a LEFT JOIN Newsroom.dbo.ArticleCategory ac on (a.ArticleID = ac.ArticleID) WHERE ToPublic = 1 AND a.DatePublished IS NOT NULL AND a.DatePublished <= '2015-07-02T04:54:11' ORDER BY DatePublished DESC) as FirstResult ORDER BY DatePublished ASC) as SecondResult ORDER BY DatePublished DESC Waikato Management School - Newsroom
University of Waikato Waikato Management School MyWeb

News

Latest Publications

Other Publications

University News