Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Viswaprabha
.
Toggle Highlighting
SQL
/* Last edited: 2018 Apr 06 Fri 04:19 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); 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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi); USE urwiki_p; SET @SNum := 0; SELECT 'ur ', @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_aspect AS Aspect, page_namespace AS NS, 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 (gu,hi);
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...