Bikoret draft - Quarry

SQL

set @max = 30000000;
select  img_size, img_media_type, img_name from hewiki_p.image where img_size > @max and img_media_type in ("UNKNOWN", "BITMAP", "DRAWING");
select count(*)
#img_size, img_media_type, img_name 
from commonswiki_p.image
where img_size > @max
and img_media_type in ("UNKNOWN", "BITMAP", "DRAWING")
and not (img_name like "%.djvu")
#and not (img_name like "%.tif%")
#and not (img_name like "%.TIF%")
#and not (img_name like "%.jp%g")
#and not (img_name like "%.JP%G")
#and not (img_name like "%.png")
#and not (img_name like "%.PNG")
#and not (img_name like "%.svg")
#and not (img_name like "%.gif")
#and not (img_name like "%.GIF")
#and not (img_name like "%.xcf")
SQL

Checking query status...
