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
EdwardAlexanderCrowley
.
Toggle Highlighting
SQL
use wikidatawiki_p; SELECT ips_item_id, ips_site_page from wb_items_per_site, sites WHERE ips_site_id = "zhwiki" AND ips_site_id = site_global_key AND ips_item_id in ( 42621, 63587, 132666, 132813, 133024, 133270, 133342, 188419, 209174, 215402, 328369, 366723, 381728, 382441, 475329, 499210, 500054, 589072, 591450, 622377, 637988, 754983, 766050, 767024, 783432, 785301, 796140, 848840, 907248, 917293, 925958, 978458, 1200566, 1320143, 1360474, 1361748, 1410542, 1434121, 1435091, 1538807, 1569387, 1570264, 1709857, 1813955, 1853154, 1922589, 2141770, 2314540, 2420570, 2475989, 2478975, 2513125, 2535935, 2553985, 2570409, 2850019, 3039055, 3402333, 3403787, 3467704, 3494746, 3768789, 3924358, 4002998, 4691832, 4748399, 5046325, 5156044, 5333234, 5391785, 5444079, 5575496, 6105961, 6146887, 6321987, 6626915, 6633490, 6647090, 6654574, 6921783, 7268458, 7439311, 7808425, 8985570, 12900190, 13419831, 15220921, 16152614, 16556658, 16635184, 16920908, 16938027, 17009294, 17119252, 20673567, 21448022, 21856072, 24901341, 25037145, 28134866, 63535006 ) ORDER BY ips_item_id #AND site_group = "wikipedia"
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...