- Indeed, it is estimated that an extra 75 million people around the world went hungry as a direct result of the higher food prices in 2007 and 2008.
- Man uppskattar faktiskt att 75 miljoner fler människor runt om i världen led av hunger som en direkt följd av de högre livsmedelspriserna under 2007 och 2008.
- As an Irish Member, I am all too aware that the overwhelming majority of environmental legislation, as well as attitude changes, are a direct result of our membership of the European Union.
- Som irländsk ledamot är jag alltför medveten om att den överväldigande delen av såväl miljölagstiftningen som attitydförändringarna är en direkt följd av vårt medlemskap i Europeiska unionen.
- Indeed, under Regulation (EC) No 546/2009 of the European Parliament and Council, of 18 June 2009, which amended Regulation (EC) No 1927/2006 of the European Parliament and Council on 20 December 2006 and established the European Globalisation Adjustment Fund, the scope of the EGF was temporarily widened as it was expected to be able intervene in situations like this if, as a direct result of the global financial and economic crisis, there are ’at least 500 redundancies over a period of nine months, particularly in small or medium-sized enterprises, within a level 2 division of NACE in one region or two contiguous regions at NUTS Level 2’.
- Enligt Europaparlamentets och rådets förordning (EG) nr 546/2009 av den 18 juni 2009 om ändring av Europaparlamentets och rådets förordning (EG) nr 1927/2006 av den 20 december 2006 om upprättande av Europeiska fonden för justering för globaliseringseffekter utvidgades tillfälligt fondens tillämpningsområde för att göra det möjligt att utnyttja fonden när - som en direkt följd av den globala finansiella och ekonomiska krisen - ”minst 500 arbetstagare sägs upp under en period på nio månader, särskilt på små eller medelstora företag, inom en Nace 2-sektor i en region eller två regioner som gränsar till varandra på Nuts II-nivå”.
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 = 48515 AND
t12.lemma_id = 25271 AND
t21.lemma_id = 34997 AND
t22.lemma_id = 20888),
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;
;