미디어위키 Newpages 쿼리

(Newpages 쿼리에서 넘어옴)

1 개요[ | ]

Newpages 쿼리
  • 특수:새문서 클릭하여 나오는 '새 문서 목록'을 추출하는 쿼리
SELECT /* IndexPager::buildQueryInfo (NewPagesPager) */ 
       rc_namespace, rc_title, rc_cur_id, rc_user, rc_user_text,
       rc_comment, rc_timestamp, rc_patrolled, rc_id, rc_deleted,
       page_len AS `length`, page_latest AS `rev_id`, rc_this_oldid, page_namespace, page_title, 
       ( SELECT Group_concat(ct_tag SEPARATOR ',') FROM `mw_change_tag` WHERE ct_rc_id = rc_id ) AS `ts_tags`
FROM   `mw_recentchanges` 
       INNER JOIN `mw_page` ON (( page_id = rc_cur_id )) 
WHERE  rc_new = '1' 
       AND rc_namespace = '0' 
       AND page_is_redirect = '0' 
ORDER  BY rc_timestamp DESC 
LIMIT  51

2 같이 보기[ | ]

문서 댓글 ({{ doc_comments.length }})
{{ comment.name }} {{ comment.created | snstime }}