- The immigrant communities are living in fear and anxiety.
- Immigranterna lever under ångest och rädsla.
- Egypt and Malaysia are among those countries where Christians live in extremely dangerous conditions, face persecution, expulsion from their homes, abductions and murders, and their churches are being closed.
- Egypten och Malaysia finns bland de länder där kristna lever under extremt farliga villkor, utsätts för förföljelse, fördrivs från sina hem, bortförs och mördas, samtidigt som deras kyrkor stängs.
- In Greece, as in other countries, the majority of Roma live in wretched conditions, in encampments, without water or drainage.
- I Grekland, liksom i andra länder, lever de flesta romer under förfärliga förhållanden, i läger utan vatten och avlopp.
- Although illegal immigrants themselves are often living in abject circumstances, they also cause huge problems in the societies and to the people living in the Member States of the European Union.
- Dels lever de illegala invandrarna själva ofta under erbarmliga villkor, dels skapar de enorma problem för samhällena och för de människor som lever i Europeiska unionens medlemsstater.
- Only people who believe in their work put up with what are now grave conditions, frequently living in often difficult circumstances and having to buy their means of production at very high prices.
- Det är bara de som tror på vad de gör som står ut med sådana dåliga villkor som nu råder och som ofta lever under svåra förhållanden och måste köpa sina produktionsmedel till en mycket hög kostnad.
- However, we must also, through this Convention, propose a common plan for European society with which our citizens can identify, and we must therefore decide immediately, at the start of the Convention’s work, what we want to do together and in what kind of society we want to live in the coming years.
- Under alla omständigheter måste vi även via detta konvent lägga fram ett gemensamt förslag till samhälle där våra medborgare kan känna igen sig, och därför måste vi genast, så snart konventet har startat sitt arbete, besluta vad det är vi vill göra tillsammans, i vilken typ av samhälle vi vill leva under de kommande åren.
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 = 1193 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 59115 AND
t22.lemma_id = 11943),
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;
;