Benutzer Diskussion:Tagishsimon

BBLd ID - ISNI

Ca. 1000 BBLd IDs (P2580) have been changed. Where a Q5 item has only one ISNI, that is the new BBLd ID.

[1]

SELECT ?human ?humanLabel ?sl
(GROUP_CONCAT(DISTINCT ?bblid) AS ?bblids) 
(GROUP_CONCAT(DISTINCT (replace(?isni, " ", "")); SEPARATOR = ",") AS ?isnis)
(GROUP_CONCAT(DISTINCT ?viaf) AS ?viafs) 
(GROUP_CONCAT(DISTINCT ?gnd) AS ?gnds)
WHERE {
    ?human wdt:P31 wd:Q5 .      
    ?human wdt:P2580 ?bblid .
    ?human wikibase:sitelinks ?sl.
    {?human wdt:P213 ?isni .}
    OPTIONAL{?human wdt:P214 ?viaf .}
    OPTIONAL{?human wdt:P227 ?gnd .}
    SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en" }
}
GROUP BY ?human ?humanLabel ?sl
ORDER BY DESC(?sl) 

77.179.28.51 18:22, 7. Sep. 2018 (CEST)