- Each and every city could make its own programme, because what the Covenant of Mayors has done is make an obligation to reduce CO2 by more than 20%.
- Varenda stad kan skapa sitt eget program, eftersom anslutningen till borgmästaravtalet innebär en skyldighet att minska koldioxidutsläppen med mer än 20 procent.
- For example, with regard to rice, he knows that the subsidy price has been reduced by 60%, that internal production has stabilised and that consumption has increased by 20%.
- När det gäller risproduktionen till exempel, vet ni att interventionspriset har minskat med 60 procent, att den interna produktionen har stabiliserats och att konsumtionen har ökat med 20 procent.
- The widespread use of mammography could reduce the number of deaths by as much as 35%, providing, of course, that the tests are carried out regularly and are readily accessible to all.
- Ett omfattande användande av mammografi skulle kunna minska antalet dödsfall med så mycket som 35 procent, naturligtvis förutsatt att undersökningen utförs regelbundet och finns lättillgänglig för alla.
- Since 97% of the Lloyd’s Names have accepted the renewal plan of 1996 and they have been able to reduce their liabilities by significant amounts, this issue has by and large been covered fully.
- Eftersom 97 procent av Lloyd’s ”namn” har accepterat förnyelseplanen från 1996 och kunnat minska sina åtaganden med avsevärda belopp har detta ärende efterhand i stort sett blivit heltäckande behandlat.
- At the same time, the financial burden for shipowners - from EUR 25 to 35 per tonne of fish caught - has increased, while the financial burden for the Community has been reduced by the same amount.
- Samtidigt har den finansiella bördan för fartygsägare ökat från 25 euro till 35 euro per ton fångad fisk, medan den finansiella bördan för gemenskapen har minskats med samma belopp.
- Even though you yourself, Mr Dimas, asked for emissions to be cut by 30% compared with 1990 levels, a poor compromise was reached to reduce them by 20%, and there is no strategy in the transport sector, on alternative energy sources or on technologies for green hydrogen.
- Trots att ni själv, herr Dimas, bad att utsläppen skulle minskas med 30 procent jämfört med 1990 års nivåer så nåddes en klen kompromiss om att minska dem med 20 procent.
show query
SET search_path TO f9miniensv;
WITH
list AS (SELECT
t11.token_id AS t11,
t12.token_id AS t12,
t21.token_id AS t21,
t22.token_id AS t22,
r1.dep_id AS dep1,
r2.dep_id AS dep2
FROM
deprel r1
JOIN depstr s1 ON s1.dep_id = r1.dep_id
JOIN word_align a1 ON a1.wsource = r1.head AND a1.wsource < a1.wtarget
JOIN word_align a2 ON a2.wsource = r1.dependent
JOIN deprel r2 ON r2.head = a1.wtarget AND r2.dependent = a2.wtarget
JOIN depstr s2 ON s2.dep_id = r2.dep_id
JOIN token t11 ON t11.token_id = r1.head
JOIN token t21 ON t21.token_id = r2.head
JOIN token t12 ON t12.token_id = r1.dependent
JOIN token t22 ON t22.token_id = r2.dependent
WHERE
s1.val = 'prep' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'ADP' AND
t22.ctag = 'ADP' AND
t11.lemma_id = 52274 AND
t12.lemma_id = 6140 AND
t21.lemma_id = 62146 AND
t22.lemma_id = 57357),
stats AS (SELECT
sentence_id,
count(DISTINCT token_id) AS c,
count(*) AS c_aligned,
count(DISTINCT wtarget) AS c_target
FROM
token
LEFT JOIN word_align ON wsource = token_id
WHERE
sentence_id IN (
SELECT sentence_id
FROM
list
JOIN token ON token_id IN(t11, t21)
)
GROUP BY sentence_id),
numbered AS (SELECT row_number() OVER () AS i, *
FROM
list),
sentences AS (SELECT *, .2 * (1 / (1 + exp(max(c) OVER (PARTITION BY i) - min(c) OVER (PARTITION BY i)))) +
.8 * (1 / log(avg(c) OVER (PARTITION BY i))) AS w
FROM
(
SELECT i, 1 AS n, sentence_id, ARRAY[t11,t12] AS tokens
FROM
numbered
JOIN token ON token_id = t11
UNION SELECT i, 2 AS n, sentence_id, ARRAY[t21,t22] AS tokens
FROM
numbered
JOIN token ON token_id = t21
) x
JOIN stats USING (sentence_id)
ORDER BY i, n)
SELECT
i,
n,
w,
c,
c_aligned,
c_target,
sentence_id,
string_agg(CASE WHEN lpad THEN ' ' ELSE '' END || '<span class="token' ||
CASE WHEN ARRAY[token_id] <@ tokens THEN ' hl' ELSE '' END || '">' || val || '</span>',
'' ORDER BY token_id ASC) AS s
FROM
sentences
JOIN token USING (sentence_id)
JOIN typestr USING (type_id)
GROUP BY i, n, w, c, c_aligned, c_target, sentence_id
ORDER BY w DESC, i, n;
;