maintenance/recount.sql


1
2
3
4
5
6
7
8

-- 
-- Recalculate the article count
-- 

SELECT @foo:=COUNT(*) FROM /*$wgDBprefix*/cur
  WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text like '%[[%';
UPDATE /*$wgDBprefix*/site_stats SET ss_good_articles=@foo, ss_total_pages=-1, ss_users=-1, ss_admins=-1;