query-7ca965ca99aef83b0372900b8c2ac205

rq turtle/ttl

Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month regularly synchronizes disease related items in Wikidata with the disease ontology. This query returns all modification dates ?date_update to less than a month. ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month regularly synchronizes disease related items in Wikidata with the disease ontology. This query returns all modification dates ?date_update to less then a month. ProteinBoxBotExpected results: All update dates older then one month require manual inspection by a curator. Elementos de enfermedades con declaraciones que capturan ID de ontología de enfermedades que no se han actualizado durante más de un mes This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Elementos de enfermedades con declaraciones que capturan ID de ontología de enfermedades que no se han actualizado durante más de un mes regularly synchronizes disease related items in Wikidata with the disease ontology. This query returns all modification dates ?date_update to less then a month. ProteinBoxBotExpected results: All update dates older then one month require manual inspection by a curator. Items de maladies avec affirmations de Disease Ontology ID qui n'ont pas été mises à jour depuis un mois de moins d'un mois. ?date_update synchronise régulièrement les éléments liés à la maladie dans Wikidata avec l'onthologie de la maladie. Cette requête renvoie les dates des modifications ProteinBoxBotRésultats attendus : toutes les dates de mise à jour de plus d'un mois nécessitent d'être revues manuellement par la maintenance. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Ziekte-items met verklaringen met ziekte-ontologie-ID's die al meer dan een maand niet zijn bijgewerkt synchroniseert regelmatig ziektegerelateerde items in Wikidata met de ziekte-ontologie. Deze query geeft alle wijzigingsdatums -date_update terug tot minder dan een maand. ProteinBoxBotVerwachte resultaten: Alle updates die ouder zijn dan een maand, deze vereisen een handmatige controle door een curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month This query returns all modification dates ?date_update to less than a month. regularly synchronizes disease related items in Wikidata with the disease ontology.ProteinBoxBotExpected results: All update dates older than one month require manual inspection by a curator. Disease items with statements capturing Disease Ontology IDs that haven't been update for more then a month regularly synchronizes disease related items in Wikidata with the disease ontology. This query returns all modification dates ?date_update to less then a month. ProteinBoxBotExpected results: All update dates older then one month require manual inspection by a curator.

Use at

PREFIX wdt: <http://www.wikidata.org/prop/direct/>
PREFIX prov: <http://www.w3.org/ns/prov#>
PREFIX pr: <http://www.wikidata.org/prop/reference/>
PREFIX p: <http://www.wikidata.org/prop/>
SELECT DISTINCT ?date_range ?date_update (count(?disease) as ?counts)
                (GROUP_CONCAT(?disease ;separator = "; ") as ?diseases)
                (GROUP_CONCAT(?do_id ;separator = "; ") as ?doids)
{
  ?disease p:P699/prov:wasDerivedFrom/pr:P813 ?date_update ;
           wdt:P699 ?do_id .
  BIND (now() - ?date_update as ?date_range)
  FILTER (?date_range > 31)
}
GROUP BY ?date_range ?date_update
ORDER BY DESC(?counts)

Query found at

graph TD classDef projected fill:lightgreen; classDef literal fill:orange; classDef iri fill:yellow; v6("?counts") v6("?date_range"):::projected v4("?date_update"):::projected v3("?disease"):::projected v6("?diseases") v5("?do_id"):::projected v7("?doids") a1((" ")) a2((" ")) f0[["?date_range > '31^^xsd:integer'"]] f0 --> v6 v3 --"p:P699"--> a1 a1 --"prov:wasDerivedFrom"--> a2 a2 --"p:reference/P813"--> v4 v3 --"p:direct/P699"--> v5 bind1[/"NOW() - ?date_update"/] v4 --o bind1 bind1 --as--o v6 bind5[/"count(?disease)"/] v3 --o bind5 bind5 --as--o v6 bind6[/"?disease"/] v3 --o bind6 bind6 --as--o v6 bind7[/"?do_id"/] v5 --o bind7 bind7 --as--o v7