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

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_070H94Q7RF5G	CNT_1YWDTDSY9V80	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 5	[]	Ao-chan Can't Study! 5	It felt so good to kiss Kijima...and now Ao-chan's head is full of impure thoughts. But, if anything, he's too good at kissing...and Ao-chan's getting suspicious. And if that's not bad enough, Ao-chan's made a powerful, well-endowed new enemy! All this and more in the hilarious, tantalizing new volume of Ao-Chan Can't Study!	01KGA6MHSKB4YXF2FB0TEKM07H	5.0	2019-03-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 5	(C) Ren Kawahara / Kodansha Ltd.	2019-03-26T07:00:00.000Z
PRD_0NYQCKK0H040	CNT_3XCBJEVTYCAG	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 8	[]	Ao-chan Can't Study! 8	Ao-chan has returned to Japan...and is up for some heavy trials of love with Kijima before they head off to college! What does the future hold for them? Will her name stigmatize her for the rest of her life? Find out in the high school conclusion of Ao-chan Can't Study!	01KGA78EH4XWP1FMSXFNZ9FTB7	8.0	2019-06-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 8	(C) Ren Kawahara / Kodansha Ltd.	2019-06-25T07:00:00.000Z
PRD_11G7SVHN6TQ0	CNT_154K1PJH4YK0	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 4	[]	Ao-chan Can't Study! 4	After months of twists and turns, Ao-chan finally tells Kijima how she feels. It's officially mutual! But now he says he doesn't want to go out until college?! She's sure all it'll take for him to get in the mood is some quality time with the girl he likes...but things are going nowhere fast. He's too pure...and Ao-chan's impatient little heart is about to burst!	01KGA6CMMM1EPW6DNS0THJ8NSW	4.0	2019-01-21T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 4	(C) Ren Kawahara / Kodansha Ltd.	2019-01-22T08:00:00.000Z
PRD_1BDV3VH3TSMG	CNT_08Z8GQXZ14S0	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 6	[]	Ao-chan Can't Study! 6	Ao-chan manages to make her way out of the changing room in one piece, but she still finds herself overrun with worry and anticipation! Then it hits her ... What if she and Kijima only have so many problems because they're not official yet? But she's scarcely got time to wonder, because Halloween's right around the corner ... as well as two trips: one to a hot-springs inn and one to another world! Still, she's determined not to let anyone get in her way!	01KGA6WS5CWSKNQJ8JMJTHW6JP	6.0	2019-04-19T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 6	(C) Ren Kawahara / Kodansha Ltd.	2019-04-24T07:00:00.000Z
PRD_2109V8C1QVDG	CNT_096KB5MGAGNG	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 1	[]	Ao-chan Can't Study! 1	When Ao was in kindergarten, she smiled ear-to-ear as she told her classmates how her father, a bestselling erotic author, chose her name: “A as in apple and O as in orgy!” That day still haunts her ten years later as she studies with a single goal in mind: to get into an elite university and achieve independence from her father once and for all. She has no youth to misspend and no time to think about boys...until her classmate, “King Normie” Kijima, approaches her with a shocking confession of love. She tries to lose Kijima, but he just can't take a hint...and as her mind runs wild with dirty thoughts, she realizes her father has totally influenced her!	01KGA3R7BDHYCKH1WDYAFT7HK9	1.0	2018-09-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 1	(C) Ren Kawahara / Kodansha Ltd.	2018-09-25T07:00:00.000Z
PRD_2PSP6YCGFV5G	CNT_27B7R894TGDG	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 3	[]	Ao-chan Can't Study! 3	Ao-chan always used to fantasize about you-know-what...but she might not have to settle for fantasy for much longer! Preppy Kijima may be a virgin, but he's been earnest in his feelings for Ao-chan, and she can't help but feel his kindness winning her over a little--body and mind! And after a summer fraught with dangers, like late-night tests of courage and beach hijinks, she can't deny that she's grown closer to Kijima...or that her salacious fantasies are threatening to become reality. But her grades are in a free fall! Ao's torn between her growing hunger for romance and her desire for study. Which will she choose?!	01KGA68VCJ22C4CZ68X6FWTV5E	3.0	2018-12-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 3	(C) Ren Kawahara / Kodansha Ltd.	2018-12-25T08:00:00.000Z
PRD_36Z32CCVAPXG	CNT_03Z16W28QV5G	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 2	[]	Ao-chan Can't Study! 2	Ao's grades are in, and they don't look good; by the standards of her school of choice, she's getting a D- average. She needs to study now more than ever, but Kijima had to ask her out at the worst possible time...and every little thing he does fills her head with sinful fantasies! And if that weren't bad enough, she's got to contend with Miyabi, her confident, experienced childhood friend who's going after Kijima, and her father, who won't lay off the unsolicited kinky advice! When's a girl supposed to find time to study?!	01KG9AS7TPN4SJRM9KEMPXGCCT	2.0	2018-11-20T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 2	(C) Ren Kawahara / Kodansha Ltd.	2018-11-27T08:00:00.000Z
PRD_3NZ0WEB3QRPG	CNT_1Q3DEVA723Z0	Ao-chan Can't Study! CNT_186DKFEW1SZG	CNT_186DKFEW1SZG	2	1	1	Volume 7	[]	Ao-chan Can't Study! 7	Kijima and Ao-chan are growing closer by the day, but she's in for a big shock when her report card comes in! Now, two choices run through Ao-chan's head...either it's time they consummate their love so she can get it out of her system, or it's time for Ao-chan to push Kijima to arm's length and lose herself in her studies!	01KGA71QQGKQNNVEPHKSXSZ805	7.0	2019-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Ao-chan Can't Study! 7	(C) Ren Kawahara / Kodansha Ltd.	2019-05-21T07: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);