• The need to communicate with European citizens is more pressing than ever.
• Behovet av att kommunicera med EU:s medborgare är mer trängande än någonsin.

• Representative democracy can function only when citizens communicate with their elected representatives and ask them to promote their interests.
• Den representativa demokratin kan fungera endast när medborgarna kommunicerar med de folkvalda och ber dem att främja deras intressen.

• Commissioner, I value your enthusiasm, but I believe that communicating with citizens is extremely important.
• Fru kommissionsledamot, jag uppskattar din entusiasm, men jag anser att det är oerhört viktigt att kommunicera med medborgarna.

• We cannot communicate with a regime where there are political prisoners and where there is no freedom of expression for civil society, or a free media.
• Vi kan inte kommunicera med en regim som håller politiska fångar, inte har fria massmedier och där det civila samhället saknar yttrandefrihet.

• I would reiterate the appeal by a previous speaker for the setting up of a competent, independent, scientific body to act as a watchdog and to communicate with the public at an early stage, especially through consumer associations.
• Jag skulle vilja upprepa föregående talares appell om att inrätta ett kompetent, oberoende, vetenskapligt organ som skulle fungera som vakthund och kommunicera med allmänheten på ett tidigt stadium, i synnerhet genom konsumentorganisationer.

• even when they produce such major results, the great international summits do not succeed in communicating with what are known as the Seattle movements and, above all, do not connect with that much deeper, much more widespread, silent demand for security on the lips of the citizens, the submerged base of an iceberg whose tip is represented by the raft of different types of protests.
• inte ens när man kommer fram till resultat som är så här viktiga lyckas man kommunicera med de rörelser som går under namnet ”Seattle” och framför allt lyckas man inte mötas i frågan om den ännu djupare, mera spridda och outtalade fråga om säkerhet som medborgarna upplever, den dolda delen av ett isberg vars topp utgörs av protesrörelsens många olika uttryck.

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 = 11952 AND
				         t12.lemma_id = 12425 AND
				         t21.lemma_id = 32986 AND
				         t22.lemma_id = 57357),
	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;
;