SELECT page.*
FROM page
JOIN categorylinks
ON cl_from = page_id
WHERE... |
7 years ago |
SELECT page.*
FROM page
JOIN categorylinks
ON cl_from = page_id
WHERE... |
7 years ago |
SELECT page.*
FROM page
WHERE page_namespace = 6
JOIN categorylinks
ON... |
7 years ago |
SELECT
pl_title,
count(*),
page_id
FROM enwiki.pagelinks
LEFT JOIN... |
7 years ago |
SELECT
pl_title,
count(*),
page_id
FROM enwiki.pagelinks
LEFT JOIN... |
7 years ago |
select DATE_FORMAT(log_timestamp,"%Y-%m-%d"), count(*)
from... |
7 years ago |