- We will widen this and use it even more in the future.
- Vi kommer att utvidga detta och tillämpa det ännu mer i framtiden.
- On the other hand, it is shameful that the death penalty is still being used to this day in the democratic United States of America.
- Å andra sidan är det en skam att dödsstraffet fortfarande tillämpas i Förenta staterna.
- Will the Commission follow the excellent lead given by the European Foundation and stop using age limits in the Commission’s own recruitment advertisements?
- Kommer kommissionen att följa Europeiska fondens utmärkta initiativ och upphöra att tillämpa åldersgränser i kommissionens egna rekryteringsannonser?
- The rates and exemptions contained in the Community framework must be seen as options subject to ceilings which the national and regional authorities may use in combination with the support needed for local production.
- De skattesatser och undantag som gemenskapsregelverket innehåller måste ses som alternativ som är underställda de tak som de nationella och regionala myndigheterna kan tillämpa i kombination med det stöd som behövs för den lokala produktionen.
- Is the Commission aware that the European Foundation for the Improvement of Living and Working Conditions does not use any age limits in its job advertisements because it stopped this practice a few years ago?
- Är kommissionen medveten om att Europeiska fonden för förbättring av arbets- och levnadsvillkor inte tillämpar några åldersgränser i sina platsannonser eftersom de upphörde med denna praxis för några år sedan?
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 = 51062 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 32869 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;
;