select sum(numeroesecuzioni) as numero_esecuzioni_anno from stati where anno =2026 and idlanguage= 7 select sum(numeroesecuzioni) as numero_esecuzioni_anno from stati where anno >= 2000 and anno <=2026 and idlanguage= 7 SELECT s.idstato, s.idtipocaino, c.idlanguage, c.idcontinente, c.continente, s.descrizione AS stato, t.descrizione AS tipo FROM stati s JOIN tipicaino t ON (s.idtipocaino=t.idtipocaino) JOIN continenti c ON (s.idcontinente=c.idcontinente) WHERE c.idlanguage = 7 AND anno = 2026 ORDER BY idcontinente, statoSELECT s.idstato, s.idtipocaino, c.idlanguage, c.idcontinente, c.continente, s.descrizione AS stato, t.descrizione AS tipo FROM stati s JOIN tipicaino t ON (s.idtipocaino=t.idtipocaino) JOIN continenti c ON (s.idcontinente=c.idcontinente) WHERE c.idlanguage = 7 AND anno = 2025 ORDER BY idcontinente, statoselect anno,count(*) as quanti,stati.idtipocaino from stati where idlanguage=7 group by anno, idtipocaino order by anno,idtipocainoselect count (*) as quanti, stati.idtipocaino from stati where idlanguage=7 and anno=2026 group by idtipocaino order by idtipocainoselect count (*) as quanti, stati.idtipocaino from stati where idlanguage=7 and anno=2025 group by idtipocaino order by idtipocainoSELECT continenti.* FROM continenti WHERE continenti.idlanguage = 7SELECT stati.* FROM stati WHERE stati.idlanguage = 7 AND stati.anno=2026SELECT stati.* FROM stati WHERE stati.idlanguage = 7 AND stati.anno=2025SELECT 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 3 SELECT distinct(d.iddocumento), d.* from documenti d JOIN destinazionidocumenti dd ON (d.iddocumento = dd.iddocumento) WHERE dd.iddestinazione=1 AND d.idtipodocumento = 2 AND d.idlanguage = 7 AND d.status = 3 ORDER BY d.datains DESC, d.rilevanza DESC LIMIT 7 SELECT distinct(d.iddocumento), d.* from documenti d JOIN destinazionidocumenti dd ON (d.iddocumento = dd.iddocumento) WHERE dd.iddestinazione=1 AND d.idtipodocumento = 3 AND d.idlanguage = 7 AND d.status = 3 ORDER BY d.datains DESC, d.rilevanza DESC LIMIT 1

The weekly newsletter - active since March 2001 - is the service that Hands off Cain provides to all its readers interested in knowing the situation and promoting or supporting policy initiatives for the abolition of the death penalty and the moratorium on executions. The newsletter lists the five most important news on the death penalty of the week. To receive it just sign up by signing up here.
The daily newsletter - active since March 2002 - is the service that Hands off Cain provides to all its readers interested in knowing the situation and promoting or supporting policy initiatives for the abolition of the death penalty and the moratorium on executions. The newsletter contains the most important news on the death penalty of the day with photos of the protagonists of the events reported. To receive it just sign up by signing up here.