Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
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
.
Toggle Highlighting
SQL
/* Last edited: 2018 Apr 06 Fri 15:36 User:Viswaprabha*/ SELECT '26173' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; USE bnwiki_p; SET @SNum := 0; SELECT concat('|- |','bn ||') as 'bn', concat(@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','Q204078','Q210960','Q109570','Q295653','Q359317','Q237821','Q47426','Q187988','Q312575','Q208124','Q1386049','Q272510','Q432890','Q1325','Q312561','Q184862','Q354897','Q157262','Q233950','Q107441','Q295761','Q110968','Q131112','Q192577','Q211097','Q44061','Q272519','Q107264','Q272508','Q233051','Q312560','Q235843','Q287542','Q157255','Q176643','Q205850','Q109721','Q219721','Q232949','Q152452','Q128736','Q243193','Q179493','Q153761','Q192566','Q109582','Q312585','Q28542','Q102454','Q107964','Q206460','Q295647','Q233947','Q12830','Q132489','Q244739','Q274111','Q338151','Q181529','Q109737','Q295717','Q157268','Q157245','Q243534','Q18430','Q219733','Q371212','Q183181','Q173994','Q211776','Q295673','Q232062');
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...