products

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

3 rows where series_id = "CNT_2FN32322JKVG"

✎ 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_1HRER83WB060 CNT_21X0Y40G2C8G Love in Focus CNT_2FN32322JKVG CNT_2FN32322JKVG 2 1 1 Volume 3 []   Love in Focus 3   Swept along by Kei's suggestion to give dating a try, Mako struggles to see where she really fits in. Meanwhile, Mitsuru has become distant, and in her attempts to get back the friendship they had, Mako discovers his hidden past. Mako, Kei, and Mitsuru now have to confront their own feelings, and they might get a little lost before they find their true answers… FINAL VOLUME! ONE LAST SHOT 01KGA7BRVVTYR6VWQ3P4MY279C 3.0 2019-07-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Love in Focus 3 (C) Yoko Nogiri / Kodansha Ltd.   2019-07-23T07:00:00.000Z   0 0
PRD_1K19SJYMDS00 CNT_2M3SZ0TTENEG Love in Focus CNT_2FN32322JKVG CNT_2FN32322JKVG 2 1 1 Volume 2 []   Love in Focus 2   After earning Mitsuru's trust, Mako's beginning to get the hang of living in Lens Inn with the high school photo club. Behind the scenes, however, Mako's best friend Kei warns Mitsuru to keep his distance. This ominous message exposes Kei's feelings for Mako, but Mitsuru is the only one who knows! Later, when the club members all go on a field trip together, a sudden downpour strands Mako and Mitsuru. What will the two do?! ALL MIXED UP 01KGA71V9TS3Q4FT25Y11QQH8Z 2.0 2019-05-14T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Love in Focus 2 (C) Yoko Nogiri / Kodansha Ltd.   2019-05-21T07:00:00.000Z   0 0
PRD_2Q626JQB6TXG CNT_3VFQ01H22600 Love in Focus CNT_2FN32322JKVG CNT_2FN32322JKVG 2 1 1 Volume 1 []   Love in Focus 1   UNDER ONE ROOF Mako's always had a passion for photography. When she loses someone dear to her, she clings to her art as a relic of the close relationship she once had...Luckily, her childhood best friend Kei encourages her to come to his high school and join their prestigious photo club. With nothing to lose, Mako grabs her camera and moves into the dorm where Kei and his classmates live. Soon, a fresh take on life, along with a mysterious new muse, begin to come into focus! From the creator of New York Times bestselling manga That Wolf-Boy Is Mine! comes a feel-good romance about a teenage girl whose passion for photography leads her to a new school, a new dorm, and a new love triangle! 01KG9B2JRVK4SK6C7H50MWS4AT 1.0 2019-02-19T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Love in Focus 1 (C) Yoko Nogiri / Kodansha Ltd.   2019-03-19T07: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);