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 actor as A, revision as R, change_tag as CT
WHERE
1 = 1
-- ME
AND A.actor_user = 1366523
-- NEW PAGE
AND R.rev_parent_id = 0
AND CT.ct_tag_id <> 10
AND R.rev_actor = A.actor_id
;
SQL

Checking query status...
