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

SQL

AخA
 
USE enwiki_p;
SELECT
  rev_user_text,
  article.page_title
FROM revision
INNER JOIN page article ON 
    article.page_id = rev_page AND
    article.page_namespace = 0
INNER JOIN page talk ON 
    talk.page_title = article.page_title AND
    talk.page_namespace = 1
INNER JOIN categorylinks ON 
    cl_from = talk.page_id
 JOIN langlinks lang ON 
    article.page_id=lang.ll_from
 and lang.ll_from in (select m.ll_from from langlinks m where m.ll_lang="ar")
 and lang.ll_lang="ar"
WHERE 
    rev_timestamp BETWEEN 20170301000000 AND 20170331000000 AND 
    cl_to = "WikiProject_Wiki_Loves_Women_translation"
GROUP BY article.page_id
LIMIT 20;
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.

Checking query status...