another.sql

SELECT rc.rc_id,
                      rc.rc_cur_id,
                      rc.rc_title,
                      rc.rc_timestamp,
                      rc.rc_this_oldid,
                      rc.rc_last_oldid,
                      rc.rc_user_text,
                      rc.rc_old_len,
                      rc.rc_new_len,
                      rc.rc_comment
               FROM recentchanges AS rc
               INNER JOIN recentchanges AS rc_talk
                   ON rc.rc_title = rc_talk.rc_title
                   AND rc.rc_namespace = 0
               INNER JOIN categorylinks AS cl
                   ON rc_talk.rc_cur_id = cl.cl_from
               WHERE cl.cl_to = 'All_stub_articles'
               AND rc.rc_type = 0
               AND rc.rc_timestamp >= DATE_SUB(NOW(),
                                               INTERVAL 1 HOUR)
               
               GROUP BY rc.rc_this_oldid
               ORDER BY rc.rc_id DESC
               LIMIT 50

category_queries.sql

SELECT rc.rc_id,
                      rc.rc_cur_id,
                      rc.rc_title,
                      rc.rc_timestamp,
                      rc.rc_this_oldid,
                      rc.rc_last_oldid,
                      rc.rc_user_text,
                      rc.rc_old_len,
                      rc.rc_new_len,
                      rc.rc_comment
               FROM recentchanges AS rc
               INNER JOIN recentchanges AS rc_talk
                   ON rc.rc_title = rc_talk.rc_title
                   AND rc.rc_namespace = (rc_talk.rc_namespace - (rc_talk.rc_namespace % 2))
               INNER JOIN categorylinks AS cl
                   ON rc_talk.rc_cur_id = cl.cl_from
               WHERE cl.cl_to = ?
               AND rc.rc_type = 0
               AND rc.rc_timestamp >= DATE_SUB(NOW(),
                                               INTERVAL ? HOUR)
               GROUP BY rc.rc_cur_id
               ORDER BY rc.rc_id DESC
               LIMIT ?