- I click on the country in an attempt to see what is receiving support in my region, but find no information.
- Jag klickar på landet för att försöka ta reda på vem som får stöd i min region, men hittar ingen information.
- We are therefore pleased with the support which our amendments received in the committee.
- Vi är också nöjda med det stöd som våra ändringsförslag i den frågan har fått i utskottet.
- How we looked forward, Mr Santer, to the presents that we were due to receive in Dublin!
- Hur gladde vi oss inte, Santer, för de presenter vi skulle få i Dublin!
- More recently, four people had to receive preventive injections in Dublin after an illegally imported kitten started to act strangely and bit them.
- Nyligen var fyra personer tvungna att få förebyggande injektioner i Dublin efter att en olagligt importerad kattunge börjat bete sig konstigt och bitit dem.
- The enduring truth is that Africa is the scene of bloody conflicts and that Africans spend more on arms than they receive in development aid.
- Den bestående sanningen är att Afrika är en scen för blodiga konflikter och att afrikanerna spenderar mer på vapen än de får i utvecklingsbistånd.
- A completely new issue, however, is the cyber war, which has received considerable coverage in the global media.
- Ett helt nytt problem är dock cyberkriget, som har fått stort utrymme i de globala medierna.
- We have received reassurances from Commissioner Kroes in this regard but, nonetheless, our committee has put those pointers down in this report.
- Vi har fått försäkringar från kommissionsledamot Neelie Kroes i detta avseende men ändå har vårt utskott behandlat detta i betänkandet.
- The European Commission is unwilling to recall that the eastern Länder received more than one and a half billion marks in aid from the German Government, and that included shipyards located on the Baltic.
- Europeiska kommissionen vill inte minnas att delstaterna i det forna Östtyskland fick över halvannan miljard mark i stöd från den tyska regeringen, däribland varv vid Östersjön.
- Could I also say on the broader topic of completing the internal market that, during the Finnish Presidency, we have had some very important strategy papers and they actually require a much higher priority than they are receiving in the Community at the moment.
- Låt mig också säga om den bredare fråga som rör slutförandet av den inre marknaden, att under det finska ordförandeskapet fick vi en del mycket viktiga strategidokument och de kräver faktiskt en mycket högre prioritet än vad de får i gemenskapen för tillfället.
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 = 47303 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 16661 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;
;