This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
public:paste:fetch_nn.sql [2014-07-10 20:24] – created Johannes Graën | public:paste:fetch_nn.sql [2023-09-15 20:33] (current) – external edit 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | <code postgresql fetch_nn.sql> | ||
+ | SELECT type, count(*) c | ||
+ | FROM europarl2.token | ||
+ | LEFT JOIN europarl2.type_list USING (type_id) | ||
+ | LEFT JOIN europarl2.paragraph USING (paragraph_id) | ||
+ | LEFT JOIN europarl2.text USING (text_id) | ||
+ | WHERE pos_id = | ||
+ | ( | ||
+ | SELECT pos_id | ||
+ | FROM europarl2.pos_list | ||
+ | WHERE tag = ' | ||
+ | ) | ||
+ | AND language_id = 1550 | ||
+ | GROUP BY type | ||
+ | ORDER BY c DESC | ||
+ | </ |