- But we are determined to come up with a solution that can be considered with a broad consensus as a balanced solution.
- Men vi är beslutna att hitta en lösning som med brett samförstånd kan anses som en balanserad lösning.
- On this basis, I think that there is a very broad consensus between the position expressed by Mrs Mann and that of the Commission.
- Ur denna synpunkt tror jag att det föreligger ett mycket brett samförstånd mellan Manns och kommissionens ställningstaganden.
- We consider some of the others superfluous, but generally speaking the broad consensus there has been throughout in this House on this report should be carried through into the vote.
- Vi anser att en del av de övriga ändringsförslagen är överflödiga, men allmänt sett bör det breda samförstånd som hela tiden rått i parlamentet om detta betänkande klara sig igenom omröstningen.
- Mr President-in-Office of the Council, Mr President, Commissioner, ladies and gentlemen, a process of such historical significance as enlargement can only be approached on the basis of broad consensus.
- En händelse av den historiska betydelse som utvidgningen kan vi endast ta itu med i ett mycket brett samförstånd.
- Mr President, President-in-Office, Commissioner, ladies and gentlemen, there are issues relating to the current situation in Iraq which are uncontentious, which we all share and where we have a broad consensus.
- Det finns frågor i samband med dagens situation i Irak, som är oomstridda, som vi alla är ense om och där vi har ett brett samförstånd.
- Thirdly, we want to develop a legal and regulatory framework for biotechnology, concerning, in particular, genetic tests, which is based on a broad social consensus which can only be achieved through open, two-way communication.
- För det tredje vill vi att en rättslig ram och ett regelverk för biotekniken skall utarbetas, som bland annat omfattar genetiska prov och grundas på ett brett socialt samförstånd som bara kan uppnås genom öppen kommunikation och som fungerar i bägge riktningar.
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 = 14936 AND
t12.lemma_id = 40903 AND
t21.lemma_id = 29717 AND
t22.lemma_id = 30824),
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;
;