- In the report, one discovers that the rules regarding the awarding of subsidies are practically non-existent;
- I rapporten upptäcker man bl.a. att reglerna för beviljande av anslag är i stort sett obefintliga.
- I am therefore very grateful that we are now to chart antibiotic resistance to the zoonoses we discover in Europe.
- Därför är jag mycket tacksam över att vi nu skall kartlägga antibiotikaresistensen hos de zoonoser vi upptäcker i Europa.
- We must remember this was discovered in January 1999 and the Commission was only able to take action after a period of months and a good deal of obfuscation.
- Vi måste komma ihåg att detta upptäcktes i januari 1999, och kommissionen kunde vidta åtgärder först efter en period på flera månader och en hel del mörkläggning.
- They know that if we are discovering sick animals in France, it is because we are looking for them, as was said earlier.
- De vet att vi upptäcker sjuka djur i Frankrike eftersom vi söker efter dem, vilket påpekades för en stund sedan.
- Mr President, as the previous speaker said, a few weeks ago poisoned cattle were discovered in the area where the railway tunnel is being built.
- Det är som föregående talare sade, att för några veckor sedan upptäcktes förgiftad boskap i det område där denna järnvägstunnel byggs.
- Another 96, 000 tonnes of CFCs, and in July of this year it was discovered that 150 tonnes of these dangerous substances were being dealt in illegally and that they come particularly from China and Russia.
- Ytterligare 96 000 ton freoner och i juli upptäcktes att illegal handel drivits med 150 ton av dessa farliga ämnen och de kommer särskilt från Kina och Ryssland.
- On the other hand, we must not forget about the alarm that was caused when thousands of tubes of counterfeit toothpaste, some of them manufactured in China, were discovered in Spain, and containing doses of toxic diethylene glycol far in excess of European standards.
- Å andra sidan får vi inte glömma den oro som orsakades av att tusentals förfalskade tandkrämstuber, varav en del tillverkats i Kina, upptäcktes i Spanien.
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 = 22333 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 15857 AND
t22.lemma_id = 26495),
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;
;