use arwiki_p;
select il_from from imagelinks
where... |
6 years ago |
use arwiki_p;
select il_from from imagelinks
where... |
6 years ago |
use arwiki_p;
select il_from from imagelinks
where... |
6 years ago |
use arwiki_p;
select page_title, count(*)
from
pagelinks
inner join page
on... |
6 years ago |
use arwiki_p;
select *
from
pagelinks
where pl_from not in (select pl_from... |
6 years ago |
use arwiki_p;
select *
from
imagelinks
where il_from= 1540
and il_to not... |
6 years ago |
use arwiki_p;
select *
from
imagelinks
where il_from= 2820967
and il_to... |
6 years ago |
use arwiki_p;
select *
from
imagelinks
where il_from= 3281419
and il_to... |
6 years ago |
use arwiki_p;
select *
from
imagelinks
where il_from= 3281419
limit 100; |
6 years ago |
use arwiki_p;
select * from imagelinks limit 100; |
6 years ago |
use wikidatawiki_p;
select * from wb_changes limit 100; |
6 years ago |
use wikidatawiki_p;
show tables; |
6 years ago |
use wikidatawiki_p;
select * from wikidatawiki_p.page_props where pp_page =... |
6 years ago |
use wikidatawiki_p;
select * from wb_claims limit 100; |
6 years ago |
use wikidatawiki_p;
select * from wikidatawiki_p.page_props where pp_page =... |
6 years ago |
use wikidatawiki_p;
select * from wikidatawiki_p.page_props limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page where page_id = 5284 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props where pp_page = 2091036 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page where page_id = 5284 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props where pp_page = 5284 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props where pp_page = 5284 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page where page_id = 1 limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props where pp_page = "Q1" limit 100; |
6 years ago |
use wikidatawiki_p;
select * from page_props where pp_page = "1" limit 100; |
6 years ago |
use wikidatawiki_p;
select * from wbs_propertypairs limit 100; |
6 years ago |
use wikidatawiki_p;
show tables; |
6 years ago |
use wikidatawiki_p;
select * from imagelinks
where il_from = 6228
limit 100;
|
6 years ago |
use wikidatawiki_p;
select * from imagelinks
limit 100;
|
6 years ago |
use wikidatawiki_p;
SHOW TABLES; |
6 years ago |
use wikidatawiki_p;
select * from wb_property_info
limit 100;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from =42388;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from =42388;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from =42388;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from like "Q42388";
|
6 years ago |
use wikidatawiki_p;
select * from page_props
where pp_page = 5806;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from = 5806;
|
6 years ago |
use wikidatawiki_p;
select * from pagelinks
where pl_from = 42388;
|
6 years ago |
use wikidatawiki_p;
select * from wb_items_per_site
where ips_item_id = 42388;
|
6 years ago |
use wikidatawiki_p;
select * from wb_terms
where term_full_entity_id like "Q42388";
|
6 years ago |
use wikidatawiki_p;
selec * from wb_terms
where term_full_entity_id like "Q42388";
|
6 years ago |