- I would like to turn now to the anti-fraud agreement with Philip Morris International, which comes under my portfolio.
- Jag skulle nu vilja gå över till avtalet mot bedrägerier med Philip Morris International, vilket faller under mitt område.
- A financial source and a legal basis that do not come under development policy will need to be found.
- Vi måste hitta en finansieringskälla och en rättslig grund som inte faller under utvecklingspolitiken.
- who is responsible for patrolling the search and rescue regions on the high seas that come under third-country responsibility?
- vem är ansvarig för att patrullera de marina räddningstjänstområdena utanför territorialgränserna som faller under tredjeländers ansvar?
- They are too rigid and they could paralyse the legal system, but more importantly, we are entering territory which is comes under the competence of the Member States.
- De är alldeles för stränga, det skulle kunna leda till rättsväsendets kollaps, men sist men inte minst ger vi oss dessutom in på ett område som faller under medlemsstaternas behörighet.
- Even more serious is the fact that, even though labour law comes under national powers, the Council has just subordinated respect for labour law to Community decisions, insofar as respect for labour law will now be subject to the judgments of the European Court of Justice.
- Ännu allvarligare är det, även om arbetslagstiftning faller under det nationella ansvaret, att rådet nu har underordnat arbetslagstiftningen gemenskapens beslut eftersom respekten för arbetslagstiftning nu kommer att underordnas EG-domstolens domslut.
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 = 55728 AND
t12.lemma_id = 11943 AND
t21.lemma_id = 50689 AND
t22.lemma_id = 11943),
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;
;