- Cohesion policy strives for equality, yet privatising directives, such as the Postal Directive, have had the effect of further eliminating services to poorly serviced areas.
- Inom ramen för sammanhållningspolitiken strävar man efter jämlikhet, ändå har privatiseringsdirektiv, som postdirektivet, lett till att ytterligare tjänster tas bort i dåligt betjänade områden.
- A smoke-free environment is a goal we should strive for, but in future we will need to pay more attention to ensuring that the action we take is reasonable and that compliance with the law can be monitored.
- En rökfri miljö är ett mål som vi bör sträva efter men i framtiden kommer vi att behöva fästa större uppmärksamhet vid att se till att de åtgärder vi vidtar är rimliga och att efterlevnaden av lagen kan övervakas.
- Certainly, in striving for perfection we may lose the opportunity to achieve something that is within our grasp, but it is important to continue along the road we have embarked on and to make a decision before the European elections in 2009.
- Genom att sträva efter perfektion kan vi faktiskt missa tillfället att åstadkomma något som är inom räckhåll, men det viktiga är att vi fortsätter längs den väg som vi har slagit in på och fattar ett beslut före valet till Europaparlamentet 2009.
- It is an auspicious moment for the scientific community in particular, because this is, after all, the third most important programme of the European Union and one that enables the scientific community to take on a European dimension and motivates it to strive for excellence.
- Det är glädjande i synnerhet för forskarvärlden eftersom detta trots allt är det tredje viktigaste programmet för EU och eftersom det gör det möjligt för forskarvärlden att arbeta med en europeisk dimension som motiverar den att sträva efter att bli världsledande.
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 = 5162 AND
t12.lemma_id = 36421 AND
t21.lemma_id = 64235 AND
t22.lemma_id = 39707),
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;
;