• Specific projects are also being prepared by EU services and will shortly be launched, in partnership with the countries concerned, starting with Tunisia and Egypt.
• Specifika projekt håller också på att förberedas av EU:s tjänster och kommer inom kort att lanseras, i partnerskap med de berörda länderna, med början i Tunisien och Egypten.

• We want a Europe that respects its people in practice and, as a start, we request that the next Intergovernmental Conference be prepared by the national parliaments and by these alone, and not the confused and illegitimate authorities or the committees of so-called wise men, which only succeed in sending Europe down dead end roads.
• Vi vill ha ett Europa som respekterar sina folk konkret, och till att börja med kräver vi att nästa regeringskonferens skall förberedas av de nationella parlamenten, och endast av dem, utan alla förvirrande instanser som inte har något berättigande, eller alla kommittéer med påstådda vise män som bara lyckas villa bort Europa på enkelriktade vägar.

• This group has also been assigned the task, and this is a response to another point in your report, of undertaking an ongoing examination of the various initiatives - according to one of your own recommendations - prepared by the Commission, in order to ensure that the legitimate interests of the outermost regions are taken into account across the board in all community policies.
• Denna grupp har även i uppdrag, och jag besvarar här en annan punkt i ert betänkande, att genomföra en permanent granskning av olika initiativ - det är en rekommendation ni lämnat - som förbereds av kommissionen, för att se till att de yttersta randområdenas berättigade intressen beaktas på ett tvärgående sätt i all gemenskapspolitik.

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 = 41958 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 17000 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;
;