VVIT WikiConnect/Wikidata Queries
| List of YouTubers from USA and Canada who have a page on IMDb |
|---|
SELECT ?item ?itemLabel ?ID ?image
WHERE
{
?item wdt:P31 wd:Q5. #human
?item wdt:P106 wd:Q17125263.#youtuber
{?item wdt:P27 wd:Q16.} #canada
UNION
{?item wdt:P27 wd:Q30.} #USA
?item wdt:P345 ?ID.
?item wdt:P18 ?image.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| List of articles published in “Journal of Chromatography A” which have notable authors on Wikidata |
|---|
SELECT ?item ?itemLabel ?author ?authorLabel
WHERE
{
?item wdt:P31 wd:Q13442814.
?item wdt:P1433 wd:Q902558.
?item wdt:P50 ?author .
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Gallery of paintings in India |
|---|
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q1007870.#art gallery
?item wdt:P17 wd:Q668.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Diseases that are treated by alpha-linolenic acid |
|---|
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q12136.
?item wdt:P2176 wd:Q256502.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Iphones manufactured by Hon Hai Precision Industry |
|---|
SELECT ?item ?itemLabel ?gene
WHERE
{
?item wdt:P31 wd:Q19723451.
?item wdt:P279 wd:Q2766.
?item wdt:P176 wd:Q463094
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| List of genes found in house mouses |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| List of authors from South India who are dead |
|---|
SELECT ?itemLabel ?dod WHERE {
?item wdt:P31 wd:Q5.
?item wdt:P106 wd:Q482980.
?item wdt:P27 wd:Q668.
?item wdt:P570 ?dod.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Grade II listed buildings in England |
|---|
| Cliquez pour essayer ! |
| Bengali authors who were awarded Sahitya Akademi award |
|---|
#Bengali authors who were awarded Sahitya Akademi award
SELECT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q5.#human
?item wdt:P27 wd:Q668.#Indian
?item wdt:P1412 wd:Q9610.#Bengali
?item wdt:P106 wd:Q482980.#authors
?item wdt:P166 wd:Q172582.#sahitya akademi award
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| List of Indian films US films which screenwriter’s received Golden Globe award |
|---|
#List of Indian films US films which screenwriter’s received Golden Globe award
SELECT ?item ?itemLabel ?sw ?swLabel
WHERE
{
{?item wdt:P495 wd:Q668.}#Indian
UNION
{?item wdt:P495 wd:Q30.}#us
?item wdt:P31 wd:Q11424.#films
?item wdt:P58 ?sw.#screenwriters
?sw wdt:P166 wd:Q1011547.#golden globe award
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Universities in India with their geo-coordinates
|
|---|
SELECT ?item ?itemLabel ?coord
WHERE {
?item wdt:P31 wd:Q3918.#universities
?item wdt:P17 wd:Q668. #India
?item wdt:P625 ?coord.#geographical coords
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en".}
}
|
| People who were awarded Nobel prize more than once |
|---|
SELECT ?winner (COUNT(?prize) AS ?wins)
WHERE
{
?winner wdt:P31 wd:Q5.
?winner wdt:P166 ?prize.
?prize wdt:P31 wd:Q7191.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
GROUP BY ?winner ?winnerLabel
ORDER BY DESC(?wins)
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| REPLACE QUERY NAME |
|---|
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
QUERY QUERY QUERY QUERY QUERY QUERY
|
| List of Indian foods which have meat as an ingredient |
|---|
SELECT ?item ?itemLabel WHERE {
{?item wdt:P279 wd:Q2095.}
UNION
{?item wdt:P31 wd:Q2095.}
?item wdt:P495 wd:Q668.
{?item wdt:P527 wd:Q10990.}
UNION
{?item wdt:P186 wd:Q10990.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| List of articles published in Indian Medical Gazette which don’t have notable authors on Wikidata |
|---|
#List of articles published in Indian Medical Gazette which don’t have notable authors on Wikidata
SELECT DISTINCT ?item ?itemLabel
WHERE
{
?item wdt:P31 wd:Q13442814.
?item wdt:P1433 wd:Q26842241.
{?item wdt:P2093 ?authorName.}
MINUS
{?item wdt:P50 ?authorname.}
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Indian athletes who either served in Rajyasabha or Loksabha |
|---|
SELECT DISTINCT ?item ?itemLabel WHERE{
?item wdt:P31 wd:Q5.
?item wdt:P27 wd:Q668.
?item wdt:P106 wd:Q2066131.
{?item wdt:P39 wd:Q16556694.}
UNION
{?item wdt:P39 wd:Q17324844.}
OPTIONAL { ?item wdt:P18 ?image. }
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|
| Chemical compounds with their PubChem CID |
|---|
Chemical compounds with their PubChem CID
SELECT DISTINCT ?item ?itemLabel ?pubchemcid WHERE {
?item wdt:P31 wd:Q11173.
?item wdt:P662 ?pubchemcid.
SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],en". }
}
|