- Irrespective of whether or not one shares these political visions, this method is in danger of devaluing the importance of fundamental rights.
- Oavsett om man håller med om dessa politiska visioner eller inte, riskerar denna metod att devalvera betydelsen av de grundläggande rättigheterna.
- Mr President, in our opinion the most striking feature of the Helsinki European Council was the absence of any long-term political vision among the Heads of State and Government.
- Det mest anmärkningsvärda med det Europeiska råd som nyligen har hållits i Helsinki är i våra ögon bristen på varje form av långsiktig politisk vision från stats- och regeringschefernas sida.
- European history teaches us that, in order to reach the Rinascimento, the era of the flowering of civilisation, a common effort of creativity and political vision is needed.
- Den europeiska historien lär oss att det krävs en gemensam skaparkraft och en politisk vision om vi skall kunna få en ny renässans, en era där civilisationen når sin höjdpunkt.
- The European Union needs a strong, legitimate and accountable Commission, capable of providing political vision and leadership.
- Europeiska unionen behöver en stark, legitim och ansvarsfull kommission, som kan formulera en politisk vision och som har ledarförmåga.
- Shameful as it is, this is what really happened, and we should not forget it in our endeavours to construct a political vision of the unification of Europe.
- Det må vara skamligt men det är vad som verkligen hände och vi bör inte glömma bort det i våra ansträngningar för att skapa en politisk vision av återföreningen av Europa.
- I would conclude by adding that the scale of the challenges lying ahead of us over the next few years calls for political vision and a fresh input of ideas.
- Låt mig avslutningsvis säga att de utmaningar som ligger framför oss under de kommande åren kräver en förnyad politisk vision och nya ideal.
- I would go so far as to say that 2006 was the Year of Parliament, because it was able to show that it had real political vision and that it was not a rubber-stamp chamber.
- Jag är beredd att gå så långt att jag säger att 2006 var parlamentets år, eftersom det lyckades visa att det har en verklig politisk vision och att det inte är någon nickedocka.
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 = 62632 AND
t12.lemma_id = 7077 AND
t21.lemma_id = 62632 AND
t22.lemma_id = 55010),
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;
;