- Firstly, efficient controls are needed in Community waters and ports in order to ensure safety in maritime transport, particularly where oil and dangerous goods are involved.
- För det första har vi säkerheten vid sjötransporter där det behövs effektiva kontroller i gemenskapsvattnen och i dess hamnar, särskilt när det gäller bränsletransporter och farligt gods.
- Investments are needed in the Member States, but they must be investments that pay off in the long term.
- Investeringar behövs i medlemsstaterna, men det måste vara investeringar som betalar sig på lång sikt.
- In the WTO framework we urgently need better rules designed to outlaw, as far as possible, trade-distorting measures such as export duties.
- I WTO:s ramverk behövs det omedelbart bättre regler som så långt det är möjligt förbjuder handelshindrande åtgärder såsom exporttullar.
- In this case, we do not need a debate about the allocation of posts, but clear rules for the financial markets in the European Union.
- I detta fall behövs ingen debatt om tilldelningen av poster utan tydliga regler för EU:s finansmarknader.
- In addition, this report shows a degree of naivety when it calls for the European blue card scheme to discourage the attraction of any Africans from sectors where they are needed in Africa.
- Dessutom visar detta betänkande en viss naivitet när man kräver ett EU-system med blå kort för att motverka att afrikaner dras från sektorer där de behövs i Afrika.
- How can efficient civil protection be organised when public goods and services needed in critical situations, such as the fire brigade, are being transferred to private individuals or turned into repressive mechanisms?
- Hur skall vi kunna organisera en effektiv räddningstjänst när offentliga tjänster som behövs i kritiska situationer, till exempel brandkåren, privatiseras eller omvandlas till mekanismer som hämmar utvecklingen?
- I plead here to the Commission to look closely at how best to involve our work with that of the United Nations, particularly UNHCR and the World Health Organization, for only the UN, can command the volumes of support that are needed in such a situation, in terms of food, clothing, shelter and the provision of basic needs.
- Jag ber här kommissionen att titta noga på hur vi på bästa sätt kan införliva vårt arbete med FN:s arbete, särskilt UNHCR och Världshälsoorganisationen, för enbart FN kan uppbringa stöd i den omfattning som behövs i en sådan situation, när det gäller mat, kläder, logi och försörjningen av grundläggande behov.
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 = 18487 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 18711 AND
t22.lemma_id = 26495),
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;
;