Untitled query #9396

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

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

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...