Android app SuggestedEdits examples: captions only, last 30 days

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(rc1.rc_title, 1, 40) as title_cut,
    substring(rc2.rc_title, 1, 40) as title_cut2,    
    REGEXP_SUBSTR(rc1.rc_comment, "^.*?[*].*?[*]/") as t,
    rc1.rc_comment 
from 
	change_tag as ct1, 
    change_tag_def as ctd1, 
    recentchanges_compat as rc1 LEFT JOIN
    	recentchanges_compat as rc2 ON rc1.rc_cur_id=rc2.rc_cur_id AND rc1.rc_id<rc2.rc_id AND rc1.rc_source=rc2.rc_source,
    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 rc_cur_id
SQL

Checking query status...
