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 =1947 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: Barclays Libor
04.07.2016 More >

QEB News: New Tenants
7.2.2013 More >

Tom Doble: Notable case

R v PBW (2015)

Defended former solicitor charged with offences of fraud and forgery.

Notable cases:

R v RR (2016)
Acting for a Barclays derivatives trader charged with alleged LIBOR manipulation.

R v M Ltd and MG (2016)
Charges of corporate manslaughter and health and safety offences.

Re SG (2016)
Acted for an interested party in confiscation proceedings, in which over £4 million was recovered.

DPS v PC G (2016)
Proceedings before the police disciplinary tribunal and police appeals tribunal concerning allegations of dishonesty.

R v KD (2015)
Defendant charged with carrying out unauthorised works to a grade II* listed building.

R v F ltd (2015)
Acted for company prosecuted by a local authority for offences arising from streetworks in breach of the legislative scheme.

R v P Ltd (2015)
Company charged with offences under the Health and Safety at Work Act 1974.

R v PBW (2015)
Defended former solicitor charged with offences of fraud and forgery.

R v DP and LP (2015)
Conspiracy to handle 114 stolen vehicles.

NMC v GMcS (2014)
Defended nurse in misconduct proceedings concerning allegations of dishonesty.

R v MP (Innospec) (2014)
Executive charged with corruption of foreign government officials.

Re Lance-Bombadier RJ (2014)
Inquest proceedings

DPS v Sgt B and others (2013)
Proceedings before police disciplinary tribunal regarding improper text messages.

R v CF (2013)
Senior solicitor acquitted of domestic common assault