- My own country, Ireland, maintains that there is no problem as regards nitrates but the most recent coast watch survey published in December last year displayed some quite alarming findings.
- Mitt hemland, Irland, hävdar att det inte föreligger något problem vad beträffar nitrater, men kustbevakningens senaste undersökning som publicerades i december förra året visade på några mycket oroväckande fynd.
- Ireland, for example, has published notices on this issue in the national press, and I believe this sets an example for other countries.
- Irland har bl.a. på den punkten publicerat kommunikéer i den nationella pressen och det tror jag kan vara en förebild för de övriga länderna.
- In January, the newspaper Frontier Post published a reader’s letter, following which the newspaper’s staff were taken into custody and accused of blasphemy.
- Tidningen Frontier Post publicerade i januari ett läsarbrev, varefter tidningens personal greps och anklagades för hädelse.
- In order to counter the proliferation of refusals of approval, it would be of great assistance if the Court of Auditors were to publish them in future in its annual report.
- Det skulle, för att bemöta djungeln av icke-godkända transaktioner, underlätta om revisionsrätten publicerade dem i sin årsrapport.
- Mr President, I wish to bring the attention of this Assembly to recent studies on the effects of climate change in particular, which were published in the scientific journal .
- Jag vill rikta denna församlings uppmärksamhet mot aktuella studier av effekterna av framför allt klimatförändringar, som har publicerats i den vetenskapliga tidskriften .
- We accept the decisions and recommendations made by the Supreme Court and, in reference to the article published in the New York Times, we should like to see the guidelines set out by President Bush and Secretary of State Rumsfeld followed to the letter.
- Vi är övertygade om att detta också är en ledstjärna i den nordamerikanska kultur som vi har så många band till. Vi godtar högsta domstolens avgöranden och rekommendationer och, i enlighet med den artikel som publicerades i New York Times, skulle vi vilja att de riktlinjer som president George Bush och försvarsminister Donald Rumsfeld har fastställt följs till punkt och pricka.
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 = 43784 AND
t12.lemma_id = 8748 AND
t21.lemma_id = 35745 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;
;