Android app SuggestedEdits examples: depicts only, last 30 days

Fork of Android app SuggestedEdits: depicts only, last 30 days by Zache

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

SQL

use commonswiki_p;

select 
	count(distinct(rc_id)) as edits, 
    ctd1.ctd_name, rc_comment, 
    group_concat(distinct(ctd2.ctd_name)) as tags,
    user_registration,
    user_editcount
from 
	change_tag as ct1, 
    change_tag_def as ctd1, 
    recentchanges_compat, 
    change_tag as ct2, 
    change_tag_def as ctd2,
    user
where 
	rc_id=ct1.ct_rc_id 
    and ct1.ct_tag_id=ctd1.ctd_id 
    and ctd1.ctd_name like "apps-suggested-edits" 
    and ct2.ct_rc_id=rc_id 
    and ctd2.ctd_id=ct2.ct_tag_id
    and rc_user=user_id
    and rc_comment like "%depicts%" 
group by (ctd2.ctd_name="mw-reverted")*rc_id;

SQL

Checking query status...