- We are assisting Greece in the important work it is doing to build up a system that is in line with European law.
- Vi hjälper Grekland i det viktiga arbete landet utför för att bygga upp ett system som stämmer överens med EU-lagstiftningen.
- Member States could be tempted to reduce budgets for mental health or to reduce their efforts to build up modern mental health systems with community-based services instead of outdated asylums.
- Medlemsstaterna kanske frestas att dra ned på budgeten för psykisk hälsa eller minska arbetet med att bygga upp moderna system för psykisk hälsa med samhällsbaserade tjänster i stället för gammalmodiga anstalter.
- Next week, on the eve of the G20 meeting in Pittsburgh, the Commission will adopt proposals to build a true European system of supervision - a system that reflects the integrated nature of our single market.
- Nästa vecka inför G20-mötet i Pittsburgh kommer kommissionen att anta förslag om att bygga upp ett verkligt europeiskt system för tillsyn - ett system som avspeglar integrationen av vår inre marknad.
- If we are truly concerned about the protection of civil rights and the maintenance of democracy, we must, without delay, build an adequate system based on criminal law that can meet the challenges we are now facing, and invest in a powerful preventive policy.
- Om vi verkligen månar om skyddet för de medborgerliga rättigheterna och upprätthållandet av demokratin så kan vi inte vänta med att bygga ut ett adekvat straffrättsligt system som är utformat i enlighet med de utmaningar som vi konfronteras med i dag, lika lite som vi kan vänta med att investera i en kraftfull förebyggande politik.
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 = 'dobj' AND
s2.val = 'OO' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'NOUN' AND
t22.ctag = 'NOUN' AND
t11.lemma_id = 63682 AND
t12.lemma_id = 38507 AND
t21.lemma_id = 19672 AND
t22.lemma_id = 38507),
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;
;