products

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

4 rows where series_id = "CNT_3MN89CFCFY2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_0CCVZ7G1XV4G CNT_07C871ATBV60 The Illustrated Guide to Monster Girls CNT_3MN89CFCFY2G CNT_3MN89CFCFY2G 2 1 1 Volume 1 []   The Illustrated Guide to Monster Girls, Vol. 1   The girls of Class Z dream of graduating and becoming full-fledged monsters. But can they make it happen when their grades are the real horror show?!   01KGB6TT6YS1TM3Z0FEWPMBDT2 1.0 2023-05-16T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Illustrated Guide to Monster Girls, Vol. 1     2023-08-29T00:00:00.000Z   0 0
PRD_30WK73X4Y7C0 CNT_1G3KTX8C0Q8G The Illustrated Guide to Monster Girls CNT_3MN89CFCFY2G CNT_3MN89CFCFY2G 2 1 1 Volume 4 []   The Illustrated Guide to Monster Girls, Vol. 4   Kidnappings, sabotage, murder—that’s school life as a monster girl. But now, Ichika and the others are hoping to finally get a ghoulish graduation!   01KGAZNM3A13QXZ0MDP5NNPD50 4.0 2024-02-27T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 The Illustrated Guide to Monster Girls, Vol. 4     2024-08-20T07:00:00.000Z   0 0
PRD_3DGHADVGK0M0 CNT_28EDEH613TB0 The Illustrated Guide to Monster Girls CNT_3MN89CFCFY2G CNT_3MN89CFCFY2G 2 1 1 Volume 3 []   The Illustrated Guide to Monster Girls, Vol. 3   The nude form of an exhibitionist invisible girl is also a classmate who was actually in the classroom the entire time? Who is she!?   01KGAT36ND3WKQXKWCS3PVZRWB 3.0 2023-10-30T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Illustrated Guide to Monster Girls, Vol. 3     2024-04-16T00:00:00.000Z   0 0
PRD_3XMJCXSE5BR0 CNT_1K8M8VECDNK0 The Illustrated Guide to Monster Girls CNT_3MN89CFCFY2G CNT_3MN89CFCFY2G 2 1 1 Volume 2 []   The Illustrated Guide to Monster Girls, Vol. 2   At the all-girls monster school Monstrum, Class Z’s performance is bottom-barrel! Can a geeky witch and a lazy vampire make any difference…?   01KH3G5KXQ91EMPWWSW0HCASP5 2.0 2023-08-21T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG The Illustrated Guide to Monster Girls, Vol. 2     2023-12-12T00:00:00.000Z   0 0

Advanced export

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

CSV options: 

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);