products

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

3 rows where series_id = "CNT_2G2F6XJYC6XG"

✎ 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_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_19XGDEBCYA00 CNT_1R304W4HYX30 The Infernal Devices CNT_2G2F6XJYC6XG CNT_2G2F6XJYC6XG 2 1 1 Clockwork Angel []   The Infernal Devices: Clockwork Angel   “I felt like you were someone I’d always been waiting for. I saw you feel it too.”Tessa Gray, a sixteen-year-old American girl, is traveling alone to Victorian London and runs afoul of the city’s sordid supernatural underworld. Rescued by the Shadowhunters of the London Institute, she quickly finds herself caught up in an intrigue that may very well destroy her new friends—including the two enigmatic young men, Jem and Will, who have taken her under their wing... Experience the graphic novel adaptation of The Infernal Devices, prequel to Cassandra Clare’s best-selling Mortal Instruments series, in this beautiful omnibus!   01KG98JQFX0K1Z2REE5EYF5VZY 1.0 2017-01-19T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QER4KFM1ZTG The Infernal Devices: Clockwork Angel     2017-01-19T15: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);