SELECt TABLE_NAME, COUNT(*) AS CNT FROM information_schema.PARTITIONS WHERe PARTITION_NAME IS NOT NULL GROUP BY TABLE_NAME ORDER BY CNT DESC LIMIT 50

SELECt TABLE_NAME, COUNT(*) AS CNT FROM information_schema.PARTITIONS WHERe PARTITION_NAME IS NOT NULL GROUP BY TABLE_NAME ORDER BY CNT DESC LIMIT 50