• It would be most unfortunate if you should start in a procedure where you are legitimate in the context of a Commission as college - I speak not of individuals but of a college - which itself is discredited.
• Det skulle vara mycket olyckligt om ni skulle inleda i ett förfarande där ni äger legitimitet inom en kommission som kollegium betraktat - jag talar inte om individer utan om ett kollegium - som i sig självt är misskrediterat.

• We are now in a leading position in the G20 - a process which, by the way, was started in Europe - but it is true that more needs to be done.
• Vi har nu en ledande ställning i G20 - en process som förresten inleddes i Europa - men det är helt riktigt att mer behöver göras.

• On the other hand, the objective of the agricultural negotiations the Commission is holding with Morocco, which started in January, is to widely liberalise agricultural trade between the European Union and Morocco.
• Målet med de jordbruksförhandlingar som kommissionen för med Marocko och som inleddes i januari i år är att i större utsträckning avreglera handeln med jordbruksprodukter med Marocko.

• The Barcelona process is necessary in order to complete the process started in Lisbon and you have said, Mr President, that there is no better means of achieving social integration than creating employment.
• Det är nödvändigt att genomföra den process som inleddes i Barcelona, och ni sade, herr ordförande, att det bästa sättet att skapa social integrering är att skapa arbetstillfällen.

• The revolutionary movements that started in Tunisia have inspired and encouraged millions of people across North Africa and the Middle East to engage in popular uprisings against the brutal regimes that have dictatorially ruled those countries for decades.
• De revolutionsrörelser som inleddes i Tunisien har inspirerat och uppmuntrat miljontals människor i Nordafrika och Mellanöstern att delta i folkuppror mot brutala regimer som i årtionden har utövat diktatoriskt styre över dessa länder.

• It may be, however, that, in actual fact, the WTO crisis which started in Seattle was only temporarily alleviated in Doha and that it re-emerged in Cancún, not by chance in relation to those same Doha issues.
• I själva verket kan det dock vara så att WTO-krisen som inleddes i Seattle bara tillfälligt lindrades i Doha och blossade upp på nytt i Cancún, vilket inte behöver hänga samman med frågorna i Doha.

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 = 298 AND
				         t12.lemma_id = 8748 AND
				         t21.lemma_id = 36055 AND
				         t22.lemma_id = 26495),
	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;
;