- We seek a greater role for regions with constitutional powers.
- Vi önskar en större roll för regioner med författningsrättsliga befogenheter.
- Likewise, it is essential that consumer organisations should be given a greater role in preparing legislative proposals.
- Det är också nödvändigt att konsumentorganisationerna får en större roll i utarbetandet av lagstiftningsförslagen.
- We hope that after the Amsterdam Treaty this part of the EU’s foreign policy will play an even greater role and will help carry our message even further afield.
- Vi hoppas att denna del i unionens utrikespolitik kommer att spela en större roll efter Amsterdamfördraget, och att vår idé kommer att bära ännu längre.
- This can be done a) by introducing codecision for the common trade policy, b) by introducing an assent procedure for all external agreements and c) by according Parliament a greater role in approving and monitoring trade negotiations.
- För det tredje, en större roll för parlamentet med avseende på godkännande och övervakning av förhandlingar inom området handel.
- Now that advertising has assumed an even greater role, it is essential that we determine the criteria that enable consumers and patients to be fully aware of, and certain about, what sort of effects these medicines have.
- Nu när reklamen har fått en ännu större roll är det viktigt att vi fastställer kriterier som gör att konsumenter och patienter kan vara fullt medvetna om vilka effekter dessa mediciner har.
- I also welcome the greater role that is given to the European Parliament, being the only directly elected body at EU level and which has an even greater role now after the Lisbon Treaty - although not everybody seems to have realised that yet.
- Jag välkomnar också att parlamentet får en större roll, eftersom det är det enda direktvalda organet på EU-nivå och har en ännu större roll nu efter Lissabonfördraget - även om inte alla verkar ha insett det ännu.
- I also welcome the greater role that is given to the European Parliament, being the only directly elected body at EU level and which has an even greater role now after the Lisbon Treaty - although not everybody seems to have realised that yet.
- Jag välkomnar också att parlamentet får en större roll, eftersom det är det enda direktvalda organet på EU-nivå och har en ännu större roll nu efter Lissabonfördraget - även om inte alla verkar ha insett det ännu.
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 = 'amod' AND
s2.val = 'AT' AND
t11.ctag = 'NOUN' AND
t21.ctag = 'NOUN' AND
t12.ctag = 'ADJ' AND
t22.ctag = 'ADJ' AND
t11.lemma_id = 45217 AND
t12.lemma_id = 43163 AND
t21.lemma_id = 33482 AND
t22.lemma_id = 35323),
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;
;