News

Lexis PSL Corporate Crime analysis – Jason Mansell and Polly Dyer review trends in the prosecution of directors
9.2.2016

Reproduced with kind permission of Lexis Nexis

Jason Mansell | Polly Dyer
Download (PDF) >

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 =601 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: Tom Coke-Smyth represents the family of LCpl James Brynin, soldier killed in friendly fire incident
16.03.2016 More >

QEB News: Inquest of Capt. Thomas Clarke - Linda Strudwick and Polly Dyer represent the family of Lynx pilot
15.03.2016 More >

QEB News: Paul Wakerley represents GMC in fitness to practice hearing of anaesthetist blackmail victim
15.03.2016 More >

QEB News: QEB Hollis Whiteman member Ari Alibhai speaks to law enforcers on internet protocol TV services
10.03.2016 More >

QEB News: BBC Radio 4’s Law in Action: Eleanor Laws QC comments on Adam Johnson sentence
08.3.2016 More >

QEB News: QEB Hollis Whiteman 2017 Pupillage Application window opens with increase in grant
07.3.2016 More >

QEB News: JUSTICE Working Party on Complex and Lengthy Trials chaired by Sir David Calvert-Smith issues report
4.3.2016 More >

QEB News: Polly Dyer appointed chair of Female Fraud Forum
02.3.2016 More >

QEB News: Stabbing murder trial opens at Central Criminal Court
2.3.2016 More >

QEB News: Philip Evans takes Silk
22.2.2016 More >

QEB News: Zoe Johnson QC represents Dr Mohan at Medical Practitioner Tribunal
18.2.2016 More >

QEB News: Rachna Gokani co-authors new guide Bribery: Law and Practice
18.2.2016 More >

QEB News: QEB Hollis Whiteman members involved in Operation Tabernula trial
12.2.2016 More >

QEB News: Lexis PSL Corporate Crime analysis – Jason Mansell and Polly Dyer review trends in the prosecution of directors
9.2.2016 More >

QEB News: Zoe Johnson QC and Paul Raudnitz on opposing sides in GMC Misconduct Hearing
8.2.2016 More >

QEB News: Nick Corsellis represents surgeon charged with assault
3.2.2016 More >

QEB News: Noel Cryan one of five acquitted of Libor rigging
27.1.2016 More >

QEB News: Nick Corsellis speaks about corruption in tennis following one of the most troublesome weeks in the game’s history
25.1.2016 More >