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
Karthik sripal
.
Toggle Highlighting
SQL
USE commonswiki_p; #show tables; #show columns from geo_tags; #show columns from page; Select * from abuse_filter limit 10; Select * from abuse_filter_action limit 10; Select * from abuse_filter_log limit 10; Select * from archive limit 10; Select * from archive_userindex limit 10; Select * from babel limit 10; Select * from category limit 10; Select * from categorylinks limit 10; Select * from change_tag limit 10; Select * from externallinks limit 10; Select * from filearchive limit 10; Select * from filearchive_userindex limit 10; Select * from geo_tags limit 10; Select * from global_block_whitelist limit 10; Select * from globalimagelinks limit 10; Select * from image limit 10; Select * from imagelinks limit 10; Select * from interwiki limit 10; Select * from ip_changes limit 10; Select * from ipblocks limit 10; Select * from ipblocks_ipindex limit 10; Select * from iwlinks limit 10; Select * from l10n_cache limit 10; Select * from langlinks limit 10; Select * from linter limit 10; Select * from localisation limit 10; #Select * from localisation_file_hash limit 10; Select * from logging limit 10; Select * from logging_logindex limit 10; Select * from logging_userindex limit 10; #Select * from mark_as_helpful limit 10; Select * from math limit 10; Select * from module_deps limit 10; Select * from msg_resource_links limit 10; Select * from oldimage limit 10; Select * from oldimage_userindex limit 10; Select * from page limit 10; Select * from page_props limit 10; Select * from page_restrictions limit 10; Select * from pagelinks limit 10; Select * from pif_edits limit 10; Select * from protected_titles limit 10; Select * from recentchanges limit 10; Select * from recentchanges_userindex limit 10; Select * from redirect limit 10; Select * from revision limit 10; Select * from revision_userindex limit 10; Select * from site_identifiers limit 10; Select * from site_stats limit 10; Select * from sites limit 10; Select * from tag_summary limit 10; Select * from templatelinks limit 10; Select * from transcode limit 10; Select * from updatelog limit 10; #Select * from updates limit 10; Select * from user limit 10; Select * from user_former_groups limit 10; Select * from user_groups limit 10; Select * from user_properties limit 10; Select * from user_properties_anon limit 10; Select * from valid_tag limit 10; Select * from wbc_entity_usage limit 10; #Select * from wikilove_image_log limit 10; Select * from wikilove_log limit 10;
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...