Fork of QID to Site Links Category:Nobel_laureates_in_Economics by Viswaprabha
This query is marked as a draft This query has been published by Viswaprabha.

SQL

x
 
    /* Last edited: 2018 Apr 06 Fri 15:36 User:Viswaprabha*/ SELECT '26231' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 
USE mlwiki_p;  SET @SNum := 0; 
SELECT eu_entity_id from wbc_entity_usage where eu_entity_id in ('Q1143729','Q222541','Q105962','Q192592','Q157235','Q191020','Q205353',
                                                   'Q188113','Q204078','Q210960', 'Q109570','Q295653','Q359317','Q237821','Q47426','Q187988','Q312575','Q208124')
        
  
LEFT JOIN  
    SELECT 'ml ', @SNum:=@SNum + 1 AS SNum, eu_entity_id,   
     page_id AS PageID,  page_title AS Title, page_latest AS LastRev, page_len AS Bytes, page_is_redirect AS Redirect,        page_is_new AS New, eu_touched AS Touched,  
    page_touched AS PageTouched, page_links_updated AS LinksUpdated  
    FROM wbc_entity_usage 
        LEFT JOIN page ON wbc_entity_usage.eu_page_id = page.page_id 
            WHERE eu_aspect = 'S' and eu_entity_id in ('Q1143729','Q222541','Q105962','Q192592','Q157235','Q191020','Q205353','Q188113') 
     As PTable                                            
     
     ON eu_entity_id.eu_entity_id = PTable.eu_entity_id
;
By running queries you agree to the Cloud Services Terms of Use and you irrevocably agree to release your SQL under CC0 License.
All SQL code is licensed under CC0 License.

Checking query status...