products

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

7 rows where series_id = "CNT_2Q8XK1453PA0"

✎ 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_03WVBM66CJS0 CNT_0BJEMZ3M86F0 Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 2 []   Our Timid First Kiss 2   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EBJRRCYBPM3ZHSSABWGSZ 2.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 2 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_0RSRDEAT4MV0 CNT_08X4N3Q3E8D0 Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 6 []   Our Timid First Kiss 6   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EBNW2YZE0QW06T8TMMH36 6.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 6 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_0ZE8R14W0KT0 CNT_287HNDDBX7E0 Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 3 []   Our Timid First Kiss 3   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EBKSCRXP6MMPB4NGY9H4R 3.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 3 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_1Y4NFC946C3G CNT_2JMNSFFW10NG Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 5 []   Our Timid First Kiss 5   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EC0G56G3G2MXEXVQ2FR6K 5.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 5 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_2043WYHBAH8G CNT_1B7541YRENRG Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 1 []   Our Timid First Kiss 1   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9E1YS9E90Z25MJFCM1QNFM 1.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 1 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_2TGHM5VN6MBG CNT_398E5TXZ9RXG Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 7 []   Our Timid First Kiss 7   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EBPC0EDPMJSPW6AJ21M9G 7.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 7 (C)Ichi/ WWWave   2021-01-26T08:00:00.000Z   0 0
PRD_2XQGHBQ1EJ9G CNT_3BX84P8G3PZG Our Timid First Kiss CNT_2Q8XK1453PA0   3 1 1 Chapter 4 []   Our Timid First Kiss 4   I'll never let you go. My first kiss with him was a sweet sensation but also left a bitter aftertaste...   01KG9EBK9QZMYC0SN3NM203896 4.0 2021-01-26T08:00:00.000Z wwwave_comics LAB_1GN8XNFCSY80 GEO_1PQM5BDYSMG0 Our Timid First Kiss 4 (C)Ichi/ WWWave   2021-01-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);