미디어위키 Newpages 쿼리

개요

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

같이 보기

• DynamicPageList 쿼리