Dysfunctional talk pages

SQL

select page_title, count(pl_title) as links from page
left join pagelinks on pl_from = page_id and pl_namespace = 3 and pl_from_namespace = 1
where page_namespace = 1 and page_is_redirect = 0
and page_id in (
  select page_title from page where page_namespace = 0 and page_is_redirect = 1
)
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 = 3 and pl_from_namespace = 1
)
*/
-- and page_title not like '%/%' -- and page_len > 20 and page_len < 100
group by page_id
-- having links < 2
order by links desc
-- limit 100
SQL

Checking query status...
