SELECT *
FROM pagelinks
WHERE pl_from = 200264;
|
3 months ago |
-- Fetch the source page and its links, ensuring target pages exist in the... |
3 months ago |
SELECT page_title
FROM page
WHERE page_id = 200264;
|
3 months ago |
SELECT p1.page_title AS SourcePageTitle, p2.page_title AS... |
3 months ago |
SELECT p1.page_title AS SourcePageTitle, p2.page_title AS... |
3 months ago |
SELECT *
FROM pagelinks
WHERE pl_from = 45139;
|
3 months ago |
-- Find all internal links pointing to non-existent pages and count how many... |
3 months ago |
SELECT p1.page_title AS LinkingPage
FROM pagelinks pl
JOIN page p1 ON... |
3 months ago |
SELECT page_id
FROM page
WHERE page_title = 'Chennai'
AND page_namespace = 0; |
3 months ago |
SELECT p1.page_title AS linking_page, COUNT(*) AS link_count
FROM pagelinks... |
3 months ago |