Below are the SQL queries that you can run to reset Hits, Visits, Votes and Reviews. This is useful when you gather these data during development and testing and wish to reset it before deploying your directory to a live site:

// Reset hits
UPDATE jos_mt_links SET link_hits = 0;

// Reset visits
UPDATE jos_mt_links SET link_visited = 0;

// Reset votes
UPDATE jos_mt_links SET link_votes = 0, link_rating = 0;
DELETE FROM jos_mt_log WHERE log_type = 'vote';

// Reset Reviews
TRUNCATE TABLE jos_mt_reviews;
DELETE FROM jos_mt_log WHERE log_type IN ('review','replyreview','votereview');