User pages with Infobox person template not edited by user

Gives  list of all user pages which need deletion, as they are not edited by the concerned user, following inclusion of Infobox person template by other wikipedians.

SQL

use tewiki_p;
SELECT  DISTINCT page_title
FROM page
LEFT JOIN templatelinks
		ON tl_from = page_id
LEFT JOIN  revision ON revision.rev_page=page.page_id
WHERE  tl_namespace = 10 AND tl_title = "Infobox_person" AND  page.page_namespace = 2 AND page_is_redirect =0   AND page_title NOT REGEXP ".+[/|.].+"   AND page_title NOT IN
	(SELECT rev_user_text
 	FROM page
 	LEFT JOIN  revision ON revision.rev_page=page.page_id
 	WHERE page_namespace = 2 AND page_is_redirect =0  AND rev_user!=0 AND page_title NOT REGEXP ".+[/|.].+") 
GROUP BY page_title, rev_user_text
ORDER BY page_title,rev_user_text

SQL

Checking query status...