SELECT distinct(d.iddocumento), d.* from documenti d JOIN destinazionidocumenti dd ON (d.iddocumento = dd.iddocumento) WHERE d.idtipodocumento = 1 AND d.idlanguage = 7 AND d.status = 3 ORDER BY d.datains DESC, d.rilevanza DESC LIMIT 6 SELECT distinct(d.iddocumento), d.* from documenti d JOIN destinazionidocumenti dd ON (d.iddocumento = dd.iddocumento) WHERE d.idtipodocumento = 1 AND d.idlanguage = 7 AND d.status = 3 AND dd.iddocumento not in (12312201) ORDER BY d.datains DESC, d.rilevanza DESC LIMIT 6 CHINA REVERSES DEATH PENALTY IN DRUNK DRIVING CASE

CHINA REVERSES DEATH PENALTY IN DRUNK DRIVING CASE

15 September 2009 :

the Sichuan Provincial Higher People's Appeals Court commuted the death penalty in a drunk driving case to life imprisonment, China Central Television reported. Sun Weiming, 30, was sentenced to death after being convicted for a fatal accident in December 2008 that killed four people and injured another in southwestern Chengdu.
 

other news