nlwiki_p Large edits by a user

SQL

SELECT page_namespace, CONVERT(page_title USING UTF8MB4), CONVERT(cf.cl_to USING UTF8MB4), cf.commas
FROM page, (
	# fraction of pages in a category having a comma in the sortkey
	SELECT cl_to, (COUNT(*) / (cat_pages+cat_subcats+cat_files)) AS commas
	FROM categorylinks, category
	WHERE 
		cl_to=cat_title AND
		cl_sortkey_prefix REGEXP ','
	GROUP BY cl_to
	HAVING commas > 0.9 AND commas < 1
	LIMIT 250) cf, categorylinks cl
WHERE 
	page_id=cl.cl_from AND
	CONVERT(page_title USING UTF8MB4) REGEXP '^[[:alpha:]][[:alpha:]\'\\-\\.]+_[[:alpha:]\']' AND
	cl.cl_to=cf.cl_to AND 
	cl.cl_sortkey_prefix=''
ORDER BY page_namespace, page_title
SQL

Checking query status...
