- You have Syria, Ashraf, you have the Gualtieri report, the Albertini report, you have the problem of Europe as a global actor in the United Nations.
- Vi har Syrien, Ashraf, vi har Gualtieribetänkandet, Albertinibetänkandet och vi har problemen med EU som global aktör i FN.
- I think it is also important to point to the fact that, during this Presidency and while we are standing here, the European Union is, for the first time, a leading global actor in one of the most important international issues mankind is facing.
- Jag anser också att det är viktigt att peka på att under detta ordförandeskap och medan vi står här är EU för första gången en ledande global aktör i en av de viktigaste internationella frågor som mänskligheten står inför.
- I endorsed this document because it is aimed at ensuring that national defence systems are consistent with EU defence systems, as well as coordinating strategies with the most important global actors, such as the United States, Russia, China, Turkey and the Arab countries.
- Jag stödde detta dokument för att det syftar till att garantera att nationella försvarssystem är förenliga med EU:s försvarssystem samt att samordna strategier med de viktigaste globala aktörerna, som Förenta staterna, Ryssland, Kina, Turkiet och arabländerna.
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 = 'amod' AND
s2.val = 'AT' AND
t11.ctag = 'NOUN' AND
t21.ctag = 'NOUN' AND
t12.ctag = 'ADJ' AND
t22.ctag = 'ADJ' AND
t11.lemma_id = 38986 AND
t12.lemma_id = 40171 AND
t21.lemma_id = 33204 AND
t22.lemma_id = 40171),
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;
;