products

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

3 rows where series_id = "CNT_1V8ZV8ZGF870"

✎ 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_02CJE572SACG CNT_3470Q7NF9JYG After School Etude CNT_1V8ZV8ZGF870 CNT_1V8ZV8ZGF870 2 1 1 Volume 2 []   After School Etude Vol. 2   Ballet student Minobe and upperclassman Ichinomiya are officially dating. As partners in pas de deux practice, on home dates together, and even their daily school lives seem so sweet, yet things are about to take a sour turn. Out of the blue, a Russian ballet troupe has set their eyes on Ichinomiya and are doing their utmost to recruit him! Ichinomiya's inherent talent shines for all to see, so it's no wonder he's been scouted, but now Minobe must face his smothered desire to be with Ichinomiya forever. THE DESIRE TO PARTNER FOREVER. 01KG9R9S23J6Y9BHKST805PHSP 2.0 2024-12-12T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG After School Etude Vol. 2 ©Hirune Cyan 2022   2025-01-21T08:00:00.000Z   0 0
PRD_143GHHHKK5S0 CNT_3BZWAMEPG96G After School Etude CNT_1V8ZV8ZGF870 CNT_1V8ZV8ZGF870 2 1 1 Volume 3 []   After School Etude Vol. 3   Minobe is the type to give everything his all, whether it be his daily ballet practices or his relationship with Ichinomiya, an upperclassman with an awe-inspiring gift for dance. When their friend Takarai posts the pas de deux the couple danced to the internet, an American ballet troupe comes knocking at their door looking to recruit them. Soon the two young men are thrust into a new environment, and find their love for each other deepening. But while they might be on the same page as lovers, as dancers they still need to get in the same groove! SWEPT OFF HIS FEET! 01KGBNF4R247PKKZCPH58DQPMM 3.0 2025-04-25T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG After School Etude Vol. 3 ©Hirune Cyan 2023   2025-06-17T07:00:00.000Z   0 0
PRD_3ZM8SJ4ZZW20 CNT_3MV2NJ6CGFT0 After School Etude CNT_1V8ZV8ZGF870 CNT_1V8ZV8ZGF870 2 1 1 Volume 1 []   After School Etude Vol. 1   When Minobe Chihiro is admitted to a private arts academy to study ballet, the last person he expects to train with is the surly second year Ichinomiya Shun. Yet by some stroke of luck, the two have been paired up for their school's mandatory pas de deux practice. While Minobe has fallen at first sight for Ichinomiya's superior dance sense, the second-year's attitude leaves a lot to be desired. For Ichinomiya, paired with Minobe as a dance partner is not how he'd like to be spending his time. The grumpy upperclassman has his walls up, but Minobe's puppy-like affection might be just what he needs! An unlikely pair makes a perfect match! 01KGBBHQ5JD6HEGEAA2VDK2CHH 1.0 2024-08-23T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG After School Etude Vol. 1 ©Hirune Cyan 2021   2024-09-17T07: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);