- We need more competition in the ICT business, and this could be encouraged by increased use of open-source code in Europe.
- Vi behöver mer konkurrens i IKT-branschen, och man skulle kunna uppmuntra till detta genom en större användning av öppen källkod i EU.
- We support the motion put forward by the three major political groups because we believe that improvements need to be made, improvements are being made, but that those improvements will be encouraged by an EU-wide approach to this whole matter.
- Vi stöder det förslag som lagts fram av de tre stora grupperna eftersom vi anser att förbättringar behöver göras, förbättringar håller på att göras, men dessa förbättringar kommer att uppmuntras genom ett tillvägagångssätt som omfattar hela EU i hela frågan.
- It is vital that the European Commission should understand once and for all that the system it has proposed - encouraging the scrapping of vessels by increasing the scrapping premium, but selecting only vessels from the Member States that have fulfilled the MAGP targets - will ultimately run seriously counter to the stated aim of the measure.
- Det är viktigt att Europeiska kommissionen en gång för alla inser att det system som den föreslagit - att uppmuntra till skrotning av fartyg genom att höja skrotningsbidraget men endast välja fartyg från medlemsstater som uppfyllt FUP-målen - till sist kommer att motarbeta det syfte som angivits för åtgärden.
show query
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 = 38361 AND
t12.lemma_id = 6140 AND
t21.lemma_id = 60068 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;
;