query-ded6e726c17dd76fcd5311c3db947413

added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200 added before 2016-10

PREFIX entity: http://www.wikidata.org/entity/

partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture WHERE { hint:Query hint:optimizer 'None' . { BIND(entity:Q42 AS ?valUrl) . BIND("N/A" AS ?propUrl ) . BIND("identity"@en AS ?propLabel ) . } UNION { entity:Q42 ?propUrl ?valUrl . ?property ?ref ?propUrl . ?property rdf:type wikibase:Property . ?property rdfs:label ?propLabel }

?valUrl rdfs:label ?valLabel
FILTER (LANG(?valLabel) = 'en') .
OPTIONAL{ ?valUrl wdt:P18 ?picture .}
FILTER (lang(?propLabel) = 'en' )

} ORDER BY ?propUrl ?valUrl LIMIT 200

Use at

https://query.wikidata.org/sparql

PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#>
PREFIX rdf: <http://www.w3.org/1999/02/22-rdf-syntax-ns#>
#added before 2016-10

PREFIX entity: <http://www.wikidata.org/entity/>
#partial results

SELECT ?propUrl ?propLabel ?valUrl ?valLabel ?picture
WHERE
{

    {   BIND(entity:Q42 AS ?valUrl) .
        BIND("N/A" AS ?propUrl ) .
        BIND("identity"@en AS ?propLabel ) .
    }
    UNION
    {   entity:Q42 ?propUrl ?valUrl .
        ?property ?ref ?propUrl .
        ?property rdf:type wikibase:Property .
        ?property rdfs:label ?propLabel
    }

    ?valUrl rdfs:label ?valLabel
    FILTER (LANG(?valLabel) = 'en') .
    OPTIONAL{ ?valUrl wdt:P18 ?picture .}
    FILTER (lang(?propLabel) = 'en' )
}
ORDER BY ?propUrl ?valUrl
LIMIT 200

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v7("?picture"):::projected v5("?propLabel"):::projected v5("?propUrl"):::projected v5("?property") v6("?ref") v4("?valLabel"):::projected v5("?valUrl"):::projected c4(["wikibase:Property"]):::iri c2([http://www.wikidata.org/entity/Q42]):::iri f0[["?propLabel = 'en'"]] f0 --> v5 f1[["?valLabel = 'en'"]] f1 --> v4 subgraph union0[" Union "] subgraph union0l[" "] style union0l fill:#abf,stroke-dasharray: 3 3; c2 -->v5--> v5 v5 -->v6--> v5 v5 --"a"--> c4 v5 --"rdfs:label"--> v5 end subgraph union0r[" "] style union0r fill:#abf,stroke-dasharray: 3 3; bind2[/"http://www.wikidata.org/entity/Q42"/] bind2 --as--o v5 bind3[/"'N/A'"/] bind3 --as--o v5 bind4[/"sidentity^^<http://www.w3.org/1999/02/22-rdf-syntax-ns#langString>'"/] bind4 --as--o v5 end union0r <== or ==> union0l end v5 --"rdfs:label"--> v4 subgraph optional0["(optional)"] style optional0 fill:#bbf,stroke-dasharray: 5 5; v5 -."wdt:P18".-> v7 end