• Today, we are on the eve of a fundamentally important event in the history of European integration.
• I dag står vi inför en fundamentalt viktig händelse i den europeiska integrationens historia.

• The replacement of the coins and notes we have been accustomed to with something completely new and different will be an important event in all our lives.
• När de nuvarande mynten och sedlarna byts ut mot något helt nytt och annorlunda, så är det en viktig händelse i en människas liv.

• Mr President, in addition to congratulating Mr Hume on winning the Nobel Peace Prize jointly with Mr Trimble, I would like to join other speakers in drawing attention to the fact that this weekend an important event took place when the British authorities carried out a request by the Spanish judicial authorities to arrest General Pinochet.
• Förutom att gratulera Hume till att han har tilldelats Nobels fredspris tillsammans med Trimble, vill jag peka på, vilket också andra talare har gjort, att det inträffade en mycket viktig händelse under helgen och det är att de brittiska myndigheterna uppfyllde en begäran från det spanska rättsväsendet om häktning av general Pinochet.

• With Europe delaying in finding its feet and appearing to be cowardly, weak and, for a long time, to have no voice in the historically important event of the last decade, by which I mean the uprisings in the Arab world, with the Member States failing to take a united stand on the critical UN Security Council Resolution 1973 on Libya, and with the Union hesitating on Syria, I wonder whether perhaps the question has already been answered in practice.
• Med ett EU som dröjer med att få fotfäste och förefaller vara fegt och svagt och under lång tid inte ha någon röst i den historiskt viktiga händelsen det senaste årtiondet, och då menar jag resningen i arabvärlden, med medlemsstater som inte lyckas inta en gemensam ståndpunkt om den kritiska resolutionen 1973 från FN:s säkerhetsråd om Libyen och med en union som tvekar när det gäller Syrien undrar jag om frågan kanske redan har besvarats i praktiken.

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 = 21476 AND
				         t12.lemma_id = 36766 AND
				         t21.lemma_id = 28920 AND
				         t22.lemma_id = 14863),
	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;
;