Untitled query #64326

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

SQL

select * from revision left join page on rev_page = page_id join actor on actor_id = rev_acto
where rev_page in(select DISTINCT log_page from logging left join page on log_page = page_id where page_id is null and log_type = 'move' and log_title like 'Liangent%' and log_params like '%Liangent~zhwiki%')/* and rev_actor = 9551 and page_id is null*/

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