query-4403058ff468ad5dd6dbb153ea7a8e6b

rq turtle/ttl

Cyrillic merges 03:33, 19 September 2015 (UTC) Jura). Maybe it's possible to find similar items merely based on labels in these languages and merge them. --- Q12171178 / Q15061198 included pairs of items with articles at ruwiki and ukwiki each (Sample: This16:33, 3 November 2015 (UTC) JuraThe ones on that list are identified based on dates of birth/death and we regularly go through them. The occasional findings there (also with ru/be) suggest that there are more (without dates). A query would need to be done to find them. --- 16:27, 3 November 2015 (UTC)) talk (InfovariusI cannot find any ru-uk pairs. Are they all done? --16:43, 2 December 2015 (UTC) Jura includes quite a few, thanks to new dates of birth/death being added. --- the listToday 11:44, 6 December 2015 (UTC) Jura. --- sample be/ru: (Q21640602)Add Names as labels A step could involve reviewing suggestions for missing labels in one language based on labels in another languages with 10:17, 15 December 2015 (UTC) Jura, merged since). --- sampleI came across a few items that had interwikis in ukwiki to ruwiki, but as they were on separate items, these weren't used to link the articles to existing items (

Use at

• https://query.wikidata.org/sparql

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?item ?Spanishlabel ?item2 ?Italianlabel
WHERE 
{
    VALUES ?item { wd:Q19909894 }
    ?item wdt:P31 wd:Q5 .

    VALUES ?item2 { wd:Q16704775 }
    ?item2 wdt:P31 wd:Q5 .

    ?item rdfs:label ?Spanishlabel . FILTER(lang(?Spanishlabel)="ru")
    BIND(REPLACE(?Spanishlabel, ",", "") as ?Spanishlabel2)

    ?item2 rdfs:label ?Italianlabel . FILTER(lang(?Italianlabel)="uk")

    FILTER(str(?Spanishlabel2) = str(?Italianlabel))
    FILTER(str(?Spanishlabel) != str(?Italianlabel))
}
LIMIT 1

#added by Jura1

Query found at

• https://www.wikidata.org/wiki/Wikidata:Bot_requests/Archive/2016/09