products

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

4 rows where series_id = "CNT_1NJG65KDPEDG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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_10SNB78EA5BG CNT_3HYYABM07D90 Crayon Shinchan CNT_1NJG65KDPEDG CNT_1NJG65KDPEDG 2 1 1 Volume 2 []   Crayon Shinchan Volume 2   Crayon Shinchan features a pint-sized terror who is a rude little dude that stands back-to-back with such contemporaries as the kids of South Park. So be warned, this hilarious romp isn't for children; instead, Crayon Shinchan is an adult, tongue-in-cheek poke at modern domestic life. Crayon Shinchan is an international cultural phenomenon and one of the best-selling Japanese manga franchises of all time. The animated version previously aired on Adult Swim and is back in print! Now readers can enjoy it from the beginning in a new, consolidated format made up of three volumes.   01KGA26296Q1XMGVZS0R0DNA0P 2.0 2017-12-07T15:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 Crayon Shinchan Volume 2 (c)Yoshito Usui／Futabasha publishers Ltd.   2017-12-13T15:00:00.000Z   0 0
PRD_1ED4K01WY28G CNT_1KXNMJPSCAM0 Crayon Shinchan CNT_1NJG65KDPEDG CNT_1NJG65KDPEDG 2 1 1 Volume 1 []   Crayon Shinchan Volume 1   Crayon Shinchan features a pint-sized terror who is a rude little dude that stands back-to-back with such contemporaries as the kids of South Park. So be warned, this hilarious romp isn't for children; instead, Crayon Shinchan is an adult, tongue-in-cheek poke at modern domestic life. Crayon Shinchan is an international cultural phenomenon and one of the best-selling Japanese manga franchises of all time. The animated version previously aired on Adult Swim and is back in print! Now readers can enjoy it from the beginning in a new, consolidated format made up of three volumes.   01KGA1GS6JJAWZS4Z669N3J1MZ 1.0 2017-12-07T15:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 Crayon Shinchan Volume 1 (c)Yoshito Usui／Futabasha publishers Ltd.   2017-12-13T15:00:00.000Z   0 0
PRD_1J6R68PKHT0G CNT_1XAX878P5JC0 Crayon Shinchan CNT_1NJG65KDPEDG CNT_1NJG65KDPEDG 2 1 1 Volume 4 []   Crayon Shinchan Volume 4   Crayon Shinchan is an iconic legend and international cultural phenomenon. The pint-sixed terror is a rude little dude who stands back to back with such contemporaries as South Park. So be warned, this hilarious romp isn't for the kids. Crayon Shinchan is an adult tongue-in-cheek poke at modern domestic life.   01KGA269EB4Y5CM4Z1505F5WBQ 4.0 2017-12-07T15:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 Crayon Shinchan Volume 4 (c)Yoshito Usui／Futabasha publishers Ltd.   2017-12-13T15:00:00.000Z   0 0
PRD_3VD3NRXX7RP0 CNT_2ZMXV5EB4ZZG Crayon Shinchan CNT_1NJG65KDPEDG CNT_1NJG65KDPEDG 2 1 1 Volume 3 []   Crayon Shinchan Volume 3   Crayon Shinchan features a pint-sized terror who is a rude little dude that stands back-to-back with such contemporaries as the kids of South Park. So be warned, this hilarious romp isn't for children; instead, Crayon Shinchan is an adult, tongue-in-cheek poke at modern domestic life. Crayon Shinchan is an international cultural phenomenon and one of the best-selling Japanese manga franchises of all time. The animated version previously aired on Adult Swim and is back in print! Now readers can enjoy it from the beginning in a new, consolidated format made up of three volumes.   01KGA265WE6DD7713MTYEA4P1E 3.0 2017-12-07T15:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1PQM5BDYSMG0 Crayon Shinchan Volume 3 (c)Yoshito Usui／Futabasha publishers Ltd.   2017-12-13T15: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);