- It was vital to take account of the interests of each party, including the interests of the regions that, as a result of their geographical situation, are extremely dependent on aviation for their development or for their links with mainland territories.
- Det var viktigt att ta hänsyn till alla parters intressen, inklusive regionernas intressen, eftersom dessa på grund av sin geografiska situation är extremt beroende av luftfart för sin utveckling och för sina band till fastlandet.
- Even if most of the attention is turned to Georgia, taking into consideration the geographical situation of Azerbaijan, I believe we should also have in view the need to establish an EU - Azerbaijan partnership for supporting and continuing the EU’s energy projects.
- Även om störst uppmärksamhet riktas mot Georgien, anser jag att vi också, med tanke på Azerbajdzjans geografiska situation, bör beakta behovet av att etablera ett samarbete mellan EU och Azerbajdzjan för att understödja och fortsätta EU:s energiprojekt.
- First, the huge disparities between the networks in the various countries and, more importantly, the geographical situations of certain Member States or regions make it very hard for them to change the system quickly and, secondly, forcing the change, as it were, on these Member States would not result in any significant benefit either to the countries in question or the Community as a whole.
- Å ena sidan gör de stora skillnaderna mellan näten i de olika länderna och framför allt vissa medlemsstaters eller områdens speciella geografiska situation att det är svårt att snabbt förändra systemet, och å andra sidan skulle ett brådstörtat genomförande av förändringen i dessa stater inte vara till någon egentlig nytta vare sig för staterna eller för gemenskapen.
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 = 12815 AND
t12.lemma_id = 53072 AND
t21.lemma_id = 12815 AND
t22.lemma_id = 28303),
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;
;