jawiktから名詞を抽出するサンプル

SQL

use jawiktionary_p;
SELECT COUNT(*)
FROM page p
WHERE p.page_namespace = 0
;

SELECT * FROM category cat WHERE cat.cat_title = "日本語_名詞";
SELECT * /* p.page_title */
FROM categorylinks cl, page p 
WHERE true
AND p.page_namespace = 0
AND cl.cl_to LIKE "日本語%"
AND "日本語_同音異義" NOT IN (SELECT clk.cl_to FROM categorylinks clk WHERE clk.cl_from = p.page_id)
AND "日本語_オノマトペ" NOT IN (SELECT clk.cl_to FROM categorylinks clk WHERE clk.cl_from = p.page_id)
AND cl.cl_from = p.page_id
ORDER BY p.page_random
LIMIT 1000;

SQL

Checking query status...