| #if you need only some columns, then change "select *" to
# select rev_id,... |
9 years ago |
| select *
from revision
join page on rev_page=page_id
where... |
9 years ago |
| select *
from revision
join page on rev_page=page_id
where... |
9 years ago |
| select *
from revision
join page on rev_page=page_id
where page_title="John... |
9 years ago |
| select *
from revision
limit 15; |
9 years ago |
| select count(*)
from wikidatawiki_p.externallinks... |
9 years ago |
| select *
from wikidatawiki_p.externallinks... |
9 years ago |
| blank query |
9 years ago |
| use wikidatawiki_p;
select term_entity_id from wb_terms where
term_language... |
9 years ago |
| use wikidatawiki_p;
select term_entity_id from wb_terms where
term_language... |
9 years ago |
| use wikidatawiki_p;
select term_entity_id from wb_terms where
term_language... |
9 years ago |
| use wikidatawiki_p;
select * from wb_terms where
term_language = 'cs'# and
... |
9 years ago |
| use wikidatawiki_p;
select * from wb_terms where
term_language = 'cs'# and
... |
9 years ago |
| use wikidatawiki_p;
select * from wb_terms where
term_language = 'cs'# and
... |
9 years ago |
| use wikidatawiki_p;
select * from wb_terms where
term_language = 'cs'# and... |
9 years ago |
| use wikidatawiki_p;
select * from wb_terms where
term_language = 'cs' and... |
9 years ago |
