• I will be voting in favour of this report especially since it promotes in a very forceful and concrete way the principle of equal treatment between persons irrespective of religion or belief, age or sexual orientation.
• Jag kommer att rösta för det här betänkandet, framför allt för att det på ett mycket kraftfullt och konkret sätt främjar principen om likabehandling av personer oavsett religion eller övertygelse, ålder eller sexuell läggning.

• Beyond the Torres Couto report, we need to become more active in promoting SMEs in their biggest arena, the single European market, a market too closely made and shaped by the image of big business.
• Utöver Torres Coutos betänkande måste vi mer aktivt främja de små och medelstora företagen på deras största arena, den inre europeiska marknaden, en marknad som alltför mycket är född och formad i storföretagens avbild.

• Last Friday, the European Council called upon the Commission to cooperate with the Cypriot Government in considering how economic development might be promoted in Northern Cyprus and how Northern Cyprus might be brought closer to the EU.
• I fredags uppmanade Europeiska rådet kommissionen att i samarbete med den cypriotiska regeringen överväga hur den ekonomiska utvecklingen skall kunna främjas på norra Cypern och hur norra Cypern skall kunna komma närmare Europeiska unionen.

• In the light of these facts, which are well reported in this document, it is necessary to develop not just specific national plans and strategies for Alzheimer’s disease, which are essential, but also an instrument at European level that promotes the effective coordination of European research in this area.
• Mot bakgrund av dessa uppgifter, som finns väl beskrivna i det här dokumentet, är det nödvändigt att utforma inte bara de oumbärliga specifika nationella planerna och strategierna för Alzheimers sjukdom utan också ett instrument på EU-nivå som främjar en effektiv samordning av europeisk forskning på detta område.

• I would like to hear from the Commission about the experience the Commission has of programmes of this kind, and also whether the Commission can, and indeed wants to, make a contribution to broadening the knowledge of the possibilities and to encouraging Member States to promote projects in this area, for example organised by sports organisation NGOs in their own country.
• Jag hoppas kommissionen vill redogöra för sina erfarenheter av program av detta slag, och jag undrar också om kommissionen kan - och vill - bidra till att bredda kunskapen om möjligheterna och till att medlemsstaterna uppmuntras att främja projekt på detta område som organiseras av t.ex. icke-statliga idrottsorganisationer i respektive land.

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 = 12318 AND
				         t12.lemma_id = 8748 AND
				         t21.lemma_id = 29642 AND
				         t22.lemma_id = 40192),
	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;
;