products

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

4 rows where series_id = "CNT_0ZPZ35VRA9EG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_06QGBTEW32A0 CNT_1MZGRH3561CG My Crush is My Roommate CNT_0ZPZ35VRA9EG CNT_0ZPZ35VRA9EG 2 1 1 Volume 2 []   My Crush is My Roommate 2   Hana and Kanata have been friend since high school. Find out how they meet and read about other episodes of their lives as roommates.   01KG79PX9M6FG923J5PVC0F800 2.0 2025-12-22T08:00:00.000Z Irodori Comics LAB_1C3V91K6SPJG GEO_1PQM5BDYSMG0 My Crush is My Roommate 2 (C) Irodori Comics   2025-12-24T08:00:00.000Z   0 0
PRD_20E9JHZZ53TG CNT_0NAT98811HK0 My Crush is My Roommate CNT_0ZPZ35VRA9EG CNT_0ZPZ35VRA9EG 2 1 1 Volume 3 []   My Crush is My Roommate 3   Enjoy a slice of life with Hana and Kanata as they celebrate Halloween and go to a theme park.   01KG79PY9AX2V8QGQ3TYYCNMTJ 3.0 2025-12-22T08:00:00.000Z Irodori Comics LAB_1C3V91K6SPJG GEO_1PQM5BDYSMG0 My Crush is My Roommate 3 (C) Irodori Comics   2025-12-24T08:00:00.000Z   0 0
PRD_24WRW4S112SG CNT_2MMQ8VY9CGW0 My Crush is My Roommate CNT_0ZPZ35VRA9EG CNT_0ZPZ35VRA9EG 2 1 1 My Crush is My Roommate []   My Crush is My Roommate   Hana is in love with her childhood best friend, Kanata. One day, Kanata invites Hana to share a room, which she accepts. For a while, living with her crush seemed manageable for Hana. However, on the other hand, Kanata realized she likes spending time with Hana a bit too much and doesn't really know what to do with her newly found feelings.   01KG79PWS1DRWRV6DQ888KWXG4 1.0 2025-12-22T08:00:00.000Z Irodori Comics LAB_1C3V91K6SPJG GEO_1PQM5BDYSMG0 My Crush is My Roommate (C) Irodori Comics   2025-12-24T08:00:00.000Z   0 0
PRD_2XSS7YXMS4VG CNT_2J0D9YKRJJJ0 My Crush is My Roommate CNT_0ZPZ35VRA9EG CNT_0ZPZ35VRA9EG 2 1 1 Volume 4 []   My Crush is My Roommate 4   Celebrate Christmas and the new year with Kanata and Hana.   01KG79PZ888QAJJ3X0JXHENWXY 4.0 2025-12-22T08:00:00.000Z Irodori Comics LAB_1C3V91K6SPJG GEO_1PQM5BDYSMG0 My Crush is My Roommate 4 (C) Irodori Comics   2025-12-24T08: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);