jawp: Semi-Braceによる新規作成記事

SQL

use jawiki_p;
SELECT * FROM actor as A
WHERE A.actor_name = "Semi-Brace";

SELECT DISTINCT P.page_title from revision_userindex as R, actor as A, page as P, change_tag as CT, change_tag_def as CTD
WHERE 1 = 1
and A.actor_name = "Semi-Brace"
and R.rev_parent_id = 0
and P.page_namespace = 0
and P.page_is_redirect = 0
and R.rev_page = P.page_id
and R.rev_actor = A.actor_id
and R.rev_id = CT.ct_rev_id
and CT.ct_tag_id = CTD.ctd_id
;


/*
SELECT *
FROM revision as R, actor as A
WHERE 1=1
and A.actor_name = "Semi-Brace"
and R.rev_parent_id = 0
and R.rev_actor = A.actor_id
LIMIT 100;
*/

SQL

Checking query status...