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 =277 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: Julian Evans appointed as first junior Treasury counsel
3.12.2015 More >

QEB News: Crispin Aylett QC and Julian Evans secure conviction of Daniel Burgess and 4 others in the killing of Marcus Innocent
5.9.2014 More >

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

QEB News: Victoria Station Murder
16.5.2011 More >

QEB News: Victoria Station Murder
28.1.2011 More >

Julian Evans: Notable case

R v Morris (2004)

Julian Evans defended a Finance Director of a non-departmental government organisation, prosecuted by the Serious Fraud Office and charged with offences of theft and false accounting over a four-year period.

Notable cases:

R v Akra & Others (Victoria Station Murder Trial 1) (2011)
The Victoria Station murder

R v Dizaei (2010)
Prosecution of senior serving police officer

R v Cameron & others (2009)
Multi-handed shooting case.

R v Rusha & others (2008)
The 'Tonbridge Robbery'

R v Morris & Mead (2006)
Multimillion pound advance-fee fraud

GMC v Dr Sinha (2006)
Series of indecent assaults

R v Morris (2004)
Finance Director charged with theft and false accounting

R v Sarasia & others (2003)
Large-scale carousel fraud

R v Cockram & others; R v Wenham & others (2002)
The Millennium Dome robbery

R v Manuelyan & Manuelyan (2001)
Fruitarian parents starved baby to death