products

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

4 rows where series_id = "CNT_2YARDCT6XKMG"

✎ 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_09REH82QADXG CNT_1F0V40CAXNDG Waqwaq CNT_2YARDCT6XKMG CNT_2YARDCT6XKMG 2 1 1 Volume 4 []   Waqwaq, Vol. 4   Shio's battles have brought him to the brink of death and back again. Now he must use every ounce of power he has left to save the Kami, his people and his world! But whose wish will ultimately come true? The conclusion to Wāqwāq begins now!The final fate of both man and machine is revealed!   01KGBHWCP9AKJKYQVM67KVB3ND 4.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Waqwaq, Vol. 4 Wāqwāq © 2004 by Ryu Fujisaki/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_0CESWWWSPCWG CNT_3EB87J2K8MEG Waqwaq CNT_2YARDCT6XKMG CNT_2YARDCT6XKMG 2 1 1 Volume 3 []   Waqwaq, Vol. 3   Shio and friends are on their way to the Spider's Thread to rescue the girl he now calls Kami, but before they can do that Shio must battle more powerful Guardians and learn the true history of Wāqwāq!   01KGBHWA9MM50E3P7Z5G9CW0T6 3.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Waqwaq, Vol. 3 Wāqwāq © 2004 by Ryu Fujisaki/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_1QDRS2R5YA2G CNT_30ZJ7FD42J8G Waqwaq CNT_2YARDCT6XKMG CNT_2YARDCT6XKMG 2 1 1 Volume 1 []   Waqwaq, Vol. 1   Shio is forced by the tragedy of the machine war to team up with a mysterious girl from another world whose blood is the color red, just like the prophecies proclaim. Is this girl the human race's last hope for survival in a world overrun by metal?   01KGBGP26P2YKMAN7ZYYN8QA70 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Waqwaq, Vol. 1 Wāqwāq © 2004 by Ryu Fujisaki/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3H4G0R90GBK0 CNT_21AVQ6KZW2Z0 Waqwaq CNT_2YARDCT6XKMG CNT_2YARDCT6XKMG 2 1 1 Volume 2 []   Waqwaq, Vol. 2   The girl who could be the Kami is kidnapped by a trio of mysterious sages. To save her, Shio must join forces with a former opponent and battle through a slew of ever-more-powerful renegade Guardians!   01KGBHW874J86R5ZVXSHR679RE 2.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Waqwaq, Vol. 2 Wāqwāq © 2004 by Ryu Fujisaki/SHUEISHA Inc.   2024-11-26T08: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);