Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
Fork of
See data sample of Wikimedia commons data | commonswiki_p tables
by
Karthik sripal
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; show columns from abuse_filter ; show columns from abuse_filter_action ; show columns from abuse_filter_log ; show columns from archive ; show columns from archive_userindex ; show columns from babel ; show columns from category ; show columns from categorylinks ; show columns from change_tag ; show columns from externallinks ; show columns from filearchive ; show columns from filearchive_userindex ; show columns from geo_tags ; show columns from global_block_whitelist ; show columns from globalimagelinks ; show columns from image ; show columns from imagelinks ; show columns from interwiki ; show columns from ip_changes ; show columns from ipblocks ; show columns from ipblocks_ipindex ; show columns from iwlinks ; show columns from l10n_cache ; show columns from langlinks ; show columns from linter ; show columns from localisation ; #show columns from localisation_file_hash ; show columns from logging ; show columns from logging_logindex ; show columns from logging_userindex ; #show columns from mark_as_helpful ; show columns from math ; show columns from module_deps ; show columns from msg_resource_links ; show columns from oldimage ; show columns from oldimage_userindex ; show columns from page ; show columns from page_props ; show columns from page_restrictions ; show columns from pagelinks ; show columns from pif_edits ; show columns from protected_titles ; show columns from recentchanges ; show columns from recentchanges_userindex ; show columns from redirect ; show columns from revision ; show columns from revision_userindex ; show columns from site_identifiers ; show columns from site_stats ; show columns from sites ; show columns from tag_summary ; show columns from templatelinks ; show columns from transcode ; show columns from updatelog ; #show columns from updates ; show columns from user ; show columns from user_former_groups ; show columns from user_groups ; show columns from user_properties ; show columns from user_properties_anon ; show columns from valid_tag ; show columns from wbc_entity_usage ; #show columns from wikilove_image_log ; show columns from wikilove_log ;
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...