- I am voting in favour of the set of proposals presented in this report.
- Jag röstar för de förslag som presenteras i betänkandet.
- These are the principles behind our SME policy as presented in the review of the Small Business Act for Europe.
- Detta är principerna bakom vår politik för små och medelstora företag som presenteras i översynen av småföretagsakten.
- The Commission believes that progress by the Member States ought to be presented in a form which permits direct comparisons between countries, if that is possible in practice.
- Kommissionen anser att medlemsstaternas framsteg bör presenteras i en form som tillåter direkta jämförelser mellan länder, om det är praktiskt möjligt.
- Mr President, firstly I should like to reply to Mr Elles’ questions concerning the preparation of the different documents which were based on the programme which Mr Santer presented in January and which was referred to in many of the discharge reports.
- Först och främst skulle jag vilja besvara Elles frågor beträffande förberedelserna av de olika dokument som grundar sig på det program herr Santer presenterade i januari och som man hänvisade till i flera av betänkandena om ansvarsfrihet.
- In April 2000, under pressure from the European Parliament, the Council presented the single, consolidated legislative instrument to approve the seven agreements between the Community and its Member States, on the one hand, and the Swiss Confederation, on the other.
- Efter påtryckningar från Europaparlamentets sida presenterade rådet i april ett enhetligt och konsoliderat lagstiftningsinstrument, för att de sju avtalen skulle godkännas av gemenskapen och dess medlemsstater, å ena sidan, och Schweiziska edsförbundet, å andra sidan.
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 = 8748 AND
t21.lemma_id = 61104 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;
;