products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_0Q16A8JKCR90"
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_19BVZ1ERN0B0 | CNT_2R26K3KPB2R0 | Juni Taisen: Zodiac War CNT_0Q16A8JKCR90 | CNT_0Q16A8JKCR90 | 2 | 1 | 1 | Volume 3 | [] | Juni Taisen: Zodiac War, Vol. 3 | With half of the fighters down for the count, the Zodiac War rages on! Usagi—the fighter of the Rabbit—and his undead army continue to rampage across the battlefield, intent on destroying anyone who stands in their way. For an honorable fighter like Ox, Rabbit's desecration of and complete disregard for human life is unacceptable. To obliterate this heretical army, Ox teams up with an unlikely ally—the drunkard Tiger! | 01KGBG3B1BKECKZH4MA4KDJ491 | 3.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Juni Taisen: Zodiac War, Vol. 3 | JUUNI TAISEN © 2017 by NISIOISIN, Hikaru Nakamura, Akira Akatsuki/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1JZWJ9WFMR30 | CNT_25FEPG5K3AG0 | Juni Taisen: Zodiac War CNT_0Q16A8JKCR90 | CNT_0Q16A8JKCR90 | 2 | 1 | 1 | Volume 1 | [] | Juni Taisen: Zodiac War, Vol. 1 | Eleven of the twelve fighters have gathered, and everyone awaits the final contender—Boar. She is strong, confident and a favorite to win the twelfth Zodiac War. However, this time, the rules have changed! The battle is limited to an abandoned city and all of the contestants are forced to ingest a deadly poison. Monkey tries to call a truce, but before she can the floor explodes, scattering all the fighters. Despite the chaos, one thing's for sure—only one will remain standing. | 01KGBEX7VKTH0Y920YR5GF04HD | 1.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Juni Taisen: Zodiac War, Vol. 1 | JUUNI TAISEN © 2017 by NISIOISIN, Hikaru Nakamura, Akira Akatsuki/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2CPMSZDAPSKG | CNT_15T87FAETV0G | Juni Taisen: Zodiac War CNT_0Q16A8JKCR90 | CNT_0Q16A8JKCR90 | 2 | 1 | 1 | Volume 2 | [] | Juni Taisen: Zodiac War, Vol. 2 | With several of the fighters already dead, the Zodiac War is in full swing! The biggest danger the remaining fighters face is Usagi, the fighter of the Rabbit. He has the unique ability to control the dead bodies of those he's slain, putting his opponents at a huge disadvantage! While Usagi and his undead army rampage in the streets above, Chicken and Rat lay low underground with Monkey, who is determined to settle the battle with as few deaths as possible. | 01KGBG3Q3T12Y3WNGC7K1B7QGQ | 2.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Juni Taisen: Zodiac War, Vol. 2 | JUUNI TAISEN © 2017 by NISIOISIN, Hikaru Nakamura, Akira Akatsuki/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3B2K6RZVQ1VG | CNT_1RD03TRJ2K8G | Juni Taisen: Zodiac War CNT_0Q16A8JKCR90 | CNT_0Q16A8JKCR90 | 2 | 1 | 1 | Volume 4 | [] | Juni Taisen: Zodiac War, Vol. 4 | With most of Rabbit's zombie army out of the way, only one thing stands between Ox and Tiger and taking down Rabbit for good—Monkey. Her sheer strength and power, once disciplined in life, are completely unhinged in death, making her far and away the strongest fighter! With only four fighters and one zombie remaining, who will come out victorious? Don't miss the thrilling, unexpected conclusion to the twelfth Zodiac War! | 01KGBG3C4NFANY0TAA9DE1WQN1 | 4.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Juni Taisen: Zodiac War, Vol. 4 | JUUNI TAISEN © 2017 by NISIOISIN, Hikaru Nakamura, Akira Akatsuki/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 |
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);