products

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

6 rows where series_id = "CNT_1STZSSR2KTF0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: geoblock_id, 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_02XAJ041TADG CNT_0Z5GK9Z13NN0 JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 1 []   JUDGE, Vol. 1   Envy, lust, sloth, wrath, gluttony, pride, greed.A group of sinners who bear the guilt of the seven deadly sins has been gathered in an old courthouse to face judgement. To leave this place alive, they must offer up a sacrifice - one of their number. As the trial begins, who will the gavel fall on first?   01KG6ZFZ7K0B23EHT30TCACPD6 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 JUDGE, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_0K5XRQFYGQQG CNT_2FYFHBHDKHK0 JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 4 []   JUDGE, Vol. 4   "You are not the only ones playing this game." Do clues discovered in a new room herald nothing more than a new despair? Soon the brutal sentencing of the third Judgment is visited upon the participants. Who here is the victim, and who the perpetrator?Until all is revealed, time is on no one's side...   01KG97TTGCQTBQK3GPKV5Z496T 4.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 JUDGE, Vol. 4     2016-06-30T15:00:00.000Z   0 0
PRD_0YCT7DAZYBEG CNT_2ZV3KYARMPM0 JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 3 []   JUDGE, Vol. 3   In the abandoned courthouse, to trust is folly. Is that the only rule, the only strategy to staying alive in the twisted game underway within? When the time for the Second Judgment arrives, a ruthless decision is made to shocking effect. The sinners must accept reality . . . for idealistic notions have no place among these halls of cruel and swift justice . . .   01KG98052NS01RN6JJ4BGXSA11 3.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 JUDGE, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_1J9P74B89T1G CNT_3CWPDYSGB510 JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 6 []   JUDGE, Vol. 6   All rise for the final verdict... With everyone playing it close to the chest, the courthouse is teeming with murderous intent. Lives are cut down, one after another, until the final four remain. At long last, the bell to signify the end of the game rings out. Will those left standing truly be able to make it out of this place alive?   01KG95KNRT253GA9QNSJFKNMQC 6.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 JUDGE, Vol. 6     2016-06-30T15:00:00.000Z   0 0
PRD_2WM2SQNWWBY0 CNT_3ZGT375WX65G JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 2 []   JUDGE, Vol. 2   Court is now in session for Hiro and the other sinners, who have been herded like cattle into an abandoned courthouse to pass judgment on one another's crimes. Suspicions whirl after the first trial is held. Were the votes cast by the sinners born of deception or goodwill? As a clearer picture of the courthouse itself is revealed, new doubts arise. What's to become of the one who has been sentenced to death?   01KG9804JBH71EK2C9VKP9Z6WC 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1KB2KYDQ0JGG JUDGE, Vol. 2     2014-04-08T07:00:00.000Z   0 0
PRD_3MW3VZ4S6WD0 CNT_34VRCV55TQPG JUDGE CNT_1STZSSR2KTF0 CNT_1STZSSR2KTF0 2 1 1 Volume 5 []   JUDGE, Vol. 5   It's time to clear the docket. Who could possibly be responsible for this game? That question swirls among the participants, who grow more desperate as they are forced to make one horrific choice after another. The game is to conclude when the requisite four survivors have been determined. For these four fortunates, court will be adjourned...but what awaits them on the other side of the courthouse doors?   01KG97T8H3AH1RCZJ9TNDC7Q23 5.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 JUDGE, Vol. 5     2016-06-30T15: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);