User:Thibaut120094/SPARQL

Labels ja/frEdit

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
prefix schema: <http://schema.org/>
 Select distinct ?sujet ?sujetLabel ?articleja ?articlefr { 

  ?articleja schema:about ?sujet .
  ?articleja schema:inLanguage "ja" .
  ?articleja wikibase:badge wd:Q17437796 . 
   

  ?articlefr rdf:type schema:Article .
  ?articlefr schema:about ?sujet .
  ?articlefr schema:inLanguage "fr" .
   
  filter not exists {
   ?articlefr wikibase:badge wd:Q17437796 .
  }
   
  filter regex(str(?articlefr), "wikipedia") .
  filter regex(str(?articleja), "wikipedia") .
          
  
  SERVICE wikibase:label {
   bd:serviceParam wikibase:language "fr" .
  }
 }
Try it!
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
prefix schema: <http://schema.org/>

Select ?sujet ?sujetLabel where { 

  ?article schema:about ?sujet .
  ?article schema:inLanguage "ja" .
  ?article wikibase:badge wd:Q17437796 .
  
  minus {
      ?articlefr schema:about ?sujet .
      ?articlefr schema:inLanguage "fr" .
  }
  
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "fr,ja" .
  }
 }
Try it!
PREFIX bd: <http://www.bigdata.com/rdf#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
prefix schema: <http://schema.org/>

Select ?sujet ?sujetLabel ?badgeLabel where { 

  ?article schema:about ?sujet .
  ?article schema:inLanguage "ja" .
  ?article wikibase:badge ?badge .
  
  minus {
      ?articlefr schema:about ?sujet .
      ?articlefr schema:inLanguage "fr" .
  }
  
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "fr,ja" .
  }
 }
Try it!
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/> 
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX v: <http://www.wikidata.org/prop/statement/>
prefix schema: <http://schema.org/>
 Select distinct ?sujet ?sujetLabel ?articleja ?articlefr ?badgeLabel { 

  ?articleja schema:about ?sujet .
  ?articleja schema:inLanguage "ja" .
  ?articleja wikibase:badge ?badge . 
   

  ?articlefr rdf:type schema:Article .
  ?articlefr schema:about ?sujet .
  ?articlefr schema:inLanguage "fr" .
   
  filter not exists {
   ?articlefr wikibase:badge wd:Q17437796 .
  }
   
  filter regex(str(?articlefr), "wikipedia") .
  filter regex(str(?articleja), "wikipedia") .
          
  
  SERVICE wikibase:label {
   bd:serviceParam wikibase:language "fr,ja" .
  }
 }
Try it!

AutresEdit

SELECT ?item ?label ?sexe
WHERE
{
  ?item schema:description "Japanese voice actor"@en.
  OPTIONAL {
    ?item schema:description ?label.}
  OPTIONAL{
      ?item wdt:P21 ?sexe.}     
    FILTER(LANG(?label) = "fr").
  }
Try it!
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>

select ?entity ?value 

{
?entity wdt:P31 wd:Q5.
?entity wdt:P1814 ?value.
filter (contains(?value,"ア"))
  }
Try it!
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>

select ?entity ?entityLabel ?value

WHERE
{
  ?entity wdt:P31 wd:Q5.
  ?entity wdt:P1814 ?value.
  filter (contains(?value,"ア")).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }.
  }
Try it!
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>

select ?entity ?entityLabel ?value ?sportLabel ?occLabel ?natLabel

WHERE
{
  ?entity wdt:P31 wd:Q5.
  ?entity wdt:P1814 ?value.
  ?entity wdt:P106 ?occ.
  ?entity wdt:P27 ?nat.
  ?entity wdt:P641 ?sport.
  filter (contains(?value,"ア")).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }.
  }
Try it!
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX p: <http://www.wikidata.org/prop/>
PREFIX ps: <http://www.wikidata.org/prop/statement/>
PREFIX pq: <http://www.wikidata.org/prop/qualifier/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX bd: <http://www.bigdata.com/rdf#>

select ?entity ?entityLabel ?value ?sportLabel ?occLabel ?natLabel

WHERE
{
  ?entity wdt:P31 wd:Q5.
  ?entity wdt:P1814 ?value.
  ?entity wdt:P106 ?occ.
  ?entity wdt:P27 ?nat.
  ?entity wdt:P641 ?sport.
  filter (contains(?value,"ア")).
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }.
  }
Try it!

P1814 but not P27/Q17Edit

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P1814 [];
        wdt:P27 [] .
  MINUS { ?item wdt:P27 wd:Q17 } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

P27/Q17 but no P1814Edit

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P27 wd:Q17 .
  MINUS { ?item wdt:P1814 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

P27/Q17 but no P1814/P1559

SELECT ?item ?itemLabel WHERE {
  ?item wdt:P27 wd:Q17 .
  MINUS { ?item wdt:P1814 [] } .
  MINUS { ?item wdt:P1559 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" }
}
Try it!

Japanese labels with (Edit

SELECT ?person ?label (LANG(?label) AS ?lang)
WHERE
{
  ?person wdt:P31 wd:Q5;
          rdfs:label ?label.
  FILTER(LANG(?label) IN ("ja")). # tweak to taste
  FILTER(CONTAINS(?label, "(")).
}
LIMIT 10
Try it!

Items with an English label but not FrenchEdit

SELECT ?person ?label (LANG(?label) AS ?lang)
WHERE
{
  ?person wdt:P31 wd:Q5;
          rdfs:label ?label.
  FILTER(LANG(?label) IN ("en")). # tweak to taste
  OPTIONAL {?person rdfs:label ?label1 	filter(lang(?label1) = "fr")}
  FILTER(!BOUND(?label1))
}
LIMIT 100
Try it!

J-Pop items with Latin characters in ja label but no en labelEdit

SELECT ?item ?label_ja WHERE {
  ?item wdt:P136 wd:Q131578 .
  ?item rdfs:label ?label_ja filter(lang(?label_ja) = "ja") .
  MINUS { ?item rdfs:label ?label_fr filter(lang(?label_fr) = "en") . }
  FILTER regex(?label_ja, "^[A-Z]*$", "i")
}
LIMIT 1000
Try it!

git protocol but don't end with .gitEdit

SELECT ?item ?itemLabel ?string ?rank {
  ?item p:P1324 [
    pq:P2700 wd:Q186055; ps:P1324 ?string; wikibase:rank ?rank
  ] .
  FILTER ( !STRENDS( STR( ?string ), ".git" ) ) .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
Try it!

Free software but no Debian package and no Free software directoryEdit

SELECT ?item ?itemLabel ?itemDescription {
  ?item wdt:P31 wd:Q341 .
  MINUS { ?item wdt:P3442 [] } .
  MINUS { ?item wdt:P2537 [] } .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" } .
}
Try it!

Japanese family names but not the same kana/Hepburn/kanjiEdit

SELECT ?name1 ?name2 ?name1Label ?name2Label ?orig ?hepburn1 ?hepburn2
WHERE {
  ?name1 wdt:P31/wdt:P279* wd:Q101352 ;
         p:P1814 ?kana1 ;
         wdt:P1705 ?count .
  ?kana1 ps:P1814 ?orig ;
         pq:P2125 ?hepburn1 .
  ?name2 wdt:P31/wdt:P279* wd:Q101352 ;
         p:P1814 ?kana2 ;
         wdt:P1705 ?count2  .
  ?kana2 ps:P1814 ?orig ;
         pq:P2125 ?hepburn2 .
  FILTER (?name1 != ?name2)
  FILTER (?hepburn1 != ?hepburn2)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
  }GROUP BY ?name1 ?name2 ?name1Label ?name2Label ?orig ?hepburn1 ?hepburn2
HAVING((COUNT(?count) = 1) && (COUNT(?count2) = 1))
Try it!