- The effect of this can be found in the Erika II package.
- Resultatet av detta återfinns i Erika II-paketet.
- The second proposal made by the High Level Panel will be found in the Amsterdam Treaty.
- Andra förslag som har lagts fram av Veil-gruppen återfinns i Amsterdamfördraget.
- This attempt at obstruction can be found in a series of proposed amendments in the Bowe report.
- Dylika försök att förhindra det hela återfinns också i en rad ändringsförslag till Bowes betänkande.
- Some of the elements which are being contested can, in fact, be found in a number of other constitutions in other Member States, and yet we are only debating one constitution in one Member State.
- Vissa av de kritiserade inslagen återfinns faktiskt i en rad andra konstitutioner i andra medlemsstater och ändå debatterar vi bara en konstitution i en medlemsstat.
- On this subject, allow me to point out to you that, on the basis of our informal contacts, the private sector has a great interest in financing certain actions to be taken by the European Institute of Technology, a state of affairs that is, moreover, only to be expected since the same ideas are to be found in many of our Member States.
- Detta är dessutom väntat eftersom samma idéer återfinns i många av medlemsstaterna.
- In my opinion, that courage, and the stance that was, as both the previous speaker and you, Mr President, have pointed out, to be found not only in Hungary but also in Poland and twelve years later in Czechoslovakia, that courage is also part of the heritage of Europe.
- Detta mod och det ställningstagande som återfanns inte bara i Ungern utan också i Polen och tolv år senare i Tjeckoslovakien, som både den föregående talaren och ni, herr talman, har talat om, detta mod är också, enligt min mening, en del av Europas arv.
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 = 23890 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 2065 AND
t22.lemma_id = 26495),
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;
;