User:Snipre/Test1

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#>

SELECT ?h ?cas ?einecs ?pubchem ?chembl ?chebi ?inchi ?inchikey WHERE {
   ?h wdt:P31 wd:Q11173 .
   ?h wdt:P231 ?cas .
   ?h wdt:P232 ?einecs .
   ?h wdt:P662 ?pubchem .
   ?h wdt:P592 ?chembl .
   ?h wdt:P683 ?chebi .
   ?h wdt:P234 ?inchi .
   ?h wdt:P235 ?inchikey .
 }


SELECT ?h
WHERE 
{
	?h wdt:P31 wd:Q11173 
	OPTIONAL {?h wdt:P662 ?d } 
	FILTER (!bound(?d))
}

Try it!

SELECT ?movie ?originalLanguage ?language
WHERE
{
  ?movie wdt:P31 wd:Q11424 .
  ?movie wdt:P364 ?originalLanguage .
  ?movie wdt:P407 ?language .
  
  FILTER (?language != ?originalLanguage)
  SERVICE wikibase:label {bd:serviceParam wikibase:language "en" .} .
}

Try it!