products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
11 rows where series_id = "CNT_1TB16969QR90"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_0N511G1NENAG | CNT_00MYD5T9KSN0 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 4 | [] | Sasaki and Miyano, Vol. 4 | What is Sasaki to Miyano? The question rings through Miyano’s mind as he struggles to come to a decision. After all, Miyano likes girls and not guys…right? Meanwhile, surprise reunions with old crushes and Miyano’s first drag beauty pageant push Sasaki’s self-restraint to the limit… | 01KG9H341PWYEWY1GQ7Z81DH67 | 4.0 | 2021-09-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sasaki and Miyano, Vol. 4 | 2021-11-09T08:00:00.000Z | 0 | 0 | ||||||
| PRD_10ATQX97EWT0 | CNT_1TQFFF2XQEJ0 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Official Comic Anthology | [] | Sasaki and Miyano Official Comic Anthology | Cat encounters, arcade trips, book-shopping sprees— sweet moments galore! It’s the simple little things that remind me most of that one BL I just read… | 01KGB6D3SF9QP60F93VXB3WP55 | 0.0 | 2023-05-08T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano Official Comic Anthology | 2023-10-17T00:00:00.000Z | 0 | 0 | ||||||
| PRD_141VMV0MDMMG | CNT_118Z0T76FE90 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 2 | [] | Sasaki and Miyano, Vol. 2 | Dating? Me and Sasaki-senpai…? We’re not like that! At least, those were Miyano’s thoughts until Sasaki gifted him chocolates on Valentine’s Day. Faced with the reality that Sasaki might like like him-in a BL kind of way-and the jarring realization that the senior’s graduation is fast approaching, it’s time for Miyano to confront his true feelings… | 01KG9E0KRDSJ2HR8BWCW19YKG7 | 2.0 | 2021-03-26T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sasaki and Miyano, Vol. 2 | 2021-04-20T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1R6GEQVEM7M0 | CNT_0851QD3DFV4G | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 3 | [] | Sasaki and Miyano, Vol. 3 | Limit overload-confession imminent. After struggling with his feelings for his adorable kouhai Mya-chan for almost a year, Sasaki takes the plunge and admits how he really feels. But has Miyano’s admiration for his senpai turned into… something more? Or will Sasaki be friend-zoned- permanently…?! | 01KG9FR9ZWRJRDW3BZCJW9GZQ9 | 3.0 | 2021-07-27T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sasaki and Miyano, Vol. 3 | 2021-08-10T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2D8RFY2F4Q4G | CNT_3GN3M3E10DH0 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 5 | [] | Sasaki and Miyano, Vol. 5 | <P>Sasaki is...Sasaki is what to me? A heated exchange between the two leads to absolutely nothing. Well, Miyano isn’t living in a BL story, so that’s fine, right? Except Miyano feels like he’s going to explode, because he can’t stop thinking about hugging his upperclassman...and taking care of him...What does it mean to like someone anyway?</P> | 01KGAEZC29RS1YM17PCM84P145 | 5.0 | 2022-03-30T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano, Vol. 5 | 2022-04-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_32GK38SBVN9G | CNT_2AQ1XN27G93G | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 10 | [] | Sasaki and Miyano, Vol. 10 | Now that reading BL is no longer just hobby for Miyano, but also the story of his life, it’s almost time for the college arc! However, before he gets to that, Miyano’s final cultural festival of his high school career is just around the corner! Meanwhile, his adorably sweet boyfriend, Sasaki, is struggling to figure out what his path forward should be... | 01KGBCC0BYTBSZEDQXEECNX87E | 10.0 | 2024-08-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sasaki and Miyano, Vol. 10 | 2025-01-21T08:00:00.000Z | 0 | 0 | ||||||
| PRD_391AW1VMJM7G | CNT_19HTQTCZQ1FG | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 8 | [] | Sasaki and Miyano, Vol. 8 | After Sasaki’s graduation, the clock ticks on while Sasaki and Miyano’s relationship slowly deepens bit by bit. They do all the little things couples do—eat lunch together, swap favorite books and music, quote BL lines…and just be there for each other. And then one day, Miyano suddenly realizes he wouldn’t mind if this lasted for the rest of his life… | 01KGB4EVJHMG9GKPC6FEDGGN9Q | 8.0 | 2023-02-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano, Vol. 8 | 2023-05-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3B4YTZWDC2Z0 | CNT_07RJXQN8GZFG | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 6 | [] | Sasaki and Miyano, Vol. 6 | <P> The moment has arrived. Miyano knows. He knows Sasaki likes him. And Miyano has realized...he likes Sasaki back, in a BL romance kind of way. Step one: realization is complete—but step two: confession is much harder than he thought it’d be. Just how did the guy he’s crushing on work up the courage to say it to his face all those months ago? </P> | 01KGAJD3BXAXJRYKFBSGME8WZS | 6.0 | 2022-07-29T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano, Vol. 6 | 2022-08-23T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3E0JKHNR78C0 | CNT_0WCDKM97W480 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 7 | [] | Sasaki and Miyano, Vol. 7 | Never in his wildest dreams did Miyano ever believe fiction would become reality—that his own life would parallel some of the BL stories he so dearly loves. But here he is with an adorably sweet boyfriend who dotes on him every chance he gets! Still, dating comes with its own challenges— especially when their families don’t know yet! Will the pair be met with love and acceptance when those they care for learn about their relationship...? | 01KGB2QAV19YWCJPZWXHGCNB3N | 7.0 | 2022-12-07T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano, Vol. 7 | 2023-02-21T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3VJ3HJC1R3NG | CNT_0NG3CV8DTNQG | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 9 | [] | Sasaki and Miyano, Vol. 9 | It’s not quite the same. As Miyano’s senior year passes by and Sasaki starts getting used to college, the strain of not spending every day together begins weighing on Sasaki’s mind. That’s why it’s a welcome relief when he and Miyano finally get a chance to go on a date— spending Sasaki’s birthday with each other for the first time since they got together. And yet, just being with Miyano isn’t enough anymore… | 01KGB7JJ9D30M9H3Z57ZJQPQ3V | 9.0 | 2023-04-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | Sasaki and Miyano, Vol. 9 | 2023-09-26T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3X65CRJDZM00 | CNT_1ZZ8E5AF88G0 | Sasaki and Miyano CNT_1TB16969QR90 | CNT_1TB16969QR90 | 2 | 1 | 1 | Volume 1 | [] | Sasaki and Miyano, Vol. 1 | It all started like a typical old-school boys’ love plotline-bad-boy senior meets adorably awkward underclassman, one of them falls in love, and so on and so forth. But although Miyano is a self-proclaimed boys’ love expert, he hasn’t quite realized…he’s in one himself. Which means it’s up to Sasaki to make sure their story has a happily ever after…! | 01KG9CGF82M22MKKFEVDKHD9WX | 1.0 | 2020-12-16T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Sasaki and Miyano, Vol. 1 | 2021-02-02T08:00:00.000Z | 0 | 0 |
Advanced export
JSON shape: default, array, newline-delimited, object
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);