products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_157Y45N5MHJG"
This data as json, CSV (advanced)
Suggested facets: display_order, 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_00JGKRGRE6R0 | CNT_0AB8M0EXECEG | Dekoboko Sugar Days CNT_157Y45N5MHJG | CNT_157Y45N5MHJG | 2 | 1 | 1 | Dekoboko Bittersweet Days | [] | Dekoboko Bittersweet Days | Tiny and adorable when they first met, Rui – still just as adorable – now looms over his boyfriend, Yuujirou. Though they were little more than best friends at first, the confusion over their true feelings for one another smoldered until they confessed. Now every day passes with such overwhelming sweetness it's all they can do not to ask themselves, "am I allowed to be this happy?"The final high school judo contest, the last summer of their high school careers, and beyond... the thought of his future with Rui makes Yuujirou's heart flutter.A slow-burn love story between a diminutive, athletic teen and his towering, kind-hearted best friend as they journey the slightly bitter road to adulthood towards sweeter days.This book contains sexual content and is intended for an audience aged 18 years and up. | 01KGAGFH35JVSC8FYFTJ8CFT5E | 1.0 | 2022-04-21T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Dekoboko Bittersweet Days | 2022-04-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1E1HAPHKZCJG | CNT_2GEF41F7HYA0 | Dekoboko Sugar Days CNT_157Y45N5MHJG | CNT_157Y45N5MHJG | 2 | 1 | 1 | Extra | [] | Dekoboko Sugar Days - Extra | A digital exclusive bonus story from hit boys love manga Dekoboko Sugar Days! Tiny and adorable when they first met, Rui – still just as adorable – now looms over his boyfriend, Yuujirou. Though they were little more than best friends at first, the confusion over their true feelings for one another smoldered until they confessed. Now, every day is filled with such overwhelming sweetness, they just can't keep their hands off each other! This book contains sexual content and is intended for an audience aged 18 years and up. | 01KGAHBQ5RJ30TMAF2SGYMVV2S | 3.0 | 2022-05-06T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Dekoboko Sugar Days - Extra | 2022-05-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_2XV7K29GBRFG | CNT_061KJQC4SBD0 | Dekoboko Sugar Days CNT_157Y45N5MHJG | CNT_157Y45N5MHJG | 2 | 1 | 1 | Dekoboko Sugar Rush! - Extra | [] | Dekoboko Sugar Rush! - Extra | Rui has his first at-home date with Yuujiro in two weeks! But he's found himself in a bit of a pickle — having promised to go without seeing each other during the exam period so as to better focus on their studies, Rui has been spending his time away from Yuujiro stressing and eating way too many sweets. Now, he's feeling a bit self-conscious about seeing Yuujiro again. Yuujiro, on the other hand, couldn't be more excited! Dekoboko Sugar Rush! is a delicious and dirty bonus story about the sugary-sweet love between a short-statured manly man and his tall, soft and fluffy boyfriend!This book contains sexual content and is intended for an audience aged 18 years and up. | 01KGAJ6NMRVAH9VKHZ6CHPTY58 | 4.0 | 2022-07-01T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Dekoboko Sugar Rush! - Extra | ©2021 | 2022-07-26T07:00:00.000Z | 0 | 0 | |||||
| PRD_33R2ZT7JPXN0 | CNT_10W3Q35FXHZG | Dekoboko Sugar Days CNT_157Y45N5MHJG | CNT_157Y45N5MHJG | 2 | 1 | 1 | Dekoboko Sugar Days | [] | Dekoboko Sugar Days | Yuujirou Matsukaze has been close friends with Rui Hanamine since the two of them were children. Back then, Yuujirou was the one who stood up for and took care of his adorable, soft-hearted friend. But as it turns out, Yuujirou's childhood dreams end up growing a little too big to handle — or, rather, too tall! At over six feet in height, the cheerful and happy-go-lucky Rui towers over his would-be protector... and still has no idea Yuujirou's had a crush on him since they were kids! | 01KG9CCXK3CGH1HQP8C6A17FHH | 1.0 | 2020-09-11T07:00:00.000Z | Tokyopop LAB_2C2B4XAHKSHG | GEO_1PQM5BDYSMG0 | Dekoboko Sugar Days | ｺﾋﾟｰﾗｲﾄなし | 2020-09-24T07: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);