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



;
SQL

Checking query status...
