NodeinfoUsage

6 rows where local_posts = 746, server = 18 and users_active_month = 13

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ server full_entry users_total users_active_half_year users_active_month local_posts local_comments
1942 HyperTuba 18 2006 2006 289 25 13 746 746
2011 HyperTuba 18 2078 2078 289 25 13 746 746
2080 HyperTuba 18 2149 2149 289 25 13 746 746
2150 HyperTuba 18 2220 2220 289 25 13 746 746
2220 HyperTuba 18 2292 2292 289 25 13 746 746
2290 HyperTuba 18 2363 2363 289 25 13 746 746

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE "NodeinfoUsage" (
  "id" INTEGER PRIMARY KEY AUTOINCREMENT,
  "server" INTEGER NOT NULL REFERENCES "Server" ("id") ON DELETE CASCADE,
  "full_entry" INTEGER NOT NULL REFERENCES "RawServerNodeInfo" ("id"),
  "users_total" INTEGER,
  "users_active_half_year" INTEGER,
  "users_active_month" INTEGER,
  "local_posts" INTEGER,
  "local_comments" INTEGER
);
CREATE INDEX "idx_nodeinfousage__full_entry" ON "NodeinfoUsage" ("full_entry");
CREATE INDEX "idx_nodeinfousage__server" ON "NodeinfoUsage" ("server");