Has a user edited after a timestamp?

This query is marked as a draft This query has been published by ಮಲ್ನಾಡಾಚ್ ಕೊಂಕ್ಣೊ.

SQL

select case when COUNT(*) > 0 -- If an entry exists in filtered revision table, the user has edited else not edited
                 then 'Has edited'
                 else 'Has not edited'
       end as 'User has edited or not?'
from revision
join actor on rev_actor = actor_id -- link revision and actor table
and actor_name = '203.94.130.78' -- Username or IP address to check whether they have edited
and rev_timestamp > '20170504000000'; -- timestamp to check

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