- the need to transform the Code into a legally binding instrument.
- behovet av att omvandla koden till ett rättsligt bindande instrument.
- If the Yugoslav Federation could indeed be transformed into a democratic constitutional state, than autonomy is, of course, also completely acceptable, but nothing more than autonomy.
- Om Förbundsrepubliken Jugoslavien verkligen skulle kunna omvandlas till en rättsstat så är autonomi naturligtvis fullt acceptabelt, inte mer än autonomi.
- This is why it is right that this piece of Swiss cheese which is full of holes is finally being transformed into something consisting of more cheese and fewer holes.
- Därför är det rätt att denna schweiziska ost som är full med hål slutligen omvandlas till något som består av mer ost och färre hål.
- It is an unusual process but one in which Parliament has to give the message from its consultation that the Brussels Convention must not merely be transformed into a regulation it has to be brought up-to-date to meet the needs of the contemporary world.
- Det är en ovanlig process, men det är en process där parlamentet efter att ha rådfrågats måste förmedla budskapet att Brysselkonventionen inte endast måste omvandlas till en förordning utan även uppdateras för att svara mot behoven i dagens värld.
- By drawing successfully on the structural funds, it was able to transform itself from the poorest region of Europe into one of the richest and to send aid from the European Solidarity Fund to those most in need.
- Genom att framgångsrikt stödja sig på strukturfonderna har man kunnat omvandla sig själv från den fattigaste regionen i Europa till en av de rikaste, och till att kunna ge bistånd genom Europeiska unionens solidaritetsfond till dem som är i störst behov av det.
- I voted in favour of the resolution on the European integration process of Serbia and on the Stabilisation and Association Agreement with the European Union because I believe that constructive approaches in regional cooperation and good relations with neighbouring countries are essential elements of the stabilisation and association process, and will play a decisive role in the process of transforming the Western Balkans into an area of long-term stability and sustainable development.
- Bakgrunden är att jag anser att en konstruktiv inställning till regionalt samarbete och goda grannförbindelser är ett viktigt inslag i stabiliserings- och associeringsprocessen som är av avgörande betydelse för att omvandla västra Balkan till ett område med varaktig stabilitet och hållbar utveckling.
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 = 58211 AND
t12.lemma_id = 46775 AND
t21.lemma_id = 3715 AND
t22.lemma_id = 31946),
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;
;