From the sept dump -- the page_counter seems a bit low doesn't it???
Sticking my query and results inline to make sure I'm sane....
mysql> select page_id, page_title, page_counter, page_touched from page where page_namespace = 0 and page_is_redirect = 0 and page_counter != 0 and page_touched > 20070401081635 order by page_counter desc limit 10;
+---------+------------------------+--------------+----------------+ | page_id | page_title | page_counter | page_touched | +---------+------------------------+--------------+----------------+ | 6658 | October_2003 | 53194 | 20070906023554 | | 10678 | List_of_French_people | 44369 | 20070907220800 | | 25422 | Deaths_in_2003 | 31832 | 20070906023330 | | 18831 | Mathematics | 30774 | 20070904214120 | | 32927 | World_War_II | 22064 | 20070908031643 | | 2749 | Aria_Giovanni | 21450 | 20070903003745 | | 22972 | Western_philosophy | 20998 | 20070905155738 | | 4015 | BASIC | 20415 | 20070905031431 | | 24961 | Prince_Albert_piercing | 19780 | 20070902144740 | | 5180 | Chemistry | 17720 | 20070908041819 | +---------+------------------------+--------------+----------------+ 10 rows in set (36.91 sec)