Untitled query #7504

This query is marked as a draft This query has been published by Slaporte.

SQL

SELECT rc.rc_title,
       rc.rc_cur_id,
       rc.rc_namespace,
       cl.cl_timestamp
       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 = 'Featured_articles'

       AND cl.cl_timestamp >= DATE_SUB(NOW(), INTERVAL 24 HOUR)
       GROUP BY rc.rc_cur_id
       ORDER BY rc.rc_id DESC
       LIMIT 10

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...