query-bf797de9d7d26445c3db857162921344
Batch mode creations ]reply[20:35, 25 December 2022 (UTC)) talk (EmuHi, please don’t use batch mode for QS item creations. This mode is prone to creation of duplicates. -- ]reply[20:40, 25 December 2022 (UTC)) talk (EmuActually, could you fix this mess yourself? Here’s the query: --]reply[11:11, 3 January 2023 (UTC)) talk (EmuThe batch mode is quite handy but has serious limitations for item creations, qualifiers and references. OpenRefine has the advantage that you can still use batches (and thus have your edits in a handy list) but isn’t without its challenges as well. But it might be worth a try. -- ]reply[10:54, 3 January 2023 (UTC)) talk (MessensFienGood to know, will never use the batch mode ever again. My dataset was cleaned in OpenRefine. After this the community recommended to use QuickStatements for the upload. Would you suggest to directly ingest new items in Wikidata with OpenRefine? ]reply[10:51, 3 January 2023 (UTC)) talk (EmuPlease don’t use batch mode when creating new items with QuickStatements. It simply doesn’t work reliably. Use the normal (non-batch) mode or use other tools like OpenRefine. -- ]reply[10:49, 3 January 2023 (UTC)) talk (MessensFienThanks for alert! I will go through the doubles and tag them as a wikimedia-doublure. ]reply[10:47, 3 January 2023 (UTC)) talk (Emu. Please stop immediately! --(Q115982704)Victorius Schoonbroodt and (Q115982705)Victorius Schoonbroodt You continue to create duplicates, e.g. ]reply[09:06, 2 January 2023 (UTC)) talk (Emu was missing. There seem to be four more duplicates created by someone else –c could you have a look at it? I’m not sure if they really are duplicates … --}Thank you! I fixed the query, one ]reply[07:25, 2 January 2023 (UTC)) talk (MessensFienSorry for the creation of certain duplicates. In the future I will only use the normal run mode in QS. I already tried to fix it with adding the Wikimedia-doublure to the instance of-statement. Is this the correct method? I tried to run the query but I got some errors.
Use at
- https://query.wikidata.org/sparql
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX bd: <http://www.bigdata.com/rdf#>
SELECT DISTINCT ?item1 ?item1Label ?item2 ?item2Label ?value
{
?item1 wdt:P2372 ?value .
?item2 wdt:P2372 ?value .
FILTER( ?item1 != ?item2 && STR( ?item1 ) < STR( ?item2 ) ) .
SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}