• Provision has been made so that products not produced in accordance with the legislation cannot be legally marketed and traded within the Community from 1 January 2012.
• Enligt bestämmelserna blir det från och med den 1 januari 2012 olagligt att inom unionen sälja och handla med produkter som inte producerats i enlighet med lagstiftningen.

• produced in the EU, and that we will have a food safety bureau in the European Union with a forceful, supranational mandate which can act promptly as and when problems arise.
• producerad i EU, och att vi har en byrå för livsmedelssäkerhet i Europeiska unionen med ett starkt mandat och som kan röra sig fritt mellan medlemsstaterna och snabbt ingripa när det förekommer problem.

• The introduction of a human gene into a sheep programmes the animal to produce a human protein in her milk which has great potential for treating emphysema and cystic fibrosis.
• Om man för in ett mänskligt arvsanlag i ett får, programmeras djuret att producera ett mänskligt protein i sin mjölk, vilket har en stor potential för att behandla emfysem och cystisk fibros.

• What is more, the quality of the seed has a decisive effect - a very decisive effect - on the quality of the food produced, in many cases even regardless of the various processing stages.
• Kvaliteten på utsädet avgör i sin tur - till stor del - kvaliteten på de livsmedel som sedan produceras, i många avseenden oberoende av förarbetningsstadierna.

• My country, Poland, which I represent here in the forum of the European Parliament, could be a major producer of agricultural products, and much healthier products than the food currently produced in the West.
• Mitt land, Polen, som jag representerar här i Europaparlamentet, skulle kunna vara en viktig producent av jordbruksprodukter, och mycket hälsosammare produkter än de livsmedel som för närvarande produceras i väst.

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