93e1024b4f0e44716f523b269dff3ebefb3d0eed
[lhc/web/wiklou.git] / maintenance / recount.sql
1 --
2 -- Recalculate the article count
3 --
4
5 SELECT @foo:=COUNT(*) FROM cur
6 WHERE cur_namespace=0 AND cur_is_redirect=0 AND cur_text like '%[[%';
7 UPDATE site_stats SET ss_good_articles=@foo;
8