NPP reviews accounting for moved pages - Quarry

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

SQL

select * from actor where actor_user = 301395;
select * from logging log1, logging log2 
where log1.log_actor = 46747 and log1.log_type = 'delete' and log1.log_action = 'restore' and log1.log_timestamp < 20130301000000
and log1.log_namespace = log2.log_namespace and log1.log_title = log2.log_title and log2.log_type = 'move'
order by log1.log_timestamp desc, log2.log_timestamp desc limit 2

AخA
 
select * from actor where actor_user = 301395;select * from logging log1, logging log2 where log1.log_actor = 46747 and log1.log_type = 'delete' and log1.log_action = 'restore' and log1.log_timestamp < 20130301000000and log1.log_namespace = log2.log_namespace and log1.log_title = log2.log_title and log2.log_type = 'move'order by log1.log_timestamp desc, log2.log_timestamp desc limit 2

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.

Checking query status...