• Finally, the simplification achieved by harmonising rules at all programming levels will facilitate the participation of small agencies in cohesion policy programmes and improve the take-up of funds.
• Slutligen kommer de förenklingar som åstadkoms genom samordnade regler på alla programplaneringsnivåer göra det lättare för små myndigheter att delta i de sammanhållningspolitiska programmen och förbättra utnyttjandet av medel.

• We wanted more transparency and more control over expenditure, and all of this was achieved by means of the Interinstitutional Agreement.
• Vi ville ha större öppenhet och mer kontroll över utgifterna och allt detta gick att åstadkomma genom det interinstitutionella avtalet.

• These days, nothing matters except the pursuit of economic growth and export benefits on the world market, achieved by low wages, poor working conditions and the banning of independent trade unions, all of which is highly reminiscent of the dictatorial model which South Korea used in the past in order to become an industrialised nation.
• Nu för tiden spelar ingenting annat någon roll än jakten på ekonomisk tillväxt och exportfördelar på världsmarknaden, vilket åstadkoms genom låga löner, dåliga arbetsförhållanden och förbud mot oberoende fackföreningar.

• For example, if the calculation of emission reductions includes those achieved by investments in ’avoided deforestation’ - depending on whether this is calculated in the United States’ emission reduction target, or in the financing, or whatever - this is something which must be clarified in order to determine the comparability between the targets of the United States and the European Union and other developed countries.
• Det måste exempelvis klargöras om beräkningen av utsläppsminskningar inkluderar minskningar som åstadkoms genom investeringar i ”undvikande av avskogning” - beroende på om detta ingår i Förenta staternas minskningsmål, eller i finansieringen, eller något annat - så att vi kan avgöra om det går att jämföra Förenta staternas, EU:s och andra industriländers mål.

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 = 5196 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 10087 AND
				         t22.lemma_id = 27140),
	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;
;