投稿履歴抽出：新規ページ作成かつNS:4かつ特定ページ名前方一致かつ特定利用者

This query is marked as a draft This query has been published by Rxy.

`page_namespace` = '4' ← NS:4 (Wikipedia 名前空間)
`rev_parent_id` = "0" ← 新規ページ作成
`page_title` LIKE '投稿ブロック依頼/%' ← "投稿ブロック/" に前方一致
`user_name` = 'ぱたごん' ← 初版の利用者名

SQL

use jawiki_p;
SELECT `page_id`,`page_namespace`,`page_title` FROM `page`,`revision`,`user` WHERE `page_id` = `rev_page` AND `page_namespace` = '4' AND `rev_user` = `user_id` AND `rev_parent_id` = "0" AND `page_title` LIKE '投稿ブロック依頼/%' AND `rev_user` = (SELECT `user_id` FROM `user` WHERE `user_name` = 'ぱたごん');

By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.

Submit Query Stop Query

All SQL code is licensed under CC0 License.

SQL

Checking query status...