products

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

5 rows where series_id = "CNT_3A7M4JEWB4V0"

✎ 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_0JCKZTRF64N0 CNT_3TMPCQ1KS7TG Mermaid Melody Pichi Pichi Pitch: Aqua CNT_3A7M4JEWB4V0 CNT_3A7M4JEWB4V0 2 1 1 Volume 5 []   Mermaid Melody Pichi Pichi Pitch: Aqua 5   When Laurent lures Kurosuna-kun to his underwater lair with a promise to reveal the truth about his mysterious past, Lukia and her friends rush to the rescue-but soon find themselves captured instead! Trapped in an aquarium adorning Laurent's throne room, Lukia and Lucia are all out of options...unless, that is, they can somehow convince the fallen mermaid princess Seira to reject the darkness in her heart and help them. It's a long shot, but Lukia knows she and Seira have something in common that might help Lukia get through to her-their shared feelings for Kurosuna-kun.   01KGBPARS0VCTMJ595K9GRSKRY 5.0 2025-05-09T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Mermaid Melody Pichi Pichi Pitch: Aqua 5 Pink Hanamori/Kodansha Ltd.   2025-05-27T07:00:00.000Z   0 0
PRD_1BKGKAK45250 CNT_2E7A1TBVPWT0 Mermaid Melody Pichi Pichi Pitch: Aqua CNT_3A7M4JEWB4V0 CNT_3A7M4JEWB4V0 2 1 1 Volume 3 []   Mermaid Melody Pichi Pichi Pitch: Aqua 3   Despite their best efforts, Lukia and the mermaid princesses fail to save the Orange Mermaid Princess Seira, whose heart has been corrupted by the nefarious Laurent. Scattered across the sea by Laurent's powerful attack, Lukia finds herself alone on a strange beach, where a handsome stranger offers to carry her home. When she finds out he is none other than Nam, the merman prince she is fated to marry, Lukia is mortified. Her mother makes things even more awkward by inviting him to a party at their house, while-unbeknownst to them both-her father invites Kurosuna-kun to the party as well. Lukia soon finds herself caught between the two boys as they face off for her affections.   01KGATE987SG8DP175VGBHJCP1 3.0 2023-12-26T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Mermaid Melody Pichi Pichi Pitch: Aqua 3 Pink Hanamori/Kodansha Ltd.   2024-01-16T08:00:00.000Z   0 0
PRD_24KJ1K3QV7BG CNT_07F3WDSVNQ70 Mermaid Melody Pichi Pichi Pitch: Aqua CNT_3A7M4JEWB4V0 CNT_3A7M4JEWB4V0 2 1 1 Volume 2 []   Mermaid Melody Pichi Pichi Pitch: Aqua 2   Lukia's life has been decidedly more complicated since finding out she's a mermaid-and a princess-on her 17th birthday. She's duty-bound to marry a merman fiancé she's never met, even while her feelings for Kurosuna-kun continue to grow stronger and stronger. Meanwhile, the new king of the deep sea schemes to drag her down to his inky domain, and a mysterious and gorgeous new transfer student arrives in class to stir things up with Kurosuna-kun!   01KGB7XJAS6Q61EF1PBKS9DSYC 2.0 2023-06-13T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Mermaid Melody Pichi Pichi Pitch: Aqua 2 Pink Hanamori/Kodansha Ltd.   2023-07-04T07:00:00.000Z   0 0
PRD_2FFXGWC6QC5G CNT_08HNWJHDJYNG Mermaid Melody Pichi Pichi Pitch: Aqua CNT_3A7M4JEWB4V0 CNT_3A7M4JEWB4V0 2 1 1 Volume 4 []   Mermaid Melody Pichi Pichi Pitch: Aqua 4   Lukia is shocked when Kurosuna-kun boldly declares that Lukia is his girlfriend-straight to her fiancé Nam's face! The bemused merman prince isn't one to back away from a challenge, and the boys are soon going head to head in a swimming race for her affections. But when Laurent's minions strike mid-race, the group find themselves quickly getting overwhelmed. Seeing Lukia in trouble, something latent stirs inside Kurosuna-kun...something that might be more than he, or Lukia, can handle...   01KGBE0ESYC5WC85RDJXY94VXW 4.0 2024-10-08T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Mermaid Melody Pichi Pichi Pitch: Aqua 4 Pink Hanamori/Kodansha Ltd.   2024-10-29T07:00:00.000Z   0 0
PRD_3RGV8BBKS4W0 CNT_20176FAEV3ZG Mermaid Melody Pichi Pichi Pitch: Aqua CNT_3A7M4JEWB4V0 CNT_3A7M4JEWB4V0 2 1 1 Volume 1 []   Mermaid Melody Pichi Pichi Pitch: Aqua 1   Lukia Nanami is turning seventeen. Her family has just moved to a town by the sea, and on her first walk down to the beach, she saves a handsome surfer from drowning. The next day, she's shocked to discover he's not only a classmate at her new school, but has no idea who she is, and insists he was saved by a mermaid! A new chapter in the saga of Mermaid Melody Pichi Pichi Pitch, from original artist Pink Hanamori!   01KGB6T3EXERVSTWT5538CYFRV 1.0 2023-05-16T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Mermaid Melody Pichi Pichi Pitch: Aqua 1 Pink Hanamori/Kodansha Ltd.   2023-06-06T07: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);