Android app SuggestedEdits examples: captions only, last 30 days

Fork of Android app SuggestedEdits examples: captions 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 
    user_name,
    user_editcount,
    DATEDIFF(STR_TO_DATE(rc_timestamp, "%Y%m%d%H%i%s"), STR_TO_DATE(user_registration, "%Y%m%d%H%i%s")) as user_age, -- user age in days
    floor(rc_timestamp/1000000) as rc_day,
    substring(rc_title, 1, 40) as title_cut,
    rc_comment 
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 "%label%" 
    and ctd2.ctd_name="mw-reverted"
group by rc_id
order by user_name, user_age DESC;

SQL

Checking query status...