Actions

Template talk

Most popular pages

From 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)