Nuke pattern and recent changes matching

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

The pattern is not working for mass delete (Nuke)

SQL

select * from recentchanges rc
left join actor a on rc_actor = actor_id
where actor_name = 'Nux'
and rc_new = 1
and rc_title like 'Nux/CzyWieszTest/%'
order by rc_id asc
limit 10

​x
 
select * from recentchanges rcleft join actor a on rc_actor = actor_idwhere actor_name = 'Nux'and rc_new = 1and rc_title like 'Nux/CzyWieszTest/%'order by rc_id asclimit 10​

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