Fork of
مقالات بر پایهٔ تعداد واگردانی
by Yamaha5
This query is marked as a draft
This query has been published
by Yamaha5.
SQL
x
USE fawiki_p;SELECT page_title, count(rev_comment)FROM revision join page WHERE page_id=rev_page and page_namespace=0 and (rev_comment LIKE '%واگردان%' or rev_comment LIKE '%خنثی%')and rev_timestamp > 20160625000000 and rev_timestamp < 20160702000000 GROUP BY page_title ORDER BY count(rev_comment) 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.