- They have grown up in a world of division and conflict.
- De har vuxit upp i en värld av splittring och konflikter.
- Most of us grew up in an atmosphere of Euro-optimism.
- De flesta av oss växte fortfarande upp i en euro-optimistisk anda.
- Between 1990 and 2000, research and development expenditure grew at twice the rate in the US compared with Europe.
- Mellan åren 1990 och 2000 växte utgifterna för forskning och utveckling dubbelt så snabbt i Förenta staterna som i Europa.
- May I wish you, on behalf of the European Parliament, all the best in your demanding work for a peaceful, flourishing and democratic Bosnia and Herzegovina where new generations will grow in the spirit of mutual understanding, tolerance and cooperations.
- Låt mig önska er, å Europaparlamentets vägnar, all lycka i ert krävande arbete för att skapa ett fredligt, blomstrande och demokratiskt Bosnien och Hercegovina, där nya generationer kan växa upp i en anda av ömsesidig förståelse, tolerans och samarbete.
- That determination must be translated into specific action, and I call upon the Council presidency to generate the necessary determination for the implementation of this project, so that the 80 million children living in the European Union can grow up in a Europe that welcomes them and is, of course, prepared for a better future.
- Den här beslutsamheten måste snarast konkretiseras, och jag vädjar till rådets ordförande att blåsa liv i den vilja som krävs för att realisera det här projektet, så att de 80 miljoner barn som lever i Europeiska unionen kan växa upp i ett Europa som är vänligt och som självklart är förberett för en bättre framtid.
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 = 22446 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 9405 AND
t22.lemma_id = 26495),
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;
;