• I should like to hear from the Commissioner whether he believes the resources are there.
• Jag skulle vilja höra från kommissionären om han tror att det finns resurser för detta.

• First, to the Commission, because it has reminded us that there may well be additional costs involved if it follows the recommendations - and I heard it from both Commissioners.
• Först, till kommissionen, eftersom den påmint oss om att det mycket väl kan handla om tillkommande kostnader om vi följer rekommendationerna - och det har jag hört från bägge kommissionärerna.

• Otherwise, the press who are listening in the press room will have heard thirteen minutes from one group - actually five but the rapporteur is from the same group - and nothing from the other groups.
• Annars kommer pressen, som sitter i pressrummet och lyssnar, att ha hört tretton minuter från en enda grupp - egentligen fem, men föredraganden tillhör samma politiska parti - och inget från de övriga grupperna.

• As we have heard from the other speakers, there is general pessimism about the prospects of success at Johannesburg, so I would like to ask the Commission what the EU strategy in pursuit of sustainable development will be if Johannesburg does not deliver.
• Som vi har hört från de andra talarna, finns det en allmän pessimism angående framgångsutsikterna vid mötet i Johannesburg, så jag skulle vilja fråga kommissionen vilken EU:s strategi för att uppnå en hållbar utveckling kommer att vara om Johannesburgmötet inte ger några resultat.

• We have also heard from leaders of many of the rebel groups that any intervention, and this intervention in particular, will be considered hostile.
• Vi har också hört från flera rebelledare att alla insatser, och i synnerhet denna, kommer att uppfattas som fientlig.

• Certainly, in this particular case, the evidence - as we have also been hearing from many of the witnesses - has been retracted and contradicted.
• I det här speciella fallet har bevisningen, som vi också har fått höra från flera olika håll, dragits tillbaka och motbevisats.

• Unfortunately, I have also heard expressions of disapproval from those who fear that the first permanent President of the Council does not have sufficient competences for the job.
• Tyvärr har jag också hört negativa uttalanden från personer som fruktar att den första permanenta ordföranden för rådet inte har tillräcklig kompetens för jobbet.

• The EU 2020 initiative is calling on Member States to contribute and we have heard from the rapporteurs (whom I thank greatly for their reports) about the fact that Member States need to contribute to the completing of the single market.
• Initiativet till EU 2020-strategin är en uppmaning till medlemsstaterna att bidra, och vi har hört från föredragandena (som jag tackar stort för deras betänkanden) att medlemsstaterna behöver medverka till att slutföra den inre marknaden.

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 = 9214 AND
				         t12.lemma_id = 15442 AND
				         t21.lemma_id = 22072 AND
				         t22.lemma_id = 58308),
	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;
;