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