Learn How to Reset the 'Hits' Counter in Joomla 1.5, 2.5 and later versions
Step 1: Open PHPMyAdmin
Step 2: Click on your database name at left.
Step 3: Click on the 'SQL' Tab
Step 4: Enter the following SQL command:
"update jos_content set hits=0" and click GO. And that's done.
If you are using Joomla 2.5 or a later version, enter the following SQL command
"update abc_content SET hits = 0"
Note: Replace 'abc' with your table prefix.
This is how to reset the Hits Counter in Joomla. Hope you found this information useful.