products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_1R8EPM105SE0"
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_006VWCAEBPZ0 | CNT_37711X7JSRM0 | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 8 | [] | Sand Chronicles, Vol. 8 | Revisiting scenes and people from earlier days drives Ann to an impulsive act of desperation. Who will stand by her now? And will she ever make peace with her past...and herself? | 01KGBHH30W96DHHW3ZQ4REE2ZR | 8.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 8 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_04QAFZ7GQNY0 | CNT_16HY18XV4QN0 | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 9 | [] | Sand Chronicles, Vol. 9 | What were our parents like at our age? We'll never really know... But now you can get a glimpse into the teenage years of the mothers of Ann, Daigo, Fuji and Shika. How was their destiny shaped? Plus, Ann's little sister visits Shika--and Ann's ex-fiancé!--in New York City. | 01KGBHH1PTMC922KA0BTC89T27 | 9.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 9 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_0S3R76E238S0 | CNT_34J761V1ZTA0 | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 10 | [] | Sand Chronicles, Vol. 10 | Daigo digs up the time capsule he buried twenty years ago when he was only ten. What message did Daigo leave for his future self? And what does it take to live life fully and without regret?Final Touching Volume! | 01KGBHH5YTZ6B1Q1AFCHFM7M7J | 10.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 10 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1A279XA29D6G | CNT_009FMMMKPFXG | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 3 | [] | Sand Chronicles, Vol. 3 | Sweet 16-year-old Ann returns to rural Shimane from Tokyo for the summer, eager to reconnect with her boyfriend Daigo. But will the allure of their close friends--wealthy brother and sister Fuji and Shika--sunder the romantic ties that have bound Ann and Daigo since they were 12? | 01KGBHHEQFQXXHCJSG7G258R29 | 3.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 3 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1EQ0WHFQVTB0 | CNT_3Z4DC1CQMCR0 | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 1 | [] | Sand Chronicles, Vol. 1 | After her parents get divorced, Ann Uekusa and her mother move from Tokyo to rural Shimane. Accustomed to the anonymity of city living, Ann can't get used to the almost overbearing kindness of the people in her mother's hometown. But when personal tragedy strikes, Ann discovers how much she needs that kindness. | 01KGBGM4HKRAQGXY74NB0AFH1B | 1.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 1 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1NE7CZRK3G10 | CNT_3V5Z2K957JJ0 | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 5 | [] | Sand Chronicles, Vol. 5 | Shika will stop at nothing to steal Daigo from Ann. And the competition ramps up when an attractive girl resurfaces from their past. Meanwhile, Fuji patiently waits to win Ann from Daigo. But who do Ann and Daigo want to be with...? | 01KGBHGSGFF9JGR6A52YY08J7T | 5.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 5 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_29D2KWGZHKCG | CNT_0SH1G3D7R67G | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 7 | [] | Sand Chronicles, Vol. 7 | Ann's junior high school reunion is coming up, and she hasn't seen Daigo in two years. How will their reunion go? Then, finally, the story behind Ann's engagement. Who is her fiancé...? | 01KGBHGZ3MPBKXSHAWRS1FBBWF | 7.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 7 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_318SD116NXNG | CNT_2WTCX352NZEG | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 2 | [] | Sand Chronicles, Vol. 2 | Just when Ann has adjusted to life in the countryside--and even has a boyfriend!--her father invites her to move back to Tokyo. Now she must choose between a father she hardly knows and a young man she is just beginning to know. But she soon discovers they aren't the only ones vying for her affections! | 01KGBHGMAECJCSN159NC6JS0WY | 2.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 2 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_32TE2E7W9YPG | CNT_0XFZXHGT60DG | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 4 | [] | Sand Chronicles, Vol. 4 | Ann and Daigo's long-distance relationship is put to the test as time goes by, and they find themselves spending more and more time with their childhood friends--aristocratic brother and sister Fuji and Shika--than each other. Is it just due to proximity or are deeper feelings at play...? | 01KGBHGNT6T36J0H0A3R1N7GZD | 4.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 4 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3Q6WVNEE5HHG | CNT_2VGRKAE1132G | Sand Chronicles CNT_1R8EPM105SE0 | CNT_1R8EPM105SE0 | 2 | 1 | 1 | Volume 6 | [] | Sand Chronicles, Vol. 6 | Ann and Daigo begin dating other people. But can anyone take the place of her first love in Ann's heart? Then, Ann learns a surprising secret about her father's romantic life! | 01KGBHGT78KRC5ZNK2RMFQXW46 | 6.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | Sand Chronicles, Vol. 6 | SUNADOKEI © 2003 Hinako ASHIHARA/Shogakukan | 2024-11-26T08: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);