- In order to complete the common market it was unavoidable that the use of additives in foods should be coordinated.
- För att fullborda den inre marknaden var det ofrånkomligt att harmonisera användandet av tillsatser i livsmedel.
- This category will include a limited number of energy network projects with a very significant impact from the point of view of the essential criteria of energy policy, in other words, to complete the internal market and to strengthen security of supply.
- Det innebär med andra ord att fullborda den inre marknaden och förbättra säkerheten i utbudet.
- We congratulate you on the fundamental direction of the work programme, which is aimed at making Europe more competitive, at consistent pursuit of the Lisbon Agenda and at completing the market as a means towards strengthening Europe’s economy - those are the right lines along which to go if Europe is to be made stronger and fitter for globalisation.
- Vi gratulerar er till den grundläggande inriktningen i arbetsprogrammet, vars målsättning är att göra Europa mer konkurrenskraftigt genom att kontinuerligt stabilisera Lissabonmålen och fullborda marknaden som ett medel att stärka Europas ekonomi.
- For me personally, our guiding principles for the immediate development of European transport are to complete the single market, promote competition, especially by liberalising transport wherever it has not yet been liberalised, ensure all forms of transport are safe and prioritise environmental protection.
- För mig personligen är de principer som måste vara vägledande för oss i den närmaste framtiden när det gäller den europeiska transportsektorns utveckling att fullborda den inre marknaden, att främja konkurrenskraften och särskilt att främja avregleringen av sektorn där den ännu inte ägt rum, att öka säkerheten för alla transportslag samt att prioritera miljöskyddet.
- I have voted in favour of this report because I believe that the approach adopted by the Commission of making greater use of the financial support instrument for the TENs (Trans-European Networks) with a view to completing the internal market for electricity and gas is, by and large, the right one.
- Jag har givit betänkandet mitt stöd eftersom jag anser att den ansats som kommissionen antagit om att i större utsträckning använda sig av instrumentet ekonomiskt stöd för TEN (transeuropeiska nät) i syfte att fullborda den inre marknaden för elektricitet och gas i stora drag är rätt ansats.
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 = 'dobj' AND
s2.val = 'OO' AND
t11.ctag = 'VERB' AND
t21.ctag = 'VERB' AND
t12.ctag = 'NOUN' AND
t22.ctag = 'NOUN' AND
t11.lemma_id = 2388 AND
t12.lemma_id = 22833 AND
t21.lemma_id = 64321 AND
t22.lemma_id = 23925),
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;
;