Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revision | |||
| public:paste:fetch_nn.sql [2014-07-24 17:57] – 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 | ||
| + | </ | ||
