Page Menu
Home
Phabricator
Search
Configure Global Search
Log In
Files
F4527581
bmps.sql
matmarex (Bartosz Dziewoński)
Actions
View File
Edit File
Delete File
View Transforms
Subscribe
Mute Notifications
Award Token
Flag For Later
Authored By
matmarex
Sep 26 2016, 9:29 PM
2016-09-26 21:29:39 (UTC+0)
Size
142 KB
Referenced Files
None
Subscribers
None
bmps.sql
View Options
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_mime
from
knwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'knwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
knwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'knwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
knwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'knwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
knwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'knwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
knwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'koiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
koiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowikiversity'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowikiversity
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'krcwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
krcwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'krwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
krwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'krwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
krwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kshwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kshwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kswikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kswikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kswikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kswikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kuwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kuwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kuwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kuwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kuwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kuwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kuwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kuwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kvwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kvwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kwwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kwwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kwwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kwwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kwwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kwwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kywikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kywikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kywikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kywikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'kywiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
kywiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ladwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ladwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lawikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lawikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lawikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lawikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lbewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lbewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lbwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lbwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lbwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lbwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lbwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lbwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lbwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lbwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'legalteamwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
legalteamwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lezwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lezwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lgwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lgwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lijwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lijwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'liwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
liwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'liwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
liwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'liwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
liwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'liwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
liwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'liwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
liwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lmowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lmowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lnwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lnwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'loginwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
loginwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lrcwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lrcwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltgwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltgwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ltwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ltwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lvwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lvwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lvwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lvwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'lvwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
lvwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'maiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
maiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'map_bmswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
map_bmswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mdfwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mdfwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mediawikiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mediawikiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'metawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
metawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mgwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mgwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mgwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mgwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mgwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mgwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mhrwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mhrwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mhwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mhwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mhwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mhwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'minwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
minwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'miwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
miwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'miwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
miwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'miwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
miwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mkwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mkwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mkwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mkwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mkwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mkwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mkwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mkwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mkwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mkwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mlwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mlwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mlwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mlwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mlwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mlwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mlwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mlwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mnwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mnwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'movementroleswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
movementroleswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrjwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrjwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mrwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mrwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mswikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mswikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mtwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mtwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mtwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mtwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'muswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
muswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mwlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mwlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mxwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mxwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'myvwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
myvwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mywikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mywikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mywiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mywiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'mznwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
mznwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nahwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nahwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nahwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nahwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nahwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nahwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'napwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
napwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nawikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nawikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nds_nlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nds_nlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ndswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ndswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ndswikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ndswikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ndswikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ndswikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ndswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ndswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'newiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
newiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'newikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
newikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'newiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
newiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'newwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
newwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ngwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ngwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nlwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nlwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nnwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nnwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'noboard_chapterswikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
noboard_chapterswikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nostalgiawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nostalgiawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'novwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
novwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nrmwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nrmwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nsowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nsowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nvwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nvwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nycwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nycwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'nzwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
nzwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ocwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ocwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ocwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ocwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ocwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ocwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'officewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
officewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ombudsmenwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ombudsmenwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'omwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
omwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'omwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
omwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'orwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
orwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'orwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
orwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'orwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
orwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'oswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
oswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'otrs_wikiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
otrs_wikiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'outreachwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
outreachwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pa_uswikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pa_uswikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pagwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pagwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pamwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pamwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'papwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
papwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pcdwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pcdwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pdcwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pdcwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pflwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pflwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pihwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pihwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'piwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
piwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'piwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
piwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'plwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
plwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pmswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pmswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pnbwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pnbwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pnbwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pnbwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pntwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pntwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pswikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pswikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'pswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
pswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikiversity'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikiversity
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ptwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ptwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'qualitywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
qualitywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'quwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
quwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'quwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
quwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'quwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
quwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'quwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
quwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rmwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rmwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rmwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rmwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rmwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rmwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rmywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rmywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'roa_rupwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
roa_rupwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'roa_rupwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
roa_rupwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'roa_tarawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
roa_tarawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rswikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rswikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikiversity'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikiversity
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ruwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ruwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rwwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rwwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'rwwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
rwwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sahwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sahwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sahwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sahwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sawikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sawikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sawikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sawikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'scnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
scnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'scnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
scnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'scowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
scowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'scwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
scwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'scwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
scwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sdwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sdwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sdwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sdwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sdwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sdwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'searchcomwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
searchcomwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sewikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sewikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sewikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sewikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sgwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sgwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sgwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sgwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'shwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
shwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'shwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
shwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'simplewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
simplewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'simplewikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
simplewikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'simplewikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
simplewikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'simplewiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
simplewiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'siwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
siwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'siwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
siwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'siwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
siwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'skwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
skwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'skwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
skwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'skwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
skwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'skwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
skwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'skwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
skwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwikiversity'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwikiversity
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'slwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
slwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'smwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
smwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'smwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
smwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'snwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
snwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'snwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
snwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sourceswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sourceswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'spcomwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
spcomwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'specieswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
specieswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sqwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sqwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sqwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sqwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sqwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sqwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sqwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sqwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sqwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sqwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'srwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
srwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'sswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
sswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'stewardwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
stewardwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'stqwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
stqwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'strategywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
strategywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'stwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
stwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'stwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
stwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'suwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
suwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'suwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
suwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'suwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
suwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'suwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
suwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikiversity'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikiversity
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'svwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
svwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'swwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
swwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'swwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
swwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'swwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
swwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'szlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
szlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tenwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tenwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'test2wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
test2wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'testwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
testwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'testwikidatawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
testwikidatawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tetwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tetwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tewikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tewikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tewikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tewikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tewikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tewikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tewiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tewiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tgwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tgwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tgwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tgwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tgwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tgwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'thwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
thwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tiwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tiwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tkwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tkwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tkwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tkwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tkwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tkwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tkwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tkwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tlwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tlwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tlwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tlwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tlwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tlwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tnwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tnwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tnwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tnwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'towiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
towiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'towiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
towiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tpiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tpiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tpiwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tpiwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'transitionteamwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
transitionteamwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'trwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
trwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tswiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tswiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ttwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ttwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ttwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ttwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ttwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ttwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ttwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ttwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tumwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tumwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'twwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
twwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'twwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
twwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tyvwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tyvwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'tywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
tywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'uawikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
uawikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'udmwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
udmwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ugwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ugwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ugwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ugwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ugwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ugwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ugwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ugwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'ukwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
ukwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'urwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
urwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'urwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
urwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'urwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
urwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'urwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
urwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'usabilitywiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
usabilitywiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'uzwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
uzwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'uzwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
uzwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'uzwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
uzwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'uzwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
uzwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vecwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vecwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vecwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vecwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vecwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vecwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vepwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vepwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vewikimedia'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vewikimedia
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'viwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
viwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vlswiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vlswiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'votewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
votewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vowikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vowikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vowikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vowikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'vowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
vowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'warwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
warwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wg_enwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wg_enwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikidatawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikidatawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2005wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2005wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2006wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2006wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2007wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2007wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2008wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2008wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2009wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2009wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2010wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2010wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2011wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2011wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2012wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2012wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2013wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2013wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2014wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2014wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2015wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2015wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2016wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2016wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimania2017wiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimania2017wiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wikimaniateamwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wikimaniateamwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wowikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wowikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'wuuwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
wuuwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'xalwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
xalwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'xhwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
xhwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'xhwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
xhwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'xhwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
xhwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'xmfwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
xmfwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yiwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yiwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yiwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yiwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yiwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yiwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yowikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yowikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'yowiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
yowiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zawikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zawikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zawikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zawikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zawiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zawiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zeawiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zeawiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zerowiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zerowiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_classicalwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_classicalwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_min_nanwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_min_nanwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_min_nanwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_min_nanwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_min_nanwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_min_nanwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_min_nanwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_min_nanwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_min_nanwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_min_nanwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zh_yuewiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zh_yuewiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwikinews'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwikinews
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwikiquote'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwikiquote
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwikisource'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwikisource
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwikivoyage'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwikivoyage
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zhwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zhwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zuwiki'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zuwiki
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zuwikibooks'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zuwikibooks
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
)
union
all
select
'zuwiktionary'
as
wiki
,
img_name
,
img_timestamp
,
img_major_mime
,
img_minor_mime
from
zuwiktionary
.
image
where
img_minor_mime
in
(
'x-bmp'
,
'x-ms-bmp'
);
File Metadata
Details
Attached
Mime Type
text/plain
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
4015943
Default Alt Text
bmps.sql (142 KB)
Attached To
Mode
T95582: it would be useful to run the same Quarry query conveniently in several database
Attached
Detach File
Event Timeline
Log In to Comment