products

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

6 rows where series_id = "CNT_3G7JSFG6NW1G"

✎ 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_0EGT5Q7XCYXG CNT_27BVECEF2K6G Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 2: Harukaze no Étranger []   Seaside Stranger Vol. 2: Harukaze no Étranger   Shun has had no contact with his family since the day he revealed that he's gay. Now he's headed home to Hokkaido to visit his ailing father, and he's taking his new boyfriend, Mio. The trip will be unpleasant enough for Shun, but what will it bring up for Mio, who knows all too well the pain of losing a parent? A Heartrending Homecoming 01KG9HG27E9QB3B06EF3CS7EK5 2.0 2021-12-10T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 2: Harukaze no Étranger Kii Kanna 2015   2022-02-10T08:00:00.000Z   0 0
PRD_11NQRM84GS4G CNT_092SM4KZQ50G Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 5: Harukaze no Etranger []   Seaside Stranger Vol. 5: Harukaze no Etranger   It's been five years since Mio and Shun came to stay with Shun's parents. By all accounts, their life is great. Shun has taken a temporary break from writing novels, and Mio is working as a mechanic. But with stability comes ennui, leading both to begin quietly questioning their relationship. And an even more turbulent storm is brewing, as Shun's now-teenage brother, Fumi, has entered a rebellious phase! A Fresh Tempest 01KGB29JT7H22T847XP358Q1BG 5.0 2022-10-24T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 5: Harukaze no Etranger Kii Kanna 2020   2022-12-08T08:00:00.000Z   0 0
PRD_1RAHWN8R33KG CNT_2VEZ9C262280 Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 6: Harukaze no Etranger []   Seaside Stranger Vol. 6: Harukaze no Etranger   For five years Mio and Shun have been living with Shun's family in Hokkaido, far from the sunny Okinawan island where they first met. But when an unexpected accident forces the couple to re-think their living situation, they decide to return to Shun's old stomping grounds: Tokyo! Shun even decides to go back to work while Mio takes a much-needed break. Now that they have a place of their own for the very first time, will they finally be able to rekindle the spark that's been absent from their relationship? NEW HORIZONS 01KGAY551MX71VEV4555PCAQQB 6.0 2024-02-19T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 6: Harukaze no Etranger Kii Kanna 2022   2024-03-26T07:00:00.000Z   0 0
PRD_27VBR1HA5W30 CNT_2ZYMPK0SAPKG Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 1: Umibe no Étranger []   Seaside Stranger Vol. 1: Umibe no Étranger   Ever since his parents disowned him for being gay, Shun has been living with his aunt on a small island near Okinawa. One day, he meets Mio, a high school student who recently lost his own parents and now spends his days sitting by the sea. The two young men begin to open up to each other...until Mio reveals that he's leaving. Three years later, an adult Mio returns to the island to confess his true feelings, but is Shun ready for a relationship? A Romance That Will Cleanse Your Heart! 01KG9E8PTSZK276S4C0AXGYES8 1.0 2021-05-25T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 1: Umibe no Étranger Kii Kanna 2014   2021-07-29T07:00:00.000Z   0 0
PRD_2ZVAQWFWANF0 CNT_26VNX8ZCDVZG Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 3: Harukaze no Etranger []   Seaside Stranger Vol. 3: Harukaze no Etranger   After returning to Shun's hometown--and moving into his family's old shop--Shun and Mio have begun their new, if slightly offbeat, life. But just as they're settling in, Shun's younger brother, Fumi, catches these two lovers in the act! With Sakurako's help, Shun tells Fumi the unvarnished truth. Will his family finally be able to accept him for who he is? A DELICATE DISCLOSURE 01KGAGEYQ5NS69ZC3HTTDECA4N 3.0 2022-04-20T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 3: Harukaze no Etranger Kii Kanna 2016   2022-06-02T07:00:00.000Z   0 0
PRD_3XQST6EAEKZG CNT_3HACBBPAT0E0 Seaside Stranger CNT_3G7JSFG6NW1G CNT_3G7JSFG6NW1G 2 1 1 Volume 4: Harukaze no Etranger []   Seaside Stranger Vol. 4: Harukaze no Etranger   When Shun and Mio attend Visitors' Day at Fumi's elementary school, Shun runs into his former classmate and crush, Wada. Though Shun is shaken, Mio grows strangely close to this carefree character from his lover's past. And if that weren't stressful enough, the novel Shun's been agonizing over is about to be published! A CHANCE ENCOUNTER 01KGAJCE3J3F24PFZ9MT7BTAYN 4.0 2022-07-29T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Seaside Stranger Vol. 4: Harukaze no Etranger Kii Kanna 2017   2022-09-02T07: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);