- a little care will keep the communication process on an objective level.
- Om vi lägger ned lite möda på det bidrar vi till att hålla kommunikationen på en objektiv nivå.
- While I very much welcome President Bush’s visit to Hungary in memory of the 1956 Hungarian uprising, we must also keep one eye on the present.
- Även om president George Bushs besök i Ungern till minne av 1956 års ungerska uppror gläder mig mycket, måste vi också hålla ett öga på nuläget.
- as we fully implement our recovery plan in order to move out of this economic and financial crisis, we must keep an eye on the future.
- Samtidigt som vi till fullo genomför vår återhämtningsplan för att ta oss ur den ekonomiska och finansiella krisen måste vi hålla ett öga på framtiden.
- We have yet to see a proposal for the other institutions, but there is cause to keep a watchful eye on the growing buildings expenditure of those, too.
- Vi väntar nu på ett förslag för de övriga institutionerna men det finns anledning att hålla ett vakande öga på deras ökande byggnadsutgifter också.
- We need to keep a close eye on all of that, otherwise we will have worked to achieve the opposite effect of the development that we wanted and to the detriment of the social well-being of the populations concerned.
- Vi måste hålla ett vakande öga på allt detta, annars kommer vårt arbete att få motsatt effekt jämfört med den utveckling som vi strävade efter, och den berörda befolkningens sociala välbefinnande kommer att ta skada.
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 = 34535 AND
t12.lemma_id = 11075 AND
t21.lemma_id = 52198 AND
t22.lemma_id = 40192),
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;
;