- Half a billion euros is supposed to be spent on mitigating the negative impact of globalisation.
- En halv miljard euro ska spenderas på att mildra de negativa följderna av globaliseringen.
- The enduring truth is that Africa is the scene of bloody conflicts and that Africans spend more on arms than they receive in development aid.
- Den bestående sanningen är att Afrika är en scen för blodiga konflikter och att afrikanerna spenderar mer på vapen än de får i utvecklingsbistånd.
- By making sure that the Union’s money is spent efficiently on reconstruction and nuclear safety in the Ukraine, Europe can avoid potential future problems.
- Genom att se till att unionens pengar spenderas effektivt på återuppbyggnad och kärnsäkerhet i Ukraina kan Europa undvika möjliga problem i framtiden.
- Add together what the EU and all its Member States spend on research and development, and it works out that, even now, that figure reaches 0.86%.
- Lägg samman vad EU och alla dess medlemsstater spenderar på forskning och utveckling, och det visar sig att den siffran redan i dag är 0,86 procent.
- Instead, it tries to justify an EU-wide policy of neo-Keynesian demand management by spending more on a great majority of items without any underlying structural reforms.
- Den är i stället ett försök att rättfärdiga en EU-omfattande nykeynesiansk politik för styrning av efterfrågan genom att spendera mer på en stor majoritet av poster utan några underliggande strukturella reformer.
- Every year our Member States spend more than EUR 180 billion on employment, which is why our committee believes that every proposed measure must always be examined as to its employment impact.
- Våra medlemsstater spenderar årligen över 180 miljarder euro på sysselsättning, och därför anser utskottet att man vid varje föreslagen åtgärd måste undersöka vilka effekter den får för sysselsättningen.
- The European Union, the Commission and the Member States have now spent a total of EUR 1 billion on the office in Phnom Penh, observation missions during elections, financial support for mine-clearing operations, and suchlike.
- Europeiska unionen, kommissionen och medlemsstaterna har nu spenderat sammanlagt 1 miljard euro på kontoret i Phnom Penh, valobservationsuppdrag, ekonomiskt stöd till minröjningsarbeten och dylikt.
- However, since it will take at least a year to get there, we must support the African Union and we must at least ensure that its soldiers are paid, because you should be aware that we have spent more money on supporting that force than on humanitarian aid.
- Men eftersom det kommer att ta minst ett år att komma dit måste vi stödja Afrikanska unionen, och vi måste åtminstone se till att soldaterna får betalt, för ni ska veta att vi har spenderat mer pengar på att stödja den styrkan än på humanitärt bistånd.
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 = 59042 AND
t12.lemma_id = 11075 AND
t21.lemma_id = 31935 AND
t22.lemma_id = 40192),
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;
;