- Securing access for citizens to high-quality telecommunications services at reasonable prices is of crucial importance to us.
- Säkerställandet av medborgarnas tillgång till teletjänster av hög kvalitet och till rimliga priser har för oss en avgörande betydelse.
- Under Article 33 of the Treaty establishing the European Community, the objectives of the CAP are to guarantee reasonable prices for European consumers and a fair standard of living for farmers.
- Enligt artikel 33 i EG-fördraget är målen för den gemensamma jordbrukspolitiken att garantera rimliga priser för de europeiska konsumenterna och en skälig levnadsstandard för jordbrukarna.
- Parliament is proposing, for example, that the Community should adopt a new way of thinking, involving the use of tax instruments to achieve better air quality at a reasonable price.
- Parlamentet föreslår bland annat, att man i gemenskapen skulle tillägna sig ett nytt tänkesätt, som skulle innebära att man även kunde använda sig av skatteinstrumentet för att få till stånd en bättre kvalitet till rimligt pris.
- Particularly in view of the increasingly fierce international competition resulting from globalisation, it must be our prime objective to enhance the competitiveness of European fruit and vegetable growers while safeguarding the availability to consumers of high-quality European produce at reasonable prices.
- Vårt främsta mål måste särskilt med hänsyn till den allt hårdare internationella konkurrensen till följd av globaliseringen vara att öka EU:s frukt- och grönsaksodlares konkurrensförmåga och samtidigt skydda konsumenternas tillgång till EU-produkter av hög kvalitet till rimliga priser.
- In addition to this, is the Commission ready to rethink its position on protecting intellectual property rights, in terms of ensuring that biological diversity and the transfer of knowledge are preserved, and that medical care at a reasonable price will be guaranteed in poorer countries?
- Är kommissionen vidare redo att omvärdera sin ställning när det gäller att skydda immateriella rättigheter, bevara den biologiska mångfalden och att se till att kunskapsöverföringen främjas samt att hälso- och sjukvård kan garanteras till ett rimligt pris i fattiga länder?
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 = 44454 AND
t12.lemma_id = 55720 AND
t21.lemma_id = 32275 AND
t22.lemma_id = 30231),
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;
;