Fork of
البحث عن مقالات ملخص تعديل معين
by جار الله
This query is marked as a draft
This query has been published
by جار الله.
SQL
AخA
use arwiki_p;
SELECT page_id, page_name
FROM revision_userindex
INNER JOIN page ON rev_page = page_id
WHERE rev_user_text = 'JarBot'
#AND rev_comment like "بوت:صيانة V3.3"
AND rev_timestamp > 20190117000000
GROUP BY page_id
ORDER BY COUNT(*) DESC;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.