Joanne Dennehy: Serial Killer
In 2013, when Detective Superintendent Martin Brunning was called to the scene of a man's body, in a black sequined dress, dumped in a ditch, he was in a race against time to catch one of the UK's most notorious female serial killers.
6.2 /10
Andrew Scanlan: Murder in the Woods
Detective Superintendent Mark Birch had to escalate a missing person case to a murder investigation just before Christmas in 2006. As the investigation unfolded a picture emerged of a brutal crime committed brothers on their brother.
6.3 /10
Steve Wright: The Suffolk Strangler
In the ten days before Christmas 2006 Detective Chief Superintendent Stewart Gull was faced with every detective's worst nightmare, as the bodies of five young murdered women are found in the Suffolk countryside
6.3 /10
John Sweeney: The Canal Killer
When Detective Chief Inspector Howard Groves took a phone call from the Dutch Cold Case Team in Rotterdam he began investigating two women's bodies found in canals in UK and Holland eleven years apart.
6.2 /10
All Filters
页面:/episodes-1/detectives-my-killer-case-223476.html | 耗时:0.1512 s | 内存:2.24 MB | 查询:12 | 缓存读取:10 写入:8 | 加载文件:24
SELECT * FROM db_content WHERE id=223476 LIMIT 0,1;
SELECT * FROM db_content_qingjie WHERE contentid=223476 group by ji;
SELECT * FROM db_content_qingjie WHERE contentid=223476 and ji='1' order by jishu asc;
SELECT * FROM db_category WHERE 1 and id=1075 LIMIT 0,1;
SELECT id FROM db_content WHERE 1 and catid=1075 and leixing=2 ORDER BY id DESC limit 5,1;
SELECT pingfen,url,title,fengmiantu FROM db_content WHERE 1 and catid=1075 and leixing=2 AND id>119985 LIMIT 5 ;
SELECT id FROM db_content WHERE 1 and catid=1075 and leixing=1 ORDER BY id DESC limit 10,1;
SELECT pingfen,url,title,fengmiantu FROM db_content WHERE 1 and catid=1075 and leixing=1 AND id>154323 LIMIT 10 ;
SELECT id FROM db_content WHERE 1 and catid=1075 and leixing=2 ORDER BY id DESC limit 10,1;
SELECT pingfen,url,title,fengmiantu FROM db_content WHERE 1 and catid=1075 and leixing=2 AND id>158029 LIMIT 10 ;
SELECT id FROM db_content WHERE 1 and catid=1075 ORDER BY id DESC limit 6,1;
SELECT url,title,images,leixing,description FROM db_content WHERE 1 and catid=1075 AND id>178864 LIMIT 6 ;