| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
11 months ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
1 year ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
2 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
2 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
2 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
3 years ago |
| set @namespace = 10;
select * from page where page_namespace=@namespace+1... |
3 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
3 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
3 years ago |
| set @namespace = 100;
select * from page where page_namespace=@namespace+1... |
4 years ago |
| set @namespace = 10;
select * from page where page_namespace=@namespace+1... |
4 years ago |
| set @namespace = 10;
select * from page where page_namespace=@namespace+1... |
4 years ago |
| set @namespace = 828;
select * from page where page_namespace=@namespace+1... |
4 years ago |
| set @namespace = 828
select * from page where page_namespace=@namespace+1... |
4 years ago |
| /*
select concat("Module:",page_title) from page where page_namespace=828... |
4 years ago |
| /*
select concat("Module:",page_title) from page where page_namespace=828... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828
and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module:",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module",page_title) from page where page_namespace=828 and... |
4 years ago |
| select concat("Module",page_title) where page_namespace=828 and not exists... |
4 years ago |
| select concat("Module",page_title) where page_namespace=828 and not exists... |
4 years ago |
| select concat("Module",page_title) where page_namespace=828 and not exists... |
4 years ago |
| select concat("Module",page_title) where page_namespace=828 and not exists... |
4 years ago |
| select concat("Module",page_title) where page_namespace=828 and not exists... |
4 years ago |
| select SUBSTRING_INDEX("A/B/C/","/",200) as "abc"; |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/",200) as "abc"; |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/",2) as "abc"; |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/",-1) as "abc"; |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/",-1) as "abc"; |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/",-1) |
4 years ago |
| select SUBSTRING_INDEX("A/B/C","/") |
4 years ago |
| select left("A/B",2); |
4 years ago |
| select left("A/B",3); |
4 years ago |
| select charindex("A/B/C","/") |
4 years ago |
| select charindex("A/B/C","/") |
4 years ago |
| select charindex("A/B/C","/") |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*select distinct... |
4 years ago |
| select max(rev_timestamp) from revision;
/*select distinct... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select max(rev_timestamp) from revision
/*select distinct... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select * from actor where actor_user="Buaidh" limit 1; |
4 years ago |
| select * from actor where actor_user="Buaidh" limit 1; |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select distinct replace(page_title,"_"," ") from revision_userindex join... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select "Wikipedian_martial_artists" like "%Wikipedian%martial%";/*
select *... |
4 years ago |
| select "Wikipedian_martial_artists" like "%Wikipedian%martial";/*
select *... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select "Wikipedian martial artists" like "%Wikipedian%marshal";/*
select *... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and (ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%box"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%cricket"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%baseb"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%badmi"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%back"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%arch"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like... |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%aikido"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%swim"; |
4 years ago |
| select * from archive where ar_namespace=14 and ar_title like "%Wikipedian%football"; |
4 years ago |
| select * from page where page_namespace=10 and page_title like "%sandbox%"... |
4 years ago |
| select * from page where page_namespace=828 and page_title like "%sandbox%"... |
4 years ago |
| select concat("Category:",replace(ar_title,"_"," ")), ar_timestamp
from... |
4 years ago |
| select concat("Category:",replace(ar_title,"_"," ")), ar_timestamp
from... |
4 years ago |
| select concat("Category:",replace(page_title,"_"," ")), ar_timestamp
from... |
4 years ago |
| select concat("Category:",replace(page_title,"_"," ")), rev_timestamp
from... |
4 years ago |
| select concat("Category:",replace(page_title,"_"," ")), rev_timestamp
from... |
4 years ago |
| select concat("Category:",page_title) from revision_userindex join... |
4 years ago |
| select * from revision_compat join page on rev_page=page_id where... |
4 years ago |
| select max(rev_timestamp) from revision; |
4 years ago |
| select max(rev_timestamp) from revision; |
4 years ago |
| select max(rev_timestamp) from revision; |
4 years ago |
| select max(rev_timestamp) from revision; |
4 years ago |
| select max(rev_timestamp) from revision;
select SLEEP(30);
select... |
4 years ago |
| select max(rev_timestamp) from revision;
SLEEP(30);
select... |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select max(rev_timestamp) from revision |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive_userindex join actor_archive on ar_actor=actor_id... |
4 years ago |
| select * from archive join actor_archive on ar_actor=actor_id where... |
4 years ago |
| select * from archive join actor_archive on ar_actor=actor_id where... |
4 years ago |
| select * from archive join actor_archive on ar_actor=actor_id where... |
4 years ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
4 years ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
4 years ago |
| select * from archive_compat where ar_namespace=3 and ar_title="ArcticDog96"; |
4 years ago |
| select * from archive_compat where ar_namespace=3 and ar_title="ArcticDog96"; |
4 years ago |
| select * from archive_compat where ar_namespace=2 and ar_title="Coriannakox/sandbox"; |
4 years ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
4 years ago |
| SELECT DISTINCT ar_title, log_timestamp, actor_name, comment_text
FROM... |
4 years ago |
| select "abc", actor_user, NULL, actor_user=NULL,actor_user>=0 from actor... |
4 years ago |
| select "abc", actor_user, NULL, actor_user=NULL from actor where... |
4 years ago |
| select "abc", actor_user, NULL from actor where actor_name="127.0.0.1" |
4 years ago |
| select "abc", actor_user from actor where actor_name="127.0.0.1" |
4 years ago |
| select actor_user from actor where actor_name="127.0.0.1" |
4 years ago |
| select exists (select actor_user from actor where actor_name="127.0.0.1") |
4 years ago |
| select exists (select 1 from page where 0=1) |
4 years ago |
| select (select 1 from page where 0=1) |
4 years ago |
| select * from page where 0=1 |
4 years ago |
| select 1 where not exists (select * from page where 0=1) |
4 years ago |
| select 1 where exists (select * from page where 0=1) |
4 years ago |
| select 1 where exists (0) |
4 years ago |
| select exists(0) |
4 years ago |
| select * from page join revision_compat_userindex on... |
4 years ago |
| select * from page where page_namespace=3 and page_title regexp... |
4 years ago |
| select * from page where page_namespace=3 and page_title regexp... |
4 years ago |
| select * from actor_revision where actor_name="127.0.0.1" and actor_user != 23; |
4 years ago |
| select * from actor_revision where actor_name="127.0.0.1" and actor_user != NULL; |
4 years ago |
| select * from actor_revision where actor_name="127.0.0.1" and actor_user = NULL; |
4 years ago |
| select * from actor_revision where actor_name="127.0.0.1" and actor_user == NULL; |
4 years ago |
| select NULL==NULL from actor_revision where actor_name="127.0.0.1"; |
4 years ago |
| select 1 from actor_revision where actor_name="127.0.0.1"; |
4 years ago |
| select (actor_user != NULL) from actor_revision where actor_name="127.0.0.1"; |
4 years ago |
| select (actor_user ~= NULL) from actor_revision where actor_name="127.0.0.1"; |
4 years ago |
| select (actor_user = NULL) from actor_revision where actor_name="127.0.0.1"; |
4 years ago |
| select (actor_user = NULL) from actor where actor_name="127.0.0.1"; |
4 years ago |
| select (actor_user == NULL) from actor where actor_name="127.0.0.1"; |
4 years ago |
| select actor_user from actor where actor_name="127.0.0.1"; |
4 years ago |
| select * from actor where actor_name="127.0.0.1"; |
4 years ago |
| select NULL; |
4 years ago |
| select * from actor where actor_user=NULL limit 10; |
4 years ago |
| select * from page join actor on actor_name=page_title where actor_user=NULL... |
4 years ago |
| select * from page join actor on actor_name=page_title where actor_user=null... |
4 years ago |
| select * from page join actor on actor_name=page_title where actor_user=0... |
4 years ago |
| select * from page join actor on actor_name=page_title where... |
4 years ago |
| select * from page where page_namespace=3 join actor on... |
4 years ago |
| select * from archive_compat where ar_namespace=14 and... |
4 years ago |
| select * from archive where ar_namespace=14 and... |
4 years ago |
| use mediawikiwiki_p;
select
*
from
page
where
page_namespace = 102
... |
4 years ago |
| use mediawikiwiki_p;
select
*
from
page
where
page_namespace = 102
... |
4 years ago |
| select
*
from
page
where
page_namespace = 102
and page_title like "%/%"
|
4 years ago |
| select
*
from
page
where
page_namespace = 102
and page_title like... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect join page on page_id=rd_from where page_namespace=3... |
4 years ago |
| select * from redirect where rd_namespace=3 limit 1; |
4 years ago |
| select * from redirect limit 1; |
4 years ago |
