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
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 page_title
 	FROM page
 	RIGHT JOIN  revision ON revision.rev_page=page.page_id
 	WHERE page_namespace = 2 AND page_is_redirect =0  AND rev_user!=0 AND (REPLACE(page_title,"_"," ")  = rev_user_text) AND  page_title NOT REGEXP ".+[/|.].+") 
GROUP BY page_title
ORDER BY page_title

SQL

Checking query status...