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.