• The Socialist Group fully endorses, as before, Mr Pimenta’s excellent report calling for a rejection of the agreement on the grounds clearly set out in his report.
• Socialistgruppen stöder, precis som innan, fullständigt Pimentas utmärkta betänkande och önskar se att avtalet förkastas på grundval av de skäl som tydligt läggs fram i hans betänkande.

• So we support the measures set out in the report and call for this action to be taken sooner rather than later, because this is discrimination that women have faced for a very long time.
• Så vi ger vårt stöd till de åtgärder som läggs fram i betänkandet och kräver att dessa åtgärder vidtas förr snarare än senare, eftersom kvinnor under en mycket lång tid har mött denna diskriminering.

• The first proposal set out in the resolution is that EU development policy must pay greater attention to the developing countries’ fishing industry by drawing up country-specific cooperation strategy documents resulting from the political dialogue between the European Union and the country concerned.
• Den första faktor som läggs fram i resolutionen är att utvecklingspolitiken måste rikta större uppmärksamhet på fiskesektorn, genom att upprätta handlingar för en särskild samarbetsstrategi för varje land som bygger på den politiska dialogen mellan Europeiska unionen och det berörda landet.

• In addition to the mutual recognition of the cards issued in individual Member States, the Commission proposed that there should be a standardized EC model parking card, and details of such a standard card are set out in the recommendation.
• I tillägg till det ömsesidiga erkännandet av de tillstånd som utfärdats av enskilda medlemsstater, föreslog kommissionen att det borde finnas ett standardiserat tillstånd av gemenskapsmodell, och detaljer om ett sådant standardtillstånd läggs fram i rekommendationen.

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