- The Commission has already pointed out the importance of that in view of the future enlargement of the European Union, in the opinion it presented to the last Intergovernmental Conference.
- Jag tycker att detta försök är en viktig del av ett förslagspaket, vars slutmål är att förbättra medborgarnas delaktighet i valet av ledamöter till Europaparlamentet, och dess betydelse inför den framtida utvidgningen av Europeiska unionen, har redan signalerats av kommissionen i sitt yttrande inför den senaste regeringskonferensen.
- For cohesion policy to be effective, we must reckon with the consequences of future enlargement, especially in the medium term as regards Turkey and Croatia, which already have official status as accession countries and with which the EU has already begun accession negotiations.
- För att sammanhållningspolitiken ska vara effektiv måste vi räkna med konsekvenserna av framtida utvidgningar, särskilt på medellång sikt som i fråga om Turkiet och Kroatien, som redan har officiell status som anslutningsländer och som EU redan har inlett anslutningsförhandlingar med.
- there have been 10 years of debates and this will make us much more demanding, not only with ourselves, but also for future enlargements, in requiring loyalty, cooperation and the assumption of responsibility from all those who sign up to the new rules that will be in operation from the time the Treaty of Lisbon enters into force.
- Vi har diskuterat i 10 år, och detta kommer att göra oss mycket mer krävande, inte bara internt utan också när det gäller framtida utvidgningar.
- Mr President, the safety of existing nuclear plants and those under construction, as accession approaches, is a primordial objective, as has been underlined on many occasions by Parliament, by the Commission with regard to the Agenda 2000 package, and by the Council in the context of nuclear safety in connection with the future enlargement of the European Union.
- I samband med anslutningen utgör säkerheten för befintliga kärnkraftverk och för de kärnkraftverk som är under uppförande en huvudfråga för kommissionen i paketet som hör till Agenda 2000, och för rådet när det gäller kärnsäkerheten i samband med den framtida utvidgningen av vår union, något som för övrigt flera gånger understrukits av parlamentet.
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 = 13319 AND
t12.lemma_id = 47826 AND
t21.lemma_id = 17372 AND
t22.lemma_id = 17639),
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;
;