- I did not welcome them with a hug and an affectionate pat on the shoulder as President Sarkozy used to.
- Jag välkomnade dem inte med en kram och en tillgiven klapp på axeln som president Nicolas Sarkozy brukade göra.
- With those remarks, I welcome this report very much and I congratulate the rapporteur on her presentation.
- Med dessa kommentarer välkomnar jag det här betänkandet och jag gratulerar föredraganden till hennes presentation.
- In addition, all the candidates gave their commitment to a variety of forms of democratic accountability, which is to be welcomed with open arms.
- Dessutom gav alla kandidater utfästelser om en mängd olika former av demokratisk ansvarighet, vilket måste välkomnas med öppna armar.
- The Committee on Legal Affairs heard your representatives, and we have now received the communication from the Commission, the substance of which we welcome along with that of the decision by the Court of Justice.
- Utskottet för rättsliga frågor har hört era företrädare, och nu har vi tagit emot kommissionens meddelande, vars innehåll vi välkomnar tillsammans med EG-domstolens domslut.
- The Parliament has already shown more ambition than the Member States in relation to a reduction in carbon emissions, and today’s resolution is to be welcomed with calls for real financing, calls for strong targets in the high end from 25-40% in line with the science, and the insistence on a legally binding agreement.
- Parlamentet har redan visat prov på mer ambition än medlemsstaterna när det gäller minskningen av koldioxidutsläpp, och denna resolution bör välkomnas med att man begär verklig finansiering, begär fasta, ambitiösa mål på 25-40 procent i linje med vetenskapen och insisterar på ett rättsligt bindande avtal.
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 = 42374 AND
t12.lemma_id = 12425 AND
t21.lemma_id = 35818 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;
;