Cross-wiki uploads to Commons and their deletion rates by metadata length, images only

SQL

use commonswiki_p;
select
	floor( least(metadata_length, 2000)/50 ) * 50 as metadata_length,
	sum(alive) as alive,
	count(*) - sum(alive) as dead
from (
	select
		(img_name is not null) as alive,
		length(coalesce(img_metadata, fa_metadata)) as metadata_length
	from logging
	join change_tag on log_id=ct_log_id
	left join image on img_name=log_title
	left join filearchive on fa_name=log_title
	where log_type='upload' and log_action='upload'
	and ct_tag='cross-wiki-upload'
	and (img_name is not null or fa_name is not null)
	and (img_major_mime='image' or fa_major_mime='image')
) t
group by floor( least(metadata_length, 2000)/50 );

SQL

Checking query status...