products

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

3 rows where series_id = "CNT_13JN3GT6HFEG"

✎ 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_277H3V8XEYF0 CNT_2WAH7CSR6BQ0 The Girl in the Arcade CNT_13JN3GT6HFEG CNT_13JN3GT6HFEG 2 1 1 Volume 3 []   The Girl in the Arcade Vol. 3   Rarara has entered the game! This new rival for Mobuo's affections means Nanora and Shigure will have to take their competition up a notch. Their hot springs getaway is filled with trials and tribulations. A livestream showcase almost turns into a blooper reel as each girl tries to find the cheat code to Mobuo's heart. His unexpected popularity with the ladies is turning his life upside down, but who is Mobuo destined to be with?! THINGS GET STREAMY! 01KG9KKE8B59P5YPZY9CXYWQ7P 3.0 2023-01-16T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1QAEGD31PNR0 The Girl in the Arcade Vol. 3 Okushou 2022, MGMEE 2022   2023-03-07T08:00:00.000Z   0 0
PRD_2HTJERXXAH7G CNT_3BYZPEJNTPCG The Girl in the Arcade CNT_13JN3GT6HFEG CNT_13JN3GT6HFEG 2 1 1 Volume 1 []   The Girl in the Arcade Vol. 1   At his job working in an arcade, "Mobuo" gets pretty much ignored by everyone--even his nickname references the way he blends into the background like some kind of NPC. All that changes when gorgeous, larger-than-life Yaegashi Nanora barges into the place and demands his help learning the ins and outs of the arcade's trickiest games. And did she just ask him out?! One thing's for sure, it's the beginning of a summer full of arcade fun and simmering sexual tension! The Hottest Player Two You Could Ask For 01KGAF2EZXS49X9ZRMNZXKEWTK 1.0 2022-02-10T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1QAEGD31PNR0 The Girl in the Arcade Vol. 1 Okushou 2020, MGMEE 2020   2022-03-08T08:00:00.000Z   0 0
PRD_31X2NRRNHPVG CNT_39K7TZ8W7320 The Girl in the Arcade CNT_13JN3GT6HFEG CNT_13JN3GT6HFEG 2 1 1 Volume 2 []   The Girl in the Arcade Vol. 2   The plain and nondescript "Mobuo" has been showing the boisterous Yaegashi the ins and outs of the arcade's trickiest games. Just as they are getting into a DDR-style rhythm, Mobuo's childhood friend Shinomiya Shigure tries to cut into the dance. Confrontation forces Yaegashi to realize her true feelings. With two girls vying for Mobuo's attention, the competition is about to get hot and heavy with both love and games! A NEW CHALLENGER APPEARS! 01KGAJDTMY79VJHTCCMPY6A10A 2.0 2022-07-29T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1QAEGD31PNR0 The Girl in the Arcade Vol. 2 Okushou 2021, MGMEE 2021   2022-08-30T07: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);