query-e8238cff0785ace820929b77e391795e

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
SELECT DISTINCT ?item ?_PubMed_ID ?PMCID ?publication_date ?DOI ?itemLabel
(GROUP_CONCAT(DISTINCT ?published_in; SEPARATOR = "; ") AS ?publicationQId)  
(GROUP_CONCAT(DISTINCT ?published_inLabel; SEPARATOR = "; ") AS ?publication)  
(GROUP_CONCAT(DISTINCT ?author_name_string; SEPARATOR = "; ") AS ?authors) 
(GROUP_CONCAT(DISTINCT ?main_subjectLabel; SEPARATOR = "; ") AS ?subject) WHERE {
{
  SELECT * WHERE {
    ?item wdt:P31 wd:Q13442814.
    ?item rdfs:label ?itemLabel.
    FILTER(CONTAINS(LCASE(?itemLabel), "zika"))
    FILTER((LANG(?itemLabel)) = "en")
  }
LIMIT 1000
}
OPTIONAL { ?item wdt:P698 ?_PubMed_ID. }
OPTIONAL { ?item wdt:P1433 ?published_in.
          ?published_in rdfs:label ?published_inLabel.
          FILTER((LANG(?published_inLabel)) = "en")
          }
OPTIONAL { ?item wdt:P921 ?main_subject. ?main_subject rdfs:label ?main_subjectLabel. FILTER((LANG(?main_subjectLabel)) = "en")}
OPTIONAL { ?item wdt:P932 ?PMCID. }
OPTIONAL { ?item wdt:P577 ?publication_date. }
OPTIONAL { ?item wdt:P921 ?published_in. }
OPTIONAL { ?item wdt:P2093 ?author_name_string. }
OPTIONAL { ?item wdt:P356 ?DOI }
}
GROUP BY ?item ?itemLabel ?_PubMed_ID ?PMCID ?publication_date ?DOI
LIMIT 100

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v11("?DOI"):::projected v8("?PMCID"):::projected v5("?_PubMed_ID"):::projected v10("?author_name_string"):::projected v14("?authors") v4("?item"):::projected v3("?itemLabel"):::projected v7("?main_subject") v1("?main_subjectLabel"):::projected v13("?publication") v12("?publicationQId") v9("?publication_date"):::projected v6("?published_in"):::projected v2("?published_inLabel"):::projected v15("?subject") c4(["wd:Q13442814"]):::iri f0[["?itemLabel = 'en'"]] f0 --> v3 f1[["contains(lower-case(?itemLabel),'zika')"]] f1 --> v3 v4 --"wdt:P31"--> c4 v4 --"rdfs:label"--> v3 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P698".-> v5 end subgraph optional1["(optional)"] style optional1 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P1433".-> v6 v6 --"rdfs:label"--> v2 end subgraph optional2["(optional)"] style optional2 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P921".-> v7 v7 --"rdfs:label"--> v1 end subgraph optional3["(optional)"] style optional3 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P932".-> v8 end subgraph optional4["(optional)"] style optional4 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P577".-> v9 end subgraph optional5["(optional)"] style optional5 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P921".-> v6 end subgraph optional6["(optional)"] style optional6 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P2093".-> v10 end subgraph optional7["(optional)"] style optional7 fill:#bbf,stroke-dasharray: 5 5; v4 -."wdt:P356".-> v11 end bind6[/"?published_in"/] v6 --o bind6 bind6 --as--o v12 bind7[/"?published_inLabel"/] v2 --o bind7 bind7 --as--o v13 bind8[/"?author_name_string"/] v10 --o bind8 bind8 --as--o v14 bind9[/"?main_subjectLabel"/] v1 --o bind9 bind9 --as--o v15