Detect tables which has hits feature in Joomla core

detect-tables-which-has-hits-feature-in-joomla-core.sql

/**
* Use the information table of MySQL to fetch corresponding column name
*/
SELECT CONCAT(a.TABLE_SCHEMA,'.',a.TABLE_NAME,'.',a.COLUMN_NAME) AS c
FROM information_schema.COLUMNS AS a
WHERE a.COLUMN_NAME = 'hits';

query-to-generate-queries-to-reset-hits.sql

/**
* Based on previous query, we can improve it to generate actual useful queries to execute later
*/
SELECT CONCAT('UPDATE ', a.TABLE_SCHEMA,'.',a.TABLE_NAME,' AS b ','SET b.',a.COLUMN_NAME, '=0 WHERE true;') AS c
FROM information_schema.COLUMNS AS a
WHERE a.COLUMN_NAME = 'hits';