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')
  		as QTable
  
LEFT JOIN 

	 (SELECT 'ml ', @SNum:=@SNum + 1 AS SNum, 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` 
		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 QTable.`eu_entity_id` = PTable.QID )  



;
SQL

Checking query status...
