products

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

4 rows where series_id = "CNT_1ZS4256VD40G"

✎ 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_01NX1WCX5B90 CNT_386RKY7J20BG ShutterBox CNT_1ZS4256VD40G CNT_1ZS4256VD40G 2 1 1 Volume 3 []   ShutterBox Volume 3   In order to face and capture the terrible Banshee lurking inside Lewis Carroll's urn, Thomas helps Megan enter yet another realm in the afterlife of Merridiah. What the two aren't prepared for is the release of an eternal entity once thought lost with Merridiah University's heart. Forever transformed by the encounter, Megan now seeks to discover the dark secret Dane has walled up inside his boutique in the deep, dark realm far below Merridiah.   01KG9D441BWVA7F3QXJFPSM5SQ 3.0 2020-08-25T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 ShutterBox Volume 3 ｺﾋﾟｰﾗｲﾄなし   2020-09-15T07:00:00.000Z   0 0
PRD_0GX0WXV29060 CNT_0QJ7HVT835EG ShutterBox CNT_1ZS4256VD40G CNT_1ZS4256VD40G 2 1 1 Volume 2 []   ShutterBox Volume 2   Megan awakens from a dream to find that she is back in Merridiah University, and now attending school in this afterlife as a full time exchange student. It is December 25th and she is told that she will remain a part of the Shutterbox Exchange Programme at Merridiah for a year. But what about her life on Earth? Megan is certain she has completely vanished from her home world and she knows her mother must be hysterical...   01KG9D4B0RBDTNP7KM8PBFWJ62 2.0 2020-08-25T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 ShutterBox Volume 2 ｺﾋﾟｰﾗｲﾄなし   2020-09-15T07:00:00.000Z   0 0
PRD_2HA8N6A7Q0NG CNT_1Q7Y1WNC9MY0 ShutterBox CNT_1ZS4256VD40G CNT_1ZS4256VD40G 2 1 1 Volume 1 []   ShutterBox Volume 1   When Megan Amano dreams, she travels to a place called Meridian University. Traditionally, spirits travel to the University to be educated before they are reborn into the world of the living. Megan, however, is still alive and attends college in Santa Monica, California by day and Meridian University at night. One night, Megan peers through the the shutter of her camera lens and discovers a mystery so deep that she begins to question her own existence and begins her search for answers.   01KG9CC4YQBKY19FA4EV8J3R2S 1.0 2020-08-25T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 ShutterBox Volume 1 ｺﾋﾟｰﾗｲﾄなし   2020-09-15T07:00:00.000Z   0 0
PRD_2WZTXZ3NVDTG CNT_096N0BP5EHS0 ShutterBox CNT_1ZS4256VD40G CNT_1ZS4256VD40G 2 1 1 Volume 4 []   ShutterBox Volume 4   Now that Megan has merged with the goddess, Laahli, the Muse to the Muse, Megan discovers that she can teleport to any place within Merridiah she desires, and she and Adrien have spent many months alone together exactly where she wants, thousands of miles away from Merridiah University in an abandoned castle keep that was once the home of giants. Yet the many creatures of Merridiah are terrified at the idea of Megan's divine union with Laahli, and thus after a meeting of Merridiah's leaders, Damien hatches a plan to imprison Megan within University grounds...   01KG9D45JNJ3WBE859KCP9V0EA 4.0 2020-08-25T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 ShutterBox Volume 4 ｺﾋﾟｰﾗｲﾄなし   2020-09-15T07: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);