products

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

8 rows where series_id = "CNT_0FNF1MJ11JSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_0TKY22Z1ZBMG CNT_00WWNZP577TG Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 2 []   Shonen Note: Boy Soprano 2   Now that Yutaka has officially decided to join the city opera, he's cast in a leading role in the ghost story The Turn of the Screw. Meanwhile, school choir president Betsuyaku struggles to prove that he and his choir are capable of winning the gold prize in the NHK All-School Choir Competition. But can he bring the choir together to achieve greatness, or will he alienate all of its members?   01KGB2TSKY3VBN9ACF5PDNFGTW 2.0 2022-12-23T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 2 Yukhi Kamatami/Kodansha Ltd.   2023-01-11T08:00:00.000Z   0 0
PRD_0TNP6A5TTDH0 CNT_26TQPTDX0CBG Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 7 []   Shonen Note: Boy Soprano 7   After an unexpected mishap at the national choir competition, Midori loses sight of who she is and decides to resign from the choir. Meanwhile, Yutaka's time as a boy soprano is reaching its end as his voice begins to change. He hopes Midori will get to hear him perform one more time, but...   01KGAZXS007A6770QSFETC15P0 7.0 2024-04-09T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 7 Yuhki Kamatani/Kodansha Ltd.   2024-04-30T07:00:00.000Z   0 0
PRD_10VRZ1K7VJ5G CNT_0R9K7YC7A57G Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 4 []   Shonen Note: Boy Soprano 4   The Kawami Higashi Middle School choir has won the district competition and is moving on to regionals, but the choir just isn't the same without Yutaka's soprano voice. In her eagerness to bring Yutaka back, Mariko must learn to speak for herself. Will she find a way to remind Yutaka of the joy of singing?   01KGB7K5PBG0BFA7X8C9FCTFRJ 4.0 2023-06-06T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 4 Yuhki Kamatani/Kodansha Ltd.   2023-06-27T07:00:00.000Z   0 0
PRD_130V2FV6NEX0 CNT_3EPT27DKC0Z0 Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 3 []   Shonen Note: Boy Soprano 3   Russian boy soprano Vladimir Popov is touring Japan when he learns about Yutaka's amazing talent. He insists on meeting this new rival and hearing him sing, but when he watches a rehearsal of The Turn of the Screw, he doesn't mince words in telling Yutaka how he feels about the performance... Will his encounter with Vladimir be a blow to Yutaka's confidence, or will it give him the strength to continue to press onward, in both the opera and school choir?   01KGB603KDS39XCCE2083K9P7S 3.0 2023-03-21T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 3 Yuhki Kamatani/Kodansha Ltd.   2023-04-11T07:00:00.000Z   0 0
PRD_1CTME16K938G CNT_30HYRR17RP80 Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 8 []   Shonen Note: Boy Soprano 8   The only constant in life is change, and now the entire town of Kawami is forced to accept that reality. After the dismal results of the vote on the industrial waste disposal facility, everyone is lost in a fog of disappointment-Everyone, that is, except for the City Opera. As the saying goes, the show must go on, and the City Opera troupe hopes to lift the town's spirits with music. But will Yutaka be able to recover from Midori's shocking confession that his singing scares her...? After a long journey of self-discovery, Yutaka finally came to terms with who he was-as a boy, a singer, and a boy soprano. But now facing Midori's words, will he gather the strength to press onward, or will all his growth come crashing down in a chaotic crescendo?   01KGBA39KPETNB8H9PMTKGQYNZ 8.0 2024-05-28T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 8 Yuhki Kamatani/Kodansha Ltd.   2024-06-18T07:00:00.000Z   0 0
PRD_2CHH26263Q3G CNT_0B3HBMNZM6Z0 Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 5 []   Shonen Note: Boy Soprano 5   The pressure mounts as the regional choir competition gets closer and closer. Tomoya is struggling to breathe in the choir and at home, as his parents refuse to stop arguing-and when the stress gets to be too much, he takes it out on Yutaka. The choir is starting to fall apart, but a mysterious wandering flautist may have some helpful advice...   01KH3EP14FR2ZN6VRKYJZV0Z2J 5.0 2023-08-22T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 5 Yuhki Kamatani/Kodansha Ltd.   2023-09-12T07:00:00.000Z   0 0
PRD_2SZW4J2SBNPG CNT_2W4XSNBCNZ9G Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 6 []   Shonen Note: Boy Soprano 6   Vladimir's voice has begun to change, and he is losing the ability to sing in the soprano style he so loves. Anatoly takes him to Kawami in the hopes that Yutaka can help him. Meanwhile, the residents of Kawami are troubled to find their city has approved the construction of the industrial waste disposal facility...   01KGASZEG0VDDTYRAYN1KRKQHH 6.0 2023-10-31T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 6 Yuhki Kamatani/Kodansha Ltd.   2023-11-21T08:00:00.000Z   0 0
PRD_39DATJ6071Q0 CNT_2FG6W0KG1Y7G Shonen Note: Boy Soprano CNT_0FNF1MJ11JSG CNT_0FNF1MJ11JSG 2 1 1 Volume 1 []   Shonen Note: Boy Soprano 1   Yutaka Aoi is sweet, sensitive, and loves singing...so much so that he can't help but be brought to tears whenever he listens to beautiful music. He also has a talent few boys have: He can sing soprano. So when Yutaka overhears his middle school's choir group perform, he can't resist joining in. Inspired by the angelic sound of Yutaka's voice, the choir eagerly accepts him into their ranks. But when Yutaka's voice begins to change as he enters puberty, the journey ahead will be one of self-discovery and reflection for not only himself, but also for those around him.   01KGAJZ7E77BHPWGSF00A9T22J 1.0 2022-08-23T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Shonen Note: Boy Soprano 1 Shonen Note: Boy Soprano Yuhki Kamatani/Kodansha Ltd.   2022-09-13T07: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);