products

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

3 rows where series_id = "CNT_1NKDSM6PQS9G"

✎ 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_1XXC0SR399Z0 CNT_0DN4SFREGD6G i tell c CNT_1NKDSM6PQS9G CNT_1NKDSM6PQS9G 2 1 1 Volume 3 []   i tell c, Vol. 3   The day of Phantom Thief mAR's heist has finally arrived! Utilizing skillful pilfering techniques to evade the police, mAR steals the targeted painting with ease. But the ever-quirky Risa comes up with a plan to counter the Phantom Thief! Will her love crack this case and reach the heart of her mysterious blight in shining armor? Find out in the final volume of this eccentric tale of suspense!   01KGBFFYCJHB85ND9TE1EZ05SA 3.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 i tell c, Vol. 3 AITERUSHI © 2021 by Kazusa Inaoka/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_329113JKT6C0 CNT_2RVC0KNE9THG i tell c CNT_1NKDSM6PQS9G CNT_1NKDSM6PQS9G 2 1 1 Volume 2 []   i tell c, Vol. 2   After solving the hotel case and once again escaping the clutches of Hikaru Kagamino, Risa is thrust into a new set of deadly cases as part of the new i Investigation Division. Their latest case? A livestreamed bank robbery, complete with hostages—including Risa herself! Will Risa's unique set of skills be enough to take down her beloved perpetrator?   01KGBFF2WVC5MF17S9F8JTKDS7 2.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 i tell c, Vol. 2 AITERUSHI © 2021 by Kazusa Inaoka/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_36V74N5AKQDG CNT_3CN8829V5VQ0 i tell c CNT_1NKDSM6PQS9G CNT_1NKDSM6PQS9G 2 1 1 Volume 1 []   i tell c, Vol. 1   When a popular entertainer is murdered, newbie detective Sakon Futatsuki and his twin brother track down the potential culprit, a stalker in love with the victim. But their investigation goes awry when eccentric detective Risa Aioi sticks her nose in the case and takes matters into her own hands!   01KGBEV0P47H144H43RHE6A8BE 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 i tell c, Vol. 1 AITERUSHI © 2021 by Kazusa Inaoka/SHUEISHA Inc.   2024-11-26T08: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);