Has a page received edits after a timestamp?

SQL

select case when COUNT(*) > 0 -- If an entry exists, the page has been edited else not edited
                 then 'Yes'
                 else 'No'
       end as 'Page has been edited?'
from revision
join page on page_id = rev_page -- link with page table
where page_title = '121.208.212.82' -- page title without namespace prefix
and page_namespace = 3 -- page namespace
and rev_timestamp > '20170504000000'; -- check if it received edits after this timestamp

​x
 
select case when COUNT(*) > 0 -- If an entry exists, the page has been edited else not edited                 then 'Yes'                 else 'No'       end as 'Page has been edited?'from revisionjoin page on page_id = rev_page -- link with page tablewhere page_title = '121.208.212.82' -- page title without namespace prefixand page_namespace = 3 -- page namespaceand rev_timestamp > '20170504000000'; -- check if it received edits after this timestamp​

SQL

Checking query status...