• No people of the Union deserves to be represented by a second-class Commissioner.
• Inget folk i unionen förtjänar att företrädas av en andra klassens kommissionsledamot.

• I look forward to continuing this close and fruitful cooperation in Bali, where Parliament will be represented by a strong delegation.
• Jag ser fram emot ett fortsatt nära och givande samarbete på Bali, där parlamentet kommer att företrädas av en stark delegation.

• I shall also take this opportunity to complain to the Commission, represented here by Mr Verheugen, that, last February, it asked the candidate countries to communicate in English during the negotiation process.
• För övrigt utnyttjar jag detta tillfälle till att protestera inför kommissionen, som här företräds av Günther Verheugen, mot att kandidatländerna i februari förra året blev ombedda att föra all kommunikation med kommissionen på engelska under förhandlingarna.

• As part of this approach and in order to provide material support for Algeria’s efforts, the Commission, represented by Mr Prodi, has signed financing agreements granting EUR 13 million for two human rights projects.
• Som en del av detta tillvägagångssätt och i syfte att ge materiellt stöd till Algeriets ansträngningar har kommissionen, företrädd av Prodi, undertecknat finansieringsavtal som ger 13 miljoner euro till två projekt för mänskliga rättigheter.

• We would like, however, to insist that in future the small islands are allowed as of right to attend those appeals panels, represented by whosoever they wish, as is the norm in all other international arenas.
• Vi skulle dock vilja insistera på att dessa små öar i framtiden får rätt att framträda inför dessa överklagandepaneler, företrädda av vem de önskar, såsom normerna är på alla andra internationella arenor.

• So let me point out that during the last plenary partsession our Parliament condemned China for its serious human rights violations in East Turkestan and thus set an example of honesty and genuine representation of the people, which sadly neither the United Nations nor the EU as a whole, given that it is represented only by government representatives, has managed to do.
• Jag vill erinra om att vårt parlament under den sista plenarveckan fördömde Kina på grund av dess allvarliga kränkningar av de mänskliga rättigheterna i Östturkestan och därmed gav ett exempel på ärlighet och äkta folkrepresentation som tyvärr varken gjorts av Förenade Nationerna eller av EU som helhet, vilket ju bara företräds av regeringsrepresentanter.

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