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: Families of servicemen killed in friendly fire incident call for inquiry
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 >

QEB News: R v Dunne
11.4.2013 More >

QEB News: Appeal of Ali Dizaei
14.2.2013 More >

QEB News: R v Hutchinson-Foster
31.1.2013 More >

QEB News: R v Ali Dizaei
13.2.2012 More >

Philip Evans: Notable case

Pakistan Cricketers match fixing allegations (2011)

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:

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

RFU Panel Hearing: Marler & James (2011)
Joe Marler & Will James in RFU Panel hearing