| SELECT *
FROM page
LEFT JOIN redirect ON rd_from = page_id
WHERE
... |
4 years ago |
| SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| /*SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| /*SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| /*SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| /*SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| /*SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| SELECT rd_namespace, COUNT(*) AS num_to_NS
FROM page
LEFT JOIN redirect ON... |
4 years ago |
| SELECT COUNT(*)
FROM page
INNER JOIN redirect ON rd_from = page_id
WHERE
... |
4 years ago |
| SELECT COUNT(*)
FROM page
WHERE
page_namespace = 118
AND page_is_redirect = 1 |
4 years ago |
| SELECT COUNT(*)
FROM page
WHERE
page_namespace = 118 |
4 years ago |
