- Let us use the opportunity to show Europeans that the European Union is looking ahead, shaping its policies to meet tomorrow’s challenges and equipping itself with the right tools.
- Låt oss använda detta tillfälle för att visa medborgarna att EU ser framåt, formar sin politik för att möta morgondagens utmaningar och utrustar sig med de rätta verktygen.
- I applaud in particular the introduction of an obligation to equip vehicles with a Brake Assist System (BAS), which will help to reduce the number of collisions between vehicles and pedestrians.
- Jag berömmer särskilt införandet av kravet att utrusta alla fordon med bromsassistanssystem (BAS), vilket kommer bidra till att minska antalet kollisioner mellan fordon och fotgängare.
- In the view of the Commission, the current deadlines of 5 May 2005 for Member States being able to issue driver cards and 5 August 2005 for the requirement that new vehicles be equipped with a digital tachograph should remain in place.
- från den 5 maj 2005 skall medlemsstaterna kunna utfärda körkort och från den 5 augusti 2005 skall nya fordon utrustas med en digital färdskrivare.
- Exchanging old driving licences will not make licence holders observe the highway code any more diligently, nor will it result in vehicles being equipped with better safety devices, but it will improve freedom of movement and considerably enhance people’s security and safety, whether on or off the road.
- Att byta ut gamla körkort kommer inte att leda till att körkortsinnehavarna följer vägtrafikbestämmelserna mer noggrant, och det kommer inte heller att leda till att fordonen utrustas med bättre säkerhetsanordningar, men däremot kommer det att förbättra den fria rörligheten och avsevärt öka människornas skydd och säkerhet, såväl på som utanför vägarna.
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 = 18326 AND
t12.lemma_id = 12425 AND
t21.lemma_id = 6039 AND
t22.lemma_id = 57357),
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;
;