products

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

16 rows where series_id = "CNT_32CMRSCAX8B0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: level, description, 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_11F0E9T7YGV0 CNT_0C39KXKKP7TG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-4 []   HOTOTOGISU, Episode 1-4   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KXHG5G6KGGFGVFPHKRRR 1.4 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-4 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_12YHWPRXJHM0 CNT_2CRWKKXBB8SG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-6 []   HOTOTOGISU, Episode 1-6   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KYFF20V46PK9DJB2P40M 1.6 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-6 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_15XGSWM9TZT0 CNT_2FD6KF9W56VG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-2 []   HOTOTOGISU, Episode 1-2   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KWJMMXS66KJNRJAG9Z2J 1.2 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-2 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_18J3BFPC6YS0 CNT_0EQKJTY4G64G HOTOTOGISU CNT_32CMRSCAX8B0 CNT_32CMRSCAX8B0 2 1 1 Volume 2 []   HOTOTOGISU, Volume 2   Late 19th Century， Tokyo. Namiko， born as the daughter of an army lieutenant， loses her mother， and finds herself suffering at the hands of her new stepmother. Soon， her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after， or so she thought...   01KGA1KTVAGV545YCM57YPG8C3 2.0 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Volume 2 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_1GMQ99152NG0 CNT_2BF8HS69QCXG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-7 []   HOTOTOGISU, Episode 2-7   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M3C1PNH0F67Z9HG066CY 2.7 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-7 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_1Q57MW3FEMQ0 CNT_0AS5H4WJ2BYG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-5 []   HOTOTOGISU, Episode 2-5   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M2DKXA6N00CGASYZMQVN 2.5 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-5 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_1VVP7GWHAKP0 CNT_2A3JGPJTHAZG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-3 []   HOTOTOGISU, Episode 2-3   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M0QBGW9N7ZC03CZTF3PB 2.3 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-3 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_1Y86H3YVPJN0 CNT_0DEFG072W9RG HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-1 []   HOTOTOGISU, Episode 2-1   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KZTFV4SZGFK4D5XGXSMC 2.1 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-1 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_337SNZB2GGBG CNT_3CDK3MRFHR90 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-5 []   HOTOTOGISU, Episode 1-5   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KY08JNSPTJP1M3J51KF7 1.5 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-5 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_37M80J54WZAG CNT_1FR036EQWQA0 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-3 []   HOTOTOGISU, Episode 1-3   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KX2H2QV7P76RKW7X88WA 1.3 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-3 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3AARJ57ERY9G CNT_3F2X2G30BPB0 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-1 []   HOTOTOGISU, Episode 1-1   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1ETR7M3K16B9JGH00Y465 1.1 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-1 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3EVBXR0H4X8G CNT_1EDA23S8PNM0 HOTOTOGISU CNT_32CMRSCAX8B0 CNT_32CMRSCAX8B0 2 1 1 Volume 1 []   HOTOTOGISU, Volume 1   Late 19th Century， Tokyo. Namiko， born as the daughter of an army lieutenant， loses her mother， and finds herself suffering at the hands of her new stepmother. Soon， her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after， or so she thought...   01KGA1ES7MY5EAGFN4XVWWMYFE 1.0 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Volume 1 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3NJED6JCCK6G CNT_1AEW1DQP8VE0 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-4 []   HOTOTOGISU, Episode 2-4   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M15W67NN5R2KKDDMSS85 2.4 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-4 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3PXZ3KGA0M7G CNT_3B4F121DXWD0 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-6 []   HOTOTOGISU, Episode 2-6   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M2WZVAKEH9SATQS4NKBY 2.6 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-6 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3R0YRSFP8J5G CNT_3DS90ZDYQTF0 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 2-2 []   HOTOTOGISU, Episode 2-2   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1M08VQHXE3D5ANANCAGZ7 2.2 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 2-2 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15:00:00.000Z   0 0
PRD_3WH9AC9RMH4G CNT_1D3609272S80 HOTOTOGISU CNT_32CMRSCAX8B0   3 1 1 Episode 1-7 []   HOTOTOGISU, Episode 1-7   Late 19th Century, Tokyo. Namiko, born as the daughter of an army lieutenant, loses her mother, and finds herself suffering at the hands of her new stepmother. Soon, her kindly aunt introduces her to Navy General Takeo Kawashima. Now Namiko lives happily ever after, or so she thought...   01KGA1KZ9XBM1QAN4E3E6PCZAZ 1.7 2017-12-12T15:00:00.000Z Beaglee LAB_3GC07XBBVKQG GEO_1PKAG51AEAQG HOTOTOGISU, Episode 1-7 (C)ROKA TOKUTOMI & MAKO TAKAMI / Beaglee Inc.   2017-12-12T15: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);