• If we asked the social partners to come to an agreement on Directive 96/34/EC on parental leave, which was also mentioned by Commissioner Špidla, why are we trying to prejudge what kind of agreement will be reached?
• Om vi ber arbetsmarknadens parter komma fram till en överenskommelse om direktiv 96/34/EG om föräldraledighet, vilket också nämndes av kommissionär Vladimir Špidla, varför försöker vi då föreskriva vilken sorts överenskommelse de ska enas om?

• I was interested by the proposal, which was also mentioned by one of the authors of this resolution, to establish a working group on Sharia and human rights and women’s rights under the Cotonou Agreement.
• Jag blev intresserad av förslaget, vilket även nämndes av en av författarna till denna resolution, att upprätta en arbetsgrupp om sharia och mänskliga rättigheter samt kvinnors rättigheter, i enlighet med Cotonouavtalet.

• I want to mention, as has already been mentioned by many speakers today, that tourism related to the natural and cultural heritage is expected to be the fastest expanding form of tourism in the EU during the next two decades.
• Jag vill säga, vilket redan nämnts av flera talare i dag, att turism kopplad till natur- och kulturarvet väntas bli den snabbast expanderande formen a turism i EU under de två kommande decennierna.

• Information and activities will be linked up by this agency rather than bureaucratised, and I believe that anyone working in this field will be aware of the urgent need for a European network of networks, as mentioned by the rapporteur.
• Information och aktiviteter kommer att kopplas samman av denna byrå, snarare än att byråkratiseras, och jag tror att alla som arbetar inom detta område kommer att vara medvetna om det trängande behovet av ett europeiskt nätverk av nätverk, vilket nämnts av föredraganden.

• Thirdly, as mentioned by Mr Cavada and Mrs Roure, major changes have taken place in the area of justice and home affairs, with a new institutional framework entering into force as regards visas, asylum and immigration, whereby codecision with Parliament and qualified majority voting in the Council now apply.
• För det tredje har, såsom har nämnts av Jean-Marie Cavada och Martine Roure, stora förändringar ägt rum inom området med rättsliga och inrikes frågor, med en ny institutionell ram som träder i kraft när det gäller viseringar, asyl och invandring, varigenom medbeslutande med parlamentet och omröstning med kvalificerad majoritet i rådet nu gäller.

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 = 16898 AND
				         t12.lemma_id = 6140 AND
				         t21.lemma_id = 63505 AND
				         t22.lemma_id = 3216),
	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;
;