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 Rusha & others (2008)

David Jeremy QC and Julian Evans prosecuted in the ‘Tonbridge Robbery’ case, Britain’s largest ever cash robbery in which £53m was stolen from Securitas in Tonbridge.

Eight defendants were charged with conspiracy to rob.

The unique feature of this trial was that during the prosecution case charges were dropped against one of the defendants who then provided prosecution evidence leading to the conviction of the others.

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