QID to Site Links Category:Nobel_laureates_in_Economics

This query is marked as a draft This query has been published by Viswaprabha.
SQL

	/* Last edited: 2018 Apr 13 Fri 07:21 User:Viswaprabha*/ SELECT '26173' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 
USE bnwiki_p;  SET @SNum := 0; SELECT 'bn ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE enwiki_p;  SET @SNum := 0; SELECT 'en ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE guwiki_p;  SET @SNum := 0; SELECT 'gu ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE hiwiki_p;  SET @SNum := 0; SELECT 'hi ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE knwiki_p;  SET @SNum := 0; SELECT 'kn ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE mlwiki_p;  SET @SNum := 0; SELECT 'ml ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE mrwiki_p;  SET @SNum := 0; SELECT 'mr ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE orwiki_p;  SET @SNum := 0; SELECT 'or ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE pawiki_p;  SET @SNum := 0; SELECT 'pa ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE sawiki_p;  SET @SNum := 0; SELECT 'sa ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE tawiki_p;  SET @SNum := 0; SELECT 'ta ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE tewiki_p;  SET @SNum := 0; SELECT 'te ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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');
USE urwiki_p;  SET @SNum := 0; SELECT 'ur ', @SNum:=@SNum + 1 AS SNum, concat("[[D:",eu_entity_id,"]]") AS QID,  page_id AS PageID,  concat("[[",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.
SQL

Checking query status...
