News:

SELECT TOP(10) ChildSite.SitePageId, ChildSite.PageFolder, ChildSite.PageName, ChildSite.PageType, CFTitle.CustomInformationValue, CFDescript.CustomInformationValue, CFDate.CustomInformationValue, CFCat.CustomInformationValue, CaseDate = CASE WHEN Len(CFDate.CustomInformationValue) < 1 THEN null ELSE CAST(SUBSTRING(CFDate.CustomInformationValue,7,4) + '-' + SUBSTRING(CFDate.CustomInformationValue,4,2) + '-' + SUBSTRING(CFDate.CustomInformationValue,1,2)AS DATETIME) END FROM tblSitePage ParentSite INNER JOIN tblLinkPage LinkPage ON (ParentSite.SitePageId = LinkPage.pageID) INNER JOIN tblSitePage ChildSite ON (LinkPage.linkPageID = ChildSite.SitePageId) INNER JOIN tblCustomFieldInformation CFTitle ON ChildSite.SitePageId = CFTitle.SitePageId AND CFTitle.CustomFieldId = 1 INNER JOIN tblCustomFieldInformation CFDescript ON ChildSite.SitePageId = CFDescript.SitePageId AND CFDescript.CustomFieldId = 2 INNER JOIN tblCustomFieldInformation CFCat ON ChildSite.SitePageId = CFCat.SitePageId AND CFCat.CustomFieldId = 3 INNER JOIN tblCustomFieldInformation CFDate ON ChildSite.SitePageId = CFDate.SitePageId AND CFDate.CustomFieldId = 4 WHERE ParentSite.SitePageId =601 AND ParentSite.PageStatus Like 'Live' AND ParentSite.PageLevel = 4 AND ChildSite.PageStatus Like 'Live' AND ChildSite.PageLevel = 4 ORDER BY CaseDate DESC, ChildSite.PageOrder, hildSite.PageName

QEB News: Philip Evans takes Silk
22.2.2016 More >

QEB News: Zoe Johnson QC represents Dr Mohan at Medical Practitioner Tribunal
18.2.2016 More >

QEB News: Rachna Gokani co-authors new guide Bribery: Law and Practice
18.2.2016 More >

QEB News: QEB Hollis Whiteman members involved in Operation Tabernula trial
12.2.2016 More >

QEB News: Lexis PSL Corporate Crime analysis – Jason Mansell and Polly Dyer review trends in the prosecution of directors
9.2.2016 More >

QEB News: Zoe Johnson QC and Paul Raudnitz on opposing sides in GMC Misconduct Hearing
8.2.2016 More >

QEB News: Nick Corsellis represents surgeon charged with assault
3.2.2016 More >

QEB News: Noel Cryan one of five acquitted of Libor rigging
27.1.2016 More >

QEB News: Nick Corsellis speaks about corruption in tennis following one of the most troublesome weeks in the game’s history
25.1.2016 More >

QEB News: Tim Naylor and Philip Evans represent the BHA in the case of Andrew Findlay and other
22.1.2016 More >