- In the morning, before I arrived at the prison and death row, I gave a press conference.
- På morgonen innan jag kom till fängelset och dödens korridorer gav jag en presskonferens.
- It is therefore vital that research in the life sciences is given the highest priority in the European Research Area.
- Det är därför av yttersta vikt att biovetenskaplig forskning ges högsta prioritet på det europeiska området för forskningsverksamhet.
- We also want access to be given to the European labour market in a controlled manner and for immigrants’ rights to be respected.
- Vi vill också att tillträde till den europeiska arbetsmarknaden ska ges på ett kontrollerat sätt och att invandrarnas rättigheter ska respekteras.
- Next, we cannot make more concessions or give more compensation in the area of agriculture, and the current jobs in the fisheries industry must be guaranteed.
- Sedan får vi inte göra fler eftergifter eller ge fler kompensationer på jordbruksområdet och de nuvarande arbetstillfällena måste garanteras inom fiskerinäringen.
- I congratulate the Commission on the idea of introducing a scoreboard, which has already given good results in the fields of the internal market and the area of freedom, security and justice.
- Jag gratulerar kommissionen till förslaget om att införa en resultattavla, som redan har gett goda resultat på den inre marknaden och området med frihet, säkerhet och rättvisa.
- Therefore, I share your concerns, and not only do I share them, but also, on behalf of all of you, I am passing them on to those governments at the same time as giving them money in the name of the European Union:
- Jag delar därför er oro, och jag inte bara delar den, utan på era vägnar för jag den också vidare till dessa regeringar samtidigt som jag ger dem pengar på EU:s vägnar:
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 = 59859 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 54254 AND
t22.lemma_id = 40192),
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;
;