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 Cockram & others; R v Wenham & others (2002)

The Millennium Dome robbery, which, if successful, would have been the most valuable (and spectacular) robbery in British criminal history.

From the Guardian
Dome robbery: how it happened

A timetable of events in the attempt to steal £200m worth of diamonds from the Millennium Dome
Monday 18 February 2002 15.09 GMT

December 31 1999
The Millennium Star plays a key role in the Dome's opening celebration on New Year's Eve - at 11.50pm laser beams are directed at the gem which fill the dome with sparkling shafts of light.

September 1 2000
One of the suspects visits the dome with a video camera but is himself filmed by undercover police.

September 7 2000
Dome chairman David James is told by police that there could be a raid and that there are certain "risk days" when it may happen. Undercover officers move in.

November 6 2000
The diamonds are replaced with a set of fake crystal dummies. The dome is put on "a high state of alert" and 90 armed officers are moved into and around the building. The raid was to have taken place on this day but the speedboat skipper who was to have helped the gang escape across the River Thames said the tide was not right and it was postponed for 24 hours.

November 7 2000
The gang tried to steal the diamonds by crashing into the Dome in a bulldozer. In scenes reminiscent of a James Bond film the raiders don gas masks and set off smoke bombs before attempting to remove the diamonds with sledgehammers and a nail gun. Media reports say the dome has at last lived up to its self-styled billing for providing "one amazing day".

November 8 2000
Eight men from southeast London, Kent and East Sussex are charged in connection with the botched raid.

November 13 2000
A ninth man is arrested and charged.

May 27 2001
A further suspect, a 46-year-old London man, is arrested in Spain.

November 8 2001
Six men go on trial at the Old Bailey for the "robbery of the Millennium".

December 4 2001
The jurors at the trial are taken to visit the now empty Dome.

December 10 2001
One of the defendants, Wayne Taylor, 35, of Tonbridge, Kent, is freed after being found not guilty of charges of conspiracy to rob and conspiracy to steal on the direction of Judge Michael Coombe.

February 18 2002
The jury of seven women and five men reach majority verdicts against the defendants after deliberating for nearly seven court days. Four of the men are found guilty of plotting to carry out the robbery.

Raymond Betson and William Cockram are jailed for 18 years each. Robert Adams and Aldo Ciarrocchi get 15 years each. Kevin Meredith, who is cleared of conspiracy to rob but convicted of conspiracy to steal, is jailed for five years.

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