Compare creation time of pages in ukwiki and enwiki

Fork of Compare creation time of pages in ukwiki and enwiki by Diego (WMF)

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

SQL

SELECT  ips_item_id as wikidataId, ips_site_page AS uktitle, english.entitle as entitle, min(enwiki_p.revision.rev_timestamp) as en_created
FROM wikidatawiki_p.wb_items_per_site  
   INNER JOIN  
  	(SELECT ips_item_id as enwikidata, ips_site_page as entitle FROM wikidatawiki_p.wb_items_per_site WHERE ips_site_id= 'enwiki') 
     as english 
     on ips_item_id=english.enwikidata 
     
   INNER JOIN enwiki_p.page ON enwiki_p.page.page_title = english.entitle
   INNER JOIN enwiki_p.revision ON enwiki_p.page.page_id = enwiki_p.revision.rev_page
     
   WHERE ips_site_id= 'ukwiki'
   GROUP BY uktitle

SQL

Checking query status...