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 =275 AND ParentSite.PageStatus Like 'Live' AND ParentSite.PageLevel = 4 AND ChildSite.PageStatus Like 'Live' AND ChildSite.PageLevel = 4 ORDER BY CaseDate DESC, ChildSite.PageOrder, ChildSite.PageName

QEB News: Philip Evans and Philip Stott open Hatton Garden trial
24.11.2015 More >

QEB News: QEB Hollis Whiteman members in Hatton Garden trial
20.11.2015 More >

QEB News: Philip Evans appointed to EPCR Disciplinary Panel
21.10.2015 More >

QEB News: Philip Evans and Tim Naylor represent the BHA in Anthony Knott’s appeal against ban
24.4.2015 More >

QEB News: Narrative conclusion in inquest into ‘friendly fire’ deaths of Captain Sawyer and Corporal Winter
12.3.2015 More >

QEB News: Philip Evans defends man acquitted of attempting to murder his grandfather
22.12.2014 More >

QEB News: Racehorse owner Anthony Knott disqualified for 3 years
19.12.2014 More >

QEB News: British Horseracing Authority announces date for McGrath corruption hearing - Phil Evans and Tim Naylor to represent BHA
19.9.2014 More >

QEB News: Ranked as Leader in Crime by Chambers UK
28.7.2014 More >

QEB News: RFU Judicial Panel Chair
12.4.2013 More >

Philip Evans: news

Pakistan Cricketers match fixing allegations

Philip Evans defends Pakistani cricketer Mohammed Asif at Southwark Crown court. Mr Asif along with Salaman Butt are standing trial with regards to allegations of 'spot fixing' following an undercover investigation by the News of the World. The matters alleged took place during the test match, against England at Lords in August 2010.


 For further details please follow the links below:

Notable cases:

Philip Evans and Tim Naylor represent the BHA in Anthony Knott’s appeal against ban (2015)
QEB Hollis Whiteman barristers Evans and Naylor appeared on behalf of the British Horseracing Authority opposing the appeal

Inquest into the deaths of Captain T Sawyer & Corporal D Winter (2015)
Article 2 inquest into friendly fire incident in Afghanistan.

R v Sibley (2014)
Philip Evans defends man acquitted of attempting to murder his grandfathe

R v Dunne (2013)
Hoaxer jailed for claiming he had kidnapped EastEnder actress

Ali Dizaei appeal (2013)
Philip Evans successful as Ali Dizaei's Appeal against conviction rejected

R v Hutchinson-Foster (2013)
The gun-man who triggered the London Riots

R v Oleksiak (2012)
World renowned artist acquitted of s.18 GBH

X v UK Athletics Selection Panel (2012)
Appeal to the UK Athletics appeal panel

R v Ali Dizaei (2012)
Corrupt Police officer jailed

Pakistan Cricketers match fixing allegations (2011)
Philip Evans defends Pakistani cricketer at Southwark Crown Court