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
Jan Ainali (WMSE)
.
Pronunciation audio (i.e. Property:P443) added in Wikidata Menu Challenge. https://www.wikidata.org/wiki/Wikidata:Menu_Challenge
Toggle Highlighting
SQL
USE wikidatawiki_p; SELECT page_title, rev_user_text, rev_timestamp, rev_comment FROM revision JOIN page ON rev_page = page_id WHERE page_title IN ("Q17","Q34","Q48","Q89","Q142","Q152","Q178","Q195","Q196","Q500","Q787","Q830","Q881","Q1072","Q5090","Q6128","Q6663","Q7150","Q7535","Q7802","Q8486","Q8495","Q9266","Q9614","Q9896","Q10943","Q10987","Q10990","Q10998","Q11002","Q11004","Q11009","Q11575","Q13158","Q13179","Q13182","Q13187","Q13195","Q13228","Q13233","Q13290","Q14088","Q17147","Q20136","Q21154","Q22847","Q23400","Q23425","Q23485","Q23501","Q25237","Q26545","Q26686","Q28165","Q28367","Q28803","Q33913","Q34172","Q35625","Q36071","Q36465","Q37153","Q37383","Q37668","Q37937","Q39918","Q41415","Q41611","Q41716","Q44952","Q45989","Q46871","Q47859","Q47859","Q58265","Q80117","Q81464","Q93165","Q93235","Q120042","Q127900","Q130882","Q131224","Q131748","Q132263","Q133428","Q134609","Q138811","Q152088","Q152964","Q153976","Q154166","Q155909","Q156790","Q156884","Q161098","Q164606","Q165199","Q165437","Q167296","Q167893","Q170486","Q177378","Q178359","Q179010","Q179254","Q186385","Q188251","Q188788","Q191655","Q191768","Q192628","Q192874","Q193713","Q198815","Q199788","Q203925","Q204251","Q204901","Q207123","Q208172","Q209889","Q211340","Q213062","Q214415","Q217927","Q229140","Q234646","Q235169","Q241987","Q251981","Q256092","Q264619","Q275068","Q275508","Q275650","Q276276","Q277628","Q283231","Q289005","Q300472","Q311071","Q322787","Q342856","Q344355","Q349894","Q383389","Q388502","Q390456","Q404114","Q408899","Q426337","Q427457","Q432308","Q460453","Q461696","Q466430","Q470873","Q504941","Q513532","Q522171","Q545985","Q549793","Q553905","Q564570","Q599870","Q599901","Q615392","Q622350","Q625825","Q636056","Q638022","Q643419","Q667478","Q715525","Q725668","Q727605","Q742385","Q784148","Q807791","Q816704","Q828043","Q840448","Q847441","Q851746","Q854618","Q860808","Q864693","Q865325","Q865419","Q867776","Q895901","Q904889","Q917761","Q945475","Q957434","Q966327","Q1045910","Q1057953","Q1072192","Q1076906","Q1089959","Q1094882","Q1106345","Q1142459","Q1156634","Q1174370","Q1188911","Q1190414","Q1200514","Q1211297","Q1322949","Q1347028","Q1359006","Q1365996","Q1420447","Q1452513","Q1501015","Q1503716","Q1503967","Q1571226","Q1572278","Q1639520","Q1650695","Q1762893","Q2114394","Q2227032","Q2255787","Q2396858","Q2459072","Q2632776","Q2690965","Q2735024","Q2763698","Q2778993","Q2920963","Q2992510","Q3073413","Q3108255","Q3246340","Q3311757","Q3393961","Q3412448","Q3596097","Q3695900","Q3733836","Q3773650","Q3776982","Q3823549","Q3919027","Q4122049","Q4865573","Q4922798","Q5005249","Q5098941","Q5125285","Q5204114","Q5256427","Q5561980","Q5706318","Q6146274","Q6501235","Q7224757","Q7323073","Q7382955","Q8752059","Q8980672","Q10497217","Q10500887","Q10509700","Q10510197","Q10535659","Q10572454","Q10572617","Q10575468","Q10658749","Q10669607","Q10669634","Q10699143","Q10717939","Q11175039","Q11839576","Q13099586","Q13362654","Q13377687","Q13400960","Q15223654","Q16860983","Q17118835","Q19862464","Q19862473","Q19862498") AND rev_comment LIKE('%wbsetclaim-create:2||1 */ [[Property:P443]]%') AND rev_timestamp > '20150507220100' AND rev_timestamp < '20150527215900' ORDER BY rev_timestamp DESC
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...