| use hewiki_p;
select page_title from page
where page_title like "%."
and not... |
4 years ago |
| use hewiki_p;
select page_title from page
where page_title like "%,"
and... |
4 years ago |
| use hewiki_p;
select page_namespace, page_title from page
where page_title like "%,"
|
4 years ago |
| use hewiki_p;
select page_namespace, page_title from page
where... |
4 years ago |
| use hewiki_p;
select page_namespace, page_title from page
where... |
4 years ago |
| use hewiki_p;
select page_title from page
where exists
(select * from... |
4 years ago |
| use hewiki_p;
select * from page
where exists
(select * from categorylinks
... |
4 years ago |
| use hewiki_p;
select * from page
where exists
(select * from categorylinks
... |
4 years ago |
| use hewiki_p;
select * from page
where exists
(select * from categorylinks
... |
4 years ago |
| use hewiki_p;
select * from user
where user_name like "%1488%"
|
4 years ago |
| use hewiki_p;
select * from user
where user_name like "%14%88%"
|
4 years ago |
| use hewiki_p;
select * from user
where user name like "%14%88%"
|
4 years ago |
| use hewiki_p;
select * from user limit 10
|
4 years ago |
| use hewiki_p;
describe user |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
/*
select count(*) from revision join page join... |
4 years ago |
| use enwiki_p;
select count(*) from revision join page join... |
4 years ago |
| use hewiki_p;
select count(*) from revision join page join... |
4 years ago |
| use hewiki_p;
select page_title, rev_timestamp, rev_actor, comment_text from... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join comment_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page join commnent_revision
on... |
4 years ago |
| use hewiki_p;
select * from revision join page
on page_id = rev_page
# where... |
4 years ago |
| use hewiki_p;
select * from revision
# where comment_text like "%http%"
limit 10 |
4 years ago |
| use hewiki_p;
select * from revision
% where comment_text like "%http%"
limit 10 |
4 years ago |
| use hewiki_p;
select * from comment_revision
where comment_text like... |
4 years ago |
| use hewiki_p;
select * from comment_revision
where comment_text like... |
4 years ago |
| use hewiki_p;
select * from comment_revision
limit 10
|
4 years ago |
| use hewiki_p;
show tables
|
4 years ago |
