products

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

4 rows where series_id = "CNT_0CE1VXWVHGVG"

✎ View and edit SQL

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_0278WJZ2HJ6G CNT_22EQ0JAV3Z8G Monster and the Beast CNT_0CE1VXWVHGVG CNT_0CE1VXWVHGVG 2 1 1 Volume 4 []   Monster and the Beast, Vol. 4   It all began with a chance encounter in a forest, when the hideous beast Cavo stumbled upon the dapper older gentleman Liam. Although they became close companions through their many travels, Liam’s background has remained a complete mystery to Cavo—until now. When Liam’s murky past comes to light, can Cavo cleanse the darkness from his dearly beloved’s heart…?   01KGB4G20YGRAH57P1D5THYZCC 4.0 2023-02-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Monster and the Beast, Vol. 4     2023-06-20T00:00:00.000Z   0 0
PRD_36EX9D1MJWM0 CNT_306GQEVR8GRG Monster and the Beast CNT_0CE1VXWVHGVG CNT_0CE1VXWVHGVG 2 1 1 Volume 3 []   Monster and the Beast, Vol. 3   Liam and Cavo’s grand plan of traveling the world together comes to a standstill when the ship sets sail for a new continent, leaving Cavo in its wake. On his own for the first time since he met Cavo, the insatiable Liam is surrounded by temptation at every corner. Meanwhile, the ever faithful Cavo must find a way to cross the ocean—or lose Liam forever…   01KG9CCTVCGBZZZJ37APFEWFC6 3.0 2020-09-18T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Monster and the Beast, Vol. 3     2020-10-20T07:00:00.000Z   0 0
PRD_3HKTFG084N60 CNT_3MJ8FV5RK76G Monster and the Beast CNT_0CE1VXWVHGVG CNT_0CE1VXWVHGVG 2 1 1 Volume 2 []   Monster and the Beast, Vol. 2   <DIV>The innocent Cavo has finally managed to express his true feelings for the irrepressible Liam, but mysterious figures related to Liam's past interrupt them. In the midst of saving damsels and fleeing enemies, they hardly have a moment alone to explore their new status quo. Chance encounters, dangerous foes, and unexpected companions test the limits of the bond between Cavo and Liam. But Liam's appetite won't be stopped forever. And Cavo may not be as innocent as he pretends...Will the strange duo escape their pursuers? And how will their relationship survive the trials ahead?</DIV>   01KGA7NSFCTQSRNZGV0SHVFY5Y 2.0 2019-12-17T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG Monster and the Beast, Vol. 2     2019-12-17T00:00:00.000Z   0 0
PRD_3JFW75D1SHAG CNT_02C0FBP84DB0 Monster and the Beast CNT_0CE1VXWVHGVG CNT_0CE1VXWVHGVG 2 1 1 Volume 1 []   Monster and the Beast, Vol. 1   Solitary Cavo is a hideous monster with a pure heart. Liam, on the other hand, might look like a gentleman, but he's a beast on the inside, warped personality and all. When Liam ends up in an unfortunate situation in the haunted woods Cavo calls home, it's the monster to the rescue! After the close call, Liam extends a more-than-friendly hand to Cavo and leads the innocent monster out of the woods...and astray?!   01KGA60KYEX6VMCH7A0SN8R7W0 1.0 2019-06-25T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Monster and the Beast, Vol. 1     2019-06-25T07: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);