Untitled query #26362

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

	/* 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 * FROM 
  wbc_entity_usage qt6
  where qt6.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 * qt1.eu_entity_id as QID,   
     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 qt1
	     LEFT JOIN */ 
         page ON qt6.eu_page_id = page.page_id 
	

;

SQL

Checking query status...