- My group would have been happy to have tightened it, with more transparency and less wriggle room for protectionists.
- Min grupp skulle ha varit nöjda med att strama till den, med större öppenhet och mindre utrymme för protektionisterna.
- We wanted more transparency and more control over expenditure, and all of this was achieved by means of the Interinstitutional Agreement.
- Vi ville ha större öppenhet och mer kontroll över utgifterna och allt detta gick att åstadkomma genom det interinstitutionella avtalet.
- This is where Mr Prodi ought to begin, instead of issuing further empty promises about more transparency and a closer relationship with the people.
- Det är här Prodi borde börja i stället för att utfärda nya tomma löften om större öppenhet och större närhet till medborgarna.
- I would just like to say in advance that on almost all points - and I would like to thank my fellow Member - there is a unanimous perception that the report could bring more transparency.
- Jag vill bara säga i förväg att det, på nästan alla punkter - och jag vill tacka mina kolleger för detta - finns en enhällig uppfattning om att man genom betänkandet skapar större öppenhet.
- Safeguards, not in the sense that you can be sure mistakes will never be made or problems will never occur, but safeguards that introduce more transparency to ensure that the process is visible and that we are not faced with surprises and faits accomplis.
- Inte skydd i den bemärkelsen att man kan vara säker på att misstag aldrig kommer att göras, eller på att problem aldrig kommer att uppstå, utan skydd som inför större öppenhet för att se till att processen är genomsynlig och att vi inte stöter på överraskningar och fullbordade faktum.
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 = 'amod' AND
s2.val = 'AT' AND
t11.ctag = 'NOUN' AND
t21.ctag = 'NOUN' AND
t12.ctag = 'ADJ' AND
t22.ctag = 'ADJ' AND
t11.lemma_id = 19300 AND
t12.lemma_id = 19006 AND
t21.lemma_id = 25763 AND
t22.lemma_id = 35323),
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;
;