• I shall begin with the developments in Ukraine and what they mean for the future.
• Jag skall börja med utvecklingen i Ukraina och vad den betyder för framtiden.

• These figures are extremely high, considering what they mean for individual people.
• Dessa siffror är oerhört höga när man beaktar vad de betyder för de enskilda människorna.

• This policy will also bring Europe closer to its people by making visible what Europe really means for them as individuals.
• Denna politik kommer också att föra Europa närmare folket genom att den synliggör vad Europa verkligen betyder för dem som individer.

• The murder is a tragedy for Pakistan, but what does it mean for the West?
• Mordet är en tragedi för Pakistan, men vad betyder det för Väst?

• Those who are familiar with the history of Poland know what corridors mean for that country.
• Den som känner till Polens historia vet vad korridorer betyder för detta land.

• It is clear that there should have been a discussion on what a system of the type we now want to introduce will mean for poor candidate countries.
• Det är klart att det borde ha funnits en diskussion om vad ett system av den typ vi nu vill införa kommer att betyda för de fattiga kandidatländerna.

• As is often said, progress is worth nothing unless it is shared, and for us this means that, in a world of constant change, we should stop placing the main burden of effort and sacrifice on employees in order then to let the most wealthy and most powerful be the first to benefit from the positive results of this effort and sacrifice.
• För oss betyder det att vi i denna ständigt föränderliga värld upphör med att lägga huvuddelen av ansträngningarna och uppoffringarna på löntagarna, för att sedan låta de rikaste och mäktigaste utnyttja de positiva effekterna av dessa ansträngningar och uppoffringar.

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 = 25163 AND
				         t12.lemma_id = 36421 AND
				         t21.lemma_id = 13403 AND
				         t22.lemma_id = 64468),
	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;
;