database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_28HPBPW4ZWYG"

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_18TDJ9GF7BC0	CNT_2TG0GVNTX1TG	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 1	[]	Phantom of the Idol 1	THIS PHANTOM'S A CUTIE! Yuya, one half of the boy pop duo ZINGS, may be the laziest performer in the Japanese music industry. His partner is out there giving 110% every night, but Yuya's sloppy dancing and his frankly hostile attitude toward the audience has the fans hating him and his agent looking for any excuse to cut him loose. The career of a pop idol just isn't the path of easy leisure Yuya expected... After a particularly lifeless concert appearance, Yuya meets a girl backstage. All she wants from life is to perform. There's just one problem: She's been dead for a year.	01KGAF6G92D76KA5MT4287MV5P	1.0	2022-05-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 1	Phantom of the Idol Hijiki Isoflavone/Kodansha Ltd.	2022-05-24T07:00:00.000Z
PRD_1GTCTR3DCY0G	CNT_3ZN3PPVBMXT0	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 6	[]	Phantom of the Idol 6	Deemed a strong actor due to his split persona on stage-even though it's really Asahi-Yuya is thrown into the task of helping his new co-star, Yakumo Nanase, for their detective drama. Despite being runner-up for the Up Next Idol Awards, Yakumo has been in the idol business for more than a decade, re-debuting twice. Yakumo is determined to make a strong impact in his role, so he takes on method acting-to the extreme. While everything seems to be going swell for Yuya and Asahi, Yakumo enters a spiral of abiding by his fans' wishes and who he is...	01KGB6JJD96JNHWA9A2NJ1ZSQY	6.0	2023-06-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 6	Hijiki Isoflavone/Kodansha Ltd.	2023-07-11T07:00:00.000Z
PRD_21ZXDQ472VAG	CNT_04HSR5TNJRMG	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 5	[]	Phantom of the Idol 5	THIS DRAMA'S A GOODIE! Finally, the Up Next Idol Awards are announced — and ZINGS manages to secure a top award! (Un)fortunately, Niyodo is rewarded with a supporting role in a television drama, along with the mysterious and aloof "Black Knight Idol"! How will Niyodo and Asahi deal with the grueling schedule of a television drama?!	01KGB5PCSQA4VFKEY8SB4SEZZX	5.0	2023-03-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 5	Hijiki Isoflavone/Kodansha Ltd.	2023-04-04T07:00:00.000Z
PRD_25WY011EGRM0	CNT_39HJ650BG52G	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 2	[]	Phantom of the Idol 2	This top idol's a meanie! Yuya Niyodo thought being an idol would mean easy money, but his lackluster performances and apathetic attitude meant his job was on the chopping block...until the ghost of Asahi Mogami possesses Yuya with the aim of becoming a top idol! After a bombastic Hottie Farm, ZINGS is the talk of the idol world. Yuya's stage persona that switches between hot mess and god status is not only puzzling (and alluring) fans, but troubling Hikaru Setouchi, the leader of top idol group Cgrass, for Yuya's apparent mimicry of star idol, Asahi Mogami!! Hikaru will not let this stand—for the sake of Asahi's divine memory...even though it's technically Asahi inside.	01KGAJBSFWTMW62TPCYV8S1DVS	2.0	2022-07-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 2	Phantom of the Idol Hijiki Isoflavone/Kodansha Ltd.	2022-08-16T07:00:00.000Z
PRD_2S8RB03G1N70	CNT_1KARMFK7WJF0	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 4	[]	Phantom of the Idol 4	THIS PARTNER'S A SWEETIE! Distraught from the realization that Yuya is willingly possessed by the ghost of Asahi--and that their dynamic duo is really a trio--Kazuki enters a depressive slump. For the first time, Kazuki is on hiatus and Yuya is mixed about the newfound responsibility of leading ZINGS's official activities. Meanwhile, Chikage Yura, Asahi's former group leader and now protege of the spiritual arts, is ecstatic about the possible breakup of ZINGS. Will ZINGS survive? Or will Yuya's cake made on live television fall flat?	01KG9KM6CMTATXD6PZD4VSACDB	4.0	2023-01-20T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 4	Hijiki Isoflavone/Kodansha Ltd.	2023-02-07T08:00:00.000Z
PRD_39DVBW62JG4G	CNT_0WDCD08XQRQG	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 8	[]	Phantom of the Idol 8	Yuya can no longer see or hear Asahi, much less have her possess his body! Furthermore, Yuya's vivacious mother, Haruka, wants Yuya to quit being an idol. For someone who has not had much interest in, well, anything, it begs the question of whether Yuya has enough energy to succeed without Asahi. But Yuya has recently found that he wants to try being good at something...will he be able to reconnect with Asahi?	01KGC090SY58KP3RGQ1RAA2ANW	8.0	2025-10-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 8	Hijiki Isoflavone/KODANSHA LTD.	2025-10-28T07:00:00.000Z
PRD_3KC5AYPJZTTG	CNT_1PWDGDC189H0	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 7	[]	Phantom of the Idol 7	Seeing how Yakumo's earnest success has led to financial wealth, Yuya suddenly feels like he wants to try being an idol. With this realization, Asahi wants to help Yuya attain ""idol enlightenment."" But before that can happen, Niyodo's mom appears on the scene, and she has some sort of connection with Shinano...?	01KGAZTNPH7KS82S13T7HRK44X	7.0	2024-04-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 7	Hijiki Isoflavone/Kodansha Ltd.	2024-04-23T07:00:00.000Z
PRD_3RAK14T84EHG	CNT_1V88DBAF5SBG	Phantom of the Idol CNT_28HPBPW4ZWYG	CNT_28HPBPW4ZWYG	2	1	1	Volume 3	[]	Phantom of the Idol 3	THESE FANS ARE CRAZY! Yuya Niyodo and his peppy phantom, Asahi Mogami, are making their way to the top of idoldom! After a successful concert, ZINGS wants to give back to their fans through the most practical merch possible—calendars! Overwhelmed with emotions after Yuya's confession that he was glad he hasn't quit being an idol, Niyodoids dive deep into product development, allowing their fantasies to go wild—such as Yuya with glasses or, wait for it... a different stage outfit! Even more exciting, ZINGS has been nominated for the Up Next Idol Awards!! Excitement is short-lived when Asahi learns of the return of her former idol group?s leader, Chikage Yura, after a year-long hiatus...but Chikage might be leaving the industry?!	01KGB2AMNF1YK53FZFNCBKGQQD	3.0	2022-11-08T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Phantom of the Idol 3	Hijiki Isoflavone/Kodansha Ltd.	2022-11-29T08: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);