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 ( 18696, 36857, 42621, 63587, 132666, 132813, 133024, 133270, 133342, 176946, 188419, 209174, 215402, 220315, 234792, 328369, 366723, 372949, 381728, 382441, 394327, 445478, 475329, 492905, 499210, 500054, 589072, 591450, 622377, 637988, 638105, 662750, 674275, 754659, 754983, 766050, 767024, 769863, 783432, 785301, 796140, 848840, 907248, 917293, 925958, 950661, 965012, 978458, 1112860, 1123578, 1133903, 1192405, 1200566, 1320143, 1345388, 1360474, 1361748, 1410542, 1411725, 1434121, 1435091, 1445211, 1470764, 1538807, 1548283, 1568355, 1569387, 1570264, 1620205, 1709857, 1784209, 1813955, 1853154, 1922589, 2141770, 2313420, 2314540, 2370000, 2409399, 2420570, 2475989, 2478975, 2513125, 2535935, 2553985, 2562599, 2570409, 2576226, 2707058, 2850019, 3039055, 3177438, 3402333, 3403787, 3467704, 3494746, 3612068, 3745023, 3768789, 3820248, 3924358, 4002998, 4006429, 4691832, 4748399, 4830105, 5046325, 5156044, 5195335, 5251091, 5282726, 5327182, 5333234, 5391785, 5444079, 5575496, 5959258, 6105961, 6146887, 6321987, 6580786, 6626915, 6633490, 6647090, 6654574, 6821418, 6901585, 6921783, 7268458, 7313244, 7317085, 7439311, 7808425, 8985570, 10395284, 10508905, 11702361, 12900190, 13419831, 15220921, 16152614, 16556658, 16635184, 16889242, 16920908, 16938027, 17009294, 17021044, 17105315, 17119252, 18466271, 20673567, 21448022, 21856072, 24901341, 24963002, 25037145, 28134866, 63535006, 103931230 ) 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...