summaryrefslogtreecommitdiffstats
path: root/extra/elasticsearch/sql_queries.md
blob: 3ea168e5c0b2045584b0251ccd1969a0e48cea61 (plain)
1
2
3
4
5
6
7
8

Top missing OA journals by `container_id`:

    POST _xpack/sql?format=txt
    {
    "query": "SELECT container_id, count(*) from fatcat_release WHERE preservation = 'none' AND is_oa = true GROUP BY container_id ORDER BY count(*) DESC LIMIT 20"
    }