Untitled query #84858

SQL

USE arwiki_p;

-- استخراج ویرایش‌هایی که در تاریخ 13 ژوئیه 2024 انجام شده‌اند
WITH revisions_on_date AS (
    SELECT rev_id, rev_page
    FROM revision
    WHERE rev_timestamp BETWEEN '20240713000000' AND '20240713235959'
)

-- استخراج پیوندهای جدید اضافه‌شده در تاریخ 13 ژوئیه 2024
SELECT COUNT(el.el_from) AS total, el.el_from, p.page_title
FROM externallinks el
JOIN page p ON el.el_from = p.page_id
JOIN revisions_on_date r ON el.el_from = r.rev_page
WHERE p.page_is_redirect = 0 AND p.page_namespace = 0
AND el.el_from IN (
    SELECT rev_page
    FROM revisions_on_date
)
GROUP BY el.el_from, p.page_title
ORDER BY total DESC
LIMIT 100;
SQL

Checking query status...
