- I would appeal to the Members to bear this in mind when they are voting tomorrow in relation to this question of increasing the budget.
- Jag skulle vilja vädja till ledamöterna att ha detta i åtanke när de i morgon röstar om denna fråga, om att öka budgeten.
- We must bear in mind that, according to the whole Russian establishment, NATO’s enlargement is causing increased security worries for Russia.
- Man måsta ha i åtanke att Natos utvidgning, enligt hela det ryska etablissemanget, innebär ökad säkerhetspolitisk oro för Ryssland.
- I think that it is very good to bear these figures in mind so that we can keep this discussion and the size of the problem in proportion.
- Det är väldigt bra att ha dessa siffror i åtanke, så att denna diskussion och problemets omfattning inte blir oproportionerliga.
- I believe that one of the most important aspects which the Commission must bear in mind is the value of transposing Directive No 22/2006 into Member States’ national legislations and the harmonisation of national provisions drafted as a result of Article 19 of Regulation No 561/2006.
- Jag anser att en av de viktigaste aspekter som kommissionen måste ha i åtanke är betydelsen av införlivandet av direktiv 22/2006/EG med medlemsstaternas nationella lagstiftning och harmoniseringen av nationella bestämmelser till följd av artikel 19 i förordning (EG) nr 561/2006.
- We must bear in mind that the ambitious goals to which the European Union has committed itself, aimed at reducing emissions of gases responsible for the greenhouse effect, increasing the use of renewable sources of energy and enhancing energy efficiency, can only be achieved if we implement them in accordance with the principle of subsidiarity, beginning with social and economic actors at local and regional level.
- Vi måste ha i åtanke att de ambitiösa mål som Europeiska unionen har ställt upp, och som syftar till att minska utsläppen av de gaser som bidrar till växthuseffekten, öka användningen av förnybara energikällor och förbättra energieffektiviteten, endast kan uppnås om vi genomför dem i enlighet med subsidiaritetsprincipen.
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 = 47875 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 54893 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;
;