Untitled query #81179

SQL

USE arwiki_p;

SELECT
    page.page_title AS page_title,
    revision.rev_id AS revision_id,
    revision.rev_timestamp AS revision_timestamp,
    revision.rev_deleted AS is_deleted
FROM
    revision
JOIN
    page ON revision.rev_page = page.page_id
WHERE
    revision.rev_deleted = 1
    AND revision.rev_actor IN (SELECT actor_id FROM actor WHERE actor_name = 'البربوشي')
    AND page.page_touched >= '2024-03-01 00:00:00'  -- تعديل التاريخ هنا للفترة التي ترغب في البحث فيها
ORDER BY
    revision.rev_timestamp DESC;
SQL

Checking query status...
