• Unfortunately, the European satellite industry is very much dominated by governments.
• Tyvärr blir den europeiska satellitindustrin starkt dominerad av myndigheterna.

• The coming years are likely to be dominated by major international financial and economic governance reforms.
• De kommande åren kommer sannolikt att domineras av omfattande internationella reformer av den finansiella och ekonomiska styrningen.

• After decades during which European action was above all dominated by economic interests, the social side has finally gained its rightful place, through the employment summit.
• Efter årtionden, då de europeiska åtgärderna framför allt dominerades av ekonomiskt intresse, har slutligen den sociala frågan gjort sig ett namn vid toppmötet för sysselsättningen.

• The setting-up of high level groups is an excellent idea in theory, but unfortunately CARS 21 was dominated by a conservative branch of industry.
• Att bilda högnivågrupper är en utmärkt idé i teorin, men tyvärr dominerades CARS 21 av en konservativ industribransch.

• Discussion of this oral question, and also of today’s resolution, has been dominated by two issues, one being the protection of minke whales and the other the trade in ivory.
• Debatten om denna muntliga fråga, och även om dagens resolution, har dominerats av två frågor:

• As has been highlighted, the highest concentration of the audiovisual market anywhere in Europe is in Italy, where the market is dominated by two players, RAI and Mediaset.
• Såsom har belysts finns den största koncentrationen av den audiovisuella marknaden i hela Europa i Italien där marknaden domineras av två aktörer, RAI och Mediaset.

• Despite the fact that the measures laid down in Regulation (EEC) No 789/89 have had positive results, they have not managed to balance the cost of production with prices on a market dominated by the enormous pressure of imports at low prices.
• Även om de åtgärder som fastställs i förordning (EEG) nr 789/89 har gett positiva resultat, har de inte lyckats justera produktionskostnaderna till priserna på en marknad som domineras av ett enormt tryck från import till låga priser.

• Now, within half a lifetime, we are entering a world which is going to be dominated by e-commerce, by new technologies and by signatures which do not exist in the old sense of the term and which therefore have to be authenticated in a new way.
• Inom loppet av en halv livstid träder vi nu in i en värld som kommer att domineras av e-handel, av nya tekniker och av underskrifter som inte existerar i ordets gamla betydelse och som därför måste verifieras på ett nytt sätt.

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