- The picture is one of some positive aspects compared with previous years, combined with continuing problems.
- denna bild visar i jämförelse med de föregående åren upp positiva aspekter men även vissa bestående problem.
- There are some positive aspects, and I would like to mention one or two of them.
- Det finns positiva aspekter och låt mig peka på ett par:
- However, there are positive aspects to the recognition of qualifications among the various Member States which should be supported.
- Det finns dock positiva aspekter när det gäller erkännandet av kvalifikationer mellan de olika medlemsstaterna, och dessa aspekter bör stödjas.
- Rather than elaborating on the positive aspects of the Martens Report, I would like instead to touch on three key points that the report highlights for improving the EU-African Union partnership.
- I stället för att närmare utveckla de positiva aspekterna i Martensbetänkandet skulle jag vilja beröra tre viktiga punkter som lyfts fram i betänkandet för att förbättra partnerskapet mellan Afrikanska unionen och EU.
- I do not wish to play down the positive aspects of gene technology, but I do wish to remind the national governments and the European Commission of their responsibility.
- Med detta vill jag inte bagatellisera genteknikens positiva aspekter.
- I hope the Commission will be able to take on board the very positive aspect that I have put forward in my amendment.
- Jag hoppas att kommissionen skall kunna godkänna den mycket positiva aspekt som jag har presenterat i mitt ändringsförslag.
- This motivation, which is despicable from a human point of view, reduces the scope of the few positive aspects of the text.
- Ur mänsklig synvinkel är detta en förhatlig strävan som minskar räckvidden för de positiva aspekterna i texten.
- I note, among other positive aspects, the introduction of the possibility of continuing aid for the distillation of alcohol intended for drinking.
- Bland flera positiva aspekter noterar jag införandet av möjligheten att fortsätta med stödet till destillation av alkohol avsedd för konsumtion.
- Otherwise there are many positive aspects to the report, so overall an abstention was the correct position in the view of the UK Conservatives.
- Annars finns det många positiva aspekter i rapporten, så på det stora hela var den riktiga ståndpunkten enligt de brittiska konservativa att lägga ned vår röst.
- I do not wish to be the judge of that - it may be that you feel I stressed the positive aspects somewhat more than the negative ones.
- Jag vill inte betygsätta det, det kan ju vara er åsikt att jag har betonat de positiva aspekterna något starkare än de negativa.
- We must at the same time accentuate the positive aspects which the information society will bring, because we have before us a predictable new model for economic growth and as such it should have a positive effect on employment.
- Samtidigt bör vi betona de positiva aspekterna som informationssamhället medför, eftersom vi befinner oss inför en förutsebar ny modell av ekonomisk tillväxt, vilken bör få positiva effekter på sysselsättningen.
- You can be sure that my group, in doing this, will avail itself of one particularly positive aspect of the new instrument, namely the better opportunity given to this House to have direct input alongside the Council and the Commission, at whose insistence, significantly, trade will, in future, be included alongside the funding of development.
- Ni kan försäkra er om att min grupp i samband med detta kommer att använda sig av en särskilt positiv aspekt på det nya instrumentet, nämligen att kammaren får större tillfälle att ge sitt direkta bidrag vid sidan av rådet och kommissionen, som insisterar på att handeln i framtiden ska ingå i betydligt högre grad tillsammans med finansieringen av utvecklingen.
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 = 'amod' AND
s2.val = 'AT' AND
t11.ctag = 'NOUN' AND
t21.ctag = 'NOUN' AND
t12.ctag = 'ADJ' AND
t22.ctag = 'ADJ' AND
t11.lemma_id = 55818 AND
t12.lemma_id = 62453 AND
t21.lemma_id = 13010 AND
t22.lemma_id = 14546),
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;
;