Untitled query #19662

This query is marked as a draft This query has been published by Bulgu.

SQL

use wikidatawiki_p;

-- show tables;

select * from abuse_filter
limit 5; select * from 
abuse_filter_action
limit 5; select * from 
abuse_filter_log
limit 5; select * from 
archive
limit 5; select * from 
archive_userindex
limit 5; select * from 
category
limit 5; select * from 
categorylinks
limit 5; select * from 
change_tag
limit 5; select * from 
externallinks
limit 5; select * from 
filearchive
limit 5; select * from 
filearchive_userindex
limit 5; select * from 
geo_tags
limit 5; select * from 
global_block_whitelist
limit 5; select * from 
globalblocks
limit 5; select * from 
image
limit 5; select * from 
imagelinks
limit 5; select * from 
interwiki
limit 5; select * from 
ipblocks
limit 5; select * from 
ipblocks_ipindex
limit 5; select * from 
iwlinks
limit 5; select * from 
l10n_cache
limit 5; select * from 
langlinks
limit 5; select * from 
linter
limit 5; select * from 
logging
limit 5; select * from 
logging_logindex
limit 5; select * from 
logging_userindex
limit 5; select * from 
math
limit 5; select * from 
module_deps
limit 5; select * from 
msg_resource_links
limit 5; select * from 
oldimage
limit 5; select * from 
oldimage_userindex
limit 5; select * from 
ores_classification
limit 5; select * from 
ores_model
limit 5; select * from 
page
limit 5; select * from 
page_props
limit 5; select * from 
page_restrictions
limit 5; select * from 
pagelinks
limit 5; select * from 
protected_titles
limit 5; select * from 
recentchanges
limit 5; select * from 
recentchanges_userindex
limit 5; select * from 
redirect
limit 5; select * from 
revision
limit 5; select * from 
revision_userindex
limit 5; select * from 
site_identifiers
limit 5; select * from 
site_stats
limit 5; select * from 
sites
limit 5; select * from 
tag_summary
limit 5; select * from 
templatelinks
limit 5; select * from 
transcode
limit 5; select * from 
updatelog
limit 5;  select * from 
user
limit 5; select * from 
user_former_groups
limit 5; select * from 
user_groups
limit 5; select * from 
user_properties
limit 5; select * from 
user_properties_anon
limit 5; select * from 
valid_tag
limit 5; select * from 
watchlist_count
limit 5; select * from 
wb_changes
limit 5; select * from 
wb_changes_dispatch
limit 5; select * from 
wb_changes_subscription
limit 5; select * from 
wb_entity_per_page
limit 5; select * from 
wb_id_counters
limit 5; select * from 
wb_items_per_site
limit 5; select * from 
wb_property_info
limit 5; select * from 
wb_terms
limit 5; select * from 
wbc_entity_usage
limit 5; select * from 
wbs_propertypairs
limit 5;



/*select * from page wp

where wp.page_title in ("Q720")
;
/*
select * from  page p
join page_props on pp_page = p.page_id
join wikidatawiki_p.page wp on wp.page_title = pp_value
where p.page_namespace = 0
and p.page_id = 10
and pp_propname = "wikibase_item"
;
*/

​x
 
use wikidatawiki_p;​-- show tables;​select * from abuse_filterlimit 5; select * from abuse_filter_actionlimit 5; select * from abuse_filter_loglimit 5; select * from archivelimit 5; select * from archive_userindexlimit 5; select * from categorylimit 5; select * from categorylinkslimit 5; select * from change_taglimit 5; select * from externallinkslimit 5; select * from filearchivelimit 5; select * from filearchive_userindexlimit 5; select * from geo_tagslimit 5; select * from global_block_whitelistlimit 5; select * from globalblockslimit 5; select * from imagelimit 5; select * from imagelinkslimit 5; select * from interwikilimit 5; select * from ipblockslimit 5; select * from ipblocks_ipindexlimit 5; select * from iwlinkslimit 5; select * from l10n_cachelimit 5; select * from langlinkslimit 5; select * from linterlimit 5; select * from logginglimit 5; select * from logging_logindexlimit 5; select * from logging_userindexlimit 5; select * from mathlimit 5; select * from module_depslimit 5; select * from msg_resource_linkslimit 5; select * from oldimagelimit 5; select * from oldimage_userindexlimit 5; select * from ores_classificationlimit 5; select * from ores_modellimit 5; select * from pagelimit 5; select * from page_propslimit 5; select * from page_restrictionslimit 5; select * from pagelinkslimit 5; select * from protected_titleslimit 5; select * from recentchangeslimit 5; select * from recentchanges_userindexlimit 5; select * from redirectlimit 5; select * from revisionlimit 5; select * from revision_userindexlimit 5; select * from site_identifierslimit 5; select * from site_statslimit 5; select * from siteslimit 5; select * from tag_summarylimit 5; select * from templatelinkslimit 5; select * from transcodelimit 5; select * from updateloglimit 5;  select * from userlimit 5; select * from user_former_groupslimit 5; select * from user_groupslimit 5; select * from user_propertieslimit 5; select * from user_properties_anonlimit 5; select * from valid_taglimit 5; select * from watchlist_countlimit 5; select * from wb_changeslimit 5; select * from wb_changes_dispatchlimit 5; select * from wb_changes_subscriptionlimit 5; select * from wb_entity_per_pagelimit 5; select * from wb_id_counterslimit 5; select * from wb_items_per_sitelimit 5; select * from wb_property_infolimit 5; select * from wb_termslimit 5; select * from wbc_entity_usagelimit 5; select * from wbs_propertypairslimit 5;​​​/*select * from page wp​where wp.page_title in ("Q720");/*select * from  page pjoin page_props on pp_page = p.page_idjoin wikidatawiki_p.page wp on wp.page_title = pp_valuewhere p.page_namespace = 0and p.page_id = 10and pp_propname = "wikibase_item";*/​​

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.

SQL

Checking query status...