ja: colors - Quarry

SQL

use jawiktionary_p;

SELECT p.page_title
FROM categorylinks cl, page p
WHERE TRUE
AND p.page_namespace = 0
AND p.page_is_redirect = 0
AND cl.cl_from = p.page_id
AND cl.cl_to = "日本語_色名"
ORDER BY page_random
LIMIT 1000;

use jawiki_p;

SELECT p.page_title
FROM categorylinks cl, page p
WHERE TRUE
AND p.page_namespace = 0
AND p.page_is_redirect = 0
AND cl.cl_to = "色名"
AND p.page_title <> "JIS慣用色名"
AND p.page_title <> "リンク色"
AND cl.cl_from = p.page_id
ORDER BY page_random
LIMIT 1000;
SQL

Checking query status...
