- The Council retained some of these but did not go so far as to go back to the restrictive clauses demanded by the European Parliament for 2005.
- Rådet godtog en del av dem, men det gick inte så långt som att ta med de tvingande bestämmelser som Europaparlamentet hade krävt för år 2005.
- For these reasons, I have voted against the Parliament resolution on the WTO ministerial conference and my Group has proposed that a new mandate should be demanded for WTO negotiations.
- Detta är motivet till att jag röstade emot parlamentets resolution om ministermötet om WTO, och till att min politiska grupp har föreslagit att vi ska kräva ett nytt mandat för WTO-förhandlingarna.
- Both Piedmontese and the other two minority languages have suffered and continue to suffer now, in 2003, from serious oppression by the centralist Italian state, and this is certainly one of the reasons for fighting to obtain federalism in Italy without delay, and demand full freedom and independence for our lovely region of Piedmont and for a free Padania.
- Både piemontesiska och de övriga två minoritetsspråken har utsatts och utsätts än i dag, år 2003, för ett betungande förtryck från den italienska centralmaktens sida och detta är ett av skälen till vår kamp för att snarast få federalism i Italien och till att vi kräver full frihet och självständighet för vårt vackra Piemonte och ett fritt Padanien.
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 = 46166 AND
t12.lemma_id = 36421 AND
t21.lemma_id = 43866 AND
t22.lemma_id = 64468),
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;
;