blank query |
3 years ago |
#DESCRIBE wb_items_per_site;
select ips_site_page#*
from page p, pagelinks... |
3 years ago |
#DESCRIBE wb_items_per_site;
select ips_site_page#*
from page p, pagelinks... |
3 years ago |
DESCRIBE wb_items_per_site; |
3 years ago |
select *
from page p, pagelinks pl#,wb_items_per_site i
where p.page_id... |
3 years ago |
select *
from page p, pagelinks pl#,wb_items_per_site i
where p.page_id... |
3 years ago |
blank query |
3 years ago |
select *
from page p, pagelinks pl#,wb_items_per_site i
where p.page_id... |
3 years ago |
select *
from page p, pagelinks pl#,wb_items_per_site i
where p.page_id... |
3 years ago |
blank query |
3 years ago |
select *
from page p, pagelinks pl
where p.page_id = pl.pl_from
AND... |
3 years ago |
select *
from page p, pagelinks pl
where p.page_id = pl.pl_from
AND... |
3 years ago |
select *
from page p, pagelinks pl
where p.page_id = pl.pl_from
AND... |
3 years ago |
DESCRIBE page_props;
|
3 years ago |
select *
FROM page_props as pp#, wikidatawiki_p.page as wdp
LIMIT 20; |
3 years ago |
select *
FROM page_props as pp#, wikidatawiki_p.page as wdp
LIMIT 2000; |
3 years ago |
select *
FROM page_props as pp#, wikidatawiki_p.page as wdp
WHERE... |
3 years ago |