- In spite of Commissioner de Silguy’s optimism that this will create employment, do you not agree even so that a real squeeze on demand leads to reduced production and increased unemployment?
- Trots kommissionär de Silguys optimism om att detta nu skall skapa sysselsättning, håller ni ändå inte med om att en real åtstramning av efterfrågan leder till minskad produktion och ökad arbetslöshet?
- I think there is an urgent need to consider which budget lines can be used to create employment in Europe, which budget lines can be used to secure jobs and which budget lines destroy jobs.
- Jag tror att det är absolut påkallat att vi tänker efter med vilka budgetposter vi skall skapa sysselsättning i Europa, med vilka budgetposter vi säkrar sysselsättningen och med vilka budgetposter vi förintar den.
- It is absolutely crucial to protect regions with strong fishing industries against job losses, creating more employment instead, just as it is to ensure that consumers have healthy and safe fisheries products of high quality and to ensure ecological balance and a sustainable environment.
- Man bör i stället skapa ökad sysselsättning, garantera konsumenterna hälsosamma och tillförlitliga fiskeriprodukter av hög kvalitet och garantera den ekologiska balansen och en bärkraftig miljö.
- The Greens are proposing a number of measures on the active, global and massive reduction of working hours, and on support for sustainable economic activities, which are creating employment, in sectors such as the construction of accommodation, public transport, renewable energy.
- De gröna föreslår ett antal åtgärder beträffande aktiv, global och massiv minskning av arbetstiden och stöd till ekonomiskt hållbar verksamhet som kan skapa sysselsättning, inom sådana sektorer som bostadsbyggande, kollektivtransporter, förnybara energikällor.
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 = 'dobj' AND
s2.val = 'OO' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'NOUN' AND
t22.ctag = 'NOUN' AND
t11.lemma_id = 53153 AND
t12.lemma_id = 52521 AND
t21.lemma_id = 7376 AND
t22.lemma_id = 9098),
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;
;