products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
16 rows where series_id = "CNT_3T75H33SAP90"
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_0081CEN54J20 | CNT_2E82HVB9VMH0 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 8 | [] | We Were There, Vol. 8 | I don't know if I'm following my fate......or going against it.But there is one thing I want......and that is for Yano's wish to come true. | 01KGBHF7ECHEB14FA00D4PT49E | 8.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 8 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_04YHZ1QF0H10 | CNT_01JZH51J6KJ0 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 6 | [] | We Were There, Vol. 6 | What would be a present that's better than your past?It's simply this...You're here,And I'm here. | 01KGBHF5FRXZ8BHBR8BJ6XXV4V | 6.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 6 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_0BF0AMGHCG00 | CNT_20XCGGQTNJK0 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 5 | [] | We Were There, Vol. 5 | In love, timing is everything.If you can't convey your feelings at that crucial moment,Even fate will pass you by. | 01KGBHF40E26HE4FCPNGQY4VAY | 5.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 5 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_0FXGM7JV8Z70 | CNT_007SG2C30HW0 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 4 | [] | We Were There, Vol. 4 | I don't regret it.I just feel that......maybe I messed up a bit...That's all. | 01KGBHF2BJ13V1ZGECV2DNQCWH | 4.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 4 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1363WSYCTBBG | CNT_38N75NDSYDRG | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 14 | [] | We Were There, Vol. 14 | When you're in love, once you hit the switch......no one can really say......what will truly happen.The impossible may even become possible. | 01KGBHFR7DJTTG7T5Y2FPKPPFC | 14.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 14 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_17MJECVQ6AAG | CNT_1BZM5722DCSG | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 12 | [] | We Were There, Vol. 12 | I love you.That's why I promised myself......the next time we meet...I'll never let you go. | 01KGBHFPE4GMH3E28HSCG42ZPY | 12.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 12 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1D8DP5H5AQFG | CNT_3DZB4E4VJA4G | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 10 | [] | We Were There, Vol. 10 | Don't regret. Do everything you can while you still have the chance.That's what I think it means......to have a "happy heart." | 01KGBHFGN588KXRWSC0CDPY3SN | 10.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 10 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1EYECKZEN6E0 | CNT_265EWZGEP950 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 3 | [] | We Were There, Vol. 3 | Every day, all day, I think about him.I wonder if there's a limit to love?I'm no longer able to imagine a world without him. | 01KGBHEPKWG7A5BTE3GSACNPTE | 3.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 3 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_1R307J20JD5G | CNT_2P0WTR194FYG | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 16 | [] | We Were There, Vol. 16 | Take back all the time you've lost......with everything you've got. | 01KGBHFVWPPCBA6N818E8JJENH | 16.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 16 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_220YV4A06KJG | CNT_1EKC1JG5N51G | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 7 | [] | We Were There, Vol. 7 | I know what Yano was like before he started going out with my sister...And what he was like after she died.How he held the tears back and looked as if he wanted to die...I understand him a whole lot better than you. | 01KGBHF85E4DTXC0RVG9203EDN | 7.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 7 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_260BYK299V60 | CNT_00AN9EV4DDX0 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 13 | [] | We Were There, Vol. 13 | I'm 24 years old......but I still feel the same as I did at 17.I can feel the waves rushing toward me. This time I'm going to let the current take me. I'm going to chase after you like a child. | 01KGBHKXMGWJW0JJNTCTJ3B2N7 | 13.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 13 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2HX99STTX4C0 | CNT_2RT8ZMWZG770 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 1 | [] | We Were There, Vol. 1 | Nanami starts high school with high hopes of making lots of friends. She develops a crush on the enigmatic Yano, but he may have too many secrets for her to handle.At that time......I didn't fully understand what Yano meant. | 01KGBGKZP2P66381WRVKS3QTNY | 1.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 1 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2HYW1RKFPPEG | CNT_1D9R7SS4195G | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 11 | [] | We Were There, Vol. 11 | There's a fine line between strength and weakness.Everyone needs something to hold on to......just to live life. | 01KGBHFER4WYAP61JHW7ZR5SF6 | 11.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 11 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2MFCKBCHJNDG | CNT_3CKN7BFCC86G | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 9 | [] | We Were There, Vol. 9 | In my memory I link together fragments from the past when we were together......to create a clear image of him in my mind.But I no longer know if that image is really him.That moment I see in my mind may have never existed. | 01KGBHFDDCPJ1YS7Q88AV9BM0X | 9.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 9 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_31FBN28HRBV0 | CNT_08AXNY8Y4X80 | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 15 | [] | We Were There, Vol. 15 | More than anything else......you must have wanted......to live up to Nanami's expectations. | 01KGBHFQEBNBJ2TFKZ05VJAJEF | 15.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 15 | BOKURA GA ITA © 2002 Yuuki OBATA/Shogakukan | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3VYANAVETWVG | CNT_35VQ2J80EY8G | We Were There CNT_3T75H33SAP90 | CNT_3T75H33SAP90 | 2 | 1 | 1 | Volume 2 | [] | We Were There, Vol. 2 | You know, that guy...He doesn't seem to need anybody else.I don't know how to put it, but...No matter how much we talk or what we do...It doesn't reach him. | 01KGBHEY0TSG0VT4XPFF14476Q | 2.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PZ1FZ4QK0N0 | We Were There, Vol. 2 | BOKURA GA ITA © 2002 Yuuki OBATA/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);