Untitled query #68221

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

SQL

SELECT 
rc1.rc_user_text,
rc1.rc_title,
rc1.rc_namespace,
rc2.rc_title
FROM 
recentchanges_compat as rc1 LEFT JOIN recentchanges_compat as rc2 ON 
	rc1.rc_cur_id=rc2.rc_cur_id 
	AND rc2.rc_user_text LIKE "Abc10"
    AND rc1.rc_id>rc2.rc_id
    AND rc2.rc_source="mw.edit"
WHERE 
rc1.rc_user_text LIKE "91.197.23%"
AND rc1.rc_source NOT IN ("mw.categorize") 
LIMIT 10

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...