• Thus the decision to send the EULEX peace-keeping force to Kosovo to take over the role that until recently had been played by UNMIK is a tactical error.
• Beslutet att skicka den fredsbevarande styrkan Eulex till Kosovo för att överta den roll som tills helt nyligen har spelats av Unmik är således ett taktiskt misstag.

• Nonetheless, I welcome the demand for openness and transparency in the use of experts and for the publishing of the composition of the committees and working groups consulted by the Commission when preparing its proposals, which will certainly highlight the role played by UNICE, the confederation of European big business.
• I vilket fall välkomnar jag kravet på öppenhet och insyn när det gäller användningen av experter och offentliggörandet av sammansättningen av de kommittéer och arbetsgrupper som skall konsulteras av kommissionen när den utarbetar sina förslag, vilket säkerligen kommer att lyfta fram den roll som spelas av Unice, de europeiska storföretagens egen union.

• However, celebrations over the historic decision to reunite Europe - and I welcome the very prominent role played by Liberals in the Council, Commission and Parliament, whether those on the benches in front of us apply that label to themselves or not - should not be allowed to overshadow another significant breakthrough at Copenhagen.
• Hyllningar angående det historiska beslutet att återförena Europa - och jag välkomnar den mycket framträdande roll som spelats av liberaler i rådet, kommissionen och parlamentet, oavsett om de på bänkarna framför oss kallar sig själva så eller inte - borde dock inte tillåtas överskugga ett annat viktigt genombrott i Köpenhamn.

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 = 39118 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 19805 AND
				         t22.lemma_id = 3216),
	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;
;