- Mr President, Commissioner, I would also finally like to congratulate you on your new post.
- Även jag vill gratulera till er nya tjänst.
- Specifically, the 65 new posts planned were integrated into the estimates, with some of the money placed in reserve.
- De 65 nya tjänsterna togs uttryckligen med i beräkningen, med en del av pengarna placerade i en reserv.
- In addition, this letter creates 15 new posts for OLAF and it goes without saying that I would like to address the questions that have been put to me here on the appointment of the director of OLAF.
- Vidare skapas det med denna tilläggs- och ändringsbudget 15 nya tjänster för OLAF, och jag vill naturligtvis gå in på frågorna som man här har ställt mig beträffande tillsättandet av direktören vid OLAF.
- The Budget Committee considered the demands of the political groups and recognised the need to strengthen the support staff, but subject to the principles of budget discipline, i.e. reemployment must take precedence over the creation of new posts.
- Budgetutskottet tog ställning till de politiska gruppernas begäran om anslag och medgav behovet av att stärka staben, men det måste ske enligt budgetdisciplinens principer, dvs. att återanställning måste prioriteras framför skapandet av nya tjänster.
- The stock-taking for this year shows us that the concerns of the Commission are very clear and very specific and that the Commission, in particular, is very concerned that the new posts should be dedicated to the implementation of the Community acquis in the candidate countries.
- ”Positioneringen” för innevarande år visar oss att kommissionen har mycket klart för sig vilka problemen är, och att den är mycket lyhörd för att de nya tjänsterna skall vikas för uppgiften att övervaka att gemenskapens regelverk följs i kandidatländerna.
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 = 8961 AND
t12.lemma_id = 15618 AND
t21.lemma_id = 834 AND
t22.lemma_id = 53462),
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;
;