Multiple columns with the same name

SQL

SELECT rc_this_oldid, rc_logid, rc_comment_id FROM recentchanges
JOIN recentchanges ON rc_id = rc_this_oldid
JOIN logging ON log_id = rc_this_oldid
JOIN revision ON rev_id = rc_logid
JOIN comment ON rc_comment_id = comment_id OR log_comment_id = comment_id OR rev_comment_id = comment_id
WHERE rc_this_oldid AND rc_logid
LIMIT 50;
/*
SELECT * FROM recentchanges JOIN comment ON rc_comment_id = comment_id WHERE rc_id = 1366924021;
SELECT * FROM logging JOIN comment ON log_comment_id = comment_id WHERE log_id = 116535403;
SELECT * FROM revision JOIN comment ON rev_comment_id = comment_id WHERE rev_id = 1013723323;
*/
SQL

Checking query status...
