products

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

3 rows where geoblock_id = "GEO_1Q329S88K9Q0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: series_id, parent_content_id, display_order, 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_15F13V9AJB10 CNT_3RRK4JE9KY20 The Infernal Devices CNT_2G2F6XJYC6XG CNT_2G2F6XJYC6XG 2 1 1 Clockwork Princess []   The Infernal Devices: Clockwork Princess   The threat of Mortmain's Infernal Devices looms as the Shadowhunters race to work out a way to counteract the mechanical monsters. Meanwhile, plans for Tessa's marriage to Jem are underway, despite her fiancé's failing health and the unresolved feelings between her and Will. When Tessa is captured, Will must leave his comrade behind to save the woman they both love... But with the final missing piece--Tessa herself--in Mortmain's possession, can anything stop his plot for revenge?   01KG9YT1ATF56BQH6B8MN4MVYV 3.0 2017-01-19T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1Q329S88K9Q0 The Infernal Devices: Clockwork Princess     2017-01-19T15:00:00.000Z   0 0
PRD_1E0VM889GAWG CNT_1JKN529MH2FG The Parasol Protectorate CNT_0EQ3FMZY41WG CNT_0EQ3FMZY41WG 2 1 1 Volume 3 []   Soulless: The Manga, Vol. 3   Condemned by society and her werewolf husband due to a pregnancy she cannot explain, Alexia Maccon - preternatural, tea aficionado - seeks an explanation for this "infant inconvenience" so as to cleanse her sullied reputation and prove her fool of a husband wrong. Preternaturals are a rare breed and the only history of their kind lies in Italy with the Templars, a group that once partnered with preternaturals to hunt down werewolves and vampires. Will Alexia find an explanation for her impossible offspring? Or do the Templars have other plans for the curious "Soulless One"?   01KGC06ERS7PVQNY2QXASD1HT2 3.0 2025-09-17T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1Q329S88K9Q0 Soulless: The Manga, Vol. 3     2025-10-08T07:00:00.000Z   0 0
PRD_3BM9M5RFGBGG CNT_0RE9MV9DRDKG The Infernal Devices CNT_2G2F6XJYC6XG CNT_2G2F6XJYC6XG 2 1 1 Clockwork Prince []   The Infernal Devices: Clockwork Prince   Tessa Gray has found friends among the Shadowhunters, supernatural protectors of mankind who possess angelic blood. But Tessa's new life is threatened when some members of the Clave challenge Charlotte's leadership and pressure her to resign as head of the London Institute. If Charlotte is forced out, Tessa will be forced to leave as well due to her warlock blood, making her easy prey for the still-at-large Magister. As Tessa and her handsome Shadowhunter escorts, Will and Jem, journey far and wide to unravel the Magister's secrets, they quickly learn that they have no secrets from the vengeful Magister...and nowhere is safe...   01KG9YT0PE2M7AJWFGJJWJZSRC 2.0 2017-01-19T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1Q329S88K9Q0 The Infernal Devices: Clockwork Prince     2017-01-19T15: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);