- Firstly, we want to see outstanding items resolved and we encourage the Commission and the Dutch presidency to focus on the item of the legal basis in particular.
- För det första vill vi se ogjorda uppgifter lösta och vi uppmuntrar kommissionen och det holländska ordförandeskapet att i synnerhet inrikta sig på frågan om rättslig grund.
- I noted very clearly and welcomed very much that the Dutch presidency said it would draw its conclusions and will produce a report.
- Jag lade väldigt noga märke till, och välkomnade i hög grad, att det holländska ordförandeskapet sade att det avsåg att dra sina slutsatser och lägga fram en rapport.
- The Dutch presidency, to its credit, clearly acknowledges and understands that it is a new Eurocontrol of which we speak and which is the subject of discussion by the Member States.
- Det holländska ordförandeskapet bekräftar klart och tydligt och förstår, vilket hedrar det, att det är ett nytt Eurocontrol vi talar om och som är föremål för diskussioner i medlemsstaterna.
- Madam President, I just wish to address a word of thanks to both the Dutch presidency and the Commission and add a sentence with a question to each of them to take away with them.
- Jag vill bara med några ord tacka såväl det holländska ordförandeskapet som kommissionen och lägga till en mening, med en fråga, som var och en av dem kan ta med sig härifrån.
- I should like to ask the Dutch presidency to ensure that that report is formally and officially communicated to Parliament so that it can be taken into account in the continuous monitoring of the follow-up.
- Jag vill gärna be det holländska ordförandeskapet säkerställa att denna rapport formellt och officiellt tillställs parlamentet, så att den kan beaktas vid den löpande övervakningen av uppföljningen.
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 = 22718 AND
t12.lemma_id = 49268 AND
t21.lemma_id = 64288 AND
t22.lemma_id = 229),
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;
;