products

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

3 rows where series_id = "CNT_2PP9JAD3J9MG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_02877YTPBZC0 CNT_3PXJA5XM44P0 Hollow Fields (color) CNT_2PP9JAD3J9MG CNT_2PP9JAD3J9MG 2 1 1 Volume 3 []   Hollow Fields (color) Vol. 3   As Miss Weaver finally reveals the true purpose of her gruesome “personal experiment,” Lucy and Claude find themselves trapped in the windmill, facing a fate worse than death! Even with the help of unexpected allies, can they turn the tide against the Engineers, or will the students of Hollow Fields be sacrificed in the name of forbidden science? It's up to Lucy to muster every ounce of courage in order to confront Miss Weaver one last time--and save the children of Hollow Fields! FINAL EXAM 01KG9AZQBAPNV7ERR5R191FKG6 3.0 2018-12-18T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Hollow Fields (color) Vol. 3 2008, 2018 Madeleine Rosca   2019-01-29T08:00:00.000Z   0 0
PRD_1G72Q20B5CJ0 CNT_178JNHKVDGG0 Hollow Fields (color) CNT_2PP9JAD3J9MG CNT_2PP9JAD3J9MG 2 1 1 Volume 2 []   Hollow Fields (color) Vol. 2   As the dark secrets of Miss Weaver's past become clear, it's up to Lucy to rally her fellow students into action against the Engineers' evil machinations. But how can she possibly turn the most influential girl in school, Summer, into an ally when she is actually Lucy's greatest enemy? And who is the mysterious apparition from the windmill that comes to Lucy with an ominous warning? TEACHER'S THREAT 01KGA3J8NC06EQB18397ZNPJCK 2.0 2018-07-31T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Hollow Fields (color) Vol. 2 2008, 2018 Madeleine Rosca   2018-08-11T07:00:00.000Z   0 0
PRD_1R1E5VD8W3HG CNT_0XHRGGGEQWCG Hollow Fields (color) CNT_2PP9JAD3J9MG CNT_2PP9JAD3J9MG 2 1 1 Volume 1 []   Hollow Fields (color) Vol. 1   Little Lucy Snow was supposed to attend a prestigious boarding school; however, a macabre twist of fate finds her enrolled instead at Miss Weaver's Academy for the Scientifically Gifted and Ethically Unfettered, also known as Hollow Fields. Located on the outskirts of Nullsville and run by the insidious Engineers, the grim boarding school dedicates itself to raising the next generation of mad scientists and evil geniuses! Classes include Live Taxidermy, Cross-Species Body Part Transplantation, and Killer Robot Construction. For her own survival, Lucy must master her lessons quickly. At the end of each week, the student with the lowest grades is sent out to the old windmill for detention...and so far, no child has ever returned.   01KG9VV1SM7DSP932QJ1EJ9ECW 1.0 2017-10-30T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Hollow Fields (color) Vol. 1 (C) 2007, 2017 Madeleine Rosca   2017-11-28T08: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);