misuse of user pages

SQL

USE commonswiki_p;#enwiki_p;#commonswiki_p;#enwiki_p;#
SELECT CONCAT('# [[User:',page_title,']]') AS page_title, page_len#, cl_to
#,GROUP_CONCAT(pl_title SEPARATOR ';')#, rev_user_text#, user_editcount
FROM page#, categorylinks#,pagelinks#, revision#, user#
WHERE /*page.page_id = revision.rev_page
#and page_title in (select pl_title from pagelinks where pl_from = 36717948)
#and page_len > 3000
and #revision.rev_user = user.user_id AND */
page_namespace = 2 AND page_is_redirect = 0#and page_title not like "%/%"
and page_len > 1000
#AND rev_parent_id = 0
#and rev_user in (select ipb_user from ipblocks)
#and page_id not in (select distinct cl_from from categorylinks where 
#                    cl_to like "Wikipedia_sockpuppets%" or cl_to like "Suspected_Wikipedia%")
#and page_id = pl_from and pl_title like "Categor%" 
#and page_id in (select distinct cl_from from categorylinks where 
#                    cl_to like "Pages%")
# externallinks
#and pl_title not in (select p2.page_title from page p2)
#and REPLACE(page_title, '_', ' ') not in (select user_name from user)
#<> rev_user_text#user_name#in (select user_name from user where user_editcount < 31)
#and user_editcount < 51
and page_id not in (select el_from from externallinks)
and page_id not in (select cl_from from categorylinks)
and page_id not in (select tl_from from templatelinks)
#and page_id = cl_from and cl_to like "Pages%"
group by page_title
ORDER BY page_len desc
limit 500
#limit 10
/*SELECT CONCAT('# [[User:', page_title, ']]') AS page_title, page_len, rev_user_text, user_editcount
FROM page, revision, user
WHERE page.page_id = revision.rev_page
and page_title in (select pl_title from pagelinks where pl_from = 36717948)
#and page_len > 3000
and revision.rev_user = user.user_id
AND page_namespace = 2 #and page_title not like "%/%"
AND rev_parent_id = 0
and user_editcount < 51
#and page_id in (select el_from from externallinks)
and rev_user in (select ipb_user from ipblocks)
and page_id not in (select distinct cl_from from categorylinks where 
                    cl_to like "Wikipedia_sockpuppets%" or cl_to like "Suspected_Wikipedia%")
and REPLACE(page_title, '_', ' ') in (select user_name from user where user_editcount < 51)
ORDER BY page_len desc*/
/*
  SELECT CONCAT('# [[User:', ar_title, ']]') AS page_title, cl_to
   FROM archive #join page on page_id=ar_page_id
   join categorylinks on ar_page_id=cl_from and ar_namespace = 2
   where cl_to like "Wikipedia_sockpuppets%" or cl_to like "Suspected_Wikipedia%"
   limit 50
   */
SQL

Checking query status...
