Untitled query #15867

SQL

USE mediawikiwiki_p;
#SELECT * FROM recentchanges WHERE rc_namespace = 0 AND rc_title = "Q1227189" AND rc_user_text = "MechQuester" ORDER BY rc_id DESC;
SELECT rc_type, MAX(rc_id) AS rc_id FROM recentchanges GROUP BY rc_type;
/*
SELECT * FROM (SELECT rc_type, MAX(rc_id) AS rc_id FROM recentchanges GROUP BY rc_type) AS src
JOIN recentchanges AS rc ON src.rc_id = rc.rc_id;
*/

SELECT rc_source, MAX(rc_id) AS rc_id FROM recentchanges GROUP BY rc_source;
/*
SELECT * FROM (SELECT rc_source, MAX(rc_id) AS rc_id FROM recentchanges GROUP BY rc_source) AS src
JOIN recentchanges AS rc ON src.rc_id = rc.rc_id;*/
SQL

Checking query status...
