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

SQL

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

SELECT  
    GROUP_CONCAT(
        CONCAT(IFNULL(cl.cl_to, '???')) SEPARATOR ', '
    ) AS name
FROM 
    categorylinks cl
WHERE true
and p.page_namespace = 0
and cl.cl_to like "日本語%"
GROUP BY 
    cl.cl_to
limit 1000;

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 cl.cl_from = p.page_id
ORDER BY p.page_random
LIMIT 1000;

SQL

Checking query status...