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.