Dysfunctional talk pages

SQL

/*
select page_title from page where page_namespace = 1 and page_is_redirect = 0
and page_id not in (
  select tl_from from templatelinks
*/
  /*
  where tl_target_id in (
    select lt_id from linktarget 
    where lt_title in ('Old_RfD', 'Old_XfD_multi', 'Old_MfD', 'Archive', 'Talk_page_of_redirect') and lt_namespace = 10 
    or lt_title = 'WikiProject_banner' and lt_namespace = 828
  )
  */
/*
)
and page_id in (
  select pl_from from pagelinks where pl_namespace = 2 and pl_from_namespace = 1
)
and page_title not like '%/%' -- and page_len > 20 and page_len < 100
limit 100
*/

select pl_namespace, pl_title from pagelinks join page on pl_from = page_id and pl_from_namespace = 1
where page_title = 'Patent_troll/Archive_2' and page_namespace = 1
SQL

Checking query status...
