products

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

9 rows where series_id = "CNT_2BSDM2N2S2C0"

✎ 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_030HNH0X4MZG CNT_2K61E55FDNW0 Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 3-4 []   Loveless 3-4   Through a video game, Ritsuka tracks down Septimal Moon, the organization responsible for his brother's death. Meanwhile, Soubi fights against two units that both call themselves ""Zero"" and who claim to feel no pain.   01KGA90PSSFGKCT32EY1R4MKFN 3.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 3-4 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_0NF6DRBEGQTG CNT_0H7AFY4P4RH0 Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 12 []   Loveless 12   Seimei refuses to fight alongside Nisei against an enraged Moonless, further straining the manipulative ties that bind the dirtiest Fighter to his heartless Sacrifice. Meanwhile, while looking at his brother's photo album, Ritsuka discovers new information that doesn't match up with what he's been told about his old self.   01KGA90W5RH8MCFTWTZZ0SD89E 12.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 12 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_0SXPZB4GWPSG CNT_2GH7F9TYKQJ0 Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 10 []   Loveless 10   Although Natsuo and Youji have transferred to Ritsuka's school to monitor him in the wake of his brother's bloody homecoming, the unit named ""Moonless"" manages to isolate Ritsuka in order to propose a scheme to turn brother against brother.   01KGA90TJET1E6J0T8JR0KRFMY 10.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 10 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_0WJ1AY6TRNRG CNT_0KVMEVF6YPK0 Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 7-8 []   Loveless 7-8   Before Ritsuka and Soubi can demand answers from Septimal Moon, the organization behind everything, Seimei undergoes a macabre resurrection! Ritsuka finally asks what he should have from the start: was Seimei a good person? Includes 50 pages of never-before-seen bonus comics!   01KGA90S6XVC1MJE35XJMG9PV9 7.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 7-8 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_219REVK22KF0 CNT_3JV7YE0KJ5DG Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 1-2 []   Loveless 1-2   Soubi leads Ritsuka through a maze of new experiences, from battles wrought in wordplay to making friends at school. But is he any less alone with the secretive Soubi than by himself?   01KG9BT3W94W7CNWDTKGXHDAF7 1.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 1-2 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_22V938HR6M80 CNT_1KHAYWAB76CG Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 5-6 []   Loveless 5-6   Ritsuka's determination to find answers brings dire consequences. While he's confined to a chair at home by his abusive mother, Soubi uncovers a truth so shocking that it completely shatters his fragile sense of self. *Contains volumes 5 and 6 of the series, along with never-before-seen bonus comics, artist commentary, and interviews.   01KGA90QBRWDFXB18TNCKRWVC1 5.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 5-6 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_2Q7ZVFR9JQB0 CNT_3HHKZN9HY91G Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 13 []   Loveless 13   With Soubi coerced back into his relationship with Seimei and now missing, Ritsuka becomes determined to reclaim the strange man who changed his life from the brother he once adored. Meanwhile, Nagisa reveals information about the past of Seven Voices Academy and the painful origins of old loves lost.   01KGA90X7ZAVQ4YVWSPMA104MV 13.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 13 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_2VME62NKYPA0 CNT_1GW0Z0ZTD82G Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 11 []   Loveless 11   Ritsuka's faith in his older brother Seimei is pushed to the limit when the unit named Moonless reveals sordid details of Seimei's horrific past deeds. Then, while Ritsuka is still reeling, the unthinkable happens: Seimei returns to reclaim Soubi.   01KGA90VBCXJDAN5XRQ1Y2BXM7 11.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 11 Yun Kouga / Ichijinsha   2020-04-28T07:00:00.000Z   0 0
PRD_2YAYHNQNTN90 CNT_3G6XYJM2R73G Loveless CNT_2BSDM2N2S2C0 CNT_2BSDM2N2S2C0 2 1 1 Volume 9 []   Loveless 9   Seimei is very much alive and has torn through the Seven Voices Academy like a whirlwind. As Septimal Moon struggles to right itself and keep its secrets from spilling out, a new enemy takes center stage: the unit named ""Bloodless"" wages a crippling psychological war, ending battles without spilling a single drop of blood. Yet Ritsuka and Soubi must emerge victorious against them—or lose Kio.   01KGA90STCZ9EA3KQFJVQBZS5K 9.0 2020-04-15T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Loveless 9 Yun Kouga / Ichijinsha   2020-04-28T07: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);