products

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

4 rows where series_id = "CNT_1YYNARQ8GBPG"

✎ 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_1EB52QWAZQ90 CNT_3GJNT5JF3140 Now playing CNT_1YYNARQ8GBPG CNT_1YYNARQ8GBPG 2 1 1 Volume 3 []   Now Playing, Vol. 3   To save the Drama Club from being shut down, Sai volunteers to resign. Can Azuma convince him to return, or will the demons of the past prevent the Drama Club from entering the district competition?   01KG9VX1G39VCBQ0TE780WSAYH 3.0 2017-11-28T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Now Playing, Vol. 3     2017-11-28T08:00:00.000Z   0 0
PRD_25XWXNEJA6RG CNT_11Y7TN4MPHZG Now playing CNT_1YYNARQ8GBPG CNT_1YYNARQ8GBPG 2 1 1 Volume 4 []   Now Playing, Vol. 4   Shinonome has to deal with the rigors of portraying the fight against something that doesn't have a correct answer. It is the actors themselves who exist on the fictitious stage. As such, he is asked to put on an act that he "can do because he's him," but he worries because he just doesn't have the confidence-!? Now begins the first and final tournament...so they can go to the national tournament and keep acting with their teammates-!! Now comes the awaited conclusion of the high school acting drama, for those who love the future or anyone who has ever gotten obsessed with something!!   01KGA1CQ0FBHDWA6AS8408B16G 4.0 2018-02-06T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Now Playing, Vol. 4     2018-02-06T08:00:00.000Z   0 0
PRD_2Y44ZY4J7X8G CNT_1FWZD9P7Y75G Now playing CNT_1YYNARQ8GBPG CNT_1YYNARQ8GBPG 2 1 1 Volume 2 []   Now Playing, Vol. 2   A game of Werewolf gets dark and personal, and all the neighborhood's a stage for a very special performance targeted at Azuma's classroom bully, Takumi. Facades don't only exist in the world of theater...   01KG9VQGC5MJVCQD79BC0MTQF9 2.0 2017-09-25T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Now Playing, Vol. 2     2017-09-25T15:00:00.000Z   0 0
PRD_3NXZC1T6DDG0 CNT_346H6H0H46D0 Now playing CNT_1YYNARQ8GBPG CNT_1YYNARQ8GBPG 2 1 1 Volume 1 []   Now Playing, Vol. 1   Bullied by his classmates, teenager Azuma Shinonome is sick of life...until a meeting with actor extraordinaire Sai Saionji changes everything. Sai sees the makings of a great thespian in Azuma, but fostering Azuma's potential might also mean drawing out his inner darkness.   01KG98PJ3HS6ACZXYS5DG57RCN 1.0 2017-07-24T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Now Playing, Vol. 1     2017-07-24T15: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);