products

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

5 rows where series_id = "CNT_3YRWBMQ66WSG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_0BPVCRT9HFH0 CNT_087ASBF8AVX0 From the Red Fog CNT_3YRWBMQ66WSG CNT_3YRWBMQ66WSG 2 1 1 Volume 4 []   From the Red Fog, Vol. 4   A young boy who came from the darkness now lives in the light. Although he has found companions of a sort, his truest desire—to search for his mother—will lead the lonesome boy elsewhere. Doubting the assassins guild he found himself a part of, Ruwanda enlists Ivan in his quest. But as the two uncover deadly secrets about the Organization, the red fog follows close behind...   01KG9KQ6BY4JZ27C5HF1ZARZ9Y 4.0 2023-01-13T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG From the Red Fog, Vol. 4     2023-04-18T00:00:00.000Z   0 0
PRD_1XV7CBQ89BRG CNT_0PX37REGVDWG From the Red Fog CNT_3YRWBMQ66WSG CNT_3YRWBMQ66WSG 2 1 1 Volume 5 []   From the Red Fog, Vol. 5   Ruwanda, a child of the darkness, now roams the world of the light. Having lost the only love he’s ever known, he cuts ties with the assassins guild and sets off on his own. Watching the days pass by vapidly, the boy grows into a young man…but he is spurred into action once more by a string of murders throughout London. In this final confrontation, who will be taken by the red fog plaguing the city…?   01KGB6ECM95GRFXARSY30SQRGS 5.0 2023-05-08T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG From the Red Fog, Vol. 5     2023-10-17T00:00:00.000Z   0 0
PRD_2QKH91BMG470 CNT_3A6YTNJRFG50 From the Red Fog CNT_3YRWBMQ66WSG CNT_3YRWBMQ66WSG 2 1 1 Volume 3 []   From the Red Fog, Vol. 3   Out of the darkness, Ruwanda stepped into the light. Seeking companions, he found his way to an assassins guild. Ruwanda’s current mission? Eliminate the target. But when he and his comrade Ivan run into trouble, can they put aside their differences and work together to take down the so-called gentlebeast?! Or will they fall prey to the red fog creeping through the manor...?   01KGB2P3YDMXDJ563A0MYW48Q4 3.0 2022-12-07T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG From the Red Fog, Vol. 3     2022-12-13T00:00:00.000Z   0 0
PRD_3NWA5AH1FWS0 CNT_2KW148BJ7YWG From the Red Fog CNT_3YRWBMQ66WSG CNT_3YRWBMQ66WSG 2 1 1 Volume 2 []   From the Red Fog, Vol. 2   A young boy born in darkness stepped into the light. His journeys all around England brought him to a mysterious assassins guild led by an enigmatic nobleman named Midwinter. Although Ruwanda had hoped to find companions who shared his eccentric interests, the jury’s still out on whether the Organization is one such place. In the meantime, Ruwanda and his colleagues venture out on a new mission—to assassinate the leader of a well-known gang. But only time will tell who will be devoured when the red fog descends...   01KGAGVTAA16TX7PEKQNF7JGN7 2.0 2022-07-26T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG From the Red Fog, Vol. 2     2022-07-26T00:00:00.000Z   0 0
PRD_3P70RXC8J670 CNT_3GVRARY1PVC0 From the Red Fog CNT_3YRWBMQ66WSG CNT_3YRWBMQ66WSG 2 1 1 Volume 1 []   From the Red Fog, Vol. 1   Born in darkness, a young boy steps into the light. Raised in a cellar steeped in solitude, his entrance into English society at the turn of the nineteenth century is anything but painless. From place to place he journeys, seeking companions who share his unusual interests. But always, always a red fog follows, consuming everything in its path…   01KGADHK5ZZYCHZM4ZTR26P28K 1.0 2022-01-18T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG From the Red Fog, Vol. 1     2022-02-22T00: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);