Untitled query #26362

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 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



;
SQL

Checking query status...
