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(rc1.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(rc1.rc_timestamp/1000000) as rc_day,
    substring(rc_title, 1, 40) as title_cut,
    REGEXP_SUBSTR(rc1.rc_comment, "^.*?[*].*?[*]") as t,
    rc1.rc_comment 
from 
	change_tag as ct1, 
    change_tag_def as ctd1, 
    recentchanges_compat as rc1, 
    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 rc1.rc_user=user_id
    and rc1.rc_comment like "%label%" 
group by rc1.rc_id
-- order by user_name, user_age DESC;

SQL

Checking query status...