- We emphasise the need for the following in the resolution:
- Vi betonar behovet av följande i resolutionen:
- In any event, we emphasise the need for an impact assessment before negotiations commence and offers are exchanged.
- Vi betonar behovet av en konsekvensbedömning innan förhandlingar inleds och förslag utbyts.
- At the same time, I would like to emphasise the need for considerably broader cooperation in the following sectors:
- Samtidigt vill jag betona behovet av ett mycket bredare samarbete inom följande områden:
- I would like to emphasise on this point the need to focus particular attention on the Black Sea and create dedicated bodies for managing it.
- Jag vill i detta sammanhang betona behovet av att ägna särskild uppmärksamhet åt Svarta havet och att inrätta engagerade organ för att förvalta det.
- We have also, however, emphasised the need for this process to be accompanied by measures guaranteeing democratic and legal control.
- Men vi har också betonat behovet av att denna process åtföljs av åtgärder som garanterar demokratisk och rättslig kontroll.
- As permanent rapporteur of the European Parliament for Armenia, I should like to emphasise the need to define a clear and effective European Union strategy for the South Caucasus.
- Som Europaparlamentets ständiga föredragande för Armenien skulle jag vilja betona behovet av att fastställa en tydlig och effektiv EU-strategi för Sydkaukasien.
- I would nevertheless like to emphasise the need for the Union to conduct an in-depth analysis of the situation with regard to respect for human rights and democratic principles within each country.
- Jag vill ändå betona behovet för EU att göra en djupgående analys av situationen med avseende på respekten för de mänskliga rättigheterna och de demokratiska principerna i varje land.
- Whilst we stand by this, I have to again emphasise the need for us to keep a sense of proportion as we prepare to take this step, for there is as yet little reliable data that would make it possible to assess purely ecological damage and to calculate what should be paid for it.
- I det här sammanhanget måste jag dock återigen betona behovet av att vi behåller känslan för proportioner när vi förbereder oss för det här steget.
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 = 'dobj' AND
s2.val = 'OO' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'NOUN' AND
t22.ctag = 'NOUN' AND
t11.lemma_id = 61406 AND
t12.lemma_id = 18487 AND
t21.lemma_id = 58789 AND
t22.lemma_id = 23045),
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;
;