• In this context, I believe that we need a strategy.
• I det här avseendet anser jag att vi behöver en strategi.

• I believe in any case that Dagmar Roth-Behrendt has expressed things very well indeed:
• Jag anser i varje fall att Dagmar Roth-Behrendt har uttryckt saken utmärkt väl:

• In particular, I believe that safety has to override all other considerations.
• I synnerhet anser jag att säkerhet måste överskugga alla andra hänsyn.

• We believe, in fact, that the substance of this recital falls largely within the domain of national laws and regulations.
• Vi anser i själva verket att innehållet i detta skäl i hög grad omfattas av nationella lagar och förordningar.

• In this regard, I believe that the Commission has put forward several suggestions here on ’how to structure this debate’ .
• Och i det sammanhanget anser jag att kommissionen har gett flera förslag till ”hur debatten kan struktureras”.

• In fact, ladies and gentlemen, by adopting such a text, I believe we are helping to bring an end to the ideological debate on the nature and form of the European project.
• Genom att anta en sådan text anser jag i själva verket att vi bidrar till att få ett slut på den ideologiska debatten om EU-projektets art och utformning.

• In all these cases, I believe that freedom of speech should be paramount, and that criminal law should only be brought in when there is clear incitement to hatred, to violence or to terrorism.
• I alla dessa fall anser jag att yttrandefrihet ska gå före allt annat och att straffrätten bara ska tillämpas i tydliga fall av anstiftan till hat, våld eller terrorism.

• In this respect, I believe, as Mr Buzek said, that the Commission’s proposal has been broadly accepted and that the improvements and amendments that have been made all point in the right direction.
• I detta avseende anser jag, som Jerzy Buzek sa, att kommissionen förslag i stort sett har godtagits och att alla de förbättringar och ändringar som har gjorts pekar i rätt riktning.

• In this context, the Presidency believes that greater involvement of the European Parliament in the Intergovernmental Conference’s work is essential in order to safeguard the constitutional legacy of the Convention and to avoid falling back into the narrow, nationalistic ways of thinking that produced the obscure agreements at Nice.
• I detta sammanhang anser ordförandeskapet att det är väsentligt att Europaparlamentet blir mer delaktigt i regeringskonferensen för att skydda konventets konstitutionella arv och undvika att vi faller tillbaka till de snäva, nationalistiska tankesätt som ledde till de oklara överenskommelserna i Nice.

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 = 23589 AND
				         t12.lemma_id = 8748 AND
				         t21.lemma_id = 24457 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;
;