- They also have a positive impact on the purchase of goods and services.
- De har också en positiv effekt på köp av varor och tjänster.
- Clearly, even partial harmonisation of provisions concerning conflict in the area of non-contractual obligations will have a positive impact on the operation of the Community’s internal market.
- Helt klart kommer även en partiell harmonisering av bestämmelserna om tvister på området för utomobligatoriska förpliktelser att få positiv effekt på hur gemenskapens inre marknad fungerar.
- I think that the proposal for a directive on introducing a common consolidated corporate tax base will boost the competitiveness of SMEs, in particular, by reducing obligations arising from administrative complexity and cutting high costs generated as a result of complying with different national tax systems, thereby exerting a potentially positive impact on public finances and employment.
- Detta kan få positiva effekter på de offentliga finanserna och sysselsättningen.
- I hope that in Austria in particular, lessons will have been learnt from this case about taking a sensitive approach when weighing up the interests of the economy and the environment and, therefore, that the case will have a positive impact in future.
- Jag hoppas att man framför allt i Österrike har dragit lärdom av ärendet och intar en förnuftig hållning där man väger ekonomiska och miljömässiga intressen mot varandra och att ärendet därför kan få positiva effekter i framtiden.
- The recent direction which this debate has taken is profoundly depressing for those of us who want to see a European Union which is capable of having a positive impact on the development not just of the present 15 Member States but also on the new democracies in Central and Eastern Europe which have applied for membership of our Union.
- Den senaste riktning som denna debatt har tagit är djupt nedslående för de av oss som vill se en europeisk union som kan skapa positiva effekter för utvecklingen i de nya demokratier i Central- och Östeuropa som har ansökt om medlemskap, och inte bara för utvecklingen i de nuvarande 15 medlemsstaterna.
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 = 49469 AND
t12.lemma_id = 62453 AND
t21.lemma_id = 6905 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;
;