[go: up one dir, main page]

Wikidata:Orb Open Graph/Queries

View scheduled queries and query result links

The Orb Open Graph operates a scheduled query service. On this page you can define a query to run at an interval of your choosing. The query service operates at that interval and caches results for use by tools, bots, and humans.

Add a query to this page

edit

Before registering a query for recurring run, try it out to make sure it works. The "try" service connects directly to a Blazegraph endpoint with no cache intermediary. This endpoint does not have a timeout limit, but queries that are overly complex may crash.

Create a new subsection at the bottom of this page using the syntax below.

  • For query identifier, come up with a unique identifier string for your Wikidata query. It should not be changed once it is set. Try to organize similar or related queries using prefixes.
  • For query title, use a more human-readable query name. This does not have to be unique, though it is recommended. Unlike the query identifier, you can change this all you like.
  • For preferred output format, describe how you want to view the query results in the query service UI. By default, query results are presented as tables, but you can also opt for the types below. Not all types are available for all queries.
    • Image grid
    • Graph builder
    • Map
    • Line chart
    • Bar chart
    • Scatter chart
    • Area chart
    • Bubble chart
    • Tree map
    • Tree
    • Timeline
    • Dimensions
    • Graph
  • For data refresh rate, How often you want the results refreshed in seconds
===query identifier===
* query title: 
* preferred output format: Table
* data refresh rate: 3600
{{SPARQL|query=

}}

Access results

edit

To conveniently access JSON-formatted results, you can use the https://query-api.orbopengraph.com/data API in conjunction with the query identifier used as the section header. For example, https://query-api.orbopengraph.com/data/last-updated updates every five minutes with the query service's last update timestamp (depending on which of the Blazegraph servers is queried). You can also specify /view instead of /data to get the results frontend, like https://query-api.orbopengraph.com/view/last-updated.

A table with queries, including the time of last update, the frequency of updates, and links to the query result display and JSON are available at https://query-api.orbopengraph.com/status

Issues

edit
  • Using [AUTO_LANGUAGE] does not work, and is probably not useful for this service, since the service submitting the queries to the backend will consistently have a user language of English.

Scheduled recurring queries

edit

last-updated

edit
  • query title: Query service last updated
  • preferred output format: Table
  • data refresh rate: 300
PREFIX schema: <http://schema.org/>
SELECT * WHERE { <http://www.wikidata.org> schema:dateModified ?y . }
Try it!

worldnews-newspapers

edit
  • query title: World News: Newspapers
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?article WHERE {
  ?item wdt:P31* wd:Q11032.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

worldnews-industry-journalism

edit
  • query title: World News: Organizations with industry of journalism
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P452 wd:Q11030.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

vsafe-vaccine-types

edit
  • query title: Vaccine safety: vaccine types
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P31* wd:Q105967696.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

vsafe-vaccine-journals

edit
  • query title: Vaccine safety: journals about vaccines
  • preferred output format: Table
  • data refresh rate: 3600
select distinct ?item ?article where {
  ?item wdt:P31 wd:Q5633421;
    rdfs:label ?itemLabel.
  filter(contains(?itemLabel, "Vaccine"))
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

stats-doi

edit
  • query title: Number of Wikidata items with DOIs
  • preferred output format: Table
  • data refresh rate: 3600
SELECT (COUNT(?item) AS ?count) WHERE {
  ?item wdt:P356 ?doi .
}
Try it!

stats-pubmed

edit
  • query title: Number of Wikidata items with PubMed IDs
  • preferred output format: Table
  • data refresh rate: 3600
SELECT (COUNT(?item) AS ?count) WHERE {
  ?item wdt:P698 ?pubmed .
}
Try it!

nioshtic-all

edit
  • query title: Mapping of NIOSHTIC2-ID with other identifiers
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?NIOSHTIC2_ID ?NTIS_accession_number ?DOI ?PubMed_Central_ID ?PubMed_ID ?ISBN_13 ?ISBN_10 ?NIOSH_Numbered_Publication_ID ?ProQuest_document_ID ?Handle_ID ?YouTube_video_ID ?JSTOR_article_ID ?CDC_Stacks_ID ?ResearchGate_publication_ID ?Patent_number WHERE {
  ?item wdt:P2880 ?NIOSHTIC2_ID.
  OPTIONAL { ?item wdt:P7791 ?NTIS_accession_number. }
  OPTIONAL { ?item wdt:P356 ?DOI. }
  OPTIONAL { ?item wdt:P932 ?PubMed_Central_ID. }
  OPTIONAL { ?item wdt:P698 ?PubMed_ID. }
  OPTIONAL { ?item wdt:P212 ?ISBN_13. }
  OPTIONAL { ?item wdt:P957 ?ISBN_10. }
  OPTIONAL { ?item wdt:P4596 ?NIOSH_Numbered_Publication_ID. }
  OPTIONAL { ?item wdt:P6572 ?ProQuest_document_ID. }
  OPTIONAL { ?item wdt:P1184 ?Handle_ID. }
  OPTIONAL { ?item wdt:P1651 ?YouTube_video_ID. }
  OPTIONAL { ?item wdt:P888 ?JSTOR_article_ID. }
  OPTIONAL { ?item wdt:P12706 ?CDC_Stacks_ID. }
  OPTIONAL { ?item wdt:P5875 ?ResearchGate_publication_ID. }
  OPTIONAL { ?item wdt:P1246 ?Patent_number. }
}
Try it!

nioshtic-with-pmcid

edit
  • query title: Identifier map: PubMed Central ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?pmcid ?NIOSHTIC2_ID WHERE {
  ?item wdt:P932 ?pmcid.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-ntis-accession-number

edit
  • query title: Identifier map: NTIS Accession Number with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?NTIS_accession_number ?NIOSHTIC2_ID WHERE {
  ?item wdt:P7791 ?NTIS_accession_number.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-isbn-10

edit
  • query title: Identifier map: ISBN-10 with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?ISBN_10 ?NIOSHTIC2_ID WHERE {
  ?item wdt:P957 ?ISBN_10.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-isbn-13

edit
  • query title: Identifier map: ISBN-13 with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?ISBN_13 ?NIOSHTIC2_ID WHERE {
  ?item wdt:P212 ?ISBN_13.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-niosh-numbered-publication-id

edit
  • query title: Identifier map: NIOSH Numbered Publication ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?NIOSH_Numbered_Publication_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P4596 ?NIOSH_Numbered_Publication_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-proquest-document-id

edit
  • query title: Identifier map: ProQuest document ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?ProQuest_document_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P6572 ?ProQuest_document_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-handle

edit
  • query title: Identifier map: Handle with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?Handle_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P1184 ?Handle_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nishotic-with-youtube-video-id

edit
  • query title: Identifier map: YouTube video ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?YouTube_video_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P1651 ?YouTube_video_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-jstor-article-id

edit
  • query title: Identifier map: JSTOR article ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?JSTOR_article_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P888 ?JSTOR_article_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-cdc-stacks-id

edit
  • query title: Identifier map: CDC Stacks ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?CDC_Stacks_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P12706 ?CDC_Stacks_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-researchgate-publication-id

edit
  • query title: Identifier map: ResearchGate publication ID with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?ResearchGate_publication_ID ?NIOSHTIC2_ID WHERE {
  ?item wdt:P5875 ?ResearchGate_publication_ID.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-patent-number

edit
  • query title: Identifier map: Patent number with or without NIOSHTIC2-ID
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?Patent_number ?NIOSHTIC2_ID WHERE {
  ?item wdt:P1246 ?Patent_number.
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-doi-1

edit
  • query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 1
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P356 ?identifier .
    bd:serviceParam bd:slice.offset 0 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-doi-2

edit
  • query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 2
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P356 ?identifier .
    bd:serviceParam bd:slice.offset 10000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-doi-3

edit
  • query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 3
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P356 ?identifier .
    bd:serviceParam bd:slice.offset 20000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-doi-4

edit
  • query title: Identifier map: DOI with or without NIOSHTIC2-ID Part 4
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P356 ?identifier .
    bd:serviceParam bd:slice.offset 30000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-pubmed-1

edit
  • query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 1
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P698 ?identifier .
    bd:serviceParam bd:slice.offset 0 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-pubmed-2

edit
  • query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 2
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P698 ?identifier .
    bd:serviceParam bd:slice.offset 10000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-pubmed-3

edit
  • query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 3
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P698 ?identifier .
    bd:serviceParam bd:slice.offset 20000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

nioshtic-with-pubmed-4

edit
  • query title: Identifier map: PubMed ID with or without NIOSHTIC2-ID Part 4
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?identifier ?NIOSHTIC2_ID WHERE {
  SERVICE bd:slice {
    ?item wdt:P698 ?identifier .
    bd:serviceParam bd:slice.offset 30000001 .
    bd:serviceParam bd:slice.limit 10000000 .
  }
  OPTIONAL { ?item wdt:P2880 ?NIOSHTIC2_ID. }
}
Try it!

osh-facet-of

edit
  • query title: Facet of occupational safety and health
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P1269 wd:Q629029.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-subclass-of

edit
  • query title: Subclass of occupational safety and health
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q629029.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-part-of

edit
  • query title: Part of occupational safety and health
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P361 wd:Q629029.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-hazards

edit
  • query title: Subclass of occupational hazard
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q3433185.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-hazards-chemical-with-exposure-items

edit
  • query title: Chemical articles with exposure items
  • preferred output format: Table
  • data refresh rate: 3600
SELECT DISTINCT ?item ?itemLabel ?article ?exposure ?exposureLabel
WHERE {
  ?item wdt:P31 wd:Q113145171;
    wdt:P1542 ?exposure.
  {
    ?exposure wdt:P279* wd:Q21167512 .
  } UNION {
    ?exposure wdt:P279* wd:Q68182219 .
  }
  OPTIONAL {
    ?article schema:about ?item;
     schema:isPartOf <https://en.wikipedia.org/>.
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
  }
}
Try it!

osh-hazards-chemical-exposure-articles

edit
  • query title: Chemical exposures with Wikipedia articles
  • preferred output format: Table
  • data refresh rate: 3600
SELECT DISTINCT ?item ?itemLabel ?article
WHERE {
  ?chemical wdt:P31 wd:Q113145171;
    wdt:P1542 ?item.
  {
    ?item wdt:P279* wd:Q21167512 .
  } UNION {
    ?item wdt:P279* wd:Q68182219 .
  }
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
  SERVICE wikibase:label {
    bd:serviceParam wikibase:language "en".
  }
}
Try it!

osh-infectious-disease

edit
  • query title: Instance of infectious disease
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P31* wd:Q18123741.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-emerging-infectious-disease

edit
  • query title: Instance of emerging infectious disease
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P31* wd:Q609748.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-biological-hazards

edit
  • query title: Subclass of biological hazard
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q864360.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-physical-injuries

edit
  • query title: Subclass of injury
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q193078.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-physical-hazards

edit
  • query title: Subclass of physical hazard
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q7189604.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-mental-disorders

edit
  • query title: Subclass of physical hazard
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q12135.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-psychosocial-hazards

edit
  • query title: Subclass of mental disorder
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279 wd:Q20899861.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-occupations

edit
  • query title: Instance of occupation
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P31 wd:Q12737077.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-industries

edit
  • query title: Instance of industry
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P31 wd:Q268592.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-part-of-hazard-control

edit
  • query title: Part of hazard control
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P361 wd:Q5753150.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-subclass-of-hazard-control

edit
  • query title: Subclass of hazard control
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279 wd:Q5753150.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-people-field-of-work

edit
  • query title: Field of work: occupational safety and health
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P101 wd:Q629029.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-disease

edit
  • query title: Subclass of disease
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q12136.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

osh-occupational-disease

edit
  • query title: Subclass of occupational disease
  • preferred output format: Table
  • data refresh rate: 3600
select ?item ?article where {
  ?item wdt:P279* wd:Q637816.
  OPTIONAL {
    ?article schema:about ?item;
             schema:isPartOf <https://en.wikipedia.org/>.
  }
}
Try it!

recent-citations-to-works-by-niosh-people

edit
  • query title: Recent citations to people related to NIOSH
  • preferred output format: Table
  • data refresh rate: 3600
PREFIX target: <http://www.wikidata.org/entity/Q60346> 

SELECT DISTINCT ?publication_date ?citing_work ?citing_workLabel ?work ?workLabel
WHERE {
  ?researcher ( wdt:P108| wdt:P463 | wdt:P1416 ) / wdt:P361* target: .
  ?work wdt:P50 ?researcher .
  ?citing_work wdt:P2860 ?work .
  ?citing_work wdt:P577 ?publication_datetime .
  BIND(xsd:date(?publication_datetime) AS ?publication_date)
  SERVICE wikibase:label { bd:serviceParam wikibase:language "en" . }
 }
ORDER BY DESC(?publication_date)
LIMIT 200
Try it!

discontinued-journals

edit
  • query title: Discontinued journals
  • preferred output format: Table
  • data refresh rate: 3600
SELECT DISTINCT ?journal (GROUP_CONCAT(DISTINCT ?title; separator=" • ") AS ?combinedTitle) (COUNT(DISTINCT ?paper) AS ?count) WHERE {
  ?journal wdt:P236 ?issn ;
           wdt:P582 ?endtime .
  ?journal wdt:P1476 ?title .
  FILTER (LANG(?title) = "en")
  ?paper wdt:P1433 ?journal .
  ?paper wdt:P50 ?author .
  ?paper wdt:P921 ?topic .
}
GROUP BY ?journal
ORDER BY DESC(?count)
LIMIT 1000
Try it!

debug-cache-miss

edit
  • query title: Debug: AUTO_LANGUAGE causes cache miss with frontend
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?itemLabel WHERE {
  ?item wdt:P31 wd:Q5 .
  SERVICE wikibase:label { bd:serviceParam wikibase:language "[AUTO_LANGUAGE],mul,en". }
}
LIMIT 5
Try it!

wikipedia-en-articles

edit
  • query title: Wikidata items with English Wikipedia pages
  • preferred output format: Table
  • data refresh rate: 3600
SELECT ?item ?enWikipediaArticle WHERE {
  ?enWikipediaArticle schema:isPartOf <https://en.wikipedia.org/> ;
                      schema:about ?item .
}
Try it!