Untitled query #19662

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 
updates
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"
;
*/
SQL

Checking query status...
