products

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

4 rows where series_id = "CNT_28922XEX4110"

✎ 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_0BVAJ2HWTJF0 CNT_2BTZTGR94XMG Rose Guns Days Season 1 CNT_28922XEX4110 CNT_28922XEX4110 2 1 1 Volume 3 []   Rose Guns Days Season 1, Vol. 3   True salvation...there is no answer to that. With Alfred out of the picture, a new force emerges into the power vacuum--and Leo's new "friend," ex-serviceman Caleb, is at the center. Though the Caleb family's motives seem well-intentioned--providing welfare for repatriated Japanese soldiers--its "donation" practices include shaking down the whole town for exorbitant fees! And when this new threat arrives at Club Primavera's doorstep, a whole new conflict begins...   01K5G9X4Z092WWB86SMEB816NB 3.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Rose Guns Days Season 1, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_0SBG0K72AW2G CNT_1KZSG6VMZ700 Rose Guns Days Season 1 CNT_28922XEX4110 CNT_28922XEX4110 2 1 1 Volume 1 []   Rose Guns Days Season 1, Vol. 1   After suffering unprecedented disasters in World War II, Japan accepts the American and Allied Forces' terms of unconditional surrender. Now the citizens of a ruined nation, the people of Japan come together amid an influx of influences and immigrants and--cunningly, carefully--survive...This is the unrecognizable Japan to which the sharpshooting, sweet-talking womanizer Leo Shishigami returns three years after the war. Against this backdrop, in the spring of 1947, everything is set into motion when Leo meets Rose Haibara, the madam of Club Primavera...   01KG931ZSZPN3Q0TPDTX0JFG4S 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Rose Guns Days Season 1, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_3QRSV513KD10 CNT_2RZYD3P2582G Rose Guns Days Season 1 CNT_28922XEX4110 CNT_28922XEX4110 2 1 1 Volume 4 []   Rose Guns Days Season 1, Vol. 4   Thank you, really... ...And I'm sorry. The battle between Club Primavera and the Caleb family--with the pride of the Japanese people at stake--finally barrels toward a conclusion. Which group will win the right to rule during the coming era...?!   01K5GB3S8EWVY31S75B0MYEF1Z 4.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Rose Guns Days Season 1, Vol. 4     2016-06-30T15:00:00.000Z   0 0
PRD_3YG0R9A5VHYG CNT_252P47V0AC40 Rose Guns Days Season 1 CNT_28922XEX4110 CNT_28922XEX4110 2 1 1 Volume 2 []   Rose Guns Days Season 1, Vol. 2   After thwarting the underhanded mafia boss Alfred in his attempts to overtake Club Primavera, Rose seeks the protection of Captain Philip Butler of the American Garrison, who benevolently agrees...for a price. But this newfound security is jeopardized when Alfred recovers, and his explosive tactics threaten to turn Primavera--and all of District 23--into a battlefield!   01KG95HDCFCE4EK0ERNH586SQM 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Rose Guns Days Season 1, Vol. 2     2016-06-30T15: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);