products

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

4 rows where series_id = "CNT_37WMWQW1QQW0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, on_sale_at, 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_1M4PJKXC1NJ0 CNT_326PY46YM0A0 Professor Strangelove CNT_37WMWQW1QQW0 CNT_37WMWQW1QQW0 2 1 1 Volume 3 []   Professor Strangelove, Volume 3   After being drugged with a love-promoting drug "Easily Fall In Love" by the eccentric genius Professor Shiina, Hayama becomes his assistant on the condition that he creates an antidote to the drug. However, they found themselves seriously in love, and finally embarked on the path of becoming a compatible (?) couple. This is the third volume of the popular Kobunsha BL comic series by Chie Sasahara! A must-see for BL-loving girls.   01KGB40HFVN4MGWP5G6SMTD9HE 3.0 2022-12-27T08:00:00.000Z Kobunsha LAB_380Z3MG78DW0 GEO_1PQM5BDYSMG0 Professor Strangelove, Volume 3 (C)Chie Sasahara 2022   2022-12-27T08:00:00.000Z   0 0
PRD_1RN1W6YPDMH0 CNT_15H3SQV73ZB0 Professor Strangelove CNT_37WMWQW1QQW0 CNT_37WMWQW1QQW0 2 1 1 Volume 2 []   Professor Strangelove, Volume 2   Hayama is a struggling student who has been drugged by the eccentric Professor Shiina, who is known as a genius, with "a drug that facilitates love," which causes a sticky love situation. In exchange for making an antidote to the drug, Hayama is assigned to be the professor's assistant...? The professor sexually harasses Hayama, who is presumed to be a virgin, and his chastity (?) is threatened!   01KGB2RRXNP3JHX3D3JAWQNRSM 2.0 2022-12-27T08:00:00.000Z Kobunsha LAB_380Z3MG78DW0 GEO_1PQM5BDYSMG0 Professor Strangelove, Volume 2 (C)Chie Sasahara 2022   2022-12-27T08:00:00.000Z   0 0
PRD_27MVN29ZC7D0 CNT_2HZ9148AJ4SG Professor Strangelove CNT_37WMWQW1QQW0 CNT_37WMWQW1QQW0 2 1 1 Volume 1 []   Professor Strangelove, Volume 1   Hayama, a struggling student who is on the verge of losing his university credits, is assigned to help wacky genius Professor Shiina with an experiment, with a promise that he is exempted from repeating the year by assisting. However, the mysterious drug used in the experiment is a "clutz-inducing" drug that causes a sticky love situation. The days of Hayama, a (presumed) virgin, being subjected to sexual harassment by the professor begin...   01KGAJYGPBJENT385GGG94WJ15 1.0 2022-08-30T07:00:00.000Z Kobunsha LAB_380Z3MG78DW0 GEO_1PQM5BDYSMG0 Professor Strangelove, Volume 1 (C)Chie Sasahara 2022   2022-08-30T07:00:00.000Z   0 0
PRD_3TDSBWFHFM1G CNT_05WDED02XFVG Professor Strangelove CNT_37WMWQW1QQW0 CNT_37WMWQW1QQW0 2 1 1 Volume 4 []   Professor Strangelove, Volume 4   Hayama, a struggling student, is assigned as an assistant under the supervision of the eccentric genius Professor Shiina. However, Hayama is drugged with a "Incredibly Easily Fall In Love" medicine, which causes him to get caught in a series of sticky love situations. Hayama continues to be sexually harassed by Professor Shiina, but on Christmas Eve, he goes to see Professor Shiina and finds himself gradually becoming attracted to him. Can this wacky Professor and his assistant have a holy night and fall in love? The fourth episode of this slapstick BL comedy.   01KGB40GZC2QS46C9Z87WVCED0 4.0 2022-12-27T08:00:00.000Z Kobunsha LAB_380Z3MG78DW0 GEO_1PQM5BDYSMG0 Professor Strangelove, Volume 4 (C)Chie Sasahara 2022   2022-12-27T08: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);