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
/*20180419 User:Viswaprabha*/ SELECT '10923' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; use bnwiki_p; SET @snum := 0; SELECT 'bn' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use guwiki_p; SET @snum := 0; SELECT 'gu' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use hiwiki_p; SET @snum := 0; SELECT 'hi' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use knwiki_p; SET @snum := 0; SELECT 'kn' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use mlwiki_p; SET @snum := 0; SELECT 'ml' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use mrwiki_p; SET @snum := 0; SELECT 'mr' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use orwiki_p; SET @snum := 0; SELECT 'or' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use pawiki_p; SET @snum := 0; SELECT 'pa' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use sawiki_p; SET @snum := 0; SELECT 'sa' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use tawiki_p; SET @snum := 0; SELECT 'ta' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use tewiki_p; SET @snum := 0; SELECT 'te' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ; use urwiki_p; SET @snum := 0; SELECT 'ur' AS lang, @snum := @snum + 1 AS SNum, distinct user_id , user_name, user_editcount FROM user where user_editcount > 0 ;
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...