select
pl_from as page_id,
count(*) as outgoing_links_count
from... |
6 years ago |
select
*
from
ukwiki_p.pagelinks
where
pl_from_namespace = 0 and
... |
6 years ago |
select
pl_title as target_title,
count(*) as... |
6 years ago |
select
pl_title as target_title,
count(*) as... |
6 years ago |
select
pl_title as target_title
count(*) as... |
6 years ago |
select
pl_from as page_id,
pl_title as target_title
from
pagelinks... |
6 years ago |
select * from pagelinks where pl_from_namespace = 0 and pl_namespace = 0 limit 10; |
6 years ago |