- The participation in the election observation of a team of nine Members of the European Parliament, led by Mr Siwiec, was an important contribution.
- Att en grupp på nio ledamöter från Europaparlamentet, ledda av Marek Maciej Siwiec, deltog i valövervakningen var ett viktigt bidrag.
- The International Election Observation Mission, led by the OSCE Office for Democratic Institutions and Human Rights, found that the re-run of the second round of the presidential elections on 26 December brought Ukraine closer to international standards.
- Den internationella observatörsstyrkan, ledd av den europeiska säkerhetsorganisationen OSSE:s kontor för demokratiska institutioner och mänskliga rättigheter, ansåg att det nya genomförandet av den andra omgången av presidentvalet den 26 december förde Ukraina närmare internationella normer.
- I wish to welcome to the Tribune this afternoon the Chairman of the Russian State Duma Delegation to the EU-Russia Parliamentary Cooperation Committee, led by Vice-President Vladimir Lukin, Mr Alexander Belousov and Mrs Valentina Demina from the Russian Federation Council.
- Jag välkomnar denna eftermiddag ordföranden för den ryska statsdumans delegation till den parlamentariska samarbetskommittén EU-Ryssland, ledd av vicepresident Vladimir Lukin, Alexander Belousov och Valentina Demina från Ryska federationsrådet, som har tagit plats på åhörarläktaren.
- Konrad Schwaiger’s excellent report, resulting both from your request for modification of the Regulation and the visit to Sarajevo on 21 February made by the delegation led by Tom Spencer, will definitely enable the process of reconstruction to be speeded up, but I consider that this remains largely insufficient.
- Det utmärkta betänkandet av Konrad Schwaiger, som kom efter er begäran om ändring av bestämmelserna, och efter att delegationen ledd av Tom Spencer hade besökt Sarajevo den 21 februari, kommer säkerligen att kunna påskynda återuppbyggnadsprocessen, men i min ögon är den fortfarande ytterst otillräcklig.
- Mr President, I would like to express here at this time the indignation of the Galician people and their disappointment at the Copenhagen resolutions, which were a complete failure and which did not even take account of the demands of the European Commission, and there are therefore States in the European Union - the majority of the governments, with the cooperation of the Spanish Government, led by Mr Aznar - which prefer to attend to the interests of the large oil companies - I would even say of the criminal capitalist mafias - rather than protecting the countries and citizens of Europe.
- Det finns alltså stater i den europeiska unionen - majoriteten av regeringarna, tillsammans med den av Aznar ledda spanska regeringen - som föredrar att värna de stora oljebolagens intressen - jag skulle vilja kalla dem den brottsliga kapitalismens maffia - i stället för att skydda de europeiska länderna och medborgarna.
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 = 'prep' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'ADP' AND
t22.ctag = 'ADP' AND
t11.lemma_id = 8856 AND
t12.lemma_id = 6140 AND
t21.lemma_id = 31737 AND
t22.lemma_id = 3216),
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;
;