products

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

3 rows where series_id = "CNT_3558V347X12G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_1VSY4ZGTZNX0 CNT_20DR9VY6JR60 Little Witch's Collier CNT_3558V347X12G CNT_3558V347X12G 2 1 1 Volume 3 []   Little Witch's Collier, Vol. 3   "I've had so many firsts with you." New visitors to the castle bring new surprises for little Lulu! But the bratty witch Oliver's protective streak might spell the end for her budding friendship with Cheryl. When the two girls escape for a little time on their own, they stumble onto a dangerous situation that only magic can solve! Will Lulu be permitted to leave the castle at last? Find out in the final volume of Little Witch's Collier!   01KG987RDF539TBSAN0RC30BGF 3.0 2016-09-01T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Witch's Collier, Vol. 3     2016-09-01T15:00:00.000Z   0 0
PRD_2GQA99J8AH3G CNT_269EEC30MC70 Little Witch's Collier CNT_3558V347X12G CNT_3558V347X12G 2 1 1 Volume 2 []   Little Witch's Collier, Vol. 2   "I've had so many firsts with you." In a castle atop a hill, in the south of France, lives a little witch named Lulu. When she meets her absentminded teacher Camillo, her closed-off world begins to change for the brighter and better. With these changes come new feelings blossoming inside Lulu...and new beginnings for all of the castle tenants! The story of a prickly witch, an airheaded young man, and the strange and lovely distance between them continues in Volume 2 of Little Witch's Collier.   01K5GB1SS73T9X71BR9GHDWWWJ 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Witch's Collier, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_3XQPK0E8GP90 CNT_35ZPW0WJC1AG Little Witch's Collier CNT_3558V347X12G CNT_3558V347X12G 2 1 1 Volume 1 []   Little Witch's Collier, Vol. 1   In a castle atop a hill, in the south of France, lives a little witch named Lulu. Hidden away from the rest of the world and forced to wear a collier around her neck to control her powers, all Lulu wants to do is escape into the real world--and will stoop to anything in her mischievous attempts to leave! But her life slowly begins to change when her new teacher, a man named Camillo, arrives...   01K5G9W5V4TCKC0M2SCXGHYD9K 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Little Witch's Collier, Vol. 1     2016-06-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);