- to guarantee equal access to high-quality services (health, transport, social, care, cultural, recreational and legal);
- garantera lika tillgång till kvalitativ hälsovård, transporter, sociala tjänster, assistans, kultur-, rekreations- och juristtjänster;
- It is important to stimulate technical development towards more advanced exhaust gas purification technology and towards more fuel-efficient engines by guaranteeing access to fuel with a very low sulphur content until the year 2005.
- Det är viktigt att stimulera den tekniska utvecklingen mot mer avancerad avgasreningsteknik och mot bränslesnålare motorer genom att garantera tillgång till bränsle med mycket låga svavelvärden till år 2005.
- We need to guarantee access to irreproachable information and education on sexual and reproductive health, make training women a priority so as to make it easier for them to make decisions on issues of sexuality and reproductive health, and thus offer them the means and methods necessary to protect themselves from HIV infection.
- Vi måste garantera tillgång till tillförlitlig information och utbildning om sexuell och reproduktiv hälsa, och göra kvinnors utbildning till en prioriterad fråga för att de lättare ska kunna fatta beslut i frågor som rör sexualitet och reproduktiv hälsa, och därigenom erbjuda dem de vägar och metoder som krävs för att de ska kunna skydda sig själva från hiv-infektioner.
- There is a need for measures to demolish, and quickly, the barriers which exist at present and still hamper the freedom of movement and of residence of people who are called EU citizens, which do not guarantee all EU citizens access to the law and to justice to the extent that they desire, and which, above all, hamper the mobility of students in schools and higher education, of apprentices, and also of teachers and the workforce.
- Vad vi behöver är åtgärder för att riva ner nuvarande barriärer, och det snabbt, barriärer som fortfarande står i vägen för de så kallade unionsmedborgarnas rörelsefrihet och rätt till uppehållstillstånd, barriärer som inte garanterar alla unionsmedborgare tillgång till rätt och rättsväsende i önskvärd utsträckning och som framför allt hindrar rörelsefriheten för elever, studenter och lärlingar men även för lärare och arbetskraft.
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 = 1368 AND
t12.lemma_id = 41962 AND
t21.lemma_id = 64416 AND
t22.lemma_id = 32322),
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;
;