products

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

3 rows where series_id = "CNT_2EXPDC1RSKS0"

✎ 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_0J0J7382V4T0 CNT_1ZCVCPW281CG Durarara!! Saika Arc CNT_2EXPDC1RSKS0 CNT_2EXPDC1RSKS0 2 1 1 Volume 2 []   Durarara!! Saika Arc, Vol. 2   <P> I want to see Shizuo. Soon, soon, soon... </P><P> A mysterious serial slasher has struck in Ikebukuro. The username &quot;Saika&quot; appears in online chat rooms in sync with the attacks. Saika-the name of the demon blade that appeared in Shinjuku years and years ago... </P><P> In its chat room posts, Saika repeats one name over and over again, as though singing the praises of its beloved: Shizuo Heiwajima, Shizuo, Shizuo... </P>   01KGAK8MBS21GR640R71SA2TW0 2.0 2022-08-05T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Saika Arc, Vol. 2     2022-08-30T00:00:00.000Z   0 0
PRD_1AM8HMXHN64G CNT_0X2TXGPD9KH0 Durarara!! Saika Arc CNT_2EXPDC1RSKS0 CNT_2EXPDC1RSKS0 2 1 1 Volume 3 []   Durarara!! Saika Arc, Vol. 3   <P> We love all of humanity. </P><P> Mysterious chat room messages, all posted under the name &quot;Saika,&quot; profess love for humanity - and for one man in particular. Saika&#39;s target: Shizuo Heiwajima!! Over fifty people have been struck in the worst case of serial slashings in the history of Ikebukuro. But the slasher&#39;s victims have tasted not only the blade, but also the vision of their attacker. A vision of love, love, love that can only be realized when their own blades have pierced the bodies of their beloveds. Shizuo braces himself for a battle to the death in the shocking climax of the Saika Arc!! </P>   01KGAK8RHTR8D47ACJZWZ753Z1 3.0 2022-08-05T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Saika Arc, Vol. 3     2022-08-30T00:00:00.000Z   0 0
PRD_2G9TRDV7S39G CNT_2Z1HWZQ6EGW0 Durarara!! Saika Arc CNT_2EXPDC1RSKS0 CNT_2EXPDC1RSKS0 2 1 1 Volume 1 []   Durarara!! Saika Arc, Vol. 1   <P> Ikebukuro, Tokyo-a neighborhood where twisted love prowls!! </P><P> A series of street slashings in Ikebukuro begins to connect total strangers: A teenage girl with no personality of her own; a beat writer for a third-rate tabloid; a teacher suspected of harassment; an informant based in Shinjuku...and a headless rider straddling a pitch-black motorcycle!! Meanwhile, the slasher continues to terrorize the night, all in search of...&quot;him&quot;!? </P>   01KGAJWAHNR4Y1F0V47W9EMC0M 1.0 2022-08-05T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Saika Arc, Vol. 1     2022-08-30T00: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);