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

SQL

x
 
SELECT rc_namespace,rc_title,rc_timestamp
FROM recentchanges
WHERE ((rc_new = 1) OR (rc_log_type = 'upload' AND rc_log_action = 'upload'))
  AND rc_user_text='Emoteplump'
GROUP BY rc_namespace, rc_title, rc_timestamp
ORDER BY rc_timestamp DESC;
SELECT rc_namespace,rc_title,rc_timestamp,rc_new
FROM recentchanges
WHERE rc_user_text='Emoteplump';
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...