- I personally would prefer it went further, because I do not believe the way to welcome new countries into the European Union - whether it is in the MEDIA II programme or any other programme - is to say that: ’you can come in as long as you speak one of the languages we are using’.
- Personligen skulle jag föredra att det gick längre än så eftersom jag inte tror att det är rätt sätt att välkomna nya länder till Europeiska unionen på - vare sig det är i Media II-programmet eller något annat program - att säga: ”du kan få vara med om du pratar ett av de språk som vi använder”.
- I hope that as we move towards the Danish Presidency later this year and the historic decisions on enlargement, we will see a responsible, united and purposeful Western Europe welcoming these new democracies into the democratic fold.
- Jag hoppas att vi, när vi närmar oss det danska ordförandeskapet senare i år och de historiska besluten om utvidgning, kommer att få se ett ansvarsfullt, enat och målmedvetet Västeuropa som välkomnar dessa nya demokratier till det demokratiska fadershuset.
- I am pleased to stress, because it is important, that we must make absolutely certain that we do everything to welcome new countries into the European Union through the MEDIA II programme, which is just one example, to make certain that they not only respect their minority cultures, languages and religions but that they do everything to encourage them, because a Europe that is built on a background of successful cultures and respect for other people’s cultures and minority languages will be a more prosperous and successful one in the future.
- Jag är glad att kunna understryka, eftersom det är viktigt, att vi måste vara absolut säkra på att vi gör allt för att välkomna nya länder till Europeiska unionen genom Media II-programmet, vilket bara är ett exempel, att se till att de inte bara respekterar sina minoritetsgrupper utan att de gör allt för att uppmuntra dem. Ett Europa som är byggt på en historia av framgångsrika kulturer och respekt för andra människors kulturer och minoritetsspråk kommer att vara ännu mer blomstrande och framgångsrikt i framtiden.
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 = 46775 AND
t21.lemma_id = 35818 AND
t22.lemma_id = 31946),
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;
;