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
Jura1
.
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT page_title, pp_value, pp_sortkey FROM page, page_props WHERE page_title in ('Q23830921','Q23830592','Q23830590','Q23830581','Q23830572','Q23830571','Q23830568','Q23830564','Q23830563','Q23830087','Q23830080','Q23830053','Q23830038','Q23830037','Q23830036','Q23830035','Q23830032','Q23830031','Q23830012','Q23829645') AND page_namespace = 0 AND page_is_redirect = 0 AND page_id = pp_page AND pp_propname="wb-claims" #AND pp_value = "0" #AND pp_sortkey = 0 #AND pp_sortkey is null #AND pp_sortkey = "0" LIMIT 50 ; SELECT MAX(rc_timestamp) FROM recentchanges
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...