en pages suspicious of receiving wrong links (excluding DAB, set index, name and surname)

SQL

USE enwiki_p;
SELECT DISTINCT CONCAT ('# [[',page_title,']]'),page_len#,tl_title
FROM revision JOIN page AS frst ON rev_page=page_id JOIN templatelinks ON page_id=tl_from
WHERE page_namespace=0
AND page_is_redirect=0
AND rev_comment LIKE concat('%moved page [[',page_title,']] to%')
AND page_id NOT IN (
  SELECT scnd.page_id
  FROM revision JOIN page AS scnd ON rev_page=scnd.page_id
  WHERE rev_comment LIKE concat('%to [[',frst.page_title,']]%')
)
AND page_id NOT IN (
  SELECT pp_page
  FROM page_props
  WHERE pp_propname = 'disambiguation'
)

#Set_index
AND tl_title NOT LIKE 'Category_handler'
AND tl_title NOT LIKE 'Dmbox'
AND tl_title NOT LIKE 'Main_other'
AND tl_title NOT LIKE 'Set_index'
AND tl_title NOT LIKE 'Set_index_article'
AND tl_title NOT LIKE 'Arguments'
AND tl_title NOT LIKE 'Category_handler'
AND tl_title NOT LIKE 'Category_handler/blacklist'
AND tl_title NOT LIKE 'Category_handler/config'
AND tl_title NOT LIKE 'Category_handler/data'
AND tl_title NOT LIKE 'Category_handler/shared'
AND tl_title NOT LIKE 'Namespace_detect/config'
AND tl_title NOT LIKE 'Namespace_detect/data'
AND tl_title NOT LIKE 'Yesno'

#Surname
AND tl_title NOT LIKE 'Surname'
AND tl_title NOT LIKE 'PAGENAMEBASE'

AND tl_title NOT LIKE 'Given_name'

AND tl_title NOT LIKE 'Animal_common_name'



AND page_len>6000

LIMIT 100;
SQL

Checking query status...
