products

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

1 row where series_id = "CNT_33P849YD8ATG"

✎ 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_168N6P5WQVA0 CNT_00P4MND0MW80 Nagi & Hayasaki CNT_33P849YD8ATG CNT_33P849YD8ATG 2 1 1 Nagi & Hayasaki []   Nagi & Hayasaki   <P><B>A spicy romcom BL about a secretly perverted class president and the goofball delinquent who catches his eye! A clumsy tryst evolves into a tender romance in this comedic story of an unlikely couple.</B><br><br><I>What's a pent-up punk to do when his mortal enemy gives him an unexpected #@%&?$! in the school restroom...? Freak the #$!& out, of course!</I><br><br>Certified slacker <B>Nagi </B>wants absolutely nothing to do with "mature" and "diligent" class president <B>Hayasaki</B>—especially after what happened in the bathroom. But Hayasaki won't leave him alone! And worse yet, Nagi can't even get himself off anymore without Hayasaki's help...<br><br><B>What the %&$# is happening?! </B>And why did it have to be <I>Hayasaki </I>of all people?!<br><br>Nagi's gay panic only intensifies when Hayasaki confesses to him. Enemies-with-benefits is one thing, but a full-blown rivals-to-lovers romance might be more than Nagi can handle...!</P><P><B>-</B></P><P><B><U>NOTE/CWs</U>: </B>explicit sexual content, sexual assault/dubious consent, homophobia, school setting <I>[all characters depicted are over the age of 18]</I></P><P><br> </P>   01KPJ80Y40XSH9KYGTXE7JWEHB 0.0 2026-04-19T06:47:34.000Z LoveLove LAB_3TY7S40666N0 GEO_1G15ETQ2GP3G Nagi & Hayasaki     2026-05-19T00: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);