products

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

2 rows where series_id = "CNT_0FJ5RBH1N1FG"

✎ 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_0RVXD1PH0B3G CNT_3Z85AWBK7PSG I'm Kinda Chubby and I'm Your Hero CNT_0FJ5RBH1N1FG CNT_0FJ5RBH1N1FG 2 1 1 Volume 1 []   I'm Kinda Chubby and I'm Your Hero Vol. 1   Ponjirou is a rookie actor trying his best to land a breakout role. He fears that his weight stands in the way of his dreams. One day, he gets some unexpected fan mail full of sweets. The package came from Konnosuke, a local pastry chef. Ponjirou has his first fan! Someone is supporting his work and giving him new confidence to face the stage with! Lights, camera, Boys' Love! 01KGB2YPA13X7B4VX5398ZWJSW 1.0 2022-12-02T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG I'm Kinda Chubby and I'm Your Hero Vol. 1 2021 Nore   2023-01-03T08:00:00.000Z   0 0
PRD_3FK8RAMY6FE0 CNT_2Y26PPS102E0 I'm Kinda Chubby and I'm Your Hero CNT_0FJ5RBH1N1FG CNT_0FJ5RBH1N1FG 2 1 1 Volume 2 []   I'm Kinda Chubby and I'm Your Hero Vol. 2   Honjirou is a chubby actor with newly found confidence! It's all thanks to the support of his biggest fan, Konnosuke. Konnosuke's support helped him gain his first big leading role. He's been scouted to audition for a TV drama! Meanwhile, Konnosuke is in training at a renowned patisserie, but all his clumsy mistakes are getting him down. As he considers quitting and giving up on his dream, who should appear but Honjirou? The two join hands again as they set out to make each other's dreams a reality. THE SWEET TASTE OF SUCCESS 01KGB6A8Z6HB52JCNWW8FQJW93 2.0 2023-04-20T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG I'm Kinda Chubby and I'm Your Hero Vol. 2 2022 Nore   2023-06-06T07: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);