- The Middle East peace process has no need for woolly pronouncements.
- Fredsprocessen i Mellanöstern har inget behov av luddiga uttalanden.
- We have a great need of artists, of their critical view of the world, of their role as the educators of our societies.
- Vi har ett stort behov av konstnärer, av deras kritiska syn på världen, av deras roll som våra samhällens utbildare.
- When it comes to Parliament’s own budget, even if we have significant needs, we must take account of the economic situation and impose major constraints on ourselves.
- När det gäller parlamentets egen budget måste vi, även om vi har stora behov, ta hänsyn till det ekonomiska läget och ålägga oss själva stor restriktivitet.
- It is certainly the job of the EBRD to do this, but it is even more important to try to do it in countries with little industrial development, which have a greater need for support and revitalisation.
- EBRD:s uppgift är naturligtvis att främja denna utveckling, men det blir än viktigare att främja och stödja en sådan utveckling i länder med svag industriell utveckling som har desto större behov av stöd och stimulans.
- We have a need for reforms, and not only reforms of our statute - important as those are - but also changes to the way in which we work, so that we can deliver the results our electorate wants to see.
- Inte enbart vad gäller vår stadga, även om detta är viktigt, utan vi har även behov av att förändra det sätt vi arbetar på, så att vi kan leverera de resultat som våra väljare vill ha.
- We are certainly living through difficult times, but this is when societies have the greatest need of daring decision makers, because, as the Roman poet Horace noted thousands of years ago, he who is afraid of turmoil ends up crawling.
- Det råder ingen tvekan om att vi upplever svåra tider, men det är nu som samhällen har det största behovet av djärva beslutsfattare, något som den romerska poeten Horatius konstaterade för tusentals år sedan:
- In fact, such states normally have an increased need for euro cash in the run-up to the introduction of the single currency in their territories, to enable them to quickly and completely engage in EU trade and thereby participate in it to the full.
- Faktum är att sådana länder normalt har ett ökat behov av kontanter i euro under upptakten till införandet av den gemensamma valutan på sina territorier, för att de snabbt och fullständigt ska kunna ta del av EU-handeln.
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 = 18487 AND
t21.lemma_id = 54893 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;
;