- Transatlantic relations covers a broader spectrum than just economic relations, which must be taken into account when we address this issue.
- De transatlantiska förbindelserna omfattar ett bredare spektrum än enbart ekonomiska förbindelser.
- This is a broad political field which includes highly explosive smaller issues and covering this broad spectrum for the twelve different candidate countries from central Europe, Malta and Cyprus was a huge challenge.
- Det är ett stort politiskt område med mycket sprängstoff i detaljfrågorna, och det är en stor utmaning att täcka detta breda spektrum för de tolv olika kandidatländerna från Centraleuropa, Malta och Cypern.
- Mr Blak, scrutiny of the agencies now covers a very broad spectrum of different activities, and your work, for which the Commission thanks you, was therefore very wide ranging.
- Kontrollen av byråerna omfattar numera ett mycket brett spektrum av olika verksamhetsområden, och därför har det arbete som kommissionen vill tacka er för varit mycket omfattande.
- Will it just be a question of how a common fisheries policy should change for the future, or will they actually consider the broad spectrum of alternatives which might go from complete renationalization - not something that I would advocate - but through regionalization and into a completely unified European fleet.
- Kommer det endast att vara frågor om hur fiskeripolitiken skall förändras inför framtiden eller kommer de faktiskt att beakta det breda spektrum av alternativ som kan gå från fullständig åternationalisering - ingenting som jag skulle vilja förespråka - men genom regionalisering till en helt enhetlig europeisk flotta.
- The European budget covers a broad spectrum of expenditure programmes, from the marketing subsidy for dairy products to slaughtering premiums for cattle, bee-keeping subsidies, restructuring measures in the fisheries sector, youth exchange programmes and support for research in biotechnology, not to mention aid to provide schooling for girls in Afghanistan or food aid in Southern Africa.
- EU:s budget omfattar ju ett brett spektrum av utgiftsprogram, från säljfrämjande åtgärder för mjölkprodukter via slaktpremier för nöt, stöd för biodling, omstruktureringsåtgärder i fiskesektorn, utbytesprogram för ungdomar och stöd för bioteknisk forskning till främjandet av skolutbildning för flickor i Afghanistan eller livsmedelsstöd i södra Afrika.
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 = 8174 AND
t12.lemma_id = 40903 AND
t21.lemma_id = 14776 AND
t22.lemma_id = 30824),
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;
;