• We must learn lessons from these judgments, even if we do not share this opinion, which is often too critical.
• Vi måste dra lärdom av dessa omdömen, även om vi inte delar denna inställning, som ofta är för kritisk.

• We must consider not only the experiences from Nagoya but also last year’s bad experiences from Copenhagen, and learn from these.
• Vi måste beakta erfarenheterna från Nagoya, och dessutom beakta förra årets dåliga erfarenheter från Köpenhamn och dra lärdom av dem. Rådet har verkligen gjort det och vi har själva antagit en tydlig ståndpunkt.

• It is also a guarantee made to the citizens of Europe of our wish to learn the lessons from the crises which shook the European Commission at the start of the year.
• Det är också ett bevis till de europeiska medborgarna på att vi vill dra lärdom av de kriser som skakade Europeiska kommissionen i början av året.

• This is true not only because the Czech Republic still has to ratify the treaty, but because we must learn lessons from the difficulties we have experienced in achieving ratification of the Treaty of Lisbon.
• Det säger jag inte bara på grund av att Tjeckien fortfarande inte har ratificerat fördraget, utan för att vi måste dra lärdom av de svårigheter vi har haft med att få Lissabonfördraget ratificerat.

• Mr President, in essence, the vote on the budget is a profoundly political act, and we must learn a political lesson - a major, fundamental political lesson - from the budget being proposed to us.
• Omröstningen om budgeten är i huvudsak en i grunden politisk handling, och vi måste dra en politisk lärdom - en betydande, grundläggande politisk lärdom - av den budget som föreslagits.

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 = 47605 AND
				         t12.lemma_id = 15442 AND
				         t21.lemma_id = 40879 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;
;