User:Iwan.Aucamp/Trash

Queries

SELECT ?item ?itemLabel ?linkTo ?linkToLabel {
  { ?item wdt:P279* wd:Q1441305 } UNION { ?item wdt:P31* wd:Q1441305 } UNION
  { ?item wdt:P279* wd:Q169872 } UNION { ?item wdt:P31* wd:Q169872 }
  OPTIONAL { ?item wdt:P279 ?linkTo }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo ?linkToLabel WHERE {
  ?item wdt:P279* wd:Q1441305
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item (wdt:P279+) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31?)/(wdt:P279*)) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31*)/(wdt:P279+)) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

All instances of spacecraft or it's subclasses ...

SELECT DISTINCT ?item ?itemLabel {
  ?item wdt:P31* wd:Q40218
  OPTIONAL { ?item wdt:P31 ?linkTo }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT DISTINCT ?item ?itemLabel {
  ?item (wdt:P31*/wdt:P279*) wd:Q40218
  OPTIONAL { ?item wdt:P31 ?linkTo }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

Symptoms

Valid values for symptoms and signs (P780)

Which has property constraint (P2302) value-type constraint (Q21510865) of

• (instance of (P31) or subclass of (P279))
  • clinical sign (Q1441305)
  • symptom (Q169872)

SELECT DISTINCT ?item ?itemLabel WHERE {
  {
    ?item ((wdt:P31+)/(wdt:P279*))|(wdt:P279+) wd:Q169872
  }
  UNION
  {
    ?item ((wdt:P31+)/(wdt:P279*))

Try it!

SELECT DISTINCT ?item ?itemLabel ?itemDescription WHERE {
  {
    ?item ((wdt:P31+)/(wdt:P279*))|(wdt:P279+) wd:Q169872
  }
  UNION
  {
    ?item ((wdt:P31+)/(wdt:P279*))

Try it!

SELECT DISTINCT ?item ?itemLabel WHERE {
  {
    ?item ((wdt:P31+)/(wdt:P279*))|(wdt:P279+) wd:Q169872
  }
  UNION
  {
    ?item ((wdt:P31+)/(wdt:P279*))|(wdt:P279+) wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31+)/(wdt:P279*))|(wdt:P279+) ?values
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Trash

• Zero or more of instance of (P31)
• One or more of subclass of (P279)

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31*)/(wdt:P279+)) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

• One or more instance of (P31) of zero or more subclass of (P279) of symptom (Q169872)

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31+)/(wdt:P279*)) wd:Q169872.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

• One or more subclass of (P279) of symptom (Q169872)

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item (wdt:P279+) wd:Q169872.
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

• One or more instance of (P31) of zero or more subclass of (P279) of clinical sign (Q1441305) or symptom (Q169872)

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item ((wdt:P31+)/(wdt:P279*)) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

• One or more subclass of (P279) of clinical sign (Q1441305) or symptom (Q169872)

SELECT DISTINCT ?item ?itemLabel WHERE {
  ?item (wdt:P279+) ?values.
  VALUES ?values {
    wd:Q169872
    wd:Q1441305
  }
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}

Try it!

Diseases ...

Has symptoms:

• visual impairment (Q737460)
• headache (Q86)
• black skin (Q21120251)

SELECT ?item ?itemLabel ?itemDescription {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  OPTIONAL { ?item rdfs:label ?itemLabel FILTER(LANG(?itemLabel) = "en") }
  OPTIONAL { ?item schema:description ?itemDescription FILTER(LANG(?itemDescription) = "en") }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  hint:Query hint:analytic "false".
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  OPTIONAL { ?item rdfs:label ?itemLabel FILTER(LANG(?itemLabel) = "en") }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
LIMIT 10

Try it!

SELECT ?item ?itemLabel ?linkTo {
  hint:Query hint:optimizer "None" .
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
LIMIT 10

Try it!

SELECT ?item ?itemLabel ?linkTo { ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q21120251.
  { SELECT ?item ?itemLabel ?linkTo { ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460.
    { SELECT ?item ?itemLabel ?linkTo { ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q86. { } } }
  } }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}
LIMIT 10

Try it!

Trash

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q86.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
} LIMIT 10

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460.
  SELECT ?item ?itemLabel ?linkTo {
    ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q86.
  }
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
} LIMIT 10

Try it!

trash

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780 wd:Q737460.
  ?item wdt:P780 wd:Q86.
  ?item wdt:P780 wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780 wd:Q737460;
        wdt:P780 wd:Q86;
        wdt:P780 wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780 wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460.
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q86.
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460;
   wdt:P780/wdt:P31*/wdt:P279* wd:Q86;
   wdt:P780/wdt:P31*/wdt:P279* wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q737460, wd:Q86, wd:Q21120251.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!

SELECT ?item ?itemLabel ?linkTo {
  ?item wdt:P780/wdt:P31*/wdt:P279* wd:Q86.
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" }
}

Try it!