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
Base
.
Toggle Highlighting
SQL
use ukwiki_p; CREATE ALGORITHM=UNDEFINED DEFINER=`viewmaster`@`%` SQL SECURITY DEFINER VIEW `user_bis` AS select `ukwiki`.`user`.`user_id` AS `user_id`,`ukwiki`.`user`.`user_name` AS `user_name`,`ukwiki`.`user`.`user_real_name` AS `user_real_name`,NULL AS `user_password`,NULL AS `user_newpassword`,NULL AS `user_email`,NULL AS `user_options`,NULL AS `user_touched`,NULL AS `user_token`,NULL AS `user_email_authenticated`,NULL AS `user_email_token`,NULL AS `user_email_token_expires`,`ukwiki`.`user`.`user_registration` AS `user_registration`,NULL AS `user_newpass_time`,`ukwiki`.`user`.`user_editcount` AS `user_editcount`,NULL AS `user_password_expires` from `ukwiki`.`user`
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...