products

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

7 rows where series_id = "CNT_1B2ECS075QHG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, copyright, on_sale_at, 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_009T85GBCWQG CNT_02FRHJ1Z66K0 Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 1 []   Grenadier, Vol. 1   Rushuna is a golden-haired Senshi--a gunslinger who travels the land with one purpose: to make the world a peaceful place. However, her journey of nonviolence is never easy, and when she joins forces with an ambitious samurai, you better look out! Rushuna just might be forced to display her amazing gun skills-and she's got?two?big ones!   01K5G79T3JB55CZMA95N9VZ74A 1.0 2015-04-27T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 1 (C) Sousuke KAISE 2003   2015-04-27T15:00:00.000Z   0 0
PRD_01EK0YFNDXY0 CNT_3JTHS8D7CR5G Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 7 []   Grenadier, Vol. 7   The Juttensen and loyalist factions prepared well for the final battle, but they weren't ready for the onslaught the rebels had prepared for them. Traitorous nobles welcome them into the Imperial Capital where the Iron-Masked Baron reveals a weapon capable of harnessing raw energy for the ultimate destructive power. Can the hot gunslinger gang possibly stand against a power great and terrible enough to destroy an entire land?   01K5GAM9FW8RHVNVSDAFTKA5GF 7.0 2015-10-04T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 7 (C) Sousuke KAISE 2005   2015-10-04T15:00:00.000Z   0 0
PRD_0FCP8T7S4290 CNT_36WBRBQERDAG Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 4 []   Grenadier, Vol. 4   Rushuna and company's long and treacherous climb up Mount Nabanba is over, but they can't even catch a minute to relax. Mikan's snack break is interrupted by a strange mechanism that captures her and threatens to cut her in two! When Rushuna and Yajiro follow the sound of Mikan's screams, salvation is near--until they discover and even deadlier adversary who doesn't understand the meaning of fear...   01K5GAFX9KJW589T97JWTT5WRC 4.0 2015-07-30T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 4 (C) Sousuke KAISE 2004   2015-07-30T15:00:00.000Z   0 0
PRD_0GP63ZTTHJV0 CNT_1Y6GZ41XDWRG Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 6 []   Grenadier, Vol. 6   When Yajiro's blade and an embarrassing picture of Rushuna are stolen, the two set off after the culprit--who turns out to be none other than Rushuna's old master! And after they're surrounded by thermal-targeting death machines commanded by the Iron-Masked Baron himself, Rushuna's "double" also shows up--itching for revenge!   01K5GAMXQ07T8DEBAVVF49738T 6.0 2015-10-04T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 6 (C) Sousuke KAISE 2005   2015-10-04T15:00:00.000Z   0 0
PRD_32K4E4K44V10 CNT_3PNMDJ1RGP2G Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 3 []   Grenadier, Vol. 3   After battling it out with Banmaru Zoushi's mechanical puppet--the Kibanten--Rushuna and Yajiro bid farewell to the denziens of the Peach Blossom...but not before they gain a new member. The trio is advised to travel to the capital in order to find Rushuna's mentor, who holds possible answers about her past. But word spreads of Banmaru's defeat, and an unhappy court sends out a Juttensen to kill Rushuna before her victory brings hope to anti-Imperialist factions...   01K5GAFB9BW344DDHREXHHBCST 3.0 2015-06-29T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 3 (C) Sousuke KAISE 2004   2015-06-29T15:00:00.000Z   0 0
PRD_32YW66AE4N9G CNT_0D76AB7B5G90 Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 2 []   Grenadier, Vol. 2   After saving two young women, Rushuna and Yajiro are invited to stay at the Peach Blossom - a pleasure palace run by a sassy hostess named Touka Kurenai. But when Rushuna's gun is stolen, our busty gun-toting hero is lead on a wild chase that ends in a hot mano-a-mano with an even more fiery Touka. Has Rushuna met her match? Or will the heat of battle lead to something more...?   01K5GAD4PF0M54J3P88AM32Y11 2.0 2015-05-26T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 2 (C)Sousuke KAISE 2003   2015-05-26T15:00:00.000Z   0 0
PRD_39X86WS3ZW30 CNT_31M9WWYTQQ0G Grenadier CNT_1B2ECS075QHG CNT_1B2ECS075QHG 2 1 1 Volume 5 []   Grenadier, Vol. 5   The golden-haired gunslinger Rushuna continues her journey through a land not her own in order to discover the truth about the past she can't remember, accompanied by the samurai Yajiro and the young balloon master Mikan. Their path has led them to the Imperial Captial - but the Juttensen, elite Imperial fighters pledged to protect the city, bar their way with deadly skill. The three aren't the only interlopers trying to get into the city - and one mercenary among the attacking rebel forces has good reason to hold a grudge against Yajiro!   01K5GAH6EK6G774B7ZBBYG6XGQ 5.0 2015-08-24T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Grenadier, Vol. 5 (C) Sousuke KAISE 2005   2015-08-24T15: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);