Untitled query #20291

SQL

SELECT ?item ?itemLabel ?sex_or_gender_label ?occupations_list WHERE {
  ?item wdt:P31 wd:Q5.
  ?item wdt:P21 wd:Q6581072.
  ?item wdt:P106 ?sci.
  VALUES ?sci {    wd:Q901    wd:Q11063    wd:Q18805    wd:Q39631    wd:Q81096    wd:Q170790    wd:Q82594    wd:Q169470    wd:Q593644    wd:Q864503    wd:Q1265807    wd:Q3126128    wd:Q3140857    wd:Q3745071    wd:Q20107384    wd:Q26726323    wd:Q28054752    wd:Q28870501    wd:Q30084569    wd:Q10872101    wd:Q14565186    wd:Q15143181    wd:Q15143191    wd:Q15401884    wd:Q15839134    wd:Q15941468}
  SERVICE wikibase:label { bd:serviceParam wikibase:language "sq,en,es,ru". }
  FILTER(NOT EXISTS {
    ?article schema:about ?item.
    ?article schema:inLanguage "sq".
    ?article schema:isPartOf <https://sq.wikipedia.org/>. })
  OPTIONAL { 
    ?item wdt:P21 ?sex_or_gender. 
    ?sex_or_gender rdfs:label ?sex_or_gender_label.
    FILTER((LANG(?sex_or_gender_label)) = "sq")
  }
  OPTIONAL { 
    SELECT ?item (GROUP_CONCAT(DISTINCT ?occu; SEPARATOR = "; ") AS ?occupations_list) WHERE {
      OPTIONAL { 
        ?item wdt:P106 ?occupation.
        ?occupation rdfs:label ?occu.
        FILTER((LANG(?occu)) = "sq")
     }
    }
    GROUP BY ?item
    #?item wdt:P106 ?occupation.              
    #?occupation rdfs:label ?occupation_label.
    #FILTER((LANG(?occupation_label)) = "sq")
  }
}LIMIT 10
SQL

Checking query status...
