- We need modern, European social harmonisation, not deregulation.
- Vi behöver en modern europeisk social harmonisering i stället för avreglering.
- I regard that as the basis of this report, namely complementarity between liberalisation and social harmonisation.
- Det ser jag som en förutsättning för betänkandet, nämligen att avregleringen och den sociala harmoniseringen kompletterar varandra.
- It could even be encouraged and developed further, whilst ensuring respect for the sovereignty of each country, for workers and their rights - guaranteeing social harmonisation by delivering more favourable working conditions - and for the rights of the user.
- Detta samarbete skulle kunna främjas och utvecklas ytterligare, samtidigt som man respekterar varje lands suveränitet, arbetstagarna och deras rättigheter - en social harmonisering uppnås genom mer gynnsamma arbetsvillkor - och användarnas rättigheter.
- Finally, I would say that if we want to create a transport area in the European Community, in which working conditions are no longer detrimental to the health, safety and quality of life of its citizens, we must consent to a minimum of social harmonisation, for there are aspects we need to regulate that the market alone will never be able to regulate.
- Slutligen, vill jag säga att vi, om vi vill skapa ett transportområde inom Europeiska gemenskapen med arbetsvillkor som inte påverkar medborgarnas hälsa, säkerhet och livskvalitet negativt, måste anta miniminormer för en social harmonisering, för vi måste reglera sådana frågor som inte marknaden själv reglerar.
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 = 28157 AND
t12.lemma_id = 65071 AND
t21.lemma_id = 31433 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;
;