zhwiki: link from article to userpage

SQL

SELECT page_title AS "from", CONCAT(case
                                    when pl_namespace = 2 then "User:"
                                    when pl_namespace = 3 then "User talk:"
                                    end, pl_title) AS "to"
FROM pagelinks
LEFT JOIN page ON pl_from = page_id
LEFT JOIN (
	SELECT * FROM categorylinks
	WHERE cl_to = '怀疑侵犯版权页面' OR cl_to = '正在构建的条目' OR cl_to = '有声条目' OR cl_to = '条目删除候选'
) cat ON pl_from = cl_from
WHERE pl_from_namespace = 0 AND (pl_namespace = 2 OR pl_namespace = 3) AND cl_to IS NULL AND page_title != 'Wikipedia:知识问答'
SQL

Checking query status...
