USE jawiki_p;
SELECT COUNT(DISTINCT page_id)
FROM page JOIN pagelinks ON... |
4 years ago |
SELECT count(distinct(page_id))
FROM pagelinks
INNER JOIN page ON pl_from =... |
4 years ago |
SELECT count(distinct(31230004))
FROM pagelinks
INNER JOIN page ON pl_from =... |
4 years ago |
SELECT count(distinct(31230004))
FROM pagelinks
INNER JOIN page ON pl_from =... |
4 years ago |
USE itwiki_p;
SELECT CONCAT('File:', REPLACE(page_title,'_',' '))
FROM... |
4 years ago |
USE itwiki_p;
SELECT CONCAT('File:', REPLACE(page_title,'_',' '))
FROM... |
4 years ago |
SELECT count(distinct(26741))
FROM pagelinks
INNER JOIN page ON pl_from =... |
4 years ago |