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_1MB6GASCNHA0"

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	on_sale_at
PRD_07P31T8BABJG	CNT_3CZEGJE2WDHG	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 6	[]	With the Light... Vol. 6	Hikaru is in Junior High School now, and he takes the community bus to get to school. For now, Sachiko needs to go with him everyday... Even though Hikaru is pretty much capable to ride the bus, there are still problems to deal with. Sometimes Hikaru gets upset because someone pushed the buzzer to stop first. Or there are days when he finds out that he can't sit down. But these problems are nothing compared to what he did to a lady sitting next to him...he sniffed her hair and touched it, causing her to freak out and treat Hikaru like a pervert! Something that wasn't a problem when Hikaru was younger becomes a major problem as he grows taller than Sachiko. How will Sachiko deal with this problem? A little hint from the Sunshine House gives her a creative idea to resolve it.	01KG9YWAQVJCRHG7RXJR775739	6.0	2017-02-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 6	2017-02-20T15:00:00.000Z
PRD_0JMY9AC8NVH0	CNT_3FJ2ZNJ33DJ0	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 3	[]	With the Light... Vol. 3	A little effort goes a long way-that's what Sachiko, Honda-san, and Gunji-sensei learn as they struggle to work together to make life easier for the Special Education children. With the help of gadgets and the support of more people in their environment than meets the eye, Hikaru and Miyu become able to communicate better with the world around them. But when Hikaru's teen idol classmate sends some mothers into a flashbulb frenzy that causes Hikaru to panic, other parents begin to question his presence alongside "normal" students in the classroom. Hikaru's first school trip also ends in disaster, when he gets separated from the group, and Sachiko begins to worry that Hikaru is losing his hard-fought place in society.	01KG9YTMD50XE2D7SMDGX7MTF0	3.0	2017-01-23T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 3	2017-01-23T15:00:00.000Z
PRD_11J10DSC9HK0	CNT_1JHTNH56AKG0	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 2	[]	With the Light... Vol. 2	Sachiko and Masato Azuma have overcome numerous obstacles in dealing with their firstborn son Hikaru's autism. Having saved their marriage from ending in ruins, the young couple has welcomed a healthy baby girl, Kanon, into their tight-knit family. But with the obvious differences between Hikaru's and Kanon's developmental abilities, it becomes apparent that social prejudices against Hikaru's disability are never far away. As Hikaru moves into fourth grade, Sachiko encounters a new student, Miyu, whose mother has completely given up on her daughter's life and her own. With the help of Hikaru's beloved teacher, Aoki-sensei, Sachiko aims to bring hope back to Miyu's family. But when Aoki-sensei transfers to a different school and Hikaru's special education class is thrown into upheaval by yet another tragedy, can Sachiko continue to hold on to her own hope for her son's future?	01KG9YR6CTBMQ8PCA5XJSYSEHD	2.0	2016-12-27T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 2	2016-12-27T15:00:00.000Z
PRD_1AY3VQ79SNNG	CNT_0V6FC34ZW7YG	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 7	[]	With the Light... Vol. 7	For most parents, their child's teenage years are just as bad, if not worse, than the terrible twos. But for Sachiko and Masato Azuma, the situation is further complicated by their son Hikaru's autism. As puberty strikes, Hikaru's growing sexual awareness creates uncomfortable and embarrassing situations, and begins to affect his little sister, Kanon. The already-taxed Sachiko must find ways to alleviate the situation, while being mindful of the effects her approach may have on her children and on the people around them. But when Masato is told he has to relocate again for work, the pressure is really on Sachiko as the decision is made to move in with her mother-in-law, who has always been less-than-accommodating to Hikaru's needs. With new challenges arising daily - Hikaru tackling adolescence through the lens of autism, Kanon struggling with peer pressure, Masato throwing himself into the new job - will Sachiko, the Azuma family's rock, succumb to the cracks that have begun to form in her generally cheerful outlook on life?	01KG9YXNT3BQEY59GAAF9X0T5H	7.0	2017-03-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 7	2017-03-20T15:00:00.000Z
PRD_1CFQG1XBQV1G	CNT_2FXCCCRYTY2G	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 4	[]	With the Light... Vol. 4	When staffing changes at Masato's company get him transferred to a dead-end job in the middle of nowhere, more suffering and despair seem imminent for the Azuma family. However, Masato approaches the situation with aplomb and comes up with new ways to pave the way for Hikaru and those like him to become "cheerful working adults"...with surprising results. Hikaru himself seems to be getting closer, bit by bit, to achieving this goal as the Azumas decide to foster their son's independence in a variety of ways, including getting to and from school on his own. But when Hikaru encounters an old acquaintance on the way home and leads Sachiko to a horrific discovery, will the Azumas be able to return a favor and help out a friend in need?	01KG9YTMXK0ZYK8MFQ3M83GFJH	4.0	2017-01-23T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 4	2017-01-23T15:00:00.000Z
PRD_25ZBT4V88A20	CNT_0CM50V972X10	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 5	[]	With the Light... Vol. 5	StartFragmentAnother school year might be over for Hikaru Azuma, but his mom has notime to rest. With both a new teacher and new classmates of differentages and varying disabilities ahead in fifth grade, Sachiko startspreparing for the difficulties that come with sudden changes to herautistic son's routine. Despite her best efforts, Sachiko meets withmuch opposition from the new teacher, and the Azumas have to cope withHikaru acting out as a result of the stressful changes at school.Moreover, when the time comes for the family to decide on Hikaru'sjunior high, the local education administrators seem to think that aschool for the disabled is the best fit for Hikaru, partly because ofhis recent behavior. But Sachiko, who has done her research, knows thisto be false. Will she and Masato be able to convince the authoritiesand specialists that they know what is best for their son?EndFragment	01KG9YWA9JNGJY19SA2XQ7AEAN	5.0	2017-02-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 5	2017-02-20T15:00:00.000Z
PRD_34PV1EM4VN60	CNT_3VH8WT9VQRD0	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 8	[]	With the Light... Vol. 8	While trying to create a place in society for her autistic son, Hikaru, has been an uphill battle, Sachiko Azuma has long known that perhaps the toughest place to find acceptance for him is within her own family. Despite some progress made, Sachiko's mother-in-law still treats her grandson as a nuisance and sees him in many ways as inferior to his little sister, Kanon. Now that the Azuma family has moved into Masato's childhood home, Sachiko must not only adapt to life with her mother-in-law - she also must help Hikaru, whose developmental disabilities make it notoriously difficult for him to accept changes to his routine, adapt to this new living situation and a new school. As Sachiko tries to balance caring for Kanon and Hikaru in the face of her mother-in-law's constant disapproval, will the Azuma family emerge from what seems like the darkest of tunnels into the light? Told in completed chapters as well as unfinished pages that the creator drew while battling a long illness, this final volume of With the Light serves as a legacy to the late Keiko Tobe's inspiring dedication to bring to light the hardships and joys of raising an autistic child for readers around the world.	01KG9YXP9PPFF1XXDFY69P9WGB	8.0	2017-03-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 8	2017-03-20T15:00:00.000Z
PRD_37V9TPBHQG2G	CNT_2J6H5T0AK31G	With the Light... CNT_1MB6GASCNHA0	CNT_1MB6GASCNHA0	2	1	1	Volume 1	[]	With the Light... Vol. 1	Born during the sunrise-an auspicious beginning-the Azumas' newborn son is named Hikaru, which means "light". But during one play date, his mother notices that her son is slightly different from the other children. In the alternately heartwarming and bittersweet tale, a young mother tries to cope with both the overwhelming discovery of her child's autism and the trials of raising him while keeping her family together. This is a story that resonates not only for those whose families have been affected by autism, but also for all past, present, and future parents.	01KG98JJ3FFJYNF0WYC55BCGQD	1.0	2016-12-27T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1QR2G8X6B6CG	With the Light... Vol. 1	2016-12-27T15: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);