- There is a ticket machine in a very dismal area.
- Det finns en biljettmaskin på en mycket mörk plats.
- In the continent as a whole there are a total of 300.
- På hela kontinenten finns det sammanlagt 300.
- In those days, there was a covenant involving industry and the municipality on building in a sustainable manner.
- På den tiden fanns det en överenskommelse mellan näringslivet och kommunen om ett hållbart byggande.
- Tourism is also in the list of subjects which do not figure as new areas of competence for the EU.
- Turism finns också på den lista över ämnen som inte nämns som ett nytt behörighetsområde för EU.
- At the same time, the Commission has taken a decision to freeze all nominations of A1 and A2 level until the new Commission is in place.
- Samtidigt har kommissionen beslutat om att stoppa alla utnämningar till A1 och A2- nivåerna tills dess att den nya kommissionen finns på plats.
- all the assets are in all the stock exchanges in New York, London, Tokyo, Frankfurt, etc. You will now collect about USD 6 trillion worth of capital.
- Alla tillgångar finns på alla börserna i New York, London, Tokyo, Frankfurt osv. Ni kommer nu att kassera in ett kapital på cirka 6 biljoner US-dollar.
- There are too many people who do not wish to reveal what is in their hidden accounts.
- Alltför många har inte lust att visa vad som finns på deras skyddade konton, och därför har det inte varit möjligt för Europa att göra något tidigare och det kommer nog att visa sig att det blir ganska besvärligt även nu.
- According to the EC Treaty it is the responsibility of the Commission to ensure that the internal control systems are in place and work effectively in practice at all levels of EU administration.
- Enligt EG-fördraget ligger det på kommissionens ansvar att se till att de interna kontrollsystemen finns på plats och fungerar effektivt i praktiken på alla nivåer inom EU:s förvaltning.
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 = 24585 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 32744 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;
;