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
.
sa,ta,te,ur
Toggle Highlighting
SQL
/*20180419 User:Viswaprabha*/ SELECT '10923' as Quarry , 'Last Updated (UTC):'+ NOW() as Time ; use sawiki_p; SET @snum := 0; SELECT 'sa' AS lang,@snum := @snum + 1 AS SNum, 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, 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, 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, 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...