- Europe’s action is rightly aimed at preserving expertise and skills.
- EU:s åtgärder är med rätta riktade mot bevarandet av expertis och kunskap.
- Policies on social inclusion also need to be aimed at those who are most in need of them without making any kind of distinction between European citizens.
- Politiken för social integration måste även riktas mot dem som är i störst behov av den, utan att det görs någon skillnad mellan europeiska medborgare.
- I should like to underline that this resolution should not be considered as a targeted attack on one specific form of child abuse, or aimed at one specific sector in industry and one product.
- Jag vill understryka att den här resolutionen inte får betraktas som ett anfall mot en specifik form av barnmissbruk, riktat mot en specifik näringsgren och en produkt.
- These budget lines should, above all, consider not only providing humanitarian assistance, including the improvement of basic living conditions, as we are already doing using the funds of ECHO, but also different initiatives aimed at economic development, improving respect for human rights, improving the independence of the judiciary, improving equal opportunities of men and women in the third countries, but also assisting the third countries to put in place the legal and practical mechanisms for dealing with asylum-seekers and refugees.
- Genom dessa budgetposter skall man framförallt inte bara se till att tillhandahålla humanitärt bistånd, inklusive förbättring av de grundläggande levnadsvillkoren, som vi redan gör genom medel från ECHO, utan också olika initiativ som riktas mot ekonomisk utveckling, förbättrad respekt för de mänskliga rättigheterna, förbättring av domstolarnas oberoende, förbättring av lika möjligheter för män och kvinnor i tredje land, samt även hjälp till tredje land att införa rättsliga och praktiska mekanismer för hantering av asylsökande och flyktingar.
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 = 'prep' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'ADP' AND
t22.ctag = 'ADP' AND
t11.lemma_id = 43257 AND
t12.lemma_id = 38254 AND
t21.lemma_id = 14115 AND
t22.lemma_id = 49261),
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;
;