products

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

3 rows where series_id = "CNT_01PJGZSECSN0"

✎ 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_092ZPNAGHT1G CNT_1ZSPX0MXBEQG Goodbye, My Rose Garden CNT_01PJGZSECSN0 CNT_01PJGZSECSN0 2 1 1 Volume 3 []   Goodbye, My Rose Garden Vol. 3   Alice has finally revealed her secret to Hanako: she is Victor Franks! Yet secrets that must be kept still abound, and family, status, and love bind Alice like thorns. Will she and Hanako ever be free? The beautiful and stirring finale of Goodbye, My Rose Garden! THE LAST GOODBYE 01KG9DEYHZMY9PBGABZD7G87A5 3.0 2020-11-13T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Goodbye, My Rose Garden Vol. 3 Dr. Pepperco 2020   2020-12-15T08:00:00.000Z   0 0
PRD_09CCNGKAYMK0 CNT_2XSDHSN9A59G Goodbye, My Rose Garden CNT_01PJGZSECSN0 CNT_01PJGZSECSN0 2 1 1 Volume 1 []   Goodbye, My Rose Garden Vol. 1   Early in the twentieth century, Hanako journeys to England to follow her dream of becoming a novelist. When things don't work out quite as she planned, she finds employment as a personal maid to noblewoman Alice Douglas, who makes a most unusual request: she begs Hanako to kill her! As Hanako tries to figure out why her mistress would make such a shocking plea, their relationship grows into something far deeper. Love Among the Thorns 01KG9BSKTB4GTWMZ3CZ3YBXF54 1.0 2020-03-23T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Goodbye, My Rose Garden Vol. 1 Dr. Pepperco 2019   2020-04-14T07:00:00.000Z   0 0
PRD_1SH2PETC646G CNT_1AV9BAV1ZSD0 Goodbye, My Rose Garden CNT_01PJGZSECSN0 CNT_01PJGZSECSN0 2 1 1 Volume 2 []   Goodbye, My Rose Garden Vol. 2   Lady Alice shares the story of her love for her former governess Eliza, as well as its tragic end. In the wake of that story, Hanako finds herself harboring two secrets--including the fact that the feelings in her heart are growing all the more intense. A LOVE THAT DARE NOT SPEAK ITS NAME 01KGA98Y9R57FASXKGHCBEKC94 2.0 2020-05-28T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Goodbye, My Rose Garden Vol. 2 Dr. Pepperco 2019   2020-07-21T07: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);