products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_1R9XQ60W8HXG"
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_0FXT189MC8A0 | CNT_1AMTPR98Z82G | Marmalade Boy: Collector's Edition CNT_1R9XQ60W8HXG | CNT_1R9XQ60W8HXG | 2 | 1 | 1 | Volume 5 | [] | Marmalade Boy: Collector's Edition 5 | Miki is blissfully enjoying life with Yuu, but stormy days are on the horizon. When Chiyako-san's younger brother, Eisaku, shows up with his two daughters, they blow into the house like a hurricane! It's not long before Miki and Yuu are swept up in their antics--and that's just the beginning of their turbulent new home life. What secrets does Eisaku have to share!? And what is the shocking true nature of Miki and Yuu's relationship!? Find out in the final volume of Marmalade Boy! | A PERFECT STORM | 01KGAY6A9VK770EKSPRQ7FMA0B | 5.0 | 2024-02-19T08:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PKAG51AEAQG | Marmalade Boy: Collector's Edition 5 | 1991 by Wataru Yoshizumi | 2024-04-09T07:00:00.000Z | 0 | 0 | ||||
| PRD_18W81NN1PG30 | CNT_3SMW5Y0ZMFRG | Marmalade Boy: Collector's Edition CNT_1R9XQ60W8HXG | CNT_1R9XQ60W8HXG | 2 | 1 | 1 | Volume 3 | [] | Marmalade Boy: Collector's Edition 3 | Miki loves Yuu, but she's got plenty of competition! The newest person vying for Yuu's affections is no less than the school president, Miwa Satoshi. Just how close are the two boys? And what's the meaning behind that serious look Yuu gets on his face from time to time? | FIERCE COMPETITION | 01KH3EJNCAXSPXYCKZ8XKBNDKR | 3.0 | 2023-06-21T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PKAG51AEAQG | Marmalade Boy: Collector's Edition 3 | 1991 by Wataru Yoshizumi | 2023-08-15T07:00:00.000Z | 0 | 0 | ||||
| PRD_1C5N1WWJFKDG | CNT_3DKZEBP9GY2G | Marmalade Boy: Collector's Edition CNT_1R9XQ60W8HXG | CNT_1R9XQ60W8HXG | 2 | 1 | 1 | Volume 4 | [] | Marmalade Boy: Collector's Edition 4 | Miki is ecstatic over her plans to take a trip with Yuu! In order to save up money, she gets a job at an ice cream shop--but disaster strikes when she's working there. What will she do when she loses the bracelet Yuu gave her?! | EMOTIONAL ROLLERCOASTER | 01KGAT9JXG00RXDZPJ3NP8CEJY | 4.0 | 2023-11-20T08:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PKAG51AEAQG | Marmalade Boy: Collector's Edition 4 | 1991 by Wataru Yoshizumi | 2023-12-12T08:00:00.000Z | 0 | 0 | ||||
| PRD_2N01HGRG508G | CNT_3PHXWN4J5DPG | Marmalade Boy: Collector's Edition CNT_1R9XQ60W8HXG | CNT_1R9XQ60W8HXG | 2 | 1 | 1 | Volume 1 | [] | Marmalade Boy: Collector's Edition 1 | Miki's life was pretty ordinary until the day her parents told her they were swapping spouses with another couple! Thanks to this unconventional arrangement, Miki now has two new stepparents and a hot new stepbrother, Yuu! Miki isn't exactly thrilled with her new situation, and though Yuu is super cute, he's also kind of a jerk. Can Miki sort out her complicated feelings for him and come to terms with her new family? | It's Complicated | 01KG9KK6HWTBFXB53XR98WJDMZ | 1.0 | 2023-01-16T08:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PKAG51AEAQG | Marmalade Boy: Collector's Edition 1 | 1991 by Wataru Yoshizumi | 2023-02-14T08:00:00.000Z | 0 | 0 | ||||
| PRD_2ZPDZ9NEEJ80 | CNT_2CAKZ8ZDPNC0 | Marmalade Boy: Collector's Edition CNT_1R9XQ60W8HXG | CNT_1R9XQ60W8HXG | 2 | 1 | 1 | Volume 2 | [] | Marmalade Boy: Collector's Edition 2 | Ginta and Yuu are in the middle of their tennis match, but it's not going so well for them. Ginta is totally off his game, but it has nothing to do with the bet he placed, and everything to do with the fact that Miki said she hates him. Can he get his act together in time for them to win the match? Or are Miki's suitors doomed to lose--the game and their hair? | GAME, SET, MATCH! | 01KGB5YGX3EFHJANH58TTRYC8P | 2.0 | 2023-03-03T08:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PKAG51AEAQG | Marmalade Boy: Collector's Edition 2 | 1991 by Wataru Yoshizumi | 2023-05-16T07: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);