Älvenäs edits -- week of 2021-03-26 - Quarry

Fork of Älvenäs edits -- week of 2021-04-02 by Slaporte

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

SQL

SELECT rc_id,
	   rc_timestamp,
       rc_actor,
       rc_title,
       rc_this_oldid
       rc_rc_lastoldid,
       rc_old_len,
       rc_new_len,
       comment_text
FROM recentchanges
JOIN comment on rc_comment_id = comment.comment_id
WHERE rc_cur_id = 522967
AND rc_type = 0
AND rc_timestamp > 20210319000000
AND rc_timestamp < 20210326000000
ORDER BY rc_timestamp
DESC

AخA
 
SELECT rc_id,       rc_timestamp,       rc_actor,       rc_title,       rc_this_oldid       rc_rc_lastoldid,       rc_old_len,       rc_new_len,       comment_textFROM recentchangesJOIN comment on rc_comment_id = comment.comment_idWHERE rc_cur_id = 522967AND rc_type = 0AND rc_timestamp > 20210319000000AND rc_timestamp < 20210326000000ORDER BY rc_timestampDESC

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.

Checking query status...