- I would briefly like to say something more on the amendments, which have reached an unbelievably high number - three in total.
- Jag vill i korthet säga ytterligare något om ändringsförslagen som har uppnått ett otroligt högt antal - totalt tre.
- Our Parliament, which has so much to say on the subject of human rights, should demand that Communism be put on trial.
- Vårt parlament, som har så mycket att säga om de mänskliga rättigheterna, borde kräva att kommunismen ställs inför rätta.
- It is what you have done on the Lisbon Treaty, and I very much hope that the people in my constituency get to have a say on that.
- Det är vad ni har gjort med Lissabonfördraget, och jag hoppas verkligen att människorna i min valkrets får något att säga till om detta.
- Mr President, I believe that nearly everything has been said on the remarkable interest of the Raphael programme at the time of its first reading in October 1995, its second reading in October 1996 and here today.
- Jag tror att nästan allt har sagts om det anmärkningsvärt stora intresset för Rafael-programmet vid den första behandlingen i oktober 1995, den andra behandlingen i oktober 1996 och här i dag.
- Could I also say on the broader topic of completing the internal market that, during the Finnish Presidency, we have had some very important strategy papers and they actually require a much higher priority than they are receiving in the Community at the moment.
- Låt mig också säga om den bredare fråga som rör slutförandet av den inre marknaden, att under det finska ordförandeskapet fick vi en del mycket viktiga strategidokument och de kräver faktiskt en mycket högre prioritet än vad de får i gemenskapen för tillfället.
- It is becoming ever more apparent that opening the debate on proportionality (votes in the Council and seats in the European Parliament), one might go so far as to say on the balance of power between the Member States, has opened a Pandora’s box which will be very difficult to close in Nice.
- Det blir allt mer uppenbart att den påbörjade debatten om proportionaliteten (vad avser röster i rådet och platser i Europaparlamentet), det vill säga om maktförhållandena mellan medlemsstaterna, har öppnat en Pandoras ask som det blir svårt att stänga i Nice.
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 = 56832 AND
t12.lemma_id = 11075 AND
t21.lemma_id = 9295 AND
t22.lemma_id = 14161),
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;
;