Page MenuHomePhabricator
Paste P7562

Masterwork From Distant Lands
ActivePublic

Authored by ProdPasteBot on Sep 18 2018, 2:56 PM.
SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,COALESCE( comment_rev_comment.comment_text, rev_comment ) AS `rev_comment_text`,comment_rev_comment.comment_data AS `rev_comment_data`,comment_rev_comment.comment_id AS `rev_comment_cid`,rev_user,rev_user_text,NULL AS `rev_actor`,rev_text_id,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name,old_text,old_flags FROM `revision` LEFT JOIN `revision_comment_temp` `temp_rev_comment` ON ((temp_rev_comment.revcomment_rev = rev_id)) LEFT JOIN `comment` `comment_rev_comment` ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) INNER JOIN `page` ON ((page_id = rev_page)) LEFT JOIN `user` ON ((rev_user != 0) AND (user_id = rev_user)) INNER JOIN `text` ON ((rev_text_id=old_id)) WHERE rev_page = '38053955' ORDER BY rev_timestamp DESC,rev_id DESC LIMIT 2;

Event Timeline

ProdPasteBot edited the content of this paste. (Show Details)Sep 18 2018, 2:56 PM
ProdPasteBot changed the title of this paste from untitled to Masterwork From Distant Lands.

SELECT rev_id,rev_page,rev_timestamp,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,COALESCE( comment_rev_comment.comment_text, rev_comment ) AS rev_comment_text,comment_rev_comment.comment_data AS rev_comment_data,comment_rev_comment.comment_id AS rev_comment_cid,rev_user,rev_user_text,NULL AS rev_actor,rev_text_id,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len FROM revision LEFT JOIN revision_comment_temp temp_rev_comment ON ((temp_rev_comment.revcomment_rev = rev_id)) LEFT JOIN comment comment_rev_comment ON ((comment_rev_comment.comment_id = temp_rev_comment.revcomment_comment_id)) INNER JOIN page ON ((page_id = rev_page)) WHERE (rev_timestamp>='19991130000000') AND rev_page = '33952837' ORDER BY rev_timestamp ,rev_id LIMIT 2 ;