root@db1159.eqiad.wmnet[dbbackups]> select max(size), file_path FROM backup_files where file_name like '%watchlist%' and backup_id > 9000 GROUP BY file_path ORDER BY max(size) desc limit 10; +-------------+--------------+ | max(size) | file_path | +-------------+--------------+ | 43645927424 | enwiki | | 38474350592 | commonswiki | | 11064573952 | wikidatawiki | | 7017070592 | dewiki | | 5356126208 | ruwiki | | 5280628736 | frwiki | | 5045747712 | metawiki | | 4823449600 | ruwikinews | | 4156555264 | eswiki | | 3955228672 | arwiki | +-------------+--------------+ 10 rows in set (24.510 sec)