- It is clear that the Greek Government, on the basis of a pre-judged decision, has thrown away every right and every opportunity to negotiate to save jobs, thereby creating an enormous social problem.
- Det är tydligt att den grekiska regeringen på grundval av ett redan på förhand bedömt beslut har avfärdat varje rätt och varje möjlighet att förhandla för att trygga arbetstillfällena, och därigenom orsakat enorma sociala problem.
- Bearing in mind all these enormous problems, it is clear that our road to rightful entry into Europe, in which Serbia and Montenegro used to have places worthy of them, will be a long one.
- Med tanke på alla dessa enorma problem är det uppenbart att vår väg mot ett rättmätigt inträde i Europa, där Serbien och Montenegro brukade inneha platser som var värdiga dem, kommer att bli en lång väg.
- If you do it against the will of the people, you are storing up enormous social and political problems for the future.
- Om ni gör det mot folkets vilja kommer ni att lagra enorma sociala och politiska problem för framtiden.
- Although this is a sensitive period of time just after the enormous problems with nuclear safety in Japan, nuclear energy remains a major contributor to energy supply cross the EU and globally.
- Även om detta är en känslig tid just efter de enorma problemen med kärnsäkerheten i Japan, fortsätter kärnenergi att ge ett viktigt bidrag till energiförsörjningen i hela EU och globalt.
- In the long term, the increase in heavy goods transport will cause enormous problems, such as congestion, the construction of new routes, and problems of safety and pollution.
- På lång sikt kommer ökningen av lastbilstransporter att ställa till enorma problem, såsom trafikstockningar, uppförande av nya vägavsnitt, säkerhet och miljöförstöring.
- The launch of a fingerprinting system by the Italian Government as an impetus to tackling the enormous problems resulting from mass Roma immigration into the country definitely has the support of the vast majority of the people.
- Den italienska regeringens införande av ett system för att ta fingeravtryck, som en drivkraft för att ta itu med de enorma problem som uppstår till följd av romernas massinvandring i landet, har definitivt stöd i de breda folklagren.
- The enormous problems of the quality of life they face, even at the level of public health, are being faced additionally by the European Union, with relevant programmes for air quality, for regional regeneration and for cultural interventions.
- Städernas invånare har enorma problem när det gäller livskvaliteten, inte minst på folkhälsans område, och Europeiska unionen försöker lösa dessa problem genom kompletterande program som gäller luftkvalitet, fysisk planering och förnyelse, kulturinsatser.
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 = 13883 AND
t12.lemma_id = 9815 AND
t21.lemma_id = 13883 AND
t22.lemma_id = 54424),
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;
;