[Wikidata-bugs] [Maniphest] [Edited] T213536: WDQS returns 2 month old data

Fri, 11 Jan 2019 03:37:31 -0800

MichaelSchoenitzer updated the task description. (Show Details)

CHANGES TO TASK DESCRIPTION
[[ https://query.wikidata.org/embed.html#%23TEMPLATE%3D%7B%20%22template%22%3A%20%7B%20%22en%22%3A%20%22settlements%20in%20%3Fstate%20with%20more%20than%20one%20word%20in%20the%20name%22%20%7D%2C%20%22variables%22%3A%20%7B%20%22%3Fstate%22%3A%20%7B%20%22query%22%3A%20%22SELECT%20DISTINCT%20%3Fid%20WHERE%20%7B%20%3Fid%20wdt%3AP31%2Fwdt%3AP279*%20wd%3AQ3624078%3B%20p%3AP463%20%3FmemberOfStatement.%20%3FmemberOfStatement%20a%20wikibase%3ABestRank%3B%20ps%3AP463%20wd%3AQ1065.%20MINUS%20%7B%20%3FmemberOfStatement%20pq%3AP582%20%3FendTime.%20%7D%20MINUS%20%7B%20%3Fid%20wdt%3AP576%7Cwdt%3AP582%20%3Fend.%20%7D%20%7D%22%20%7D%20%7D%20%7D%0A%23defaultView%3AMap%7B%20%22layer%22%3A%20%22%3Fwords%22%2C%20%22hide%22%3A%20%5B%22%3Fwords%22%2C%20%22%3Fcoordinates%22%5D%20%7D%0ASELECT%20%3Fcity%20%3FcityLabel%20%3Fwords%20%3Fcoordinates%20WHERE%20%7B%0A%20%20BIND(wd%3AQ183%20AS%20%3Fstate)%0A%20%20%3Fcity%20(wdt%3AP31%2Fwdt%3AP279*)%20wd%3AQ486972.%0A%20%20%3Fcity%20wdt%3AP17%20%3Fstate.%0A%20%20%3Fcity%20wdt%3AP625%20%3Fcoordinates.%0A%20%20%3Fcity%20wdt%3AP1448%20%3FcityLabel.%0A%20%20BIND(IF(REGEX(%3FcityLabel%2C%20%22%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%22)%2C%20%225%2B%22%40en%2C%20IF(REGEX(%3FcityLabel%2C%20%22%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%22)%2C%20%224%22%40en%2C%20IF(REGEX(%3FcityLabel%2C%20%22%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%22)%2C%20%223%22%40en%2C%20%222%22%40en)))%20AS%20%3Fwords)%0A%20%20FILTER(REGEX(%3FcityLabel%2C%20%22%5C%5Cw%5C%5CW%2B%5C%5Cw%22))%0A%20%20FILTER(REGEX(%3FcityLabel%2C%20%22%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%5B%5E%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%2B%5B%5C%5Cp%7BIsAlphabetic%7D%5C%5Cp%7Bgc%3DMn%7D%5C%5Cp%7Bgc%3DMe%7D%5C%5Cp%7Bgc%3DMc%7D%5C%5Cp%7BIsDigit%7D%5C%5Cp%7Bgc%3DPc%7D%5D%22))%0A%7D%0AORDER%20BY%20DESC(%3Fwords) | This query ]] retruns "Essenbach, Markt", but this label [[ https://www.wikidata.org/w/index.php?title=Q269499&diff=798533510&oldid=770985502 | has been removed from the corresponding item on November 25th 2018 ]].

TASK DETAIL
https://phabricator.wikimedia.org/T213536

EMAIL PREFERENCES
https://phabricator.wikimedia.org/settings/panel/emailpreferences/

To: MichaelSchoenitzer
Cc: Aklapper, MichaelSchoenitzer, Nandana, Lahi, Gq86, Lucas_Werkmeister_WMDE, GoranSMilovanovic, QZanden, EBjune, merbst, LawExplorer, _jensen, D3r1ck01, Jonas, Xmlizer, jkroll, Smalyshev, Wikidata-bugs, Jdouglas, aude, Tobias1984, Manybubbles, Mbch331
_______________________________________________
Wikidata-bugs mailing list
Wikidata-bugs@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikidata-bugs

Reply via email to