Diffs where people added depicts through suggestededits

SQL

SELECT comment_text,page_namespace, page_title, actor_name, DATE(rev_timestamp), CONCAT("https://commons.wikimedia.org/w/index.php?diff=", rev_id) AS `diff`
FROM revision_userindex
JOIN change_tag ON ct_rev_id = rev_id
JOIN page ON rev_page = page_id
JOIN actor_revision ON rev_actor = actor_id
JOIN `comment` ON comment_id = rev_comment_id AND comment_text like "%add-depicts:%"
WHERE ct_tag_id = (
  SELECT ctd_id
  FROM change_tag_def
  WHERE ctd_name = "apps-suggested-edits"
)
and rev_timestamp >= DATE_ADD(NOW(), INTERVAL -3 MONTH)
ORDER BY RAND()
LIMIT 300

AخA
 
SELECT comment_text,page_namespace, page_title, actor_name, DATE(rev_timestamp), CONCAT("https://commons.wikimedia.org/w/index.php?diff=", rev_id) AS `diff`FROM revision_userindexJOIN change_tag ON ct_rev_id = rev_idJOIN page ON rev_page = page_idJOIN actor_revision ON rev_actor = actor_idJOIN `comment` ON comment_id = rev_comment_id AND comment_text like "%add-depicts:%"WHERE ct_tag_id = (  SELECT ctd_id  FROM change_tag_def  WHERE ctd_name = "apps-suggested-edits")and rev_timestamp >= DATE_ADD(NOW(), INTERVAL -3 MONTH)ORDER BY RAND()LIMIT 300

SQL

Checking query status...