Untitled query #68221

SQL

SELECT t1.min_timestamp, t1.rc_title, t2.rc_title FROM 
(SELECT 
rc1.rc_user_text,
rc1.rc_title,
min(rc1.rc_timestamp) as min_timestamp
FROM 
recentchanges_compat as rc1
WHERE 
rc1.rc_user_text LIKE "91.197.23%"
AND rc1.rc_namespace=0
AND rc1.rc_source NOT IN ("mw.categorize") 
 GROUP BY rc_title) as t1 LEFT JOIN
 (SELECT 
rc1.rc_user_text,
rc1.rc_title,
min(rc1.rc_timestamp) as min_timestamp
FROM 
recentchanges_compat as rc1
WHERE 
rc1.rc_user_text LIKE "Abc10"
AND rc1.rc_namespace=0
AND rc1.rc_source="mw.edit" 
 GROUP BY rc_title) as t2
ON t1.rc_title=t2.rc_title AND t1.min_timestamp>t2.min_timestamp
SQL

Checking query status...
