- I will try not to repeat any except the necessity of incorporating the European dimension in education.
- Jag skall försöka att inte upprepa något, bortsett från nödvändigheten av att införliva den europeiska dimensionen i utbildningen.
- We want to see CSR issues incorporated in the European social dialogue, but we support too the setting up of an EU multi-stakeholder CSR forum.
- Vi vill att frågor om företagens sociala ansvar skall införlivas i den europeiska sociala dialogen, men vi stöder också inrättandet av ett flerintressentsforum i EU för företagens sociala ansvar.
- I know how hard it is to find fresh ideas and yet he has come forward not only with fresh ideas but with extremely good points that we have now tried to incorporate in our rules for the future.
- Jag vet hur svårt det är att hitta nya idéer, och ändå har han inte bara gjort detta, utan även lagt fram oerhört bra punkter som vi har försökt att införliva i våra framtida bestämmelser.
- Given that the CFR will be a longer-term project, we will have to make sure that the final definitions and rules of the Consumer Rights Directive are incorporated in the section of the CFR dealing with consumer contracts.
- Med tanke på att den gemensamma referensramen kommer att vara ett projekt på längre sikt, måste vi se till att de slutliga definitionerna och reglerna i direktivet om konsumentskydd införlivas i den del av den gemensamma referensramen som behandlar konsumentavtal.
- Finally, we took care to send a specific message to the developing countries, many of whose airlines could be exempt from the scheme due to the de minimis clause incorporated in the text of the agreement.
- Avslutningsvis var vi noga med att skicka ett särskilt budskap till utvecklingsländerna eftersom många av dessa länders flygbolag eventuellt kommer att undantas från systemet på grund av den klausul om minimistorlek som införlivades i överenskommelsen.
- A lot of her report deserves applause but she went somewhat awry when she tried to interfere in decisions that were made at Fontainebleau and were incorporated in the own resources decision, a decision which requires unanimity to change it.
- En stor del av hennes betänkande förtjänar applåder, men hon var en aning på villovägar när hon försökte blanda sig i beslut som fattades i Fontainebleau och införlivades i beslutet om egna medel, ett beslut som kräver enhällighet för att kunna förändras.
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 = 37784 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 41068 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;
;