- Will it be achieved in 24 hours?
- Kommer vi att uppnå det inom 24 timmar?
- I maintain that what we have achieved in this field of communicable diseases represents a good illustration of the Commission working across the different areas of responsibility.
- Jag vidhåller att det vi har uppnått inom området för överförbara sjukdomar representerar ett belysande exempel på hur kommissionen arbetar tvärs över sina olika ansvarsområden.
- It is pointless to remind you that we already know that these goals will not be achieved in the timeframe that we had set ourselves and that they are about to be added to the list of promises broken by the rich nations.
- Jag behöver inte påminna er om att vi redan nu vet att dessa mål inte kommer att uppnås inom den tidsram vi hade satt upp och att de är på god väg att hamna på listan över löften som brutits av de rika nationerna.
- In order to exploit fully the potential for growth of the regions and to achieve economic, social and territorial cohesion in the European Union, it is essential for us to focus on the goal of competitiveness, as well as on cohesion.
- För att frigöra hela tillväxtpotentialen i regionerna och uppnå ekonomisk, social och territoriell sammanhållning inom EU måste vi utöver sammanhållningen även betona konkurrenskraftsmålet.
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 = 5196 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 35250 AND
t22.lemma_id = 15813),
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;
;