SELECT rc_timestamp,
	rc_log_action,
	rc_namespace,
	rc_title,
	user_name,
	user_editcount,
	rc_comment,
	(unix_timestamp(rc_timestamp)-unix_timestamp(user_registration)) as user_age,
	log_params
FROM recentchanges
	LEFT OUTER JOIN logging ON rc_logid=log_id
	LEFT OUTER JOIN user ON rc_user=user_id
	LEFT OUTER JOIN ipblocks ON ipb_user=rc_user AND (unix_timestamp(ipb_timestamp)-unix_timestamp(rc_timestamp))<600
ORDER BY rc_timestamp DESC
LIMIT 50000;