- I think that the European Institute in China for small and medium-sized European companies is an excellent Commission initiative.
- Jag anser att det europeiska institutet i Kina för små och medelstora europeiska företag är ett utmärkt initiativ från kommissionen.
- the Council should also be thinking about providing new funding for research and development in the field of energy efficiency, especially in the new European Institute of Technology.
- Det är därför nödvändigt att inte bara göra något för länderna utanför Europa - rådet bör också överväga att tillhandahålla nya medel för forskning och utveckling på energieffektivitetsområdet, särskilt vid det nya Europeiska tekniska institutet.
- Innovation, too - which is quite crucial to Europe, being at the heart of the Lisbon Strategy - is mentioned, so to speak, only in passing and in terms of the European Institute of Technology and the Seventh Research Framework Programme.
- Också innovation - som är helt avgörande för Europa och står i centrum för Lissabonstrategin - nämns så att säga endast i förbigående i samband med Europeiska tekniska institutet och sjunde ramprogrammet för forskning.
- With regard, first of all, to the European Institute of Technology - and as Prime Minister Vanhanen pointed out - the European Council gave the green light - not the orange light, but the green light - to the initiative at the end of the Lahti summit.
- Som statsminister Matti Vanhanen även påpekade gav Europeiska rådet först och främst klartecken utan tvekan klartecken till initiativet om ett Europeiskt tekniskt institut i slutet av toppmötet i Lahtis.
- On this subject, allow me to point out to you that, on the basis of our informal contacts, the private sector has a great interest in financing certain actions to be taken by the European Institute of Technology, a state of affairs that is, moreover, only to be expected since the same ideas are to be found in many of our Member States.
- I det sammanhanget vill jag påpeka för er att den privata sektorn är mycket intresserad av att med utgångspunkt i våra informella förbindelser finansiera en viss del av verksamheten vid Europeiska tekniska institutet.
- A number of our countries have major institutions in the form of great universities, but it is only now that we have set up the European Research Council, which is an institution crucial to implementing the Seventh Research Framework Programme, and the European Institute of Technology, which is an institution specifically founded on the idea of networks with a view to giving a European impetus and perspective to innovation, research and teaching focused on excellence.
- Det är dock först nu som vi har inrättat Europeiska forskningsrådet, en institution som har mycket stor betydelse för genomförandet av det sjunde ramprogrammet för forskning, och Europeiska tekniska institutet, en särskild nätverksinstitution som inrättats i syfte att ge framstående europeisk innovation, forskning och undervisning en skjuts framåt.
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 = 34909 AND
t12.lemma_id = 21311 AND
t21.lemma_id = 14553 AND
t22.lemma_id = 11582),
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;
;