- I am very pleased with the progress that has been made on this proposal and applaud the important role that Parliament has played in moving towards an agreement at first reading.
- Jag är mycket nöjd med de framsteg som gjorts i detta förslag och gratulerar parlamentet till den betydande roll det har haft i fråga om att nå en överenskommelse vid förstabehandlingen.
- I am also in favour of making contraception and education on these matters more easily accessible because this is the best way to avoid unwanted pregnancies.
- Jag är också positiv till att man gör preventivmedel och utbildning i dessa frågor mer lättillgängliga eftersom det är det bästa sättet att undvika oönskade graviditeter på.
- Turkey also regards comments made on this subject as inadmissible interference in its internal affairs and has to date not been prepared to talk to the European Union or anyone else about the Kurdish issue.
- Turkiet betraktar dessutom alla uttalanden som görs i frågan som en otillåten inblandning i deras inre angelägenheter och har hittills inte varit beredd att diskutera kurdfrågan varken med Europeiska unionen eller med någon annan.
- Pension funds are the prime source of capital, and I have advocated UK-style self-select pension plans for the self-employed being permitted to make such investments on a pan-European basis, although this was rejected in committee, unfortunately.
- Pensionsfonderna är den största kapitalkällan, och jag har förespråkat individuella pensionssystem, liknande dem som används i Förenade kungariket, för egenföretagare, som därmed skall tillåtas att göra sådana investeringar i hela Europeiska unionen, även om detta tyvärr förkastades av utskottet.
- I should like to launch an appeal to the Member States - the Presidency is not here, but I know how capable you are of transmitting messages to it, Commissioner, and also how appreciative we are of your efforts to make progress on this matter.
- Jag vill rikta en uppmaning till medlemsstaterna - ordförandeskapet är inte här, men jag vet hur bra ni är på att vidarebefordra meddelanden till det, herr kommissionsledamot, och vi uppskattar era bemödanden att göra framsteg i den här frågan.
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 = 13701 AND
t12.lemma_id = 11075 AND
t21.lemma_id = 2855 AND
t22.lemma_id = 26495),
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;
;