query-c84ed6ce88b7c4dc34c75798fe7160d3
added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts) added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE { ?gene p:P351 ?ncbigene ; wdt:P351 ?ncbi_gene . ?ncbigene prov:wasDerivedFrom ?derivedFrom . ?derivedFrom pr:P813 ?date_update . BIND (now() - ?date_update as ?date_range) FILTER (?date_range > 31) } GROUP BY ?date_range ?date_update ORDER BY DESC(?counts)
Use at
- https://query.wikidata.org/sparql
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/>
#added before 2016-10
SELECT DISTINCT ?date_range ?date_update (count(?gene) as ?counts) (GROUP_CONCAT(?gene ;separator = "; ") as ?genes) (GROUP_CONCAT(?ncbi_gene ;separator = "; ") as ?gene_ids) WHERE {
?gene p:P351 ?ncbigene ;
wdt:P351 ?ncbi_gene .
?ncbigene prov:wasDerivedFrom ?derivedFrom .
?derivedFrom pr:P813 ?date_update .
BIND (now() - ?date_update as ?date_range)
FILTER (?date_range > 31)
}
GROUP BY ?date_range ?date_update
ORDER BY DESC(?counts)
Query found at
- https://www.wikidata.org/wiki/User:Amitie_10g/Sandbox/Wikidata:SPARQL_query_service/queries/examples/maintenance
- https://www.wikidata.org/wiki/User:Amitie_10g/Sandbox/Wikidata:SPARQL_query_service/queries/examples/maintenance/en
- https://www.wikidata.org/wiki/User:Amitie_10g/Sandbox/Wikidata:SPARQL_query_service/queries/examples/maintenance/es
- https://www.wikidata.org/wiki/User:Amitie_10g/Sandbox/Wikidata:SPARQL_query_service/queries/examples/maintenance/zh
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/cs
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/en
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/es
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/fr
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/ja
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/nl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/pl
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/sv
- https://www.wikidata.org/wiki/Wikidata:SPARQL_query_service/queries/examples/maintenance/uk