- It is hoped that this process will contribute to improving the social climate in particular as regards inter-ethnic and inter-religious tensions.
- Man hoppas att denna process skall medverka till att förbättra det sociala klimatet i synnerhet beträffande etniska och religiösa spänningar.
- However, the report also says, as the Chairman of my group, that this cooperation between Parliament and the Council could be improved, especially in terms of timing.
- Det fastslås dock även i betänkandet, i likhet med vad ordföranden för min grupp gör, att samarbetet mellan parlamentet och rådet kan förbättras, särskilt i fråga om timing.
- Indeed, it is already clear that the fuel used in this sector in some Member States will have to be improved in the future.
- Det står förvisso redan klart att bränslet som används på detta område i vissa medlemsstater måste förbättras i framtiden.
- It is appropriate that the Council has decided not to accept Burma’s participation in the meeting between the EU and ASEAN until the human rights situation has improved in Burma.
- Det är bra att rådet har beslutat att inte acceptera Burmas deltagande i möten mellan EU och Asean till dess att situationen för de mänskliga rättigheterna har förbättrats i Burma.
- Mrs Jöns, we particularly value your report’s support for the application of the open coordination method in order to improve health care for the elderly in the countries of the Union.
- Vi värdesätter särskilt att ni i betänkandet stöder tillämpningen av den öppna samordningsmetoden för att förbättra hälso- och sjukvården och äldreomsorgen i unionens medlemsstater.
- This directive, part of a package of measures aimed at making our use of energy more intelligent, should disseminate the existing good practice of some Member States right across the EU, and will also be very important in improving the situation in applicant countries where energy-efficient buildings could do much to help their economies as well as protecting the environment.
- Detta direktiv, som utgör en del av ett åtgärdspaket som syftar till att göra vår energianvändning mer intelligent, borde sprida den befintliga goda praxisen hos vissa medlemsstater inom hela EU, och kommer också att vara mycket viktigt när det gäller att förbättra situationen i ansökarländerna, där energieffektiva byggnader skulle kunna vara av stor betydelse när det gäller att hjälpa deras ekonomier, likväl som att skydda miljön.
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 = 34382 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 57806 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;
;