products

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

4 rows where series_id = "CNT_3H71MMKPAD8G"

✎ 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_05XED3614800 CNT_3CBF1DYFHB5G Sensei's Pious Lie CNT_3H71MMKPAD8G CNT_3H71MMKPAD8G 2 1 1 Volume 2 []   Sensei's Pious Lie 2   Blinded by our own pain, we end up hurting the very people we want to protect. Under the sway of her abuser, 24-year-old teacher Misuzu Hara must lie to herself to survive—but she's not the only one. And when she and Niizuma find themselves caught up in Kanamisa's power games, they'll all learn hard lessons about self-deception, violence, control...and maybe even love.   01KGAGKWXR9AZK0MG1J3CC3997 2.0 2022-05-16T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Sensei's Pious Lie 2 Sensei's Pious Lie Akane Torikai/Kodansha Ltd.   2022-05-17T07:00:00.000Z   0 0
PRD_2KJ8HNFCNE60 CNT_397YR3K7KH7G Sensei's Pious Lie CNT_3H71MMKPAD8G CNT_3H71MMKPAD8G 2 1 1 Volume 3 []   Sensei's Pious Lie 3   Desperate in the face of Minako's pregnancy, Hayafuji's simmering hatred reaches the boiling point—and his grotesque imagination leaves Misuzu with an impossible choice to make. Unflinching and sometimes brutal, Akane Torikai's examination of sex, gender, and power is nonetheless warm and humane at heart, boasting a rich cast of characters whose all-too-human need for love takes them to dark and unexpected places. Warning: Includes graphic depictions of sexual violence.   01KGAJ761N8YJ7A973H9VSPNWF 3.0 2022-07-21T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Sensei's Pious Lie 3 Sensei's Pious Lie Akane Torikai/Kodansha Ltd.   2022-08-09T07:00:00.000Z   0 0
PRD_39N9Y8026BB0 CNT_26P3EEXDJRKG Sensei's Pious Lie CNT_3H71MMKPAD8G CNT_3H71MMKPAD8G 2 1 1 Volume 4 []   Sensei's Pious Lie 4   Seeking to free herself and transform sex into something more than a curse, Misuzu Hara has finally stood up to her abuser, with devastating results. But what lesson will she take from that explosion of violence? And how will it affect the people around her? Akane Torikai brings her deftly woven masterpiece of power dynamics and gender relations to its conclusion with a series of startling turns and a seemingly limitless reserve of compassion for the human condition. 18+. Warning: Includes graphic depictions of sexual violence.   01KGAJT6W4MXHNCC7VZ94H0KKZ 4.0 2022-10-12T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Sensei's Pious Lie 4 Sensei's Pious Lie Akane Torikai/Kodansha Ltd.   2022-10-25T07:00:00.000Z   0 0
PRD_3DS7TK4MV6T0 CNT_03WVEQ6KKCCG Sensei's Pious Lie CNT_3H71MMKPAD8G CNT_3H71MMKPAD8G 2 1 1 Volume 1 []   Sensei's Pious Lie 1   Misuzu Hara is a quiet, reserved 24-year-old high school teacher whose world is turned upside down after her friend's fiancé rapes her. Her attempt to connect with one of her students, himself a victim of sexual trauma, results in an unlikely romance, and the repercussions of these events affect everyone around them in often unpredicatable ways. 18+. Warning: Includes graphic depictions of sexual violence.   01KGAF36M90E2FRM2M47WAQ2HK 1.0 2022-02-08T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Sensei's Pious Lie 1 Sensei's Pious Lie Akane Torikai/Kodansha Ltd.   2022-03-01T08: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);