Compare creation time of pages in ukwiki and enwiki

SQL

SELECT * FROM 
(SELECT * FROM 
   	(SELECT  ips_item_id as wikidataId, ips_site_page AS uktitle, english.entitle as entitle 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  WHERE ips_site_id= 'ukwiki' LIMIT 50)  
         bothlangs 
        
         INNER JOIN (SELECT ukwiki_p.page.page_id as en_page_id,ukwiki_p.page.page_title as uktitle2 ,MIN(ukwiki_p.revision.rev_timestamp) 
         as ukwiki_timestamp  FROM ukwiki_p.page INNER JOIN  ukwiki_p.revision ON ukwiki_p.page.page_id = ukwiki_p.revision.rev_page
         GROUP BY ukwiki_p.page.page_id) 
         ukinfo 
         ON ukinfo.uktitle2 = bothlangs.uktitle) as timestamp1
         
         INNER JOIN 
         (SELECT MIN(rev_timestamp) as enwiki_timestamp,rev_page FROM enwiki_p.revision GROUP BY rev_page) 
          eninfo ON eninfo.rev_page = timestamp1.en_page_id;
SQL

Checking query status...
