Untitled query #87637

SQL

select page_namespace,page_title from page talk where page_content_model='flow-board' and page_namespace != 2600
and (select count(*) from page sub where sub.page_namespace=talk.page_namespace and sub.page_title like concat(talk.page_title,"/%")
and sub.page_title != concat(talk.page_title,"/Archive")
and sub.page_title != concat(talk.page_title,"/Archive_1")
and sub.page_title != concat(talk.page_title,"/LQT_Archive_1")
and not exists (select 1 from page bsub where bsub.page_namespace=sub.page_namespace-1 and bsub.page_title=sub.page_title)
)
SQL

Checking query status...
