Untitled query #38900

SQL

use fawiki_p;
select distinct concat("[[", page_title, "]]") as Title, concat("[[", ll_title, "]]") as enwiki, 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
join langlinks
on ll_from = page_id
join comment
on comment_id = rev_comment_id
where rev_parent_id = 0
and rev_timestamp between "20181102000000" and "20181123000000"
and page_namespace = 0
and page_is_redirect = 0
and ll_lang = "en"
and comment_text not like ("%به_ویکی‌فا%")
-- and actor_name not in ("MOSIOR", "AbDaryaee", "Roozitaa", "Mr.Robot-ER28-0652", "Rmashhadi", "Wikimostafa", "Darafsh", "Hanooz", "Modern Sciences", "Nightdevil", "UnitedPowers", "Mensis Mirabilis", "Tisfoon", "Saeidpourbabak", "4nn1l2", "Markman Darkman", "Huji", "Mardetanha")
order by rev_timestamp desc;
SQL

Checking query status...
