summaryrefslogtreecommitdiffstats
path: root/extra/elasticsearch/sql_queries.md
diff options
context:
space:
mode:
Diffstat (limited to 'extra/elasticsearch/sql_queries.md')
-rw-r--r--extra/elasticsearch/sql_queries.md8
1 files changed, 8 insertions, 0 deletions
diff --git a/extra/elasticsearch/sql_queries.md b/extra/elasticsearch/sql_queries.md
new file mode 100644
index 00000000..3ea168e5
--- /dev/null
+++ b/extra/elasticsearch/sql_queries.md
@@ -0,0 +1,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"
+ }
+