- It is strange that, in certain places, only two kinds are included, even though it is precisely these that account for 80% of illnesses among people today.
- Det är konstigt att man i vissa lägen enbart inbegriper två sorter, även om just dessa står för 80 procent av sjukdomsfallen hos människor idag.
- I feel that this legislative initiative is welcome at a time when workers from third countries account for a non-negligible percentage of the European Union’s labour force, making illegal immigration a concern.
- Jag anser att lagstiftningsinitiativet är välkommet i en tid då arbetstagare från tredjeländer står för en icke-försumbar andel av EU:s arbetskraft, vilket gör olaglig invandring till ett bekymmer.
- According to the Commission’s White Paper, carbon dioxide emissions associated with transport are estimated to increase by 50% over the period 1990-2010, and the main source of emissions is road traffic, which accounts for 84% of carbon dioxide emissions connected with transport.
- Enligt kommissionens vitbok beräknas koldioxidutsläppen från trafiken öka mellan åren 1990 och 2010 med 50 procent, och den huvudsakliga källan för utsläppen är vägtrafiken som står för 84 procent av koldioxidutsläppen som härstammar från trafiken.
- For the new Member States in eastern Europe, however, with few exceptions, the international lending markets have closed their doors, there is an outflow of capital, and western European banks, which account for the majority of the market in the region, have changed the expansive lending policies they were pursuing not long ago for a more cautious approach.
- Det finns ett utflöde av kapital och västeuropeiska banker, som står för den största delen av marknaden i regionen, har gått från den expansiva lånestrategi som de hade för inte så länge sedan till en mer försiktig inställning.
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 = 8388 AND
t12.lemma_id = 36421 AND
t21.lemma_id = 33479 AND
t22.lemma_id = 64468),
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;
;