- I voted against Mrs Kósáné Kovács’s report on the social situation of the Roma and their improved access to the labour market in the EU.
- Jag röstade mot Magda Kósáné Kovács betänkande om romernas sociala situation och om att förbättra deras tillträde till arbetsmarknaden i EU.
- If this Parliament is intent on interfering in the social situation of the Roma and their access to the labour market, would it be asking too much to observe a minimum of objectivity?
- Om parlamentet har för avsikt att ingripa i romernas sociala situation och i deras tillträde till arbetsmarknaden, skulle det vara för mycket begärt att be om ett uns av objektivitet?
- Due to the difficult social situation - according to official figures, unemployment affects around 30 % of the working population, and probably affects more in reality - efforts in this multiannual programme have been focused for the most part on this question of support for policies aimed at reducing unemployment.
- På grund av den besvärliga sociala situationen - arbetslösheten ligger, enligt officiella siffror, och i verkligheten är de säkerligen ännu högre, på 30 procent av den aktiva befolkningen -, har arbetet med detta fleråriga avtal huvudsakligen inriktats på problemet med stöd för den politik som handlar om att minska arbetslösheten.
- Equally important is the existence of credible and relevant social indicators, also in terms of gender, which enable us not only to observe trends in the social situation in the various EU countries, but also to warn of and monitor trends in the social situation as regards poverty and social exclusion in particular.
- Lika viktigt är det att det finns trovärdiga och relevanta sociala indikatorer och, också när det gäller könsaspekter, som kan mäta människors förändrade dagliga liv, men också vara indikatorer för varning och uppföljning av den sociala situationen och särskilt när det gäller fattigdom och utslagning.
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 = 12815 AND
t12.lemma_id = 65071 AND
t21.lemma_id = 12815 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;
;