Lancashire seamer Tom Bailey claims match-figures of 10-98, leaving the Red Rose county a target of 221 to beat Middlesex.
England paceman Toby Roland-Jones hits 53 to rescue Middlesex with the bat against Lancashire as the bowlers dominate.
Essex become county champions for the first time since 1992 as closest challengers Lancashire lose to Somerset at Taunton.
Lancashire retain a miniscule hope of winning the Championship title after batting through the third day against Somerset.
Audio & Video
England bowling coach Ottis Gibson says seamer James Anderson wants to continue playing cricket for "as long as he can".
Analysis and opinion from the BBC's cricket correspondent.
Follow a summer of cricket on the BBC
BBC Sport brings you live radio commentary plus online video clips and highlights from England's summer of cricket.
Cricket alerts, newsletters and social media
Get latest scores and headlines sent straight to your phone, sign-up to our newsletter and learn where to find us on online.
How to get into Cricket
How to get into cricket - physical exertion with a chess-like element in matches which range from half an hour to five days.