• The EU must ensure that no EU investor will be treated worse than under the bilateral investment agreements signed between Member States.
• EU måste se till att ingen investerare inom EU behandlas sämre än i de bilaterala investeringsavtal som undertecknats mellan medlemsstaterna.

• It would thus be possible for the Constitutional Treaty - a Constitution for Europe, as President Giscard d’Estaing has described it - to be signed between 1 May 2004, the date set for the entry of the ten new Member States, and the European Parliament elections.
• Det konstitutionella fördraget - en konstitution för Europa, som ordförande Giscard d’Estaing har kallat det - skulle därmed kunna undertecknas mellan den 1 maj 2004, det datum som fastställts för de tio nya medlemsstaternas anslutning, och valet till Europaparlamentet.

• I agree with the rapporteur that this form of cooperation must be promoted in the Latin American region as a whole and that we should provide impetus for the negotiation of the agreement with Mercosur, an agreement which - I think we have to accept - I believe has come to a bit of a halt or, to put it another way, has not proceeded at the speed which we expected in 1995 when we approved it and when the Agreement on Interregional Cooperation was signed between the European Union and Mercosur in Madrid.
• Jag håller med föredraganden om att samarbetet måste kunna stödjas på hela Latinamerika och underlätta utvecklingen av förhandlingarna med Mercosur, ett avtal - allt måste sägas - som enligt min mening verkar ha stannat upp litet, eller annorlunda uttryckt ett avtal som inte har utvecklats så snabbt som vi hade hoppats 1995 när vi godkände och undertecknade anslutningsavtalet mellan Europeiska unionen och Mercosur i Madrid.

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 = 32509 AND
				         t12.lemma_id = 53533 AND
				         t21.lemma_id = 42592 AND
				         t22.lemma_id = 469),
	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;
;