- This six-month limit had already been suggested by the national authorities to protect data when the first directive on data protection had been approved.
- Denna sexmånadersgräns för dataskydd föreslogs av de nationella myndigheterna redan när det första direktivet om dataskydd antogs.
- I hope, thinking about tomorrow, that in its new term this Parliament may also have a constitutional role, as suggested by many, among them Mr Gargani, chairman of the Committee on Legal Affairs, and Mr Brunetta.
- Inför framtiden hoppas jag att parlamentet under denna nya valperiod även kommer att ges en konstitutionell roll, vilket har föreslagits av många, bland andra Giuseppe Gargani, ordförande för utskottet för rättsliga frågor, och Renato Brunetta.
- The current system demonstrates weaknesses and problems with which we are all familiar, but there is no guarantee that the innovations proposed by the Commission - and even less those suggested by other institutions - will do anything to improve the situation.
- Det aktuella systemet uppvisar kända svagheter och problem, men det är långt ifrån säkert att de innovationer som kommissionen föreslår (och i ännu mindre grad de som föreslås av andra institutioner) bidrar till att förbättra situationen.
- My sincere thanks go to the rapporteur, Mrs Paliadeli, who efficiently took on board the proposals and additions suggested by many of us in the Committee on Culture and Education, providing, in particular, for procedures that are more certain and more respectful of the Treaty of Lisbon with regard to the subdivision of tasks among Member States, the Commission, the Council and Parliament.
- Jag vill rikta mitt uppriktiga tack till föredraganden Chrysoula Paliadeli, som på ett effektivt sätt tog med de förslag och tillägg som föreslagits av flera av oss i utskottet för kultur och utbildning.
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 = 18283 AND
t12.lemma_id = 6140 AND
t21.lemma_id = 6708 AND
t22.lemma_id = 3216),
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;
;