products

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

3 rows where series_id = "CNT_3K7F35JK3P4G"

✎ 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_0JBJD1VRPXY0 CNT_3ZYX9PHS7240 Karate Heat CNT_3K7F35JK3P4G CNT_3K7F35JK3P4G 2 1 1 Volume 3 []   Karate Heat Volume 3   The first round of the group fights... It's Shinya's turn in the 3rd fight where he gets overwhelmed by his rival who is higher rank and much more talented than him. When Shinya is about to lose all hope, he's saved by his teammates - the first ones he's ever had in his whole life. Shinya learns what friendship and teammates mean in the path of karate, and even though he's a beginner, his growth is accelerating!   01KGA56K1EFVX2JGSY5ASPNYDB 3.0 2018-09-05T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Karate Heat Volume 3 (C) Eiichi Kitano / Kodansha Ltd.   2018-09-18T07:00:00.000Z   0 0
PRD_16VDC1DTASQG CNT_2CC2ZTX9WDKG Karate Heat CNT_3K7F35JK3P4G CNT_3K7F35JK3P4G 2 1 1 Volume 2 []   Karate Heat Volume 2   Shinya and Takumi have joined the elite Kawasaki Ukishima Junior High Karate Club. Waiting for them is the Kanagawa preferectural tournament. This is the first real tournament for Shinya, and he is struck by the atmosphere of the grounds and the passion of his rivals. Shinya is still in the beginning of his journey through the long and rugged path of karate, but he's already run past everyone else with his cheerful and fun attitude. ""Kumite is like a conversation where instead of words you exchange fists.” 01KGA535FZXVFQPXC0ZWHJJD0W 2.0 2018-08-13T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Karate Heat Volume 2 (C) Eiichi Kitano / Kodansha Ltd.   2018-08-21T07:00:00.000Z   0 0
PRD_20VXMMAEWXNG CNT_21FF8MP8XHXG Karate Heat CNT_3K7F35JK3P4G CNT_3K7F35JK3P4G 2 1 1 Volume 1 []   Karate Heat Volume 1   Shinya Kinoshita, a boy with incredible posture, and Takumi Yanagiya, the 6-time elementary school national champion. They met by chance... but it was surely fate. The two meet, laugh, and are drawn together by each other. The stage of this story is the Kawasaki Ukishima Junior High School Karate Club. A karate journey full of sweat, bonds, and smiles is just beginning!! “All you need is the floor and your body. Then all that's left is to make a fist.” 01KGA3NX4K29NNBJ7HRNEW5XYH 1.0 2018-06-14T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Karate Heat Volume 1 (C) Eiichi Kitano / Kodansha Ltd.   2018-06-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);