- The economic damage and the losses resulting from the trade coming to a standstill are hitting the farming sector hard.
- Den ekonomiska skadan och de förluster som orsakats av att handeln paralyserats drabbar jordbrukssektorn hårt.
- The Solidarity Fund and other EU financial instruments can at least make it possible to tackle the economic damage of the disaster more quickly.
- Solidaritetsfonden och andra finansiella instrument inom EU kan åtminstone göra det möjligt att snabbare hantera katastrofens ekonomiska skada.
- Five million homes have been swept away and $20 billion worth of economic damage has been done to the country, 4-5 % of GNP.
- Fem miljoner hem rasade bort och ekonomiska skador för 20 miljarder dollar orsakades landet, 4-5 procent av BNP.
- It is the economic damage which will crucify us, and it will crucify specifically Europe because developing countries like China and India have far too much common sense to be taken in by it.
- Det är den ekonomiska skadan som kommer att få oss på fall, och EU kommer att bli särskilt lidande eftersom utvecklingsländer som Kina och Indien är alldeles för kloka för att låta sig dras med i detta.
- In the mean time we are going to do huge economic damage to the people we represent in a futile and doomed attempt to influence a speculative problem, which, in the view of many people, does not exist.
- Under tiden kommer vi att orsaka enorma ekonomiska skador för de människor vi företräder i ett fåfängt försök som är dömt att misslyckas, för att påverka ett spekulativt problem som enligt mångas åsikt inte existerar.
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 = 49959 AND
t12.lemma_id = 21339 AND
t21.lemma_id = 42798 AND
t22.lemma_id = 45195),
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;
;