- The new Slovak Government is ready to go the extra mile.
- Den slovakiska regeringen vill verkligen göra sitt allra bästa.
- We are asking the Slovak Government to pursue a critical policy on energy, an energy policy aimed at shutting down unsafe nuclear reactors.
- Vi kräver en kritisk energipolitik av den slovakiska regeringen.
- With the language policy of the former Slovak Government and the current media law in Hungary, I doubt that Márai would ever have existed.
- Under den före detta slovakiska regeringens språkpolitik och den nuvarande medielagstiftningen i Ungern betvivlar jag att Márai skulle ha kunnat existera.
- However, before the Commission and the EBRD had announced their decision about the loans, the Slovak government decided to withdraw the loan requests and use other resources to finance the installation of the reactors.
- Dock beslutade den slovakiska regeringen att dra tillbaka sina låneansökningar, innan kommissionen och EBRD hade uttalat sig om lånen, och finansiera installerandet av reaktorerna med andra medel.
- I therefore call upon the Commission to review the grounds for the carbon dioxide quota awarded to Slovakia, because if the Slovak government is racking its brains about a giant coal-fired power plant using obsolete technology in 2008, it means that the Union’s incentive system is not working.
- Jag uppmanar därför kommissionen att se över gurnderna för de koldioxidkvoter som tilldelas Slovakien, för om det är så att den slovakiska regeringen bråkar sin hjärna över ett gigantiskt koleldat kraftverk med gammal teknik år 2008, då betyder det att unionens incitamentsystem inte fungerar.
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 = 41286 AND
t12.lemma_id = 36903 AND
t21.lemma_id = 46843 AND
t22.lemma_id = 55418),
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;
;