products

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

3 rows where series_id = "CNT_0T1EDNZHCKBG"

✎ 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_1W92Y32DJSKG CNT_1MXQ3XB3XVGG Tokyo Mew Mew Omnibus CNT_0T1EDNZHCKBG CNT_0T1EDNZHCKBG 2 1 1 Volume 2 []   Tokyo Mew Mew Omnibus 2   MEW MEW! SPLASH SPLASH! On a quest to discover the Mew Aqua, a powerful element that can purify anything contaminated, our favorite female fighting force - Tokyo Mew Mew - discover much more than they bargained for! Will they be able to retrieve Mew Aqua - or will they end up all wet? New adventures and romances are just around the corner in this stunning collection of stories from Tokyo Mew Mew volumes 3 & 4! Includes special extras after the story!   01KG9998K12HC9JXZ2FCKAYY55 2.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Tokyo Mew Mew Omnibus 2 (C) Mia Ikumi / Reiko Yoshida / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_32PAQDCJGR30 CNT_2MKDK6682B00 Tokyo Mew Mew Omnibus CNT_0T1EDNZHCKBG CNT_0T1EDNZHCKBG 2 1 1 Volume 1 []   Tokyo Mew Mew Omnibus 1   UNLEASH THE FULL POWER OF MEW MEW! On her first date with the cutest boy in school, Ichigo is exposed to a mysterious ray that meshes her DNA with that of the endangered Iriomote wildcat. She soon discovers that she has developed superhuman abilities and enhanced agility. Her new powers are put to the test when she leads a team with four other girls, each endowed with special abilities of their own. Together, they must now protect the Earth from an alien menace known as Deep Blue. This omnibus edition contains volumes 1 and 2 of Tokyo Mew Mew. Includes special extras after the story!   01KG98DR2H4ECVM6R3XQ2E9BBP 1.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Tokyo Mew Mew Omnibus 1 (C) Mia Ikumi / Reiko Yoshida / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_3Y1T5TK8MSW0 CNT_0N8GKMHZQC70 Tokyo Mew Mew Omnibus CNT_0T1EDNZHCKBG CNT_0T1EDNZHCKBG 2 1 1 Volume 3 []   Tokyo Mew Mew Omnibus 3   CAT-ASTROPHE! Tokyo Mew Mew - the crime-fighting collection of girls imbued with the power of cat DNA? - face their greatest battle ever to save their beloved city of Tokyo. Arch-villian Deep Blue reveals a startling secret, and Ichigo and Masaya reveal their true feelings to each other. Will they survive long enough to celebrate their love? Find out in the thrilling conclusion to Tokyo Mew Mew! This omnibus edition contains volumes 5, 6, and 7 of Tokyo Mew Mew! Includes special extras after the story! FINAL VOLUME!   01KG99994WBQATQNGY4WSS5T72 3.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Tokyo Mew Mew Omnibus 3 (C) Mia Ikumi / Reiko Yoshida / Kodansha Ltd.   2016-10-25T07: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);