- As is the prospect of a countdown to unprecedented catastrophe for further generations if the present unacceptable situation continues.
- Det är också nedräkningen till en aldrig förut skådad katastrof för kommande generationer om den nuvarande oacceptabla situationen fortsätter.
- We must make it clear to those forces in Nigeria who insist on such rules that these lead to unacceptable situations and in this case also to the further spread of venereal diseases, including AIDS.
- Vi måste göra klart för de krafter i Nigeria som insisterar på sådana regler att de leder till oacceptabla situationer och i detta fall även till en ytterligare spridning av könssjukdomar, däribland aids.
- These monopolies are not only concerned with the production of energy, but also the distribution of energy, and citizens and undertakings, both small businesses and large industries, are therefore locked into an unacceptable situation.
- Dessa monopol handlar inte bara om produktion av energi utan också om distribution av energi, och låser därmed medborgarna och företagen, såväl de små företagen som industrierna, i en oacceptabel situation.
- Although I believe that the European Union should be very careful when it comes to interfering in countries’ constitutions, I support this resolution denouncing the unacceptable situation of the Dalits, which is due to the non-application of various provisions prohibiting caste discrimination.
- Jag anser visserligen att EU bör gå mycket försiktigt fram när det gäller inblandning i länders konstitutioner, men jag stöder denna resolution som fördömer daliternas oacceptabla situation, som beror på den bristande tillämpningen av olika bestämmelser som förbjuder kastdiskriminering.
- I would like to take this opportunity to speak in the plenary to denounce the unacceptable situation of Kader Şahin, a young Turkish Communist Party activist who has been detained by decision of the Turkish authorities since January 2007, with no grounds being given for the charges against her, or for holding her in preventive custody awaiting trial.
- Under mitt anförande här i kammaren vill jag passa på att fördöma den oacceptabla situationen för Kader Şahin, den unga turkiska aktivisten och kommunisten, som på order av de turkiska myndigheterna suttit fängslad sedan januari 2007.
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 = 12815 AND
t12.lemma_id = 47992 AND
t21.lemma_id = 12815 AND
t22.lemma_id = 7405),
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;
;