query-2b07836b83b84a8b841c9b6d0af18126
Items with DOI (P356) that start with 10.1023/A: without a Label or a title (P1476) is such an item. Q58391055. I'm not sure what is causing this. That's a problem far from my skills to resolve. I have followed the DOI of these items and added the journal article's title to the item's label and title, but there are so many. I'm not even sure one couldn't create yet another item with that DOI using SourceMD (resulting in another item to fix). Example, (P1476)title that start with 10.1023/A: without a Label or a (P356)DOI There are quite a few items with , I can create a table to generate a correction through QuickStatement. (P1476)title that start with 10.1023/A: without a Label or a (P356)DOI Can someone create a list for me that has the QID and the DOI (as a link, preferably) for those items with 01:53, 4 July 2021 (UTC)) talk (TrilotatIf anyone can prevent this from continuing to happen, it would be nice to think there's a list that I can correct and it won't continue to add new items without a title. Thank you, 13:16, 4 July 2021 (UTC) Jura has a title-statement, but that doesn't really help. Looks like some cleanup is needed. --- Q57554778 finds some .. https://www.wikidata.org/w/index.php?search=10.1023&fulltext=1&ns0=1: (P1433)published in BTW, you could also try starting out from } } ."[AUTO_LANGUAGE],en" language:wikibase serviceParam:bd { label:wikibase SERVICE } ?doi P356:wdt ?item { OPTIONAL } [] P1476:wdt ?item { NOT EXISTS FILTER . Q5133623:wd P1433:wdt ?item { WHERE ?doi ?itemDescription ?itemLabel ?item SELECT 13:16, 4 July 2021 (UTC) Jura --- 17:20, 4 July 2021 (UTC)) talk (Trilotat: A follow-up... This is working better than expected! I have been able to update a few hundred items very quickly working through your list. I then went on to find other journals published by SpringerLink plugged into your query. Thanks so much. I'll keep looking for examples and then chasing down others published in that journal. Jura1@ 16:05, 4 July 2021 (UTC)) talk (Trilotat: Thank you! Hey, did you provide an example of items in that specific journal as an example? It works for me, but I was hoping for ALL journals. If you limited to items that are scholarly articles, that might limit some. Did you limit to a specific journal because otherwise it times out? Thanks again, I can address these pretty quickly now so thank you so much. Jura1@For the query, I used that journal as it was in your sample. Apparently "10.1023" could be any Springer publication. The below is probably closer to your question: } } "[AUTO_LANGUAGE],en" language:wikibase serviceParam:bd { label:wikibase SERVICE } ?instance_of P31:wdt ?item { OPTIONAL } [] P1476:wdt ?item { NOT EXISTS FILTER ) )?search_string ,?doi(CONTAINS ( FILTER ?doi P356:wdt ?item ) )?item(BOUND (FILTER } . title:mwapi apiOutputItem:wikibase ?item . "0" gsrnamespace:mwapi serviceParam:bd . "max" gsrlimit:mwapi serviceParam:bd . ?search_string gsrsearch:mwapi serviceParam:bd . "search" generator:mwapi serviceParam:bd . "Generator" api:wikibase serviceParam:bd . "www.wikidata.org" endpoint:wikibase serviceParam:bd { mwapi:wikibase SERVICE ."None" optimizer:hint Query:hint ) ?search_string as "10.1023/A" ( BIND { WHERE ?instance_ofLabel ?instance_of ?itemLabel ?item SELECT 18:11, 4 July 2021 (UTC) Jura--- 18:30, 8 July 2021 (UTC)) talk (Trilotat: I've completed this update. Truth is, though, every time I run this, it seems to add previously unseen items to repair. After a few days and running it again and again, I just ran it and got NO results. I wonder how many will be on it the next time. The new items don't seem to have changed. Thanks again. Jura1@ 04:46, 6 July 2021 (UTC)) talk (Trilotat: even better!! Thank you, Jura1:@
Use at
- https://query.wikidata.org/sparql
PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT (COUNT(*) as ?count)
WHERE
{
BIND ( "10.1023/A" as ?search_string )
SERVICE wikibase:mwapi
{
bd:serviceParam wikibase:endpoint "www.wikidata.org" .
bd:serviceParam wikibase:api "Generator" .
bd:serviceParam mwapi:generator "search" .
bd:serviceParam mwapi:gsrsearch ?search_string .
bd:serviceParam mwapi:gsrlimit "max" .
bd:serviceParam mwapi:gsrnamespace "0" .
?item wikibase:apiOutputItem mwapi:title .
}
}