- As the adopted report says, although the new Criminal Code, which entered into force in June 2005, has substantially improved the fundamental rights of Turkish women, the European Directives on gender equality have yet to be transposed in full.
- Liksom det står i det antagna betänkandet så har EU:s direktiv om jämställdhet ännu inte införlivats till fullo, även om den nya strafflagen, som trädde i kraft i juni 2005, har förbättrat de turkiska kvinnornas grundläggande rättigheter avsevärt.
- On the date of its entry into force, this Agreement will repeal and replace the Agreement between the European Economic Community and the Republic of Gabon on fishing off the coast of Gabon, which entered into force in December 1998.
- När avtalet träder i kraft kommer det att upphäva och ersätta det avtal mellan Europeiska ekonomiska gemenskapen och Republiken Gabon om fiske utanför Gabons kust som trädde i kraft i december 1998.
- In the meantime, it is intended that what remains of our shipbuilding industry will subsist thanks to a package of aid to research and development, which will enter into force in January, as Commissioner Monti pointed out yesterday afternoon.
- Under tiden tänker man sig att det som är kvar av vår varvsindustri skall överleva med hjälp av ett stödpaket för forskning och utveckling som kommer att träda i kraft i januari, vilket Monti i går eftermiddag berättade.
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 = 14089 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 4523 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;
;