MariaDB [(none)]> SELECT TABLE_NAME, COLUMN_NAME, COLUMN_TYPE
-> FROM information_schema.COLUMNS
-> WHERE TABLE_SCHEMA='my_wiki' AND COLUMN_NAME LIKE '%_user_text'
-> ORDER BY TABLE_NAME;
+----------------------+---------------+----------------+
| TABLE_NAME | COLUMN_NAME | COLUMN_TYPE |
+----------------------+---------------+----------------+
| abuse_filter | af_user_text | varbinary(255) |
| abuse_filter_history | afh_user_text | varbinary(255) |
| abuse_filter_log | afl_user_text | varbinary(255) |
| archive | ar_user_text | varbinary(255) |
| cu_changes | cuc_user_text | varbinary(255) |
| cu_log | cul_user_text | varbinary(255) |
| filearchive | fa_user_text | varbinary(255) |
| image | img_user_text | varbinary(255) |
| logging | log_user_text | varbinary(255) |
| oldimage | oi_user_text | varbinary(255) |
| recentchanges | rc_user_text | varbinary(255) |
| revision | rev_user_text | varbinary(255) |
+----------------------+---------------+----------------+
12 rows in set (0.00 sec)
SELECT m, COUNT(*) FROM (SELECT ar_user u, CONCAT(ar_user, ' - ', ar_user_text) m FROM `archive` WHERE ar_user != 0) A GROUP BY m ORDER BY u;
SELECT m, COUNT(*) FROM (SELECT rc_user u, CONCAT(rc_user, ' - ', rc_user_text) m FROM `recentchanges` WHERE rc_user != 0) A GROUP BY m ORDER BY u;
SELECT m, COUNT(*) FROM (SELECT rev_user u, CONCAT(rev_user, ' - ', rev_user_text) m FROM `revision` WHERE rev_user != 0) A GROUP BY m ORDER BY u;
