select pl_title,c
from (select pl_title , count(*) as c , pl_namespace
... |
5 years ago |
select pl_title,c
from (select pl_title , count(*) as c , pl_namespace
... |
5 years ago |
USE dinwiki_p;
SELECT FROM pagelinks COUNT(pagelinks.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT FROM pagelinks COUNT(pagelinks.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT FROM pagelinks COUNT(DISTINCT pagelinks.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT COUNT(DISTINCT pagelinks.pl_from) AS direct_links
LIMIT 10; |
5 years ago |
USE dinwiki_p;
SELECT COUNT(DISTINCT links.pl_from) AS direct_links
LIMIT 10; |
5 years ago |
USE dinwiki_p;
SELECT disambigs.page_title, COUNT(DISTINCT links.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT disambigs.page_title, COUNT(DISTINCT links.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT disambigs.page_title, COUNT(DISTINCT links.pl_from) AS... |
5 years ago |
USE dinwiki_p;
SELECT disambigs.page_title, COUNT(DISTINCT links.pl_from) AS... |
5 years ago |