- Let us not forget that in the administration of a common fisheries policy the statistical analysis used must include the social aspect.
- Förvaltningen av en gemensam fiskeripolitik, det får vi inte glömma, måste låta de statistiska analyserna omfatta en social dimension.
- So the COM proposal for the graduation of Vietnam is based on extensive objectives and statistical analyses applied in the same way to all GSP+ beneficiaries.
- Så kommissionens förslag om gradering av produkter från Vietnam bygger på omfattande målsättningar och statistiska analyser som tillämpas på samma sätt för alla GSP+-förmånsländer.
- Madam President, I have taken the liberty of carrying out a brief statistical analysis of the Commission work and legislative programme, and have counted 57 non-legislative acts and only 37 of a legislative nature, so it would appear that the vast majority are non-legislative, and that strikes me as confirming a trend that has made itself clearly visible in recent times, that being that the Commission is more inclined to take refuge in non-legislative acts such as Green Papers, White Papers, communications, and so on, thereby in part circumventing its own legislature.
- Jag har tagit mig friheten att genomföra en kortfattad statistisk analys av kommissionens arbets- och lagstiftningsprogram, och jag har räknat till 57 akter som inte är rättsakter och endast 37 rättsakter, så det verkar som om den stora majoriteten inte är rättsakter, och som jag ser det är detta en bekräftelse på en trend som blivit mycket tydlig på senare tid, nämligen att kommissionen är mer benägen att använda sig av akter som inte är rättsakter, som till exempel grönböcker, vitböcker, meddelanden och så vidare, och därigenom delvis kringgå sin egen lagstiftande makt.
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 = 16902 AND
t12.lemma_id = 17447 AND
t21.lemma_id = 43579 AND
t22.lemma_id = 65144),
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;
;