- The second concerns the reform of the structural funds which should not negatively strike zones and regions already burdened by serious social problems resulting from structural situations and the economic crisis.
- Det andra gäller reformeringen av strukturfonderna som inte får negativt drabba områden och regioner som redan tyngs av svåra sociala problem som en följd av strukturella förhållanden och den ekonomiska krisen.
- As Mrs van Putten well knows, this amendment poses serious problems in terms of proof before a national judge.
- Detta ändringsförslag, och det är van Putten väl medveten om, medför svåra problem vad gäller bevis inför en nationell domare.
- By comparison with other regions, the situation in Georgia was relatively good, so that the collapse of communism and the quest for new structures and the new democratic possibilities opened up by a market economy was accompanied by some particularly serious problems.
- I förhållande till andra stater gick det relativt bra för Georgien och därför åtföljdes kommunismens fall och sökandet efter nya strukturer och nya demokratiska möjligheter inom marknadsekonomin av utomordentligt svåra problem.
- among immigrants or third-country nationals, among all those young people who drop out of education before they reach the age of majority, who are exploited, underpaid and untrained, thereby constituting a serious problem of exploitation and undeclared work because they do not have a qualification which can be used to ensure that they are adequately paid.
- bland invandrare eller personer som inte är EU-medborgare, bland alla de ungdomar som avslutar sin skolgång i förtid och som blir utnyttjade, underbetalda och som inte får någon utbildning, vilket sålunda utgör ett svårt problem vad gäller utnyttjande och odeklarerat arbete, för de har inga kvalifikationer som skulle kunna dras fram i ljuset och ges en lämplig ersättning.
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 = 13883 AND
t12.lemma_id = 33635 AND
t21.lemma_id = 13883 AND
t22.lemma_id = 54953),
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;
;