products

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

4 rows where series_id = "CNT_2SSXVJWX8S6G"

✎ 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_0N2ZJQ8STRW0 CNT_3X061NBGJX70 The Lines that Define Me CNT_2SSXVJWX8S6G CNT_2SSXVJWX8S6G 2 1 1 Volume 2 []   The Lines that Define Me 2   Sosuke Aoyama, a college student with deep emotional scars, is scouted by Kozan Shinoda, a giant in the ink-painting scene. Through him, he encounters an entire world of passionate artists, an experience that helps rescue him from his loneliness. Through painting, he discovers, he can face up to his past, connect with others, and get the contours of his life back in order...   01KGAENVER6B0HPYWXNWQPNK4T 2.0 2022-02-01T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG The Lines that Define Me 2 The Lines that Define Me Hiromasa Togami, Atsunori Horiuchi/Kodansha Ltd.   2022-02-15T08:00:00.000Z   0 0
PRD_1QQPY4XXJFW0 CNT_3HE95KHRY5AG The Lines that Define Me CNT_2SSXVJWX8S6G CNT_2SSXVJWX8S6G 2 1 1 Volume 3 []   The Lines that Define Me 3   As his work's displayed at his college's festival, Sosuke finds that it brings him new interaction with friends, master artists, and others. It only serves to deepen his knowledge of the craft, and as he senses a warmer wind blowing across his heart, he hears that his teacher Kozan Shinoda will hold a public painting session at the festival. There, a miracle unfolds...   01KGAEW3Q8GW2ZHKF4D6RP9MG8 3.0 2022-02-25T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG The Lines that Define Me 3 The Lines that Define Me Hiromasa Togami, Atsunori Horiuchi/Kodansha Ltd.   2022-03-15T07:00:00.000Z   0 0
PRD_2J770H6XF4TG CNT_2KPWR87Y8T30 The Lines that Define Me CNT_2SSXVJWX8S6G CNT_2SSXVJWX8S6G 2 1 1 Volume 4 []   The Lines that Define Me 4   Encountering ink-painting master Kozan Shinoda has changed solitary college student Sosuke Aoyama's life. Through the hidden thoughts of Kozan, Sosuke recalls fonder memories of his parents...and the gratitude he feels for the people he's met. And now he's ready to pour it all into a single flower... Every young man's path is lined with miracles. And as this story closes, his will be brimming with shining life like never before.   01KGAG24HMXWSRE7VR54AH20QS 4.0 2022-04-05T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG The Lines that Define Me 4 The Lines that Define Me Hiromasa Togami, Atsunori Horiuchi/Kodansha Ltd.   2022-04-19T07:00:00.000Z   0 0
PRD_39ZEBG5V8DV0 CNT_2QDH55XC4HR0 The Lines that Define Me CNT_2SSXVJWX8S6G CNT_2SSXVJWX8S6G 2 1 1 Volume 1 []   The Lines that Define Me 1   Sosuke Aoyama is a college student adrift on his own...until a chance meeting with suibokuga artist Kozan Shinoda brings him into the world of India-ink painting. But though he finds connection with the art and Shinoda himself, there's more to both the art world and Shinoda's family than Sosuke realizes...   01KGADFSPRMSY58KC5C51VQ7RA 1.0 2021-12-23T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG The Lines that Define Me 1 The Lines that Define Me Hiromasa Togami, Atsunori Horiuchi/Kodansha Ltd.   2022-01-18T08: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);