jawp: New articles by Semi-Brace

SQL

use jawiki_p;
/*
SELECT COUNT(*) as `Number of articles`
FROM revision as R, `actor` as A
WHERE
1 = 1
-- NEW PAGE
AND A.actor_name = "Semi-Brace"
AND R.rev_parent_id = 0
AND R.rev_minor_edit = 0
AND R.rev_actor = A.actor_id
LIMIT 50;
*/
-- タグ一覧確認用
/*
SELECT *
FROM change_tag_def
;
*/
SELECT * FROM actor WHERE actor_user = 1366523;
-- 全列挙
SELECT RC.rc_title as title, RC.rc_new_len as size, R.rev_timestamp as timestamp
FROM recentchanges as RC, actor as A, revision as R, change_tag as CT, page as P
WHERE
1 = 1
-- ME
AND A.actor_user = 1366523
-- NEW PAGE
AND R.rev_parent_id = 0
-- ARTICLE NAMESPACE
AND P.page_namespace = 0
-- NOT REDIRECT
AND CT.ct_tag_id <> 10
AND RC.rc_this_oldid = R.rev_id
AND CT.ct_rev_id = R.rev_id
AND RC.rc_actor = A.actor_id
AND R.rev_page = P.page_id
;
-- 最近の執筆
SELECT RC.rc_title as title, RC.rc_new_len as size, R.rev_timestamp as timestamp
FROM recentchanges as RC, actor as A, revision as R, change_tag as CT
WHERE
1 = 1
-- ME
AND A.actor_user = 1366523
-- NEW PAGE
AND RC.rc_new = 1
-- ARTICLE NAMESPACE
AND RC.rc_namespace = 0
-- NOT REDIRECT
AND CT.ct_tag_id <> 10
AND RC.rc_this_oldid = R.rev_id
AND CT.ct_rev_id = R.rev_id
AND RC.rc_actor = A.actor_id
;
SQL

Checking query status...
