- I should also like to congratulate the rapporteur most warmly on her excellent report.
- Samtidigt vill jag hjärtligt lyckönska föredraganden till detta utmärkta betänkande.
- Mr President, I would also like to congratulate the rapporteur on an excellent report.
- Herr ordförande, jag skulle också vilja lyckönska föredraganden till ett utmärkt betänkande.
- This is why we support the Hatzidakis report and I should like to congratulate the rapporteur on its clarity, despite the technical nature of the subject.
- Därför stöder vi Hatzidakis betänkande, och jag vill lyckönska föredraganden för hans tydlighet, trots ärendets teknikalitet.
- Madam President, I wish to begin by congratulating the rapporteur on his report and also the Commissioner, because with New Labour he is going to have a new colour in his kitchen, which I am sure will be a very pale shade of pink!
- Fru ordförande, jag skulle vilja börja med att lyckönska föredraganden till detta hans betänkande och även kommissionsledamoten, för nya labour kommer att få en ny färg i sitt kök, och jag är säker på att den kommer att vara en mycket svag rosa nyans!
- Mr President, may I also begin by warmly congratulating the rapporteur, Mr Graziani, on this comprehensive report and perhaps firstly just add to the introductory remarks that he made on the disaster that has befallen his country.
- Får även jag börja med att lyckönska föredraganden, Graziani, till detta omfattande betänkande och kanske först ansluta till de inledande kommentarerna han gjort om den katastrof som drabbat hans land.
- Therefore, as well as expressing gratitude for European solidarity, I would like to say that this Watson report - and I would like to congratulate the rapporteur, who has made great efforts - also represents a very important milestone on this journey which we, including all of us here in this European Parliament, are making together in the construction of Europe.
- Och jag vill lyckönska föredraganden som har gjort ett oerhört arbete.
- Mr President, ladies and gentlemen, I should like, firstly, to congratulate the rapporteur, Mr Bakopoulos, for the splendid work he has carried out and for the speed and efficiency with which this matter has been addressed and resolved.
- Till att börja med vill jag lyckönska föredraganden, Bakopoulos, för det utomordentliga arbete som han har lagt ned och för den snabbhet och effektivitet med vilka detta ärende har lösts och handlagts.
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 = 42266 AND
t12.lemma_id = 56398 AND
t21.lemma_id = 59324 AND
t22.lemma_id = 15487),
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;
;