Untitled query #38900

SQL

use fawiki_p;
select distinct concat("[[", page_title, "]]") as Title, concat ("{{نوپینگ|", actor_name, "}}") as Creator, rev_timestamp as Date, concat(page_len, " کیلوبایت") as Size
from page
join revision
on rev_page = page_id
join actor
on rev_actor = actor_id
where rev_parent_id = 0
and rev_timestamp between "20181102000000" and "20181123000000"
and page_namespace = 0
and page_is_redirect = 0
and actor_name not in ("MOSIOR", "AbDaryaee", "Roozitaa", "Mr.Robot-ER28-0652", "Rmashhadi", "Wikimostafa", "Darafsh", "Hanooz", "Modern Sciences")
order by rev_timestamp desc;
SQL

Checking query status...
