• After the minimalist proposal for a directive on family reunification that we examined just now in this House, we can only imagine the kind of discrimination that the European Union intends to reserve for the most marginalised and weak in the future.
• Efter detta minimalistiska förslag till direktiv om familjeåterförening, vilket vi behandlade för en stund sedan i denna församling, kan vi bara föreställa oss hur Europeiska unionen avser att diskriminera de svagaste och de mest utslagna i framtiden.

• Many of the legislative proposals that we are examining in the Committee on Economic and Monetary Affairs, from derivatives to short selling, give ESMA considerable powers of surveillance and control, and so it is crucial that this authority should be enabled to get up to speed as quickly as possible.
• Många av de lagstiftningsförslag vi nu behandlar i utskottet för ekonomi och valutafrågor, från derivatinstrument till blankning, ger ESMA avsevärda befogenheter att utöva tillsyn och kontroll, och det är därför av stor vikt att myndigheten ges möjlighet att så snart som möjligt få full överblick över verksamheten.

• While, in March, the Parliamentary Assembly of the Council of Europe adopted a resolution that contemplates the possibility of setting up an International Tribunal in order to bring those guilty of serious violations of human rights in Chechnya to justice, more recently, the political and institutional process begun was examined in depth in the course of the talks of the Commissioner for Human Rights in Moscow.
• Samtidigt som Europarådets parlamentariska församling har godkänt en resolution som föreslår att det inrättas en internationell tribunal för att ställa de personer som gjort sig skyldiga till allvarliga kränkningar av de mänskliga rättigheterna i Tjetjenien inför rätta, har på senare tid den politiska institutionella utvecklingen behandlats i samtal i Moskva under ledning av kommissionären för de mänskliga rättigheterna.

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 = 25643 AND
				         t12.lemma_id = 8748 AND
				         t21.lemma_id = 18246 AND
				         t22.lemma_id = 26495),
	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;
;