products

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

7 rows where series_id = "CNT_3E7QTTRZCX2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, listed_at, on_sale_at, 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_04BGSDM59R20 CNT_0G09A9PYP2X0 The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 7 []   The Marriage of a Tyrant King 7   "It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first." Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming "there isn't a living soul who hasn't fallen for me..."   01KGATE0QB1JH44PHV5WFJV032 7.0 2023-12-08T08:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 7 (C)rasu/Mobile Media Research   2023-12-08T08:00:00.000Z   0 0
PRD_1HMBAHQC719G CNT_1GGC1G6RBH10 The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 2 []   The Marriage of a Tyrant King 2   It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first. Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming there isn't a living soul who hasn't fallen for me...   01KH3EYV932JW2N4MBJE0NDK7F 2.0 2023-06-06T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 2 (C)rasu/Mobile Media Research   2023-06-06T07:00:00.000Z   0 0
PRD_1RVA7QJRFFFG CNT_1K4P1DH94F30 The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 3 []   The Marriage of a Tyrant King 3   It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first. Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming there isn't a living soul who hasn't fallen for me...   01KH3EYRG9EPZR74TQZWT5V97Z 3.0 2023-06-06T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 3 (C)rasu/Mobile Media Research   2023-06-06T07:00:00.000Z   0 0
PRD_2AZZAG7HE3XG CNT_3CB2PG3SSDYG The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 6 []   The Marriage of a Tyrant King 6   "It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first." Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming "there isn't a living soul who hasn't fallen for me..."   01KH3H292FX49FJNH343DMZYNC 6.0 2023-09-01T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 6 (C)rasu/Mobile Media Research   2023-09-01T07:00:00.000Z   0 0
PRD_2W37NTBJVXK0 CNT_03HRDS4B5780 The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 5 []   The Marriage of a Tyrant King 5   "It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first." Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming "there isn't a living soul who hasn't fallen for me..."   01KG9NZZHE3YN6HNNRKKNCETSR 5.0 2023-08-07T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 5 (C)rasu/Mobile Media Research   2023-08-07T07:00:00.000Z   0 0
PRD_3BBM717S39C0 CNT_048VWZ9NHSFG The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 4 []   The Marriage of a Tyrant King 4   "It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first." Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming "there isn't a living soul who hasn't fallen for me..."   01KH3FK8GZ7WRNHAD9VZHJZMKA 4.0 2023-07-11T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 4 (C)rasu/Mobile Media Research   2023-07-11T07:00:00.000Z   0 0
PRD_3QXK3T1H51S0 CNT_2G52HS1WG0JG The Marriage of a Tyrant King CNT_3E7QTTRZCX2G   3 1 1 Chapter 1 []   The Marriage of a Tyrant King 1   It'll be simple once we've bed each other. You'll lose yourself to me... especially if this is your first. Ritsu, a normal college student, receives an unexpected letter. It says that he is betrothed to a king in a foreign country per his late grandfather's promise...! With no interest in love, let alone marrying a man, he refuses! Ritsu travels far to arrive at the royal palace where he meets Seren, a king with unparalleled beauty. Seren steals a kiss, claiming there isn't a living soul who hasn't fallen for me...   01KH3ED41KS1SJ704R78M7W4ST 1.0 2023-06-06T07:00:00.000Z Mobile Media Research LAB_135JKJ373XXG GEO_1PQM5BDYSMG0 The Marriage of a Tyrant King 1 (C)rasu/Mobile Media Research   2023-06-06T07: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);