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
)
and page_title not like '%/%' -- and page_len > 20 and page_len < 100
limit 100
SQL

Checking query status...
