query-18593b858165710ea6195a3a56325fbd
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:
Use at
- https://query.wikidata.org/sparql
PREFIX mwapi: <http://wikiba.se/ontology#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT ?item ?itemLabel ?instance_of ?instance_ofLabel
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 .
}
FILTER( BOUND(?item) )
?item wdt:P356 ?doi
FILTER ( CONTAINS(?doi, ?search_string) )
FILTER NOT EXISTS { ?item wdt:P1476 [] }
OPTIONAL { ?item wdt:P31 ?instance_of }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}