products

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

6 rows where series_id = "CNT_16XRMK8YE63G"

✎ 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_07J5BXZS8F7G CNT_2YXA6E3CVT30 X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 1 []   X, Vol. 1   Kamui Shiro is a young man followed by mystery. Taken from Tokyo by his mother when only a child, Kamui left behind his dearest friends - the gentle Kotori and her brother Fuma - in the aftermath of a terrible incident that claimed their mother's life. Returning to Tokyo after his mother's death, Kamui is a changed young man - moody and distant to his old friends, yet determined to protect them from the dark forces that swirl around him. For he is the nexus of a great cataclysm to come, and inheritor to a strange destiny that could decide the fate of the entire world.   01K5G77HF47X5FC73ZDKQZR955 1.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 1 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (1992-1993)   2015-01-20T15:00:00.000Z   0 0
PRD_0A0NPGS3ME6G CNT_0Y771SSN6SC0 X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 3 []   X, Vol. 3   As the gears of fate turn, Kamui draws ever closer to the moment when he must make his inevitable choice: become either humanity's savior or its scourge. After his last surviving blood relative sacrifices herself to bring forth the Sacred Sword, the weapon he will need in the war to come, that moment finally arrives. With Kamui's decision, however, come unimaginable consequences for Fuma and Kotori. Meanwhile, the members of both sides of the conflict - the Dragons of Heaven and the Dragons of Earth - converge on Tokyo, obeying the call of their intertwined destinies. Among them is Subaru Sumeragi, a powerful magic user, who arrives just in time to help Kamui see the path that he must take. But Subaru must conquer his own doubts and fears when he's finally reunited with the one person who is truly special to him - and whom he must fight to the death.   01KKTXY6HKK2KC76H06SQG6AT5 3.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 3 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (1995-1997)   2015-01-20T15:00:00.000Z   0 0
PRD_0EH403V5GD5G CNT_2HHM1BFXNRD0 X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 4 []   X, Vol. 4   Kamui and Fuma have made their decisions and chosen their sides, but at an appalling cost. A traumatized Kamui needs the kind of healing that only a powerful psychic can provide. He goes to visit the seer Hinoto, and although her visions bring him clarity, they also unearth painful memories from deep within his past. Fortunately, there's time for reflection as both sides of the conflict regroup: Kamui and other Dragons of Heaven attend school at CLAMP Academy, while Fuma finds his place among the Dragons of Earth.   01KKTXY6SKE43BTKM5S0F4AD6Y 4.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 4 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (1997-1999)   2015-01-20T15:00:00.000Z   0 0
PRD_22M270JJE1H0 CNT_3ZX6PVJ06BJG X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 5 []   X, Vol. 5   Duality is a fact of Kamui's prophecy - driven life, but he's not the only one - as the battle between the Dragons of Heaven and the Dragons of Earth heats up, the warriors begin to realize who their opposite numbers are. The members on both sides of the conflict all have their reasons for wanting to save the world or destroy it, and the greatest of those is love. For the sake of loved ones long lost, and of those still living, decisions are made that will move heaven and earth.   01KKTXYA6FYX6TV5BPSHKS1Q62 5.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 5 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (1999,2000)   2015-01-20T15:00:00.000Z   0 0
PRD_2CYCSCAAYDN0 CNT_3H7AHC91T7YG X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 6 []   X, Vol. 6   Subaru and Seishiro face off in a desperate battle on the Rainbow Bridge, as the years of twisted love and bitterness between them lead at last to their inevitable, heart-rending culmination. In the tragic aftermath, with their kekkai failing and their Dreamseer's predictions foiled, the Seven Seals split up and roam Tokyo in an attempt to halt the destruction engulfing the city. But time is running out. The time of the final battle between the Dragons of Heaven and the Dragons of Earth is drawing near...   01KKTXXWBB2ERK2N5WJX2VEQ1W 6.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 6 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (2000,2001)   2015-01-20T15:00:00.000Z   0 0
PRD_2VH3ATQ663K0 CNT_3X8WQY7FCDGG X (3-in-1) CNT_16XRMK8YE63G CNT_16XRMK8YE63G 2 1 1 Volume 2 []   X, Vol. 2   Hinoto, Japan's greatest seer, has foretold the end of the world. At the center of her prophecy is a young man named Kamui Shiro, who possesses startling psychic powers. But Kamui is far from alone in this destiny. Armies are gathering, other people with unique powers: the ""Seven Seals"", who seem to be Kamui's allies, and the ""Seven Angels"", who might be his enemies. All are somehow linked to the destruction to come, and all are now coming to Tokyo to choose sides in the upcoming battle.   01KKTXYNYV66Y69GDB51NFF3JE 2.0 2015-01-20T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 X, Vol. 2 (C)CLAMP／KADOKAWA　(C)CLAMP・ShigatsuTsuitachi CO.,LTD. (1993-1994)   2015-01-20T15: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);