Empty pages created by অভিধান বট

This query is marked as a draft This query has been published by Yahya.

SQL

USE bnwiki_p;
SELECT
    page.page_id,
    CONCAT("[[", page_title, "]]") AS page_title,
    page.page_len
FROM page
JOIN revision ON page.page_id = revision.rev_page AND revision.rev_parent_id = 0
JOIN actor ON revision.rev_actor = actor.actor_id
WHERE actor.actor_name = 'অভিধান বট'
AND page.page_len < 38
AND page.page_namespace = 0 -- Assuming you're only interested in the main namespace
AND page.page_is_redirect = 0 -- Excluding redirects
ORDER BY page.page_len ASC;

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...