• I hope that the recommendations made by the reports are taken into consideration by the relevant institutions in Member States.
• Jag hoppas att de rekommendationer som gjorts genom betänkandena beaktas av de relevanta institutionerna i medlemsstaterna.

• Many of them make the biggest financial investment they will ever make in their lives by purchasing real property.
• Många av dem gör den största ekonomiska investering de någonsin kommer att göra i sina liv genom at köpa fast egendom.

• The purpose of this regulation is to empower consumers to make choices in the single market, by giving them information and allowing them to exercise their choice.
• Syftet med förordningen är att göra det möjligt för konsumenterna att göra val på den inre marknaden genom att ge dem information och låta dem utöva sitt fria val.

• We therefore endorse the changes made by this report to the regulation:
• Vi stöder därför de ändringar av förordningen som görs genom detta betänkande - förändringarna som avser tillämpningsområdet, flexibiliteten för medlemsstaterna, kontroller och den fria rörligheten för ekologiska produkter inom Europeiska unionen.

• Since then, substantial progress has been made on the part of the Member States by way of the Italian feasibility study, and on the part of the Commission by way of this communication, for which I thank Commissioner Vitorino.
• Sedan dess har medlemsstaterna gjort viktiga framsteg genom den italienska genomförbarhetsundersökningen, och kommissionen genom detta meddelande - för vilket jag vill tacka kommissionär Vitorino.

• Indeed, we can make a particularly important contribution by trying to ensure that training in this area, and in others which are related to civilian crisis management, is compatible with that provided by the UN.
• Vi kan i själva verket göra en särskilt viktig insats genom att försöka se till att utbildningen på detta område - och på andra områden som står i samband med civil krishantering - är förenlig med den utbildning som erbjuds av FN.

• We would also like to highlight the Commission’s proposal to evaluate the Small Business Act by the end of 2010, so as to make life easier for these companies, especially by simplifying bureaucratic and tax matters, and placing greater emphasis on social responsibility.
• Vi skulle också vilja lyfta fram kommissionens förslag att utvärdera småföretagsakten senast vid slutet av 2010 för att göra livet lättare för dessa företag, särskilt genom att förenkla byråkratin och beskattningen och mer betona det sociala ansvaret.

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 = 13701 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 2855 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;
;