MariaDB [enwiki_p]> SELECT NOW() AS time, COUNT(*) AS number_of_subpages FROM page WHERE page_title LIKE "Cite\_pmid/%" AND page_namespace = 10; +---------------------+--------------------+ | time | number_of_subpages | +---------------------+--------------------+ | 2015-12-19 07:32:19 | 37204 | +---------------------+--------------------+ 1 row in set (0.02 sec)