maintenance/recount.sql

   1 --
   2 -- Recalculate the article count
   3 --
   4
   5 SELECT @foo:=COUNT(*) FROM /*$wgDBprefix*/cur
   6   WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text like '%[[%';
   7 UPDATE /*$wgDBprefix*/site_stats SET ss_good_articles=@foo;
   8