products

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

7 rows where series_id = "CNT_0SKCC0GHD3A0"

✎ 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_02MQCNW3H85G CNT_0P1B5NK30M80 Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 3 []   Ran and the Gray World, Vol. 3   Taneatsu's shogun Iesada has died, but unlike previous bereaved consorts, he has been denied the refuge of taking Buddhist vows. Stuck in the Inner Chambers, he has instead thrown himself into supporting the new shogun, Iemochi. But salacious rumors about the nature of their relationship and the arrival of Iemochi's new consort threaten to make a mockery of his noble intentions!   01KGA6YGVSDCTVPE7BDWG0K5CS 3.0 2019-05-09T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 3 © Aki Irie 2011 / KADOKAWA CORPORATION   2019-05-21T07:00:00.000Z   0 0
PRD_04AGYJ50NX2G CNT_0AWK6ND8G930 Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 4 []   Ran and the Gray World, Vol. 4   Knowing that Makoto Hibi has witnessed her magical transformation, Ran is now desperate to erase his memory. But if she gets her way, she might lose a friend in the process. Later, a powerful sorceress in training named Nio Gekkoin shows up and challenges Ran to a duel! Which novice will emerge the victor in this supernatural showdown?   01KGA7H0E1M0RRW9Y5D967377S 4.0 2019-09-09T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 4 © Aki Irie 2012 / KADOKAWA CORPORATION   2019-09-17T07:00:00.000Z   0 0
PRD_04TYH2WXRNX0 CNT_1RAVXMJBM11G Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 2 []   Ran and the Gray World, Vol. 2   With Ran's powers growing stronger day by day, Grand Sorceress Shizuka decides that it's time for Ran to begin her magical training and sends a master instructor to the human world to look after her. Meanwhile, a deadly insect has escaped from the confines of the Door and must be destroyed before havoc ensues!   01KGA6PSGG00WPM8JCNR3ZSM45 2.0 2019-04-05T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 2 ©2010 Aki Irie / KADOKAWA CORPORATION   2019-04-09T07:00:00.000Z   0 0
PRD_11ECQQCWJB60 CNT_04RKRY6T4V5G Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 5 []   Ran and the Gray World, Vol. 5   With the Door destroyed, bugs are an even greater danger than before. The sorceresses build a glass fortress, but it's only a matter of time before the bugs break through. Meanwhile, Ran tries to protect Otaro from being hunted down, but will she end up jeopardizing the battle against the bugs?   01KGB6JMVG9DBMFFHK0PC0S3T3 5.0 2023-05-19T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 5 © Aki Irie 2013 / KADOKAWA CORPORATION   2023-05-20T07:00:00.000Z   0 0
PRD_1F3YZG5K68B0 CNT_26RAV57KDR0G Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 7 []   Ran and the Gray World, Vol. 7   After Ran finally awakens from her long slumber, she discovers the terrible news about Otaro, and her sorrow sends the whole town of Haimachi into tears. As she works toward accepting the tragedy, she ponders how she can become a stronger sorceress, even if it means leaving her home and the people she loves...   01KGB7VTYST2QS6CQZV72EXJSX 7.0 2023-05-19T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 7 © Aki Irie 2014 / KADOKAWA CORPORATION   2023-05-20T07:00:00.000Z   0 0
PRD_2521ABF36MCG CNT_2VZJDXDFTGH0 Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 1 []   Ran and the Gray World, Vol. 1   Even though Ran looks like an adult during her transformation, she doesn't really know what perils the outside world holds. When she meets rich playboy Otaro Mikado, does she gain a friend or foe?   01KGA5WBYD86G08S7CVFQPGR1B 1.0 2019-04-05T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 1 ©2009 Aki Irie / KADOKAWA CORPORATION   2019-04-09T07:00:00.000Z   0 0
PRD_2KG9937N2QA0 CNT_0627TGXVRQ1G Ran and the Gray World CNT_0SKCC0GHD3A0 CNT_0SKCC0GHD3A0 2 1 1 Volume 6 []   Ran and the Gray World, Vol. 6   The sorceresses, Black Crows and White Dogs celebrate the end of their battle against the bugs, but Jin makes a horrible discovery—Ran has managed to save Otaro, thereby guaranteeing the bugs' survival! As everyone races to destroy the bugs once and for all, what other lives will this war claim?   01KGB7VSR8DG0ZEJK2QKJZM1E3 6.0 2023-05-19T07:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Ran and the Gray World, Vol. 6 © Aki Irie 2014 / KADOKAWA CORPORATION   2023-05-20T07: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);