# Wikidata items for concepts that have a Disease Ontology ID (P699)
# sorted by number of sitelinks
# optionally with their Wikidata label in English
# optionally with their Wikidata label in Hindi, Bangla and Swahili
# optionally with their Wikidata label in Marathi, Telugu, Eastern Punjabi, Western Punjabi, Gujarathi, Maithili, Kannada, Odia, Bhojpuri, Tamil, Nepali, Urdu, Malayalam, Esperanto

SELECT DISTINCT ?item 
# English Wikidata label
 ?LabelEN

#    English Wikipedia article title
?PageTitleEN 

# Hindi,   Bangla and Swahili Wikidata labels
?LabelHI ?LabelBN    ?LabelSW 

# Marathi,  Telugu, Eastern Punjabi, Western Punjabi, Gujarathi, Maithili, Kannada,    Odia, Bhojpuri,   Tamil,  Nepali,    Urdu, Malayalam, Esperanto
 ?LabelMR ?LabelTE         ?LabelPA        ?LabelPNB   ?LabelGU ?LabelMAI ?LabelKN ?LabelOR  ?LabelBH ?LabelTA ?LabelNE ?LabelUR   ?LabelML   ?LabelEO

?sitelinks 

WHERE {
  ?item wdt:P699 [] .  
  ?item wikibase:sitelinks ?sitelinks .

  OPTIONAL { ?item rdfs:label ??LabelEN filter (lang(?LabelEN) = "en") . } 
  OPTIONAL { ?article schema:about ?item ; schema:isPartOf <https://en.wikipedia.org/> ;  schema:name ?PageTitleEN . }

  OPTIONAL { ?item rdfs:label ?LabelHI filter (lang(?LabelHI) = "hi") . } 
  OPTIONAL { ?item rdfs:label ?LabelBN filter (lang(?LabelBN) = "bn") . }
  OPTIONAL { ?item rdfs:label ?LabelSW filter (lang(?LabelSW) = "sw") . }

  OPTIONAL { ?item rdfs:label ?LabelMR filter (lang(?LabelMR) = "mr") . }
  OPTIONAL { ?item rdfs:label ?LabelTE filter (lang(?LabelTE) = "te") . }
  OPTIONAL { ?item rdfs:label ?LabelPA filter (lang(?LabelPA) = "pa") . }
  OPTIONAL { ?item rdfs:label ?LabelPNB filter (lang(?LabelPNB) = "pnb") . }
  OPTIONAL { ?item rdfs:label ?LabelGU filter (lang(?LabelGU) = "gu") . }
  OPTIONAL { ?item rdfs:label ?LabelMAI filter (lang(?LabelMAI) = "mai") . }
  OPTIONAL { ?item rdfs:label ?LabelKN filter (lang(?LabelKN) = "kn") . }
  OPTIONAL { ?item rdfs:label ?LabelOR filter (lang(?LabelOR) = "or") . }
  OPTIONAL { ?item rdfs:label ?LabelBH filter (lang(?LabelBH) = "bh") . }
  OPTIONAL { ?item rdfs:label ?LabelTA filter (lang(?LabelTA) = "ta") . }
  OPTIONAL { ?item rdfs:label ?LabelNE filter (lang(?LabelNE) = "ne") . }
  OPTIONAL { ?item rdfs:label ?LabelUR filter (lang(?LabelUR) = "ur") . }
  OPTIONAL { ?item rdfs:label ?LabelML filter (lang(?LabelML) = "ml") . }
  OPTIONAL { ?item rdfs:label ?LabelEO filter (lang(?LabelEO) = "eo") . }
}
ORDER BY DESC(?sitelinks)
LIMIT 1000