New discussions in the MILHIST-sphere, 24 hour period (enwiki)

SQL

select distinct recentchanges.rc_title,recentchanges.rc_comment,recentchanges.rc_timestamp,page.page_namespace
from recentchanges
join page on recentchanges.rc_namespace = page.page_namespace
and recentchanges.rc_title = page.page_title
join categorylinks on page.page_id=categorylinks.cl_from
where rc_timestamp >= 20150506164500
and rc_timestamp < 20150507164500 # i.e. the past 24 hours, roughly
and rc_comment like "% new section"
and rc_deleted = 0
and cl_to like "%_military_history_articles"
order by rc_timestamp desc;

SQL

Checking query status...