Find draftifications of old articles

SQL

/* Find draftifications of old articles */


SELECT  
  *,
  (
    SELECT MIN(rev_timestamp)
	FROM revision
	WHERE revision.rev_page = page.page_id
  ) as oldest_revision
FROM page
-- WHERE page.page_title = 'Future Generation Europe'
WHERE page.page_id = 62139187
LIMIT 10;



-- SELECT  *
-- FROM logging
-- JOIN page 
-- ON logging.log_title = page.page_title
-- AND page.page_namespace = 118
-- JOIN 
--    
-- 	
-- 	
-- WHERE logging.log_type = 'move'
-- AND logging.log_namespace = 0
-- AND page.page_is_redirect = 0
-- AND log_params LIKE '%Draft:%'
-- ORDER BY logging.log_timestamp DESC
-- LIMIT 10;
SQL

Checking query status...
