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 (12318258) ORDER BY d.datains DESC, d.rilevanza DESC LIMIT 6 FIVE SENTENCED TO DEATH IN SOUTHWEST CHINA GANG TRIAL

FIVE SENTENCED TO DEATH IN SOUTHWEST CHINA GANG TRIAL

09 December 2009 :

five people were sentenced to death after being convicted of drug trafficking, racketeering, fraud and selling counterfeit currency in southwest China. The Intermediate Court of Kunming, capital of Yunnan Province, sentenced Jiang Jiatian, gang leader, his mistress Yang Jufen, Yang's father Yang Guoying, and Xie Mingxiang, to death. Li Wencai, a woman who played a lead role in the gang's drug trafficking, was sentenced to death with a two-year reprieve.
 

other news