• All the speakers talked of Lampedusa, but I would like to invite you to reflect on what the kind of migratory process we are experiencing at present really means for an island that lives on tourism and fishing.
• Samtliga talare tog upp Lampedusa, och jag skulle vilja att ni funderar över hur den slags migrationsprocess som vi upplever just nu påverkar en ö som lever på turism och fiske.

• Over 5 billion people in such countries live on one or two dollars a day, and a bloody children’s war is being fought in Congo, where over 300 000 children are fighting in military interventions which have killed more than 3 million people in recent years.
• Över fem miljarder människor i sådana länder lever på en eller två US-dollar per dag, och ett blodigt barnkrig utkämpas i Demokratiska republiken Kongo, där över 300 000 barn slåss i militära operationer som har dödat mer än tre miljoner människor de senaste åren.

• When looking ahead to the creation of this free trade area, the main theme must remain the objective of having a form of trade that serves development and the reduction of poverty, particularly in this region in which 30% of the population lives on USD 2 a day and in which mass unemployment and uncontrolled immigration are the only prospects for a growing number of young people.
• När vi blickar framåt på skapandet av detta frihandelsområde måste huvudtemat förbli målet om en handelsform som främjar utveckling och minskad fattigdom, särskilt i denna region där 30 procent av befolkningen lever på 2 US-dollar om dagen och där massarbetslöshet och okontrollerad invandring är de enda framtidsutsikterna för en allt större mängd unga människor.

• It is therefore important to restate our commitment and determination on the eve of this summit, and we must also dedicate ourselves even more firmly to the cause of children, not just in Europe, but throughout the world, because there are now 600 million children worldwide in families living on less than a dollar a day, facing the real evils of malnutrition, lack of education and lack of health provision.
• Det är därför viktigt att vi inför detta toppmöte påminner om vårt engagemang och vår beslutsamhet, att vi också erinrar om kravet på att engagera sig ständigt mer för barnens sak, inte bara i Europa men även i resten av världen, för det står utom allt tvivel att det för närvarande finns 600 miljoner barn i världen vilkas familjer lever på mindre än 1 dollar om dagen, att det finns verkliga missförhållanden som dålig utbildning och sjukvård och undernärda spädbarn, och att vi måste mobilisera oss på dessa områden.

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 = 1193 AND
				         t12.lemma_id = 11075 AND
				         t21.lemma_id = 59115 AND
				         t22.lemma_id = 40192),
	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;
;