- 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.
- The recent direction which this debate has taken is profoundly depressing for those of us who want to see a European Union which is capable of having a positive impact on the development not just of the present 15 Member States but also on the new democracies in Central and Eastern Europe which have applied for membership of our Union.
- Den senaste riktning som denna debatt har tagit är djupt nedslående för de av oss som vill se en europeisk union som kan skapa positiva effekter för utvecklingen i de nya demokratier i Central- och Östeuropa som har ansökt om medlemskap, och inte bara för utvecklingen i de nuvarande 15 medlemsstaterna.
- How, above all, can we convince our citizens that the Community is justified in showing solidarity towards the new democracies of Eastern Europe, which face an overwhelming task in developing their infrastructure, environment, production sector and human resources?
- Vi frågar oss hur man skall kunna överbrygga de svårigheter som de olika medlemsstaterna möter, när det gäller att gemensamt finansiera projekt i dessa kärva tider som för nästa år innebär en nedskärning med 500 miljoner ecu enbart när det gäller betalningskrediter, men framför allt hur man skall kunna övertyga gemenskapens medborgare om det rätta i gemenskapens solidaritet med de nya demokratierna i östra Europa, som står inför så massiva behov när det gäller utvecklingen av infrastrukturer, miljö, produktionsresurser och mänskliga resurser.
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 = 54559 AND
t12.lemma_id = 15618 AND
t21.lemma_id = 18052 AND
t22.lemma_id = 53462),
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;
;