- although we are not in agreement, we had an extremely useful discussion.
- även om vi inte är överens har vi verkligen haft en bra diskussion.
- In the Committee on Economic and Monetary Affairs, we had a discussion with Mr Blokland, and came to a broad agreement.
- I utskottet för ekonomi och valutafrågor hade vi en diskussion med Blokland och kom fram till en bred överenskommelse.
- Let us have good discussions, then, but let us also play hard ball and let us, I beg, secure the energy supplies of our Member States.
- Vi bör ha en bra diskussion, men vi bör också vara tuffa och trygga medlemsstaternas energiförsörjning.
- We have many discussions on how funds are distributed between the Member States, but we also need to discuss how they are allocated within Member States.
- Vi har många diskussioner om hur medel fördelas mellan medlemsstaterna, men vi måste också diskutera hur de fördelas inom medlemsstaterna.
- This is the background against which we think it useful to have a broader and more open discussion about the virtues of a specific budget line for this item, but my own decision is that we need a broad, open discussion and should give ourselves enough time to allow everybody to participate in the discussion.
- Det är mot denna bakgrund vi anser att det är bättre att ha en bredare och öppnare diskussion om egenskaperna för en specifik budgetpost för denna punkt, men min egen uppfattning är att vi behöver en bred, öppen diskussion och avsätta tillräckligt med tid för att göra det möjligt för alla att delta i diskussionen.
- We have therefore had a very interesting discussion with some of the big names in the creation of Internet initiatives, from the head of Google to Mr Zuckerberg, the head of Facebook, and others.
- Därför har vi haft en mycket intressant diskussion med några av de stora aktörerna på nätet, bland andra med Googlechefen och Facebooks vd Mark Zuckerberg.
- The Danish Presidency has had discussion of the mid-term review on the agenda of all the Council sessions in July, September and October, and the Council has thus had a thorough debate on the main topics in the Commission’s discussion paper.
- Det danska ordförandeskapet har haft diskussionen om halvtidsutvärderingen på dagordningen vid alla rådets möten under juli, september och oktober månad, och rådet har därigenom fått till stånd en genomgripande diskussion rörande alla de viktigaste frågorna i kommissionens reflektionsdokument.
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 = 48540 AND
t12.lemma_id = 64078 AND
t21.lemma_id = 54893 AND
t22.lemma_id = 33119),
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;
;