| use wikidatawiki_p;
-- show tables;
select * from abuse_filter
limit 5;... |
6 years ago |
| use wikidatawiki_p;
-- show tables;
select * from abuse_filter
limit 5;... |
6 years ago |
| use wikidatawiki_p;
show tables;
/*select * from page wp
where... |
6 years ago |
| use wikidatawiki_p;
select * from page wp
where wp.page_title in... |
6 years ago |
| use trwiki_p;
select * from page p
join page_props on pp_page =... |
6 years ago |
| use trwiki_p;
select pp_value from page p
join page_props on pp_page =... |
6 years ago |
| use trwiki_p;
select pp_value from page p
join page_props on pp_page =... |
6 years ago |
| use trwiki_p;
select * from page p
join page_props on pp_page =... |
6 years ago |
| use trwiki_p;
select * from langlinks
join page on page_id = ll_from
where... |
6 years ago |
| use trwiki_p;
select * from langlinks
join page on page_id = ll_from
where... |
6 years ago |
| use trwiki_p;
select * from langlinks
join page on page_id = ll_from
where... |
6 years ago |
| use trwiki_p;
select * from langlinks
join page on page_id = ll_from
where... |
6 years ago |
| use trwiki_p;
select *, count(*) from langlinks
group by ll_lang
order by... |
6 years ago |
| use trwiki_p;
select *, count(*) from langlinks
group by ll_lang
limit 100;
|
6 years ago |
| use trwiki_p;
select * from langlinks
limit 100;
|
6 years ago |
