database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_3BVZMN71YZ0G"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0D6BCYFB5V10	CNT_2399YE8T3E20	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 2	[]	Sweetness and Lightning 2	Having lost his wife, math teacher Kouhei Inuzuka is doing his best to raise his young daughter Tsumugi as a single father. He's pretty bad at cooking and doesn't have a huge appetite to begin with, but chance brings his little family and one of his students, Kotori Iida, together for homemade adventures. With those three cooks in the kitchen, it's no wonder this dinner table drama is so delicious.		01KG9915CNR9A5BP9V7CRDB8V4	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 2	(C) Gido Amagakure / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0EHR1BD0SW20	CNT_03YWYWJHMF10	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 4	[]	Sweetness and Lightning 4	Having lost his wife, math teacher Kouhei Inuzuka is doing his best to raise his young daughter Tsumugi as a single father. He's pretty bad at cooking and doesn't have a huge appetite to begin with, but chance brings his little family and one of his students, Kotori Iida, together for homemade adventures. With those three cooks in the kitchen, it's no wonder this dinner table drama is so delicious.		01KG9916BZZPGHKMK2EWC9QZ7N	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 4	(C) Gido Amagakure / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0TP03W6KQWBG	CNT_0496N9QTN5TG	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 9	[]	Sweetness and Lightning 9	BRAND NEW FLAVORS First grade is a time for new adventures for Tsumugi-from cutting her hair, to meeting a new relative for the first time, and even trying her hand at cooking all by herself! Tsumugi seems eager to try new things on her own, but Kohei can't help but feel anxious, wondering if Tsumugi is growing up too fast. And when Tsumugi asks her father if he is ever going to get remarried, how will he respond? Does this mean Tsumugi is ready to move on from her mother-and if so, what about Kohei?		01KG9VV907E9FHSX0BENJBH061	9.0	2017-11-06T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 9	(C) Gido Amagakure / Kodansha Ltd.	2017-11-28T08:00:00.000Z
PRD_18BNBKXQEYR0	CNT_0Y90BP5G5T6G	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 12	[]	Sweetness and Lightning 12	Ever since losing his wife, high school teacher Kohei Inuzuka has raised his daughter Tsumugi alone. But what once seemed like an impossible task has become possible, as Kohei's friendship with his student Kotori has led all three of them to discover the delight of food and cooking. But when Kohei has a health scare of his own, their hard-won happiness will face its greatest test...	Scenes from a Life	01KGA76GEEHFGKMNFB5TF3MYWG	12.0	2019-05-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 12	(C) Gido Amagakure / Kodansha Ltd.	2019-06-04T07:00:00.000Z
PRD_1C0FF3139D30	CNT_3F9Q3AF4XS40	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 10	[]	Sweetness and Lightning 10	Tsumugi's growing up fast, and the more she wants to do, the more complications Kohei has to deal with--from misunderstandings at school to the major milestone of Tsumugi's first bicycle. Kotori's life is getting busier, too, and it's not just because of her burgeoning ambitions: Her family situation may be about to change. But despite all the hustle and bustle of their lives, the delights of food and cooking (sukiyaki, udon, and more!) sustain all three.	Growing Pains	01KGA3E7GCEH3GTBAQZZVTY8J6	10.0	2018-04-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 10	(C) Gido Amagakure / Kodansha Ltd.	2018-05-08T07:00:00.000Z
PRD_288G8123VXJG	CNT_3096EVQDFZHG	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 5	[]	Sweetness and Lightning 5	Having lost his wife, math teacher Kouhei Inuzuka is doing his best to raise his young daughter Tsumugi as a single father. He's pretty bad at cooking and doesn't have a huge appetite to begin with, but chance brings his little family and one of his students, Kotori Iida, together for homemade adventures. With those three cooks in the kitchen, it's no wonder this dinner table drama is so delicious.		01KG9917VRE66X1WGSA9EHA5YR	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 5	(C) Gido Amagakure / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2CS0VNW67WHG	CNT_13KKE5DNTYJG	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 3	[]	Sweetness and Lightning 3	Having lost his wife, math teacher Kouhei Inuzuka is doing his best to raise his young daughter Tsumugi as a single father. He's pretty bad at cooking and doesn't have a huge appetite to begin with, but chance brings his little family and one of his students, Kotori Iida, together for homemade adventures. With those three cooks in the kitchen, it's no wonder this dinner table drama is so delicious.		01KG9915W9GY9YK248Y0E58D15	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 3	(C) Gido Amagakure / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2J1RB93QPG3G	CNT_1X0980F5DN7G	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 11	[]	Sweetness and Lightning 11	The older Tsumugi gets, the stronger her personality and preferences become. As a responsible single dad, Kohei always does his best to keep up, but sometimes desperate measures are necessary--like the classic Japanese comfort food, a rice omelet. Later, Kotori's on the brink of making a big decision, and she won't be the only one affected by it. But no matter how things turn out, with Kohei and Tsumugi in her life, good food and good company are never far away.	You Can't Make an Omelet…	01KGA5JXC4NZD3CT43EDHK6Q5F	11.0	2019-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 11	(C) Gido Amagakure / Kodansha Ltd.	2019-01-15T08:00:00.000Z
PRD_2NDANR80QEQ0	CNT_2GBEV85KN7E0	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 7	[]	Sweetness and Lightning 7	Tsumugi is now in kindergarten, and as she grows up, her questions are becoming more complicated. Her curiosity about her mother leads to a quiet search for an old photo album that brings up memories as beautiful as they are poignant--but when a character in her favorite TV show dies, she begins to ask about “heaven” and “hell,” and Kohei will have to find a way to answer. But as always, home cooking-- like candied chestnuts, oyakodon, and somen noodles poured down a bamboo flume--is a balm for the wounded souls of father and daughter alike.	The Truth is Complicated	01KG9Z6RHDKX8XWPSSFDJT2R2G	7.0	2017-07-03T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 7	Gido Amagakure / Kodansha Ltd.	2017-07-18T04:00:00.000Z
PRD_35QGS7KPRPCG	CNT_28FRSZ0JYG1G	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 6	[]	Sweetness and Lightning 6	A single dad, a little girl, and a quirky teenager learn about food's power to help people grow and love! “This season's number one feel-good anime! Grade A.” -Anime News Network “A beautifully drawn story about comfort food and family and grief, it's a delightful read. Recommended.” -Otaku USA Magazine		01KG9Z3WTVE0FVZZ2N3YV986T7	6.0	2017-05-22T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 6	(C) Gido Amagakure / Kodansha Ltd.	2017-06-06T05:00:00.000Z
PRD_3EH9KFZZ2290	CNT_3F2AKPPYCC40	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 8	[]	Sweetness and Lightning 8	Tsumugi's started elementary school, and it's one new experience after another. She's excited to try the all-important school lunch, but she'll have to get used to some new rules--eating at school isn't like eating at home. Then, the ability of sandwiches to mend a broken friendship is put to the test, even as Kotori braces herself for an important decision. Finally, it's time for Tsumugi's first athletics festival--her world just keeps getting bigger!	LUNCHTIME BLUES	01KG9ZB3AEH43SZ8GV09YVS5CS	8.0	2017-08-21T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 8	Gido Amagakure / Kodansha Ltd.	2017-09-05T04:00:00.000Z
PRD_3KFK58Y83VGG	CNT_32Y09Q3Y9XKG	Sweetness and Lightning CNT_3BVZMN71YZ0G	CNT_3BVZMN71YZ0G	2	1	1	Volume 1	[]	Sweetness and Lightning 1	Having lost his wife, math teacher Kouhei Inuzuka is doing his best to raise his young daughter Tsumugi as a single father. He's pretty bad at cooking and doesn't have a huge appetite to begin with, but chance brings his little family and one of his students, Kotori Iida, together for homemade adventures. With those three cooks in the kitchen, it's no wonder this dinner table drama is so delicious.		01KG936BF0JH0SYM13YPMFA29Y	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sweetness and Lightning 1	(C) Gido Amagakure / Kodansha Ltd.	2016-10-25T07: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);