products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_0MPJK3CADC9G"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_040HC80EK230 | CNT_02NH5KNA4Q70 | A Polar Bear in Love CNT_0MPJK3CADC9G | CNT_0MPJK3CADC9G | 2 | 1 | 1 | Volume 4 | [] | A Polar Bear in Love, Vol. 4 | Seal has finally learned how to swim, but Polar Bear isn't ready to say good-bye to his love just yet--not until Orca shares with the novice a heart-wrenching love story of his own...You won't be able to take your eyes off Volume 4!! | 01KG9AV686YFZK30MRCRRC5XYH | 4.0 | 2018-12-11T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | A Polar Bear in Love, Vol. 4 | 2018-12-11T08:00:00.000Z | 0 | 0 | ||||||
| PRD_0ZF78MQ6SRVG | CNT_00X80JVJNCZG | A Polar Bear in Love CNT_0MPJK3CADC9G | CNT_0MPJK3CADC9G | 2 | 1 | 1 | Volume 3 | [] | A Polar Bear in Love, Vol. 3 | Cathy the penguin makes a debut, and is giving our duo a pep talk on love. But what'll happen when an orca-apex predator of the Arctic-bears down on them?! Love comes in all shapes and sizes in Volume 3! | 01KGA3HNDRY5CPSAJX5TZJJSWX | 3.0 | 2018-07-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | A Polar Bear in Love, Vol. 3 | 2018-07-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3F6WH1TF5VHG | CNT_02CH172MZPPG | A Polar Bear in Love CNT_0MPJK3CADC9G | CNT_0MPJK3CADC9G | 2 | 1 | 1 | Volume 2 | [] | A Polar Bear in Love, Vol. 2 | IS LOVE MORE THAN FUR DEEP?! Polar Bear and Seal are headed toward their first date! But will their bond last after Seal falls head over fins for an older lady...? | 01KGA1DZWZ4ZB20M8E1J9D21A8 | 2.0 | 2018-02-27T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | A Polar Bear in Love, Vol. 2 | 2018-02-27T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3VNN4HTRBNWG | CNT_2EBH9CKEYEHG | A Polar Bear in Love CNT_0MPJK3CADC9G | CNT_0MPJK3CADC9G | 2 | 1 | 1 | Volume 1 | [] | A Polar Bear in Love, Vol. 1 | A polar bear falls in love with a seal, but the seal thinks the polar bear is trying to eat it! | 01KG9VW304KAV5EHX3C87SP828 | 1.0 | 2017-11-21T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | A Polar Bear in Love, Vol. 1 | 2017-11-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3XYGR427QC80 | CNT_0V2SH3J688C0 | A Polar Bear in Love CNT_0MPJK3CADC9G | CNT_0MPJK3CADC9G | 2 | 1 | 1 | Volume 5 | [] | A Polar Bear in Love, Vol. 5 | Orca warns Polar Bear about his cross-species romance, but Polar Bear isn’t going to give up on his love for Seal so easily… Meanwhile, Cathy finds an encounter of their own! The long-awaited Volume 5 is finally here!  | 01KGB2QCFX7H8VSEHHQVDT716H | 5.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1G5EK0KH20W0 | A Polar Bear in Love, Vol. 5 | 2023-01-17T00:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);