• Among most observers, there is a growing consensus that more needs to be done about the political and socioeconomic situation.
• Bland de flesta observatörerna finns en växande enighet om att mer måste göras för att förbättra det politiska och socioekonomiska läget.

• Egypt and Malaysia are among those countries where Christians live in extremely dangerous conditions, face persecution, expulsion from their homes, abductions and murders, and their churches are being closed.
• Egypten och Malaysia finns bland de länder där kristna lever under extremt farliga villkor, utsätts för förföljelse, fördrivs från sina hem, bortförs och mördas, samtidigt som deras kyrkor stängs.

• Direct and indirect taxation are among these instruments, which it must be able to use as it pleases because each economy remains distinctive, even if it forms an integral part of a globalised system.
• Direkta och indirekta skatter finns bland dessa instrument som staterna måste kunna använda som de vill, eftersom varje enskild ekonomi inte är lik någon annan, även om den utgör en del av ett globaliserat system.

• And among the socialist amendments, there is one, which Mrs Wallis highlighted, which points out the special position of the outermost regions, which are totally separated from Community territory, a long way from it and which therefore, in the application of Community law, in accordance with the new article 299.2 of the Treaty, cannot be subject to the same regulations which are in force in the internal market in continental Europe.
• Bland de socialdemokratiska ändringsförslagen finns ett som Wallis framhöll och som visar de ultraperifera regionernas särskilda ståndpunkt, regioner som är helt åtskilda gemenskapens förvaltningsområde.

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 = 24585 AND
				         t12.lemma_id = 1278 AND
				         t21.lemma_id = 32744 AND
				         t22.lemma_id = 1832),
	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;
;