nlwiki Main article redirect category sort

SQL

SELECT 
	clm.cl_to AS cat, clr.cl_sortkey_prefix AS fsk,
    pr.page_namespace AS fns, pr.page_title AS ftitle, 
    pm.page_namespace AS tns, pm.page_title AS ttitle
FROM page pm, categorylinks clm, redirect, categorylinks clr, page pr, page pc, revision, actor
WHERE pm.page_id=clm.cl_from AND clm.cl_sortkey_prefix=' ' AND rd_namespace=pm.page_namespace AND rd_title=pm.page_title AND
	clr.cl_sortkey_prefix!=' ' AND clm.cl_to=clr.cl_to AND rd_from=pr.page_id AND clr.cl_from=pr.page_id AND pc.page_title=clm.cl_to AND
    pc.page_namespace=14 AND rev_parent_id=0 AND rev_page=pc.page_id AND rev_actor=actor_id AND actor_name='Bitbotje'

SQL

Checking query status...