LIVE
 
ASTeC on Twitter  ASTeC on Twitter

News



from items


Items 1 to 5 of 198 articles



News from our partners... |




|
WITH ListEntries AS (SELECT ROW_NUMBER() OVER (ORDER BY WebPageMetadata.fileAmendedDate DESC) AS row, websMasterDetails.wbItemId, WebPageMetadata.fileTitle, WebPageMetadata.fileSummary, WebPageMetadata.fileDescription, websMasterDetails.wbItemFullPath, websMasterDetails.wbItemFileName, WebPageMetadata.fileAmendedDate, REPLACE(REPLACE(Web_News_Image_Types.imgPath, '\Square', ''), '\', '/') + Web_Document_Links.linkTarget AS NewsImage FROM Web_News_Image_Types INNER JOIN Web_Document_Links ON Web_News_Image_Types.imgType = Web_Document_Links.linkImageType RIGHT OUTER JOIN WebPageMetadata INNER JOIN websMasterDetails ON WebPageMetadata.fileID = websMasterDetails.wbItemId LEFT OUTER JOIN Web_Publishing_Embargo ON websMasterDetails.wbItemId = Web_Publishing_Embargo.fileId ON Web_Document_Links.fileID = WebPageMetadata.fileID WHERE (websMasterDetails.wbWebId = 16) AND (WebPageMetadata.fileIsNews = 'Y') AND (Web_Document_Links.linkType = 'nw_image') AND (WebPageMetadata.fileStatus IN (0,2)) AND (Web_Publishing_Embargo.fileId IS NULL) ) SELECT * FROM ListEntries WHERE row > 0 and row <= 5
Back to Top

© 2013 Science and Technology Facilities Council - All Rights Reserved.