database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_2HKQXC9Q81AG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_087ED43YN2S0	CNT_0AAFMM2DE170	My Noisy Roommate: The Roof Over My Head Comes with Monsters and a Hottie CNT_2HKQXC9Q81AG	CNT_2HKQXC9Q81AG	2	1	1	Volume 3	[]	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 3	After Nijio's ex-partner tried and failed to come between them, and after so many successful cases together, Nijio and Osuke's relationship has deepened. But right as they finally begin to trust each other as partners, Osuke's older brother and sister come knocking at Divine Inspiration! Osuke's overprotective siblings are raring to take their precious little brother back home where he'll be safe and sound. But Nijio might have something to say about that. And just why do Osuke's older siblings recognize Nijio? And what does this have to do with Osuke's powers?	01KGBRA7769RNGPBJEKVX41088	3.0	2025-06-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 3	Kaho Ozaki/KODANSHA LTD.	2025-07-08T07:00:00.000Z
PRD_23GYASKBHEQ0	CNT_0C02P80FXWQG	My Noisy Roommate: The Roof Over My Head Comes with Monsters and a Hottie CNT_2HKQXC9Q81AG	CNT_2HKQXC9Q81AG	2	1	1	Volume 4	[]	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 4	Osuke and Nijio have come to discover that their acquaintance goes further back than either of them could have known, and that both their fantastical powers came from the same god. But this god is strangely attached to Nijio, and dangerous. To keep them both safe, Osuke has decided that they will continue working together as partners. Meanwhile, Nijio has come to a different realization altogether-he has feelings for Osuke-and he fears pulling Osuke in too deep. Just as unspoken doubts are beginning to take a toll on their partnership, Ten invites Osuke to accompany him on a job to some hot springs in a mysterious, remote village...just the two of them! Will this be the incentive Nijio needs to start bridging the gap between them?	01KG79124B4V216HF3Q3YST7HS	4.0	2025-12-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 4	Kaho Ozaki/KODANSHA LTD.	2025-12-30T08:00:00.000Z
PRD_3D1EEPKZKS9G	CNT_0NZYVBNR89D0	My Noisy Roommate: The Roof Over My Head Comes with Monsters and a Hottie CNT_2HKQXC9Q81AG	CNT_2HKQXC9Q81AG	2	1	1	Volume 2	[]	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 2	Osuke Kuroe is loved by all kinds of creepy ghosts and ghouls, while Nijio Yuki has such powerful spiritual energy, it scares off every spirit around. This unlikely duo, who seem worlds apart, have now teamed up together to help the supernatural relocate and find safer places to live. When a new job comes in, Osuke and Nijio are tasked to stay overnight in an inescapable mansion. But this time, they're joined by their colleagues, Takao and Ten. After walking in on an intimate moment between them, Osuke becomes more and more self-conscious about his own relationship with Nijio...	01KG9Q3SG0SZKTRK7JZYWTD241	2.0	2025-02-06T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 2	Kaho Ozaki/Kodansha Ltd.	2025-02-18T08:00:00.000Z
PRD_3EMB5S7540W0	CNT_1BXSSDBTM35G	My Noisy Roommate: The Roof Over My Head Comes with Monsters and a Hottie CNT_2HKQXC9Q81AG	CNT_2HKQXC9Q81AG	2	1	1	Volume 1	[]	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 1	Osuke's excited about finally getting to live on his own, but on his first day in his new apartment, he finds himself kicked out onto the street! So, when a real estate agent appears out of nowhere offering him a beautiful, new place (with just a couple conditions), he jumps at the chance. But when he opens the door, a drop-dead gorgeous blond guy pops out! It turns out living with him is one of the conditions! His name is Nijio, and he tells Osuke that, not only are ghosts real, but Osuke himself is a magnet for all things supernatural...	01KGB9S87V58YC6RPZKCVWHRAH	1.0	2024-06-04T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	My Noisy Roommate: The Roof Over My Head Comes With Monsters and a Hottie 1	Kaho Ozaki/Kodansha Ltd.	2024-06-25T07:00:00.000Z

Advanced export

JSON shape: default, array, newline-delimited, object

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);