database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_1NFN3PGS7VE0"

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_04MRSK7NBCS0	CNT_1XXYXQ6T75M0	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 5	[]	Anne Happy, Vol. 5	Lots of surprises are in store for Tennomifune Academy's Happiness Class. Not only do they have Tsubaki, a shy new classmate, but for the upcoming school culture festival, they'll be doing...improv?! Will Hibari, Hanako, and Botan (along with Hibiki and Ren) be ready to take the stage, or will their collective misfortune lead to chaos? And just why does Tsubaki's voice sound so familiar...?	01KG9Z33C4J52SWSCQ818M8973	5.0	2017-05-22T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 5	2017-05-22T15:00:00.000Z
PRD_082DY93FN2JG	CNT_3NT1HAMY2MHG	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 3	[]	Anne Happy, Vol. 3	In Tennomifune Academy Class 1-7, the lovelorn Ruri Hibarigaoka (Hibari), the luckless Anne Hanakoizumi (Hanako), and the less than healthy Botan Kumegawa (...Botan) are just trying to get by. But add the perpetually lost Hibiki Hagyo and literal chick magnet Ren Ekoda into the mix, and the hijinks explode as these cursed kids tackle an endless lineup of lessons in luck. But who knows what their teacher has cooked up for their upcoming special "happiness exam"...?	01KG989QETP0A6DVAEN4TW3N1A	3.0	2016-11-21T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 3	2016-11-21T15:00:00.000Z
PRD_0G97RHJM463G	CNT_39DWTGTKRS0G	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 1	[]	Anne Happy, Vol. 1	At Tennomifune Academy, students with "negative karma"-the kids who are practically weighed down by misfortune-are all collected into one place: Class 1-7. On the first day of school, Ruri Hibarigaoka (Hibari) meets fellow 1-7 classmates Anne Hanakoizumi (Hanako), a girl up to her ears in bad luck, and the all-too-frail Botan Kumegawa (...Botan). These fast friends just want to have a fun high school life, but are they pushing their luck...?!	01KG6ZGZCJFFR143DMK7SQGP4S	1.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 1	2016-08-18T15:00:00.000Z
PRD_10FHT94TRS7G	CNT_16F9KAQMP5E0	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 10	[]	Anne Happy, Vol. 10	After months of self-discovery and the craziest tests imaginable, the Happiness Class has, at long last, reached the end of their first year at Tennomifune Academy. Whether they realize it or not, Hibari, Hanako, Botan, Hibiki, Ren, and Tsubaki have learned to chase their dreams and overcome the odds-but do they truly know what it menas to be happy? Keep your fingers crossed for these luckless girls in this final volume of Anne Happy!	01KGA7JN2FY46P58EC4Y5684A1	10.0	2019-09-30T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Anne Happy, Vol. 10	2019-11-12T00:00:00.000Z
PRD_15Y3GKT3EJR0	CNT_1VJQRX7DBVN0	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 6	[]	Anne Happy, Vol. 6	It's the Happiness Class's improv performance, and Hanako and the rest of the girls are up! But going onstage isn't so easy. When there's this much concentrated bad luck among the actors, "break a leg" may be more than just a saying!	01KG9ZAV0Y29PEGH37M29QRHTT	6.0	2017-08-21T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 6	2017-08-21T15:00:00.000Z
PRD_1ENE2TYR5GQ0	CNT_12N8TSVX7SE0	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 7	[]	Anne Happy, Vol. 7	It's time for the annual Sports Day at Tennomifune Academy! But between Hibiki's terrible sense of direction, Botan's frail body, and Anne's perpetual magnetism for misfortune, the Happiness Class's chances of winning are slim. What's more, Kodaira-sensei has a surprise in store for her students -- one that will turn the whole event upside down!	01KG9VVGH04ZYYM1416JSTVV6F	7.0	2017-11-14T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 7	2017-11-14T08:00:00.000Z
PRD_29N7GB9R9H5G	CNT_2SSTAEQK0PDG	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 8	[]	Anne Happy, Vol. 8	Tennomifune Academy's Sports Day continues, and Hibari is in the Sports Bingo ? Special Race along with her friends! But when it's the disaster-prone students of the Happiness Class against the top talents of the athletics program, is there any hope of avoiding a shutout-especially when some unexpected trouble comes rolling their way?	01KGA3K7N5QD0WAH831QWMNTZW	8.0	2018-10-30T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 8	2018-10-30T07:00:00.000Z
PRD_2J1Z673Q66C0	CNT_29R6BFZFJ9Q0	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 2	[]	Anne Happy, Vol. 2	Class 1-7's sugoroku challenge is in full swing, but even in a class full of students afflicted with "negative karma," Hibari, Hanako, and Botan's collective bad luck is really just staggering... When the girls are given an extra assignment to collect lucky items, could this be their opportunity to turn their fortunes around?? Sadly, sour luck won't be their only obstacle!	01KG9842R8025DJ8ZWF5XYYGH9	2.0	2016-08-29T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 2	2016-08-29T15:00:00.000Z
PRD_2YBSJBXT4DX0	CNT_2ANE6C8DX060	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 4	[]	Anne Happy, Vol. 4	Tennomifune Academy's Class 1-7 is on a trip to summer camp! That's nothing out of the ordinary for your typical teenagers, but for the misfortune-plagued students of the "Happiness Class" it's a surefire recipe for disaster! Can Hibari, Hanako, Botan, Hibiki, and Ren overcome their collective lack of luck, or will their summer memories be filled with endless mishaps?	01KGB1F60RRMFSX13Z9KN6ZT6E	4.0	2017-02-27T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 4	2017-02-27T15:00:00.000Z
PRD_33QFC88XEKS0	CNT_14JN1XEVTZ5G	Anne Happy CNT_1NFN3PGS7VE0	CNT_1NFN3PGS7VE0	2	1	1	Volume 9	[]	Anne Happy, Vol. 9	The school culture festival and Sports Day at Tennomifune were both full of their ups and downs, but Hibari and her usually unlucky friends managed to pull through with a victory! At last second semester has arrived, bringing along...a special happiness test?!	01KGA5Q48Y8GY4N1D99Y0WXVN5	9.0	2019-05-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Anne Happy, Vol. 9	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);