use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0
and... |
8 years ago |
use hewiki_p;
select count(*) from page
where page_namespace = 0 |
8 years ago |
use wikidatawiki_p;
select count(*) from page
where page_namespace = 0 |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
# select * from page where page_title like "Q%" limit... |
8 years ago |
use wikidatawiki_p;
select * from page where page_title like "Q%" limit 10
|
8 years ago |
use wikidatawiki_p;
select * from page limit 10
|
8 years ago |
use wikidatawiki_p;
select * from langlinks where ll_lang = "he" limit 10
|
8 years ago |
use wikidatawiki_p;
select * from langlinks and ll_lang = "he" limit 10
|
8 years ago |
use wikidatawiki_p;
select * from langlinks limit 10
|
8 years ago |
use wikidatawiki_p;
select * from iwlinks where iwl_prefix = "he" limit 10
|
8 years ago |
use wikidatawiki_p;
select * from iwlinks where iwl_prefix = he limit 10
|
8 years ago |
use wikidatawiki_p;
select * from iwlinks where lwl_prefix = he limit 10
|
8 years ago |
use wikidatawiki_p;
select * from iwlinks limit 10
|
8 years ago |
use wikidatawiki_p;
select * from interwiki limit 10
|
8 years ago |
use wikidatawiki_p;
select * from archive limit 10
|
8 years ago |
use wikidatawiki_p;
select * from hitcounter limit 10
|
8 years ago |
SHOW TABLES FROM wikidatawiki_p;
|
8 years ago |
use wikidatawiki_p;
|
8 years ago |
use wikidata_p;
|
8 years ago |
use hewiki_p;
select count(*) from page join templatelinks
on page_id =... |
8 years ago |
use hewiki_p;
select count(*) from page join templatelinks
on page_id =... |
8 years ago |
use hewiki_p;
select count(*) from page join templatelinks
on page_id =... |
8 years ago |
use hewiki_p;
select distinct(rev_user_text) from revision
where rev_comment... |
9 years ago |
use hewiki_p;
select distinct(rev_user_text) from revision
where rev_comment... |
9 years ago |
use hewiki_p;
select rev_user_text from revision
where rev_comment like "%/*... |
9 years ago |
use hewiki_p;
select * from revision
where rev_comment like "%/* Request */... |
9 years ago |
use hewiki_p;
select * from revision
where rev_comment like "%/* Request */... |
9 years ago |
use hewiki_p;
select * from revision
where #rev_comment like "%Request: פסקה... |
9 years ago |
use hewiki_p;
select * from revision
where rev_comment like "%Request: פסקה חדשה%"
|
9 years ago |
use hewiki_p;
select * from revision
where rev_comment = "Request: פסקה חדשה"
|
9 years ago |