query-375c742e372e795d22a12f27e7725c86

rq turtle/ttl

]reply[09:27, 3 January 2018 (UTC)) talk (本日晴天). --P3150In the most of listed items, P569 will be used wrongly as birthday(]reply[11:14, 31 March 2018 (UTC)) talk (本日晴天Added to complex constraint.-- ]reply[11:51, 3 January 2018 (UTC) Jura--- Nice query. Maybe they could be converted directly. ). Talk:Q26961029#year 0I created new one. Dates with year 0 seem to be sometimes used to specify "unknown year" (see also:

Use at

• https://query.wikidata.org/sparql

PREFIX xsd: <http://www.w3.org/2001/XMLSchema#>
PREFIX wikibase: <http://wikiba.se/ontology#>
PREFIX wd: <http://www.wikidata.org/entity/>
PREFIX psv: <http://www.wikidata.org/prop/statement/value/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?item ?birth WHERE {
    ?item p:P569/psv:P569 [
      wikibase:timeValue ?birth; wikibase:timePrecision ?precision
    ].
    # If year of ?birth is ±0, DATATYPE(?birth) is xsd:string, not xsd:dateTime.
    FILTER REGEX(?birth, "0000\\-\\d\\d-\\d\\dT").
    FILTER(?precision >= 9).
    FILTER (?item not in (wd:Q4115189,wd:Q13406268,wd:Q15397819)).
  }
  LIMIT 1000

Query found at

• https://www.wikidata.org/wiki/Property_talk:P569