- The Member States must choose between these two objectives;
- Medlemsstaterna måste välja mellan dessa två målsättningar.
- I would not like to have to choose between coal and nuclear for 2050.
- Jag har ingen lust att stå där 2050 och tvingas välja mellan kol och kärnkraft.
- If we had to choose between the transatlantic alliance and the dictators, the choice would be easy.
- Om vi hade haft att välja mellan Nato och tyrannerna hade valet varit lätt.
- ACP countries should not have to choose between trade agreements which may damage their local/regional markets or barriers which cripple their export markets.
- AVS-länderna bör inte tvingas välja mellan handelsavtal som kan skada deras lokala/regionala marknader och hinder som försvagar deras exportmarknader.
- As it is, we have to choose between Kofi Annan and George Bush, we have to choose between Prime Minister Simitis and President Prodi, who are the leaders of the Union, and Tony Blair and José Maria Aznar.
- Men nu måste vi välja mellan Kofi Annan och Bush.
- In this respect, a decision by the former President Marc Ravalomanana to return to his country is essential, taking into consideration the fact that the current leaders are forcing him to choose between exile and forced labour for life.
- I detta avseende är ett beslut från den f.d. presidenten Marc Ravalomanana om att återvända till landet helt avgörande, med tanke på att de nuvarande ledarna tvingar honom att välja mellan exil eller tvångsarbete på livstid.
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 = 30827 AND
t12.lemma_id = 53533 AND
t21.lemma_id = 19329 AND
t22.lemma_id = 469),
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;
;