• The only innovations are those inspired by your new whims:
• Det enda nya är sådant som har inspirerats av era nya nycker:

• It was only to be expected, however, that all of the Members would want to add some of the huge number of ideas inspired by the Commission’s proposal.
• Det var emellertid väntat att alla medlemsstater skulle vilja lägga till några av de enormt många idéer som inspirerats av kommissionens förslag.

• To conclude, the Buitenweg report is inspired by a proactive and progressive approach which I have supported.
• Sammanfattningsvis har betänkandet från Buitenweg inspirerats av en voluntaristisk och framstegsvänlig åtgärd som jag gett mitt stöd till. För risken att den nyfascistiska och rasistiska hydran skall återuppstå gör att vi mer än någonsin måste vara mycket vaksamma.

• Therefore, inspired by the Asian example transposed to Europe, loans need to be made in small circles, having gained their confidence, basing the credit more on trust than on collateral.
• Därför måste lån göras i mindre kretsar, inspirerat av det asiatiska exemplet som överförts till Europa, efter att man har vunnit deras förtroende, genom att bygga krediten mer på tillit än på säkerhet.

• The new European strategy, inspired by the guidelines of the Monti report, has the merit of indicating concrete measures for getting out of this period of economic crisis by restoring productivity and employment levels.
• Den nya europeiska strategi som har inspirerats av riktlinjerna i Montirapporten har den fördelen att den anger konkreta åtgärder för att vi ska komma ur denna ekonomiska kris genom att återställa produktivitets- och sysselsättningsnivåer.

• It says it is inspired by Article 12 of the European Convention on Human Rights which states ‘men and women of marriageable age have the right to marry and found a family according to national laws’.
• Det står att man inspirerats av artikel 12 i Europeiska konventionen om de mänskliga rättigheterna, i vilken fastställs att, ”män och kvinnor i giftasvuxen ålder har rätt att gifta sig bilda familj i enlighet med nationell lagstiftning”.

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 = 38546 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 36826 AND
				         t22.lemma_id = 3216),
	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;
;