products

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

7 rows where series_id = "CNT_37PF4X1M717G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_16J3BREMBGBG CNT_2M7J8S5WE41G CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 5 []   CLAMP Premium Collection Tokyo Babylon, Vol. 5   Tokyo—a dazzling yet melancholic city, full of meetings and partings. There resides Subaru Sumeragi, the thirteenth head of his clan and a powerful onmyouji. When Subaru meets an old man who shares his affinity for animals, he’s delighted to bond with a kindred spirit. But behind his elderly friend’s warm smile lies a troubled household and an unfulfilled promise…To someone treated as a “burden” by his family, what might be the price of a dream?   01KGBAZ93KESYKC3E0AVGJBXP8 5.0 2024-06-18T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 CLAMP Premium Collection Tokyo Babylon, Vol. 5     2024-11-26T08:00:00.000Z   0 0
PRD_1B0CJHAJN2B0 CNT_1XTGWV91TMQ0 CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 6 []   CLAMP Premium Collection Tokyo Babylon, Vol. 6   Subaru Sumeragi is a powerful onmyouji who solves the supernatural troubles that plague the citizens of Tokyo—both living and deceased! Thanks to the extreme actions of a grieving mother, Seishirou has suffered a grave injury. How will Subaru face him? And what will become of the mother’s son after her crimes are broadcasted for the world to see?   01KGBCHT5ZDZ2EYNNS9CW5SKZN 6.0 2024-08-29T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 CLAMP Premium Collection Tokyo Babylon, Vol. 6     2025-02-18T08:00:00.000Z   0 0
PRD_1EPJMYRD9NX0 CNT_2AX4VCGK2N90 CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 3 []   CLAMP Premium Collection Tokyo Babylon, Vol. 3   Subaru Sumeragi is an onmyouji and the current head of the Sumeragi clan. When Subaru joins a phone call between three mysterious girls, he is startled when they declare him to be an enemy and use a mantra against him! Will he be able to get down to the bottom of things?   01KG9PG639Q7GAHTNDBX7HHXRZ 3.0 2023-12-21T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG CLAMP Premium Collection Tokyo Babylon, Vol. 3     2024-05-21T00:00:00.000Z   0 0
PRD_1M88XDJWZDAG CNT_0GYKSN8QD81G CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 2 []   CLAMP Premium Collection Tokyo Babylon, Vol. 2   Tokyo—a lively yet congested city, full of laughter and merriment. There resides Subaru Sumeragi, the thirteenth head of his clan and a powerful onmyouji. When Subaru is called to awaken a girl trapped in a four-month-long slumber, he’s startled to see his childhood friend Mitsuki, who’s barricaded her consciousness within her own memories. All he needs to do is coax her out…but that’s easier said than done when the target claims to hate him!   01KH3G5QA6BYCS6YJTQ7NY0KB0 2.0 2023-08-21T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG CLAMP Premium Collection Tokyo Babylon, Vol. 2     2024-01-23T00:00:00.000Z   0 0
PRD_1VMTSMY6Y8W0 CNT_2DA43T4JK7RG CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 4 []   CLAMP Premium Collection Tokyo Babylon, Vol. 4   Tokyo—an enthralling yet tragic city, full of wishes and faith. There resides Subaru Sumeragi, the thirteenth head of his clan and a powerful onmyouji. When Subaru visits a shrine to finish an art assignment, he runs into a woman pursuing revenge for a crime gone unpunished. He’s determined to use his powers to help her—but when the answer he finds isn’t the one he seeks, Subaru must choose between justice or salvation for a lost soul…   01KGAZMVH5NHECYBJ5T64GJPHX 4.0 2024-02-27T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 CLAMP Premium Collection Tokyo Babylon, Vol. 4     2024-08-27T07:00:00.000Z   0 0
PRD_29WF0MXGDTBG CNT_32KSFBH9Q2QG CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 7 []   CLAMP Premium Collection Tokyo Babylon, Vol. 7   Tokyo—a loving yet distant city, full of promises and betrayal. There resides Subaru Sumeragi, the thirteenth head of his clan and a powerful onmyouji. At long last, the time has come for Subaru to settle his “bet” with Seishirou. What was forgotten all those years ago beneath the cherry blossom tree? And when the man known as Seishirou Sakurazuka shows his true colors, will Subaru and Hokuto manage to escape the twisted clutches of fate…?   01KG9RJ91R7QSAGMSR3A88CZ7G 7.0 2024-11-20T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 CLAMP Premium Collection Tokyo Babylon, Vol. 7     2025-05-27T07:00:00.000Z   0 0
PRD_3RXC8EA1FCA0 CNT_1QXZM5X47Z20 CLAMP Premium Collection Tokyo Babylon CNT_37PF4X1M717G CNT_37PF4X1M717G 2 1 1 Volume 1 []   CLAMP Premium Collection Tokyo Babylon, Vol. 1   Tokyo—a beautiful yet cold city, full of life and twinkling lights. There resides Subaru Sumeragi, the thirteenth head of his clan and a powerful onmyouji. Aided by his glamorous twin sister, Hokuto, and the veterinarian who claims to love him, Seishirou Sakurazuka, he solves the supernatural troubles that plague the citizens of Tokyo—both living and deceased!   01KGB6SAHGJE7CS7QXJ411HPP2 1.0 2023-05-08T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG CLAMP Premium Collection Tokyo Babylon, Vol. 1     2023-10-17T00: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);