Wikidata QID for Site links "Category:States_and_union_territories_of_India"

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

/* Last edited: 2018 Apr 06 Fri 12:21 User:Viswaprabha*/ SELECT '26172' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; 
USE bnwiki_p;  SET @SNum := 0; SELECT 'bn ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE enwiki_p;  SET @SNum := 0; SELECT 'en ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE guwiki_p;  SET @SNum := 0; SELECT 'gu ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE hiwiki_p;  SET @SNum := 0; SELECT 'hi ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE knwiki_p;  SET @SNum := 0; SELECT 'kn ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE mlwiki_p;  SET @SNum := 0; 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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE mrwiki_p;  SET @SNum := 0; SELECT 'mr ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE orwiki_p;  SET @SNum := 0; SELECT 'or ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE pawiki_p;  SET @SNum := 0; SELECT 'pa ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE sawiki_p;  SET @SNum := 0; SELECT 'sa ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE tawiki_p;  SET @SNum := 0; SELECT 'ta ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
USE tewiki_p;  SET @SNum := 0; SELECT 'te ', @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 ('Q131541','Q1159','Q1162','Q1164','Q1165','Q1168','Q1061','Q1174','Q1184','Q1188','Q1191','Q1193','Q1502','Q1599','Q22048','Q22424','Q1437','Q1445','Q1363','Q467745','Q1498','Q1499','Q1356');
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...
