products

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

2 rows where series_id = "CNT_203XWYXC8ATG"

✎ 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_0FVZKW41X4V0 CNT_3ARC0HA0Y6H0 My Dear Agent CNT_203XWYXC8ATG CNT_203XWYXC8ATG 2 1 1 Volume 2 []   My Dear Agent, Volume 2   Professional bodyguard Riichi has recently entered his first relationship ever with Mario Tachibana, the mysterious newbie agent whom Riichi was tasked with training and housing. After discovering Tachibana is actually the illegitimate son of the conglomerate's CEO and his ward's secret brother, Riichi realizes there's a lot he likely doesn't know about his new partner. When Tachibana starts acting more aloof and coming home late, Riichi can't help but worry that his boyfriend is hiding more secrets from him. Riichi has trained his entire life to maintain composure and keep a handle on any and all situations that may arise, but in this uncharted new territory, will he be able to protect his most precious first love?NOTE: This book contains sexual content and is intended for an audience aged 18 years and up.   01KGB60BYYRAH9ZVSTY5C118HD 2.0 2023-03-16T07:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 My Dear Agent, Volume 2 ©2021   2023-03-16T07:00:00.000Z   0 0
PRD_0FWCE94N01D0 CNT_30G68Z1SQYH0 My Dear Agent CNT_203XWYXC8ATG CNT_203XWYXC8ATG 2 1 1 Volume 1 []   My Dear Agent, Volume 1   Riichi is a man everyone describes as being ice cold. He's a talented agent who manages bodyguards for the heir to a major financial conglomerate. One day, he's ordered to be a buddy for a bold but capable newbie who shows great promise, Tachibana. Tachibana uses up his salary right off the bat and says he doesn't even have an apartment to live in. Riichi allows Tachibana to stay with him and orders him around both in his work and private lives, but every day, he has his hands full with Tachibana's nonsense. And on top of all of that, Tachibana fell in love with him at first sight and tries to seduce him day and night!The bold newbie and the calm and collected hottie — a BL story about an oddball buddy agent duo!This book contains sexual content and is intended for an audience aged 18 years and up.   01KG9KQGST3D6JRT7Q4DWJH5BM 1.0 2023-02-10T08:00:00.000Z Tokyopop LAB_2C2B4XAHKSHG GEO_1PQM5BDYSMG0 My Dear Agent, Volume 1 ©2021   2023-02-10T08: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);