| desc uw_campaigns |
1 year ago |
| desc uw_campaign |
1 year ago |
| desc uw_campaign |
1 year ago |
| desc uw_campaign |
1 year ago |
| desc uw_campaigns |
1 year ago |
| select *
from image
join page on page.page_title=image.img_name
join... |
1 year ago |
| desc change_tag |
1 year ago |
| desc change_tag_def |
1 year ago |
| desc change_tag |
1 year ago |
| select count(distinct page_title)
from image
join page on... |
1 year ago |
| select count(distinct page_title)
from image
join page on... |
1 year ago |
| select distinct(page_title)
from image
join page on... |
1 year ago |
| select page_title,rev_id,rev_timestamp,comment_text,img_timestamp
from... |
1 year ago |
| select page_title,rev_id,comment_text,img_timestamp
from image
join page on... |
1 year ago |
| desc revision |
1 year ago |
| select page_title,rev_id,comment_text,img_timestamp
from image
join page on... |
1 year ago |
| select page_title,rev_id,comment_text,img_timestamp
from image
join page on... |
1 year ago |
| select page_title,rev_id,comment_text
from image
join page on... |
1 year ago |
| select rev_id,comment_text
from image
join page on... |
1 year ago |
| select comment_text
from image
join page on... |
1 year ago |
| select comment_text
from image
join page on... |
1 year ago |
| select comment_text,count(distinct img_name)
from image
join page on... |
1 year ago |
| select count(distinct img_name)
from comment_text,image
join page on... |
1 year ago |
| select count(distinct img_name)
from image
join page on... |
1 year ago |
| select count(*)
from image
join page on page.page_title=image.img_name
join... |
1 year ago |
| select * from page join revision on page_id=rev_page join comment on... |
1 year ago |
| select * from page join revision on page_id=rev_page where page_id=86748633 |
1 year ago |
| select * from page join revision on page_id=rev_page where... |
1 year ago |
| select * from archive where ar_namespace=6 limit 10 |
1 year ago |
| select * from archive where ar_namespace=6 and ar_comment_id is not null limit 10 |
1 year ago |
| select * from archive where ar_namespace=6 limit 10 |
1 year ago |
| select * from filearchive limit 10 |
1 year ago |
| select count(distinct fa_name) from filearchive where... |
1 year ago |
| select count(*) from filearchive where fa_timestamp>='20220901000000' and... |
1 year ago |
| select count(*) from filearchive where ar_timestamp>='20220901000000' and... |
1 year ago |
| select count(*) from image where img_timestamp>='20220901000000' and... |
1 year ago |
| select * from filearchive where fa_name='Riboflavina.jpg' |
1 year ago |
| select * from filearchive where fa_name='AK_Parti_tr_009.jpeg' |
1 year ago |
| select * from filearchive where fa_name='AK Parti tr 009.jpeg' |
1 year ago |
| select * from change_tag_def where ctd_name like 'visual%' |
1 year ago |
| desc image |
1 year ago |
| select * from change_tag_def where ctd_name like 'cross%' |
1 year ago |
| desc change_tag_def |
1 year ago |
| descchange_tag_def |
1 year ago |
| show tables like 'change_tag%' |
1 year ago |
| desc revision |
1 year ago |
| desc page |
1 year ago |
| desc filearchive |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id=6474655 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 1 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 1 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474651 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474655 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id>=6474654 limit 2 |
1 year ago |
| select fa_id,fa_metadata from filearchive where fa_id=6474654 |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select distinct
fa_id,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_id,CONVERT(fa_metadata USING utf8) AS... |
1 year ago |
| select * from filearchive where fa_metadata = '' limit 10 |
1 year ago |
| select * from filearchive where fa_metadata = 0 limit 10 |
1 year ago |
| select * from filearchive where fa_metadata = -1 limit 10 |
1 year ago |
| select * from filearchive where (fa_metadata is not null and fa_metadata not... |
1 year ago |
| select * from filearchive where (fa_metadata is not null and... |
1 year ago |
| select * from filearchive where fa_metadata is not null limit 10 |
1 year ago |
| select * from filearchive where fa_metadata is null limit 10 |
1 year ago |
| desc filearchive
|
1 year ago |
| select count(*)
from filearchive where fa_deleted_timestamp>="202209010000"... |
1 year ago |
| select count(*)
from image where img_timestamp>="20210901000000" and... |
1 year ago |
| select count(*)
from filearchive where fa_timestamp>="20210901000000" and... |
1 year ago |
| select count(*)
from filearchive where fa_timestamp>="20210901000000" and... |
1 year ago |
| select count(*)
from filearchive where fa_timestamp>="20220901000000" and... |
1 year ago |
| select count(*)
from image where img_timestamp>="20220901000000" and... |
1 year ago |
| select count(distinct fa_name)
from filearchive |
1 year ago |
| select count(*)
from image |
1 year ago |
| select count(*)
from page where page_namespace=6 |
1 year ago |
| select count(distinct rev_page)
from revision
join change_tag on... |
1 year ago |
| select count(distinct img_name)
from revision
join change_tag on... |
1 year ago |
| desc image |
1 year ago |
| select count(distinct img_title)
from revision
join change_tag on... |
1 year ago |
| select count(distinct rev_page)
from revision
join change_tag on... |
1 year ago |
| desc revision |
1 year ago |
| select count(distinct ar_title)
from archive
join change_tag on... |
1 year ago |
| select count(distinct rev_page)
from revision
join change_tag on... |
1 year ago |
| select count(distinct ar_title)
from archive
join change_tag on... |
1 year ago |
| select count(*)
from archive
join change_tag on... |
1 year ago |
| select *
from archive
join change_tag on... |
1 year ago |
| desc archive |
1 year ago |
| desc filearchive |
1 year ago |
| desc archive |
1 year ago |
| desc change_tag |
1 year ago |
| select * from archive order by ar_id desc limit 100 |
1 year ago |
| desc archive |
1 year ago |
| desc image |
1 year ago |
| desc page; |
1 year ago |
| select * from filearchive where fa_name='AN_260778.jpg' |
1 year ago |
| select * from image where img_name='AN_260778.jpg' |
1 year ago |
| select * from image where img_name='AN 260778.jpg' |
1 year ago |
| select * from filearchive join comment on fa_deleted_reason_id=comment_id... |
1 year ago |
| select * from filearchive join comment on fa_deleted_reason_id=comment_id... |
1 year ago |
| select * from filearchive where fa_id=7442013 |
1 year ago |
| desc filearchive |
1 year ago |
| desc page |
1 year ago |
| select * from revision where rev_timestamp>=20210101000000 order by rev_id limit 10 |
1 year ago |
| select * from revision where rev_id>=721614737 order by rev_id limit 10 |
1 year ago |
| select * from revision where rev_timestamp>='20210101000000' order by rev_id limit 10 |
1 year ago |
| desc revision |
1 year ago |
| select * from change_tag_def where ctd_name like 'visual%' |
1 year ago |
| select * from change_tag_def |
1 year ago |
| show tables |
1 year ago |
| select * from change_tag limit 10 |
1 year ago |
| select * from change_tag |
1 year ago |
| desc comment |
1 year ago |
| select * from filearchive where fa_name='ПроєктВукоопромради_1935.jpg' |
1 year ago |
| select * from image where img_name='ПроєктВукоопромради_1935.jpg' |
1 year ago |
| select * from image where img_name='ПроєктВукоопромради 1935.jpg' |
1 year ago |
| select * from image where img_name='Nissan Serena (C27) e-Power XV aero,... |
1 year ago |
| select * from image where... |
1 year ago |
| select * from filearchive where... |
1 year ago |
| select * from filearchive where fa_name='Nissan Serena (C27) e-Power XV... |
1 year ago |
| select * from filearchive where fa_name='1960_Edsel_Villager_(4452450278).jpg' |
1 year ago |
| select * from filearchive where fa_name='1960 Edsel Villager (4452450278).jpg' |
1 year ago |
| select * from image where img_name='1960_Edsel_Villager_(4452450278).jpg' |
1 year ago |
| select * from image where img_name='1960 Edsel Villager (4452450278).jpg' |
1 year ago |
| desc image |
1 year ago |
| select * from filearchive where fa_name like '2004_weird.svg' |
1 year ago |
| select * from filearchive where fa_name='2004 weird.svg' |
1 year ago |
| select count(*) from filearchive where fa_id>=6460760 and fa_id<=7970474 |
1 year ago |
| select * from filearchive order by fa_id desc limit 10 |
1 year ago |
| desc filearchive |
1 year ago |
| show create table filearchive |
1 year ago |
| desc filearchive |
1 year ago |
| select fa_id from filearchive where fa_timestamp>=20220701000000 order by... |
1 year ago |
| select fa_id from filearchive where fa_timestamp>=20220601000000 order by... |
1 year ago |
| select count(*) from filearchive where fa_id>=7200235 and fa_id<=7818300 |
1 year ago |
| select * from filearchive where fa_id in (7200235,7818300) |
1 year ago |
| select count(*) from filearchive where fa_id>=7200235 and fa_id<=7818300 |
1 year ago |
| select count(*) from file_archive where fa_id>=7200235 and fa_id<=7818300 |
1 year ago |
| select * from filearchive where fa_id=7818300 |
1 year ago |
| select * from filearchive where fa_id=7818301 |
1 year ago |
| select * from filearchive where fa_deleted_timestamp>=20230601000000 order... |
1 year ago |
| select * from filearchive where fa_deleted_timestamp>=20220501000000 order... |
1 year ago |
| select * from filearchive where fa_name='Josef_Pawliczek_(1921-1931).jpg' |
1 year ago |
| select * from filearchive where fa_name='Josef_Pawliczek_(1921-1931).jpg' |
1 year ago |
| select count(*) from filearchive where fa_id>6460760 |
1 year ago |
| select * from filearchive where fa_name='Barham_Bridge_(6949757996).jpg' |
1 year ago |
| show tables; |
1 year ago |
| select count(*) from echo_notification join echo_event on... |
1 year ago |
| select max(fa_id) from filearchive |
1 year ago |
| select * from filearchive where fa_id=6542837 |
1 year ago |
| select * from filearchive where fa_id>=6542837 |
1 year ago |
| select * from filearchive where fa_id>=6542837 limit 100 |
1 year ago |
| select * from filearchive
where fa_id>=6542760 limit 100 |
1 year ago |
| select * from filearchive
where fa_id>=6640440 limit 10 |
1 year ago |
| select * from filearchive
where fa_id=6640440 |
1 year ago |
| select distinct
fa_id,fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select * from filearchive where fa_media_type!='BITMAP' limit 100 |
1 year ago |
| select * from filearchive here fa_media_type!='BITMAP' limit 100 |
1 year ago |
| select fa_media_type from filearchive limit 100 |
1 year ago |
| desc filearchive |
1 year ago |
| select distinct
fa_id,fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
where... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
where... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
where... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
where... |
1 year ago |
| select distinct
fa_name,fa_metadata
from filearchive
where... |
1 year ago |
| select distinct
fa_id,
ar_page_id,
ar_title,fa_metadata
... |
1 year ago |
| select distinct
ar_page_id,
ar_title,fa_metadata
... |
1 year ago |
| select distinct
ar_page_id,
ar_title,fa_metadata
... |
1 year ago |
| select distinct
ar_page_id,
ar_title,fa_metadata
... |
1 year ago |
| select distinct
ar_page_id,
ar_title,fa_metadata,
... |
1 year ago |
| select max(fa_id) from filearchive |
1 year ago |
| select max(fa_id) from file_archive |
1 year ago |
| select count(*) from filearchive where fa_id>6450760; |
1 year ago |
| select fa_id,fa_deleted_timestamp from filearchive where... |
1 year ago |
| select fa_id,fa_deleted_timestamp from filearchive where... |
1 year ago |
| select fa_id,fa_deleted_timestamp from filearchive order by fa_id desc limit 10; |
1 year ago |
| select fa_id,fa_timestamp from filearchive order by fa_id desc limit 10; |
1 year ago |
| select fa_id,fa_timestamp from filearchive order by fa_id limit 10; |
1 year ago |
| select fa_id,fa_timestamp from filearchive limit 10; |
1 year ago |
| select min(ar_id)
from archive join (
select... |
1 year ago |
| select min(ar_id)
from archive join (
select... |
1 year ago |
| select *
from filearchive
where fa_name='Beckham.jpg' |
1 year ago |
| select *
from archive join filearchive on fa_name=ar_title
where... |
1 year ago |
| select *
from archive join filearchive on fa_name=ar_title
where... |
1 year ago |
| select *
from archive join filearchive on fa_name=ar_title
where... |
1 year ago |
| select ar_id,ar_title
from archive join filearchive on fa_name=ar_title... |
1 year ago |
| select min(ar_id)
from archive join filearchive on fa_name=ar_title
where... |
1 year ago |
| select * from filearchive where fa_name='Casino_site.jpg' |
1 year ago |
| select min(ar_id)
from archive join filearchive on fa_name=ar_title
where... |
1 year ago |
| select count(distinct ar_page_id)
from archive join filearchive on... |
1 year ago |
| select *
from archive join filearchive on fa_name=ar_title
order by... |
1 year ago |
| select *
from archive join filearchive on fa_name=ar_title
limit 10 |
1 year ago |
| select * from archive where ar_title='ASDAWARRIORS.jpg' |
1 year ago |
| select * from image where img_name='ASDAWARRIORS.jpg' |
1 year ago |
| select img_timestamp from image join page on page_title=img_name where... |
1 year ago |
| select img_timestamp from image join page on page_title=img_name where... |
1 year ago |
| select count(distinct ar_page_id)
from archive join image on... |
1 year ago |
| explain select count(distinct ar_page_id)
from archive join image on... |
1 year ago |
| select count(distinct ar_page_id)
from archive join image on... |
1 year ago |
| show create table image |
1 year ago |
| desc page |
1 year ago |
| desc image |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| select page_id,img_timestamp
from image join page on... |
1 year ago |
| desc image |
1 year ago |
| desc page |
1 year ago |
| select
count(distinct ar_page_id)
from archive
where ar_page_id>=113875000... |
1 year ago |
| select
count(distinct ar_page_id)
from archive
where ar_page_id>=113875000... |
1 year ago |
| select
count(*)
from page
where page_id>=113875000
and page_namespace=6 |
1 year ago |
| select distinct
count(*)
from page
where page_id>=113875000
and page_namespace=6 |
1 year ago |
| select distinct
count(*)
from archive
where archive.ar_page_id>=113875000... |
1 year ago |
| select distinct
image.img_name,
JSON_EXTRACT(img_metadata,... |
1 year ago |
| select distinct
image.img_name,
JSON_EXTRACT(img_metadata,... |
1 year ago |
| select distinct
image.img_name,
JSON_EXTRACT(img_metadata,... |
1 year ago |
| select distinct
image.img_name,
JSON_EXTRACT(img_metadata,... |
1 year ago |
| select
image.img_name,
JSON_EXTRACT(img_metadata,... |
1 year ago |
| select
image.img_name,
image.img_metadata
from... |
1 year ago |
| select
ar.ar_page_id,
ar.max_rev_id,
... |
1 year ago |
| select
ar.ar_page_id,
ar.ar_rev_id,
... |
1 year ago |
| select
ar.ar_page_id,
ar.ar_rev_id,
... |
1 year ago |
| select
archive.ar_page_id,
ar_rev_id,
... |
1 year ago |
| select
archive.ar_page_id,
image.img_name,
... |
1 year ago |
| select
archive.ar_page_id,
image.img_name,
... |
1 year ago |
| select
*
from archive
where ar_namespace=6
... |
1 year ago |
| desc archive |
1 year ago |
| show tables |
1 year ago |
| desc archive |
1 year ago |
| select
archive.ar_id,
image.img_name,
... |
1 year ago |
| select
archive.ar_id,
image.img_name,
... |
1 year ago |
| select
archive.ar_id,
image.img_title,
... |
1 year ago |
| select
ar.ar_id,
image.img_title,
... |
1 year ago |
| select
page.page_id,
page.page_title,
... |
1 year ago |
| desc archive; |
1 year ago |
| desc archive; |
1 year ago |
| desc archive; |
1 year ago |
