products

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

10 rows where series_id = "CNT_1XSGA99PZZ40"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, listed_at, 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_07VNXF2T7710 CNT_197HC41M0GW0 Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 5 []   Big Order, Vol. 5   The latest installment of author Sakae Esuno's action packed BIG ORDER!   01KG9VMTHKTPRM2V52DQCWZKZS 5.0 2017-09-18T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 5     2017-09-18T15:00:00.000Z   0 0
PRD_0D87K5N3G3E0 CNT_208RNVA9SZ90 Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 8 []   Big Order, Vol. 8   The latest installment of author Sakae Esuno's action packed BIG ORDER!   01KGA2TMFN30G2F9ZM9W63YD4W 8.0 2018-02-06T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 8     2018-02-06T08:00:00.000Z   0 0
PRD_0Q01BKCJ7W40 CNT_1PVKE2Y2G1E0 Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 10 []   Big Order, Vol. 10   It's the climactic final volume of Big Order! What future awaits Eiji and his allies...?   01KGA4QZDY2EZ1MXG6P028Y9H6 10.0 2018-06-26T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 10     2018-06-26T07:00:00.000Z   0 0
PRD_0TJY67CWV0N0 CNT_1RMAKYFRK980 Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 3 []   Big Order, Vol. 3   Sena's awake! Upon hearing the news, Eiji rushes back to Dazaifu, only to hear Hiiragi reveal to Sena that she's got six months left to live! Eiji is livid, but Hiiragi has one more bombshell to drop--they've located someone who can cure Sena! Now it's off to Hiroshima to find this mysterious Order! Could this be the chance Eiji's been waiting for, or is Hiiragi hiding something else?   01KG9Z3AYWF19KBF22S8RF4QVN 3.0 2017-05-22T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 3     2017-05-22T15:00:00.000Z   0 0
PRD_125NYM5K7ZXG CNT_2AKRDT1X626G Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 1 []   Big Order, Vol. 1   When Eiji Hoshimiya was asked his heart's desire, the young boy could never have predicted the catastrophic consequences. Ten years after the "Great Destruction," the world has been reshaped with gifted individuals called "Orders" emerging, people capable to reshaping reality to their whims.When some of these Orders start hunting Eiji, though will he have to summon the power that nearly destroyed the world?   01KG98K6W8Y5TC4H3V1DMHQ21T 1.0 2017-01-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 1     2017-01-30T15:00:00.000Z   0 0
PRD_21JD46KMRRHG CNT_09JTW36FT1CG Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 6 []   Big Order, Vol. 6   The latest installment of author Sakae Esuno's action packed BIG ORDER!   01KG9VMVK4BMFHJ74PF0WK9TW3 6.0 2017-09-18T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 6     2017-09-18T15:00:00.000Z   0 0
PRD_2PRYH92CSXMG CNT_0Q6WYR4YBHYG Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 9 []   Big Order, Vol. 9   Big Order is revving up to its climactic conclusion! What future awaits Eiji and his allies...?   01KGA3GVTPAFEMM047X5BN7MDZ 9.0 2018-06-26T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 9     2018-06-26T07:00:00.000Z   0 0
PRD_2RT6RHZ1SF4G CNT_2R9137AWSRSG Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 4 []   Big Order, Vol. 4   In the hopes of curing Sena, Eiji and Iyo are off to see Kamimusubi, an Order who can cure any disease! However, upon meeting this Order, Eiji is told that he'll have to prove the strength of his bond with Iyo if he wants to make a request. Will Eiji be able to cooperate with his new partner, or will his distrust of the Ten Hands ultimately deny him the cure he's been striving to obtain?   01KG9Z3AD6RSN2Z3FGVRJ7RD1X 4.0 2017-05-22T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 4     2017-05-22T15:00:00.000Z   0 0
PRD_3KHE4E40Y3XG CNT_33XZ5W5DYETG Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 7 []   Big Order, Vol. 7   The latest installment of author Sakae Esuno's action packed BIG ORDER!   01KGA1CD23MF8TCBJPCC3KC019 7.0 2018-02-06T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 7     2018-02-06T08:00:00.000Z   0 0
PRD_3XWD4BVDSZE0 CNT_1AY1XH6S1JN0 Big Order CNT_1XSGA99PZZ40 CNT_1XSGA99PZZ40 2 1 1 Volume 2 []   Big Order, Vol. 2   The invasion of Yamaguchi has begun! After arriving, Eiji and Rin soon discover that the United Nations has approved a measure to nuke Yamaguchi to get rid of Eiji once and for all! Later, they find themselves up against another Order--Heavy Rockstar and her Rock God! With Rin trying to kill him at every opportunity and a nuclear missile on the way, how will Eiji survive?   01KG9YTTKY7ZYFW3ECTC550Q4X 2.0 2017-01-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PTQTSR31PRG Big Order, Vol. 2     2017-01-30T15: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);