- This is the reason why the Commission is proposing this current Regulation in order to complete the 1995 ESA, otherwise known as the European System of National and Regional Accounting which is currently in force.
- Det är anledningen till att kommissionen föreslår föreliggande förordning för att komplettera ENS 1995, dvs. det nu gällande europeiska nationella och regionala räkenskapssystemet.
- On the basis of the results of a consultation launched on 23 May 2008, the European Commission has proposed a regulation on type-approval requirements for the general safety of vehicles which states that, from 2012, electronic stability control systems are to be installed in new vehicles in order significantly to improve the safety of those vehicles.
- På grundval av ett samråd som inleddes den 23 maj 2008 har kommissionen föreslagit en förordning om krav för typgodkännande av allmän säkerhet hos motorfordon.
- Secondly, the Commission proposes a regulation allowing the non-application of Article 85, for a limited period, in certain categories of agreement between airlines, decisions by associations of undertakings and concerted practices on international routes.
- För det andra föreslår kommissionen en förordning som gör det möjligt att inte tillämpa artikel 85 på vissa kategorier avtal mellan företag, beslut om samgående mellan företag och överenskommen praxis på de internationella flyglinjerna under obegränsad tid. Kommissionens beslut kan hänföra sig till gemensam planering, samordning av resurser och flygtidtabeller liksom till fördelning av intäkter, samråd om biljettpriser, fördelning av avgångs- och ankomsttider samt gemensam drift av en flygförbindelse.
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 = 28702 AND
t12.lemma_id = 41152 AND
t21.lemma_id = 6708 AND
t22.lemma_id = 8969),
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;
;