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 =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: 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 >

QEB News: Pakistan Cricketers match fixing allegations
11.10.2011 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:

http://www.bbc.co.uk/news/uk-15311607

http://www.bbc.co.uk/news/uk-15334013

Notable cases:

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

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

Manu Tuilagi banned (2011)
Leicester rugby centre banned

Articles: