- This will certainly be a central issue in Almaty.
- Detta kommer verkligen att bli en central fråga i Almaty.
- This Parliament has made the Europe 2020 strategy a central issue of the budgetary discussions right from the start.
- Parlamentet har redan från början gjort Europa 2020-strategin till en central fråga i budgetförhandlingarna.
- I think that it manages, through a series of clever devices, to carefully avoid addressing the central issue, i.e. the final status of Kosovo.
- Genom en rad konstgrepp tror jag att man i den omsorgsfullt har undvikit att ta itu med den centrala frågan, nämligen Kosovos slutliga status.
- Madam President, President of the Commission, ladies and gentlemen, at the beginning of this legislative term, one of the central issues under debate was the institutional issue.
- I inledningen av denna mandatperiod var en av de centrala frågor som debatterades den institutionella frågan.
- We made it very clear to everybody that it was now - and not in December - that the decisions were to be taken and we focused the agenda on the central issues.
- Vi klargjorde för alla att det var nu och inte i december som besluten skulle fattas, och vi hade i dagordningen fokuserat just på de centrala frågorna.
- The fundamental issue of debt is not the central issue for these countries - the main issue is their development, and this is the key point behind all this.
- Den viktiga frågan om skulderna är inte den centrala frågan för de länder vi talar om, den viktiga frågan är deras utveckling, och detta är den grundläggande punkt som ligger bakom allt det här.
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 = 35278 AND
t12.lemma_id = 11059 AND
t21.lemma_id = 19168 AND
t22.lemma_id = 11059),
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;
;