- I would also stress that the guidelines presented by the rapporteur are part of a major reform movement.
- Jag skulle också vilja understryka att de riktlinjer som presenterades av föredraganden är en del av en större reformrörelse.
- Mr President, Commissioner, the draft European Private Company statute is presented by the Commission as a component of the European Small Business Act.
- Utkastet till stadgan för privata Europabolag presenteras av kommissionen och är en del av småföretagsakten för Europa.
- Many of the proposals which have been put forward by the technical committee are to be found in one form or another in the report presented by Mrs Gonzalez Alvarez today.
- Många av de förslag som forskningsutskottet har lagt fram finns med i någon form i betänkandet som presenterats av González Álvarez i dag.
- I think Parliament itself should do more to ensure that the nice, correct analysis presented by all parties here is representative of the whole House.
- Jag anser att parlamentet självt borde göra mer för att se till så att denna omdömesgilla, oklanderliga analys som presenterats av alla närvarande partier blir representativ för hela kammaren.
- Mr President, Mr Commissioner, ladies and gentlemen, first of all I want to express my appreciation of the reports under discussion, in particular that presented by Mr Colom i Naval, on behalf of the Committee on Budgets, inasmuch as it frankly faces up to what I consider the main problems.
- Låt mig först av allt uttrycka min uppskattning av de betänkanden som diskuteras, framför allt det som presenterats av kollegan Colom i Naval för budgetutskottet, eftersom det så tydligt tar upp de problem som jag anser vara av avgörande betydelse:
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 = 1723 AND
t12.lemma_id = 6140 AND
t21.lemma_id = 61104 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;
;