Joomla! Documentation™

SELECT REPLACE( CONCAT('[[',
 IF(`page_namespace`=14,'Category',
  IF(`page_namespace`=102,'Tutorial',
   IF(`page_namespace`=104,'Framework', ''))),':', `page_title`,'|]]'), '_', ' ') `pagename`,
`page_title`, `page_counter`
FROM `page`
WHERE `page_namespace` in (0,14,102,104)
ORDER BY `page_counter` DESC
LIMIT 20

gives something along

pagename	page_title	page_counter
Joomla! Doc Camp	Joomla!_Doc_Camp	5600
Main Page	Main_Page	2441
Upgrade Instructions	Upgrade_Instructions	1474
Doc Campers Start Here	Doc_Campers_Start_Here	1123
Upgrading to 1.0.14 RC1	Upgrading_to_1.0.14_RC1	815
JEDL	JEDL	511
. . .

Perhaps you could use: TopTenPages

Looks interesting. I'll give it a try when I have some time. It will actually give different results as it retrieves the most popular pages over the lifetime of the wiki, whereas the data currently displayed is taken from Google Analytics and covers just the previous 24 hours (roughly). Chris Davenport 14:32, 2 December 2008 (EST)