• In my view, further harmonisation in implementing customs legislation can be achieved through the following initiatives:
• Enligt min åsikt kan vidare harmonisering av tillämpningen av tullagstiftningen uppnås genom följande initiativ:

• If we are to create a knowledge-based society, sustainable economic development and greater social cohesion, we will have to establish a strong foundation from the outset, and that can only be achieved through effective education.
• Detta kan endast uppnås genom effektiv utbildning.

• Such a European strategy will be achieved through building on the commitment by Member States and the Commission to cooperate in a number of priority areas:
• En sådan europeisk strategi kommer att uppnås genom att bygga vidare på medlemsstaternas och kommissionens åtagande att samarbeta inom ett antal prioritetsområden:

• They have the right to make a qualified choice, and this has been achieved to some extent through the conciliation text - but not to such an extent, unfortunately, that we can now talk about a responsible consumer policy.
• De har rätt att få göra ett kvalificerat val, och detta uppnås till viss grad genom förlikningstexten.

• The only way in which we can preserve the European social model is by making it sustainable, viable and fundable, and this is achieved through growth and employment, which are, of course, the approaches that we have to support.
• Det enda sätt vi har för att bevara den europeiska sociala modellen är att göra den hållbar, genomförbar och möjlig att finansiera, och detta uppnår vi genom tillväxt och skapande av arbetstillfällen, som helt klart är de recept som vi måste stödja.

• Thirdly, we want to develop a legal and regulatory framework for biotechnology, concerning, in particular, genetic tests, which is based on a broad social consensus which can only be achieved through open, two-way communication.
• För det tredje vill vi att en rättslig ram och ett regelverk för biotekniken skall utarbetas, som bland annat omfattar genetiska prov och grundas på ett brett socialt samförstånd som bara kan uppnås genom öppen kommunikation och som fungerar i bägge riktningar.

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 = 51739 AND
				         t21.lemma_id = 35250 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;
;