- In an area where Europe is sometimes criticised for its lack of action in the social field, we must make every effort to resolve an issue of such deep concern to workers in the road transport industries.
- På ett område där Europa ibland kritiseras för sin brist på agerande inom det sociala området, måste vi göra allt som går för att lösa en fråga som är så viktig för arbetstagarna inom vägtransportindustrin.
- They are asking us to fight to achieve the same victories we are winning in the economic field in the social field as well, so as to help solve the major everyday problems.
- De begär att vi skall kämpa för att vi även inom det sociala området skall uppnå de resultat som vi nu har uppnått på det ekonomiska, så att vi skall kunna hjälpa till att lösa de stora vardagsproblemen.
- They negotiate a multinational agreement on investments which is exactly the contrary of this approach, and which goes in the direction of the World Trade Organization, which further strengthens the policy aimed at depriving the Member States of their means of action in the social field.
- De förhandlar ett multilateralt avtal om investeringar som är en fullständig motsats till denna åtgärd, som går i samma riktning som Världshandelsorganisationen, som ytterligare förstärker politiken vilken syftar till att skinna medlemsstaterna på medel för åtgärder på det sociala området.
- Given this situation, with the systematic increase in priorities and with the savings policy that has been pursued - inseparable from the Stability Pact and which contains the systematic practice of cuts, freezes, call-backs, redeployment and reprogramming of budgetary expenditure - consequences that are damaging to the implementation levels of the EU’s traditional priorities are inevitable, especially in the social fields and those of cohesion and cooperation.
- med en systematisk ökning av prioriteringar och en besparingspolitik med oupplösliga band till stabilitetspakten och med inneboende systematiska bruk av nedskärningar, frysningar, tidigareläggningar, överföringar och omprogrammeringar av budgetutgifterna, är ofrånkomligen de negativa konsekvenserna som följer på genomförandet av EU:s traditionella prioriteringar när det gäller sammanhållning och samarbete, särskilt på det sociala området, och som undergräver själva budgetförfarandets trovärdighet.
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 = 26065 AND
t12.lemma_id = 65071 AND
t21.lemma_id = 50187 AND
t22.lemma_id = 65071),
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;
;