database: products: 8 rows where series_id = "CNT

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

8 rows where series_id = "CNT_0R6JT52KEDVG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_045MZVZ3VCZ0	CNT_3VCAHSQKY15G	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 6	[]	That Blue Summer 6	With only two weeks of summer vacation left, Ginzo finally asks Rio to spend the rest of it with him. The two lovers indulge in their covert affair wherever they can steal a moment alone?whether at Ginzo's house or the hot summer beach?when one afternoon, Ginzo's face drifts close to Rio's, and then... Find out more in volume 6 of the fateful summer love story that's purer and more exciting than youth itself!	01KPB8X4TNMF98AHBTHB79K2YJ	6.0	2020-06-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 6	Atsuko Namba / Kodansha Ltd.	2020-06-16T07:00:00.000Z
PRD_0PJ7NE7ZEZ20	CNT_1B6FTB2MN0TG	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 1	[]	That Blue Summer 1	Rio was looking forward to spending her summer vacation in Tokyo, meeting boys and going out with friends. But after a change of plans forces her to stay the (whole!!) summer with her grandmother in the countryside, she's devastated...until she meets Ginzo, a handsome, mysterious guy with incredible talent and a hidden past...	01KPB8WZXED9VN002SWKTWFQJ1	1.0	2020-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 1	Atsuko Nanba / Kodansha Ltd.	2020-01-10T08:00:00.000Z
PRD_13GTCTJ2TKRG	CNT_371KAE0CWMK0	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 5	[]	That Blue Summer 5	At Ginzo's invitation, he and Rio go off to see the fireworks. With his hand in hers and the fireworks bursting overhead, Rio knows she needs to be with him, and the words tumble out of her mouth. That's when Ginzo says something she never expected to hear! Find out more in volume 5 of the fateful summer love story that's more passionate and exciting than youth itself!	01KPB8X3W3Q5HTRCKDX8Z7PGC6	5.0	2020-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 5	Atsuko Namba / Kodansha Ltd.	2020-05-19T07:00:00.000Z
PRD_19JCCN2VEA60	CNT_1ZJWXE8RSC6G	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 4	[]	That Blue Summer 4	With Rio's Tokyo pals mingling with Ginzo's, Ueko has gone from quaint village to full-blown summer camp... and what summer camp is complete without a test of courage? Rio's going to need THAT in spades, after being randomly paired with Kanno of all people! Meanwhile, Ginzo can't stop glaring at the guy, and that's only making her MORE confused!	01KPB8X2YPP0ZABGHM89FSHPP7	4.0	2020-04-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 4	Atsuko Namba / Kodansha Ltd.	2020-04-28T07:00:00.000Z
PRD_1EZAG53JN460	CNT_3X6SFCSW79EG	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 8	[]	That Blue Summer 8	Rio decided to give up on Ginzo for good before she falls for him even harder... But when her last night in Ueko rolls around and she watches the movie they'd worked all summer to complete, Rio's cherished memories with Ginzo—from the moment they'd met until that day—surge inside her heart. And just like that, it's time to say goodbye... What will become of Rio and Ginzo's summer-long love affair!? Find out in the conclusion to the endlessly pure "Fateful Summer Love" story!	01KPB8X6QVGM1V5TNRV9770T0B	8.0	2020-08-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 8	Atsuko Namba / Kodansha Ltd.	2020-08-18T07:00:00.000Z
PRD_2DTC9QA0MQ6G	CNT_1A0BP54QCS50	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 2	[]	That Blue Summer 2	So what if Ginzo might end up marrying Marika someday? To Rio, only one thing matters, and that's the way her heart skipped a beat when they first met. That's when she decides that if fate doesn't want to play nice, she'll make it! Soon after, she's invited to help plan the summer send-off festival—and that means spending quality time with Ginzo! But little does she know that her mouth is about to spill a whole lot of secrets she was hoping to keep ... Find out more in Volume 2 of the hit love story that's more innocent and passionate than youth itself ...	01KPB8X12F8095KDHBDFTQ33QV	2.0	2020-01-28T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 2	Atsuko Nanba / Kodansha Ltd.	2020-02-11T08:00:00.000Z
PRD_37K38ZJPGWBG	CNT_1GQF2288CE00	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 3	[]	That Blue Summer 3	Rio's a temporarily displaced Tokyoite destined for the big city once summer's over, and Ginzo's a country boy, through and through. Even though Ginzo turned down her advances once before, Rio can't help but notice that he still treats her as someone special. But just as things start looking up for our heart-struck heroine, trouble comes charging in on a train straight out of Tokyo!	01KPB8X20BRDG0C9S82AYT4GVW	3.0	2020-03-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 3	Atsuko Namba / Kodansha Ltd.	2020-03-31T07:00:00.000Z
PRD_3S1GNMB16D3G	CNT_2NAKD3MVGJ00	That Blue Summer CNT_0R6JT52KEDVG	CNT_0R6JT52KEDVG	2	1	1	Volume 7	[]	That Blue Summer 7	Summer break is down to its final week, and Rio is determined to spend it all with Ginzo! Unfortunately, he's too busy with the liquor store and the summer festival to even look at her texts. But when Ginzo invites Rio to visit his school, something happens that brings them closer together than ever before! Caught between her feelings for Ginzo and their impending separation, a single sentence slips from Rio's mouth, and then... Find out more in the exciting 7th installment of the fateful summer love story that's hot and pure, all at the same time!	01KPB8X5P32521W30Z28FTS1XY	7.0	2020-07-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	That Blue Summer 7	Atsuko Namba / Kodansha Ltd.	2020-07-23T07:00:00.000Z

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);