- We also agree with the Council that we should build bridges with developing countries, but building bridges with these countries means two things:
- Man att bygga broar till utvecklingsländerna betyder två saker:
- You are in fact building a bridge, which is why I would like to say a few words on the stage reached in the public consultations on the future of European cohesion policy.
- Ni bygger faktiskt en bro och därför vill jag säga några ord om var vi befinner oss i det offentliga samrådet om framtiden för EU:s sammanhållningspolitik.
- Mr President, ladies and gentlemen, I very much welcome - personally, as well as in my function as the rapporteur for multiannual financial planning - the report by the chairman of our committee, Mr Lamassoure, as it builds the necessary bridges, including in terms of legal certainty, that we need until we have agreed on the necessary adaptation of the interinstitutional agreement and on further technical procedures that we need to clear up under treaty law.
- Jag välkomnar hjärtligt - både personligen och som föredragande för den fleråriga budgetramen - betänkandet av vår utskottsordförande Alain Lamassoure, eftersom det bygger de broar, bland annat i fråga om rättssäkerhet, som vi behöver tills vi har enats om den nödvändiga anpassningen av den interinstitutionella överenskommelsen och om de ytterligare förfaranden av teknisk karaktär som vi måste reda ut enligt traktaträtten.
- It is against this background that it is essential to nurture the idea that it is possible, in the face of all these challenges, to achieve consensus, to establish dialogue and to build bridges, and to do so without dogmatism or prejudice, while making available to everyone, rich or poor, large or small, new or old, the option of helping us to define relevant parameters and objectives for Europe.
- Mot denna bakgrund är det mycket viktigt att hålla liv i idén att det trots alla dessa utmaningar är möjligt att uppnå samförstånd, etablera en dialog och bygga broar, att göra detta utan dogmer eller fördomar och samtidigt göra det möjligt för alla - rika som fattiga, stora som små, nya som gamla - att hjälpa till med att utforma relevanta parametrar och mål för EU.
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 = 'dobj' AND
s2.val = 'OO' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'NOUN' AND
t22.ctag = 'NOUN' AND
t11.lemma_id = 63682 AND
t12.lemma_id = 41085 AND
t21.lemma_id = 19672 AND
t22.lemma_id = 51086),
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;
;