Untitled query #11321

This query is marked as a draft This query has been published by NKohli (WMF).
SQL

select 'aawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'abwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from abwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'abwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from abwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'acewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from acewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'advisorywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from advisorywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'adywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from adywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'afwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from afwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'afwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from afwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'afwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from afwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'afwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from afwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'akwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from akwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'akwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from akwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'akwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from akwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'alswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from alswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'alswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from alswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'alswikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from alswikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'alswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from alswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'amwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from amwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'amwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from amwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'amwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from amwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'angwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from angwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'angwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from angwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'angwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from angwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'angwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from angwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'angwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from angwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'anwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from anwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'anwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from anwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arbcom_dewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arbcom_dewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arbcom_enwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arbcom_enwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arbcom_fiwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arbcom_fiwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arbcom_nlwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arbcom_nlwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arcwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arcwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'arzwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from arzwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'astwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from astwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'astwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from astwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'astwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from astwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'astwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from astwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aswikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aswikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'auditcomwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from auditcomwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'avwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from avwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'avwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from avwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aywikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aywikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'aywiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from aywiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azbwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azbwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'azwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from azwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'barwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from barwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bat_smgwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bat_smgwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bclwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bclwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bdwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bdwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'be_x_oldwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from be_x_oldwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'betawikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from betawikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bewiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bewiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bgwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bgwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bhwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bhwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bhwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bhwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'biwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from biwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'biwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from biwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'biwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from biwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bjnwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bjnwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bmwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bmwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bmwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bmwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bmwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bmwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bmwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bmwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bnwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bnwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bnwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bnwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bnwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bnwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bnwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bnwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'boardgovcomwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from boardgovcomwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'boardwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from boardwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bowikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bowikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bpywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bpywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'brwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from brwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'brwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from brwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'brwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from brwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'brwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from brwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'brwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from brwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bugwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bugwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'bxrwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from bxrwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cbk_zamwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cbk_zamwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cdowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cdowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cebwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cebwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chairwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chairwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chapcomwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chapcomwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'checkuserwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from checkuserwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chrwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chrwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chrwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chrwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'chywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from chywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ckbwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ckbwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cnwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cnwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'collabwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from collabwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cowikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cowikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cowikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cowikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cowikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cowikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'crhwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from crhwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'crwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from crwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'crwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from crwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'crwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from crwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'csbwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from csbwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'csbwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from csbwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cuwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cuwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cvwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cvwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cvwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cvwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cywikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cywikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cywikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cywikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cywikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cywikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'cywiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from cywiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dawikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dawikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dewiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dewiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'diqwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from diqwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dkwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dkwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'donatewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from donatewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dsbwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dsbwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dvwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dvwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dvwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dvwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dzwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dzwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'dzwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from dzwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'elwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from elwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'emlwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from emlwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'enwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from enwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'eswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from eswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'etwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from etwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'euwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from euwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'euwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from euwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'euwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from euwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'euwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from euwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'execwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from execwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'extwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from extwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fdcwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fdcwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ffwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ffwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiu_vrowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiu_vrowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fiwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fiwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fjwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fjwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fjwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fjwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'foundationwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from foundationwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fowikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fowikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frpwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frpwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frrwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frrwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'frwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from frwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'furwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from furwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fywikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fywikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'fywiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from fywiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gagwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gagwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ganwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ganwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gdwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gdwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gdwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gdwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glkwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glkwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'glwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from glwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gnwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gnwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gnwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gnwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gnwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gnwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gomwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gomwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gotwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gotwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gotwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gotwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'grantswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from grantswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'guwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from guwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'guwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from guwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'guwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from guwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'guwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from guwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'guwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from guwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gvwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gvwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'gvwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from gvwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hakwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hakwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hawwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hawwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hewiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hewiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hifwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hifwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hiwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hiwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hiwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hiwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hiwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hiwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hiwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hiwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'howiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from howiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hrwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hrwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hrwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hrwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hrwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hrwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hrwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hrwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hrwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hrwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hsbwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hsbwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hsbwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hsbwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'htwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from htwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'htwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from htwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'huwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from huwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hywiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hywiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hywikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hywikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hywikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hywikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hywikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hywikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hywiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hywiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'hzwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from hzwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'idwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from idwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'idwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from idwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'idwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from idwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'idwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from idwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'idwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from idwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iegcomwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iegcomwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iewiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iewiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iewikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iewikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iewiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iewiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'igwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from igwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iiwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iiwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ikwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ikwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ikwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ikwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ilowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ilowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'ilwikimedia' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from ilwikimedia.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'incubatorwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from incubatorwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'internalwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from internalwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iswiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iswiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iswikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iswikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iswikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iswikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iswikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iswikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iswiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iswiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwikivoyage' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwikivoyage.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'itwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from itwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iuwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iuwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'iuwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from iuwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawikinews' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawikinews.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawikisource' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawikisource.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawikiversity' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawikiversity.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jbowiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jbowiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jbowiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jbowiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jvwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jvwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'jvwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from jvwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kaawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kaawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kabwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kabwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kawiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kawiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kawikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kawikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kawikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kawikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kawiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kawiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kbdwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kbdwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kgwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kgwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kiwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kiwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kjwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kjwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kkwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kkwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kkwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kkwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kkwikiquote' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kkwikiquote.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kkwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kkwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'klwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from klwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'klwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from klwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kmwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kmwiki.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kmwikibooks' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kmwikibooks.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'kmwiktionary' as wiki, img_name, img_timestamp, img_major_mime, img_minor_mime from kmwiktionary.image where img_minor_mime in ('x-bmp', 'x-ms-bmp') union all
select 'knwiki' as wiki, img_name, img_timestamp, img_major_mime, img_minor
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
Submit Query Stop Query
All SQL code is licensed under CC0 License.
SQL

Checking query status...
