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

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_0Y2H7A8A830G	CNT_1BCM5ZVD1P3G	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 4	[]	Merman in My Tub Vol. 4	A handsome merman named Wakasa has made his home in the bathtub of Tatsumi, a high school student who otherwise lives alone. Their friends gather around the tub to sing karaoke, dress up, and play all kinds of inappropriate games...love is in the air, until suddenly their precious tub gets caught in an explosion! Tatsumi's sketchy uncle, Hisatora, appears in this volume, along with his collection of self-formulated bath salts! The fourth volume of this popular bath comedy brings the story to the boiling point!		01KG983XXCXDNDB786WDFSPC11	4.0	2016-08-23T06:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 4	(C) 2012 Itokichi	2016-08-23T06:00:00.000Z
PRD_21WTPC9BKKJ0	CNT_3RFK07VMAXHG	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 3	[]	Merman in My Tub Vol. 3	The ill-fated Tatsumi, who used to live alone, is now the unwitting host to a growing menagerie of undersea creatures. His bathtub has become the abode of the self-indulgent merman, Wakasa, with regular visits from his aquatic friends--the octopus Takasu, the shellfish Maki, the jellyfish Mikuni, the shark Agari, and the newest member, the starfish Goromaru. With the New Year upon them, it's time for sweets, bean-tossing and more, but can a tub this small possibly hold a crowd this large?	BIG FISH IN A SMALL BATH!	01K5GAY7JCFD746KXCGKVA53BC	3.0	2016-04-11T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 3	(C) 2012 Itokichi	2016-04-11T15:00:00.000Z
PRD_27TM1865YBK0	CNT_2E0S1CA745GG	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 1	[]	Merman in My Tub Vol. 1	Merman in My Tub is an uproarious supernatural comedy manga that turns the popular ""monster girl"" genre on its tail by focusing on monster boys. What happens when an intruder from the sea stakes claim to your bathtub? A cool yet demure teenage boy named Tatsumi must learn to live with the self-obsessed and playful merman, Wakasa, in a small Tokyo apartment. These two dissimilar young men will learn what it takes to deal with one another in their everyday lives.		01K5G9SH5JFDPTEXHC2DHMXX00	1.0	2015-10-12T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 1	(C) 2012 Itokichi	2015-10-12T15:00:00.000Z
PRD_2JPRGF5GG0YG	CNT_3QGQDSZ2FTQ0	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 8	[]	Merman in My Tub Vol. 8	When Wakasa the merman moved into Tatsumi's bathtub, it seemed like the weird sea creature party would never end. But after dealing with time slips, crow battles, and drain explorations, Wakasa suddenly disappear! Will Tatsumi finally get his bathtub back? Find out in this hilarious final volume!	LATHER, RINSE, REPEAT!	01KG9FHY8Y8KY3M3CJQF9QYDEE	8.0	2021-05-25T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 8	Itokichi 2020	2021-06-29T07:00:00.000Z
PRD_2VPWRQR4NGRG	CNT_2ZT0E7G9Z2VG	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 6	[]	Merman in My Tub Vol. 6	Wakasa the handsome merman is being happily spoiled by Tatsumi, an ordinary high school student, when Echizen the super-sadistic crab pops up to take Wakasa back. Old rivalries flare when Echizen meets up with Takasu… Wait, those two were rivals? Also in this chapter, meet Makara, a clownfis with a sexy surprise! This comedy serves up laughter and heart as warm as bathwater!	Rub-a-dub-dub?a merman in a tub!	01KG9YXED06HXSAYCF8VT47C2Q	6.0	2017-03-20T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 6	(C) 2012 Itokichi	2017-03-20T15:00:00.000Z
PRD_2W4457279K3G	CNT_2FP4YNTW660G	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 5	[]	Merman in My Tub Vol. 5	A handsome merman named Wakasa is living with Tatsumi, a high school student?in his bathtub! Visits from Wakasa’s crazy friends Takasu the octopus, Agari the shark, Mikuni the jellyfish, and Maki the snail raise the chaos level even higher. As if that isn’t crazy enough, now a super-sadistic crab wants to take Wakasa away! The first meeting between Wakasa and Tatsumi is also revealed in this volume of the frothy bathtub comedy!		01KG9894TSWC4HVW3HNGPQ2H5E	5.0	2016-11-22T04:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 5	(C) 2014 Itokichi	2016-11-22T04:00:00.000Z
PRD_3HWKSQSYZ06G	CNT_1M53AKB135CG	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 7	[]	Merman in My Tub Vol. 7	Wakasa wants to write a book! Before he can do that, he's got to master a few rudimentary skills--like learning how to write the word merman. After that, things get dirty when Takasu and Wakasa decide to make mudballs. Meanwhile, Tatsumi's uncle is cooking up his own crafty creations: romantic bath salts! And who better to test them out but the merman in Tatsumi's bathtub?	Crafty Sea Creatures!	01KGA3G2N5CF35AA6614Z1VDC8	7.0	2018-05-20T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 7	(C) Itokichi 2017	2018-06-01T07:00:00.000Z
PRD_3PYXBDDWRTR0	CNT_044NJ0CNFMVG	Merman in My Tub CNT_3AE10YX07MJ0	CNT_3AE10YX07MJ0	2	1	1	Volume 2	[]	Merman in My Tub Vol. 2	Mellow and responsible Tatsumi has gotten pretty uesd to his new roommate--the energetic and needy merman, Wakasa--who has taken what seems like permanent refuge in his bathtub. While regular visits from Wakasa's undersea friends and Tatsumi's affectionate little sister have become commonplace, the bathrub suddenly seems a little less safe when a shark appears. Is their hungry new acquaintance friend or foe? Whether it's testing new bubble bath, hosting a butler cafe, or training for the Olympics, it's never a dull day in Tatsumi's bathroom.	Flipper Whipped!	01K5GAWB1A1CDZRZGY8N302AB3	2.0	2016-01-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Merman in My Tub Vol. 2	(C) 2012 Itokichi	2016-01-25T15: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);