database: products: 19 rows where series_id = "CNT

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

19 rows where series_id = "CNT_00TV5JA72540"

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_03G8R21SHDK0	CNT_26G5FSP1DGJG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 13	[]	Ranma 1/2 (2-in-1 Edition), Vol. 13	Ranma's latest challenge is Furinkan High's newest teacher, Hinako Ninomiya. She can drain an opponent's energy and transform from her childlike stature to a tall, sultry siren. Will Ranma defeat Hinako, or will he be the one who's schooled? Then, Akane reunites with a boy from her childhood who's dying of a wound she inflicted on him when they were young. With his fatal wound on her conscience, will Akane choose to stay with Shinnosuke until the bitter end?	01KGBFXAQZ7XKAC50NSG5KNWNR	13.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 13	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_0AQBN9X5SBH0	CNT_2S5FEN2J6EWG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 9	[]	Ranma 1/2 (2-in-1 Edition), Vol. 9	Meet Picolet Chardin II, master of the très terrifying La Belle France School of Martial Arts Dining. A style of martial arts based on eating doesn't seem like it would be hard to master...but if Ranma can't defeat Picolet in La Belle France, it'll be wedding bells! Then, the unfortunately named "Pantyhose Taro" makes trouble for Ranma and the others, but who's really the target—and cause—of all the vengeance?	01KGBFX8YMC3P648ENZ814H4HK	9.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 9	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_0DTAJFRJ19Q0	CNT_2VT99JD30CYG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 5	[]	Ranma 1/2 (2-in-1 Edition), Vol. 5	Ranma's latest rival is Ukyo Kuonji, a chef in the art of cooking okonomiyaki, Japanese pizza. But the latest fight is more than just a rivalry with a fellow martial artist—Ukyo's issues with Ranma go all the way back to childhood and a certain promise he once made. Though just because there's a new rival doesn't mean the others have gone away, as Mousse returns to kidnap Akane!	01KGBFX5W95T4ZF691P2058DNJ	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 5	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_0NWYG98BDFE0	CNT_04HECJN84KQG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 19	[]	Ranma 1/2 (2-in-1 Edition), Vol. 19	The outrageous, entertaining and beloved stories of Ranma and the gang come to a conclusion! Will Ranma break his gender-flipping curse? Will anybody find a way to reverse the effects of the legendary cursed springs? Will Mousse get Shampoo? Will Kuno finally get his little redheaded pigtailed girl? Will the panty-stealing Happosai pilfer enough undergarments to complete his collection? And the ultimate question—will Ranma and Akane get married?!	01KGBFXG62K9TEP3H72JKB5AQP	19.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 19	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_0RD93WAD9ED0	CNT_27VVCWBGKJGG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 17	[]	Ranma 1/2 (2-in-1 Edition), Vol. 17	Ryoga and Ranma will stay forever young unless they eat a special mushroom at just the right time. But will they survive their squabbling over not wanting to share, or are they two shiitakes out of luck? Then, Akane's got a secret—a brand-new and bigger bra, waiting to be tried on. But when Ranma suggests that Akane's chest size may be shrinking, Akane goes from upset to enraged, and the arrival of Ranma's mother, Nodoka, only adds fuel to the developing battle of the busts, and bust-ups.	01KGBFXDTXARXTEPEHFPJDHP0Z	17.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 17	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_16Z5T04BK5VG	CNT_107PK5ESZ8S0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 12	[]	Ranma 1/2 (2-in-1 Edition), Vol. 12	Pantyhose Taro's back, and he's got a thirst for vengeance that can only be quenched by dunking Happosai in water from Drowned Man Spring. But the water might actually result in more trouble than he anticipated—in fact, double the trouble. Then, a zesty trio in search of a particular treasure inspires Ryoga, Mousse and Ranma to form a truce. But is their temporary alliance a recipe for disaster?	01KGBFXR77VE0ACMEXVG3CG8K1	12.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 12	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1824Q63QV3SG	CNT_12WGJ2SAS6V0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 8	[]	Ranma 1/2 (2-in-1 Edition), Vol. 8	Ranma wants it; four martial artist pork buns from China want it; Genma especially wants it... Described by a reluctant Ranma as the "seal" that keeps something terrible from happening, what is the "Dragon's Whisker"? Once that plot's tied up, the whole gang heads to a hot springs obstacle course. And then, a martial arts eating contest guaranteed to flip your stomach!	01KGBFXN3W5BTW2JQHHZR6Y9FX	8.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 8	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1CGQ2TXT72RG	CNT_327DJCFK4640	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 6	[]	Ranma 1/2 (2-in-1 Edition), Vol. 6	Furinkan High gets a new principal with some very radical ideas about student discipline and a rather unexpected relationship with blustering upperclassman Kuno. Then, poor lovesick Ryoga finally gets a break when a magical bar of soap cures his porcine transformations. If it's not too good to be true, then it won't all come out in the wash.	01KGBFXKTRJ05HZ2Q6DS2YXJKP	6.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 6	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1GB5X2TMD8P0	CNT_0V469W3BFBZG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 3	[]	Ranma 1/2 (2-in-1 Edition), Vol. 3	Contains volumes 5 and 6!Chinese Amazon warrior Shampoo hasn't given up on Ranma yet—only instead of killing him, she now wants to marry him! There are just a few obstacles in the way of their future happiness, though, starting with a childhood phobia of Ranma's and followed by Shampoo's suitor, Mousse, martial arts master of hidden weapons. Can Ranma escape Shampoo's soap opera? Or a better question might be, does he even want to?	01KGBFX3NQAGTSF19H2HYXNEYW	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 3	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1MSM8NMY9QN0	CNT_2TEK9FSKTARG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 1	[]	Ranma 1/2 (2-in-1 Edition), Vol. 1	Contains volumes 1 and 2!Years ago, Genma promised his old friend Soun Tendo that Ranma would marry one of Soun's three daughters and carry on the family's martial arts school. Except that the girl picked to be Ranma's bride doesn't seem to like him, Ranma keeps getting into fights...and did we mention that whole changing into a girl thing?	01KGBEWQKFGG72NPEV6603Z971	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 1	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1VBBJ7ENERPG	CNT_3E8ZGYC0PBY0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 18	[]	Ranma 1/2 (2-in-1 Edition), Vol. 18	Girl-type Ranma uncovers a cursed mirror that makes a love-hungry copy of her who kisses everyone she can get her hands on, including boy-type Ranma! A magical compact can capture the kooky copy, but then Ranma and Akane get trapped inside the compact! Later, Akane wins an enchanted bathing suit that finally enables her to swim. In return for the suit, she must enter a swimming competition. She takes the lead in the race, but a dangerous surprise awaits her at the finish line!	01KGBFXWRTAK38RR85RTHCM77A	18.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 18	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_1ZSTXT8ZB7NG	CNT_11KCG8295AZ0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 15	[]	Ranma 1/2 (2-in-1 Edition), Vol. 15	The Egg of the Phoenix is a legendary treasure and pounding headache for Ranma. Unless Ranma can force-feed the bird into maturity (and thus free himself from its attacks), he'll be on the bottom of the pecking order for the next 100 years. Will the bird, bird, bird have the final word? Elsewhere, Ryoga makes a potential love connection with a breeder of sumo-wrestling pigs, but will his alter ego P-chan cause a misunderstanding with dire consequences?	01KGBFXVDJBQEN8HH4JRX361D5	15.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 15	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_24E3WZJ0VB1G	CNT_1SG8ZC7E1Z30	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 10	[]	Ranma 1/2 (2-in-1 Edition), Vol. 10	Ten years ago, Ukyo made a special okonomiyaki sauce—which Ranma secretly ruined. Unaware of what Ranma had done, Ukyo to this day can't quite understand why Ranma's being extra nice to her despite the phenomenal failure of her special sauce. Akane's onto Ranma, though, and one way or another he's going to pay.	01KGBFX9KEQCEGMRS5RDMSTFM8	10.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 10	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_30QX1QN6N540	CNT_00JG3WKNPS9G	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 14	[]	Ranma 1/2 (2-in-1 Edition), Vol. 14	Home is where the heart is, except when it's invaded by unwanted guests. Ranma's teacher Miss Hinako falls in love with Akane's father and moves into the Tendo Dojo. But when Ranma tries to drive her out, Miss Hinako gives Ranma a run for his money! Later, a Ranma imposter takes up residence in the heart of Nodoka, Ranma's mother. It doesn't take long for the two "Ranmas" to begin fighting, and not just over their true identities.	01KGBFXRWD1CNM6T2ZQPSTRFGN	14.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 14	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_374DKAQ8H4B0	CNT_23XD3E9Y5RAG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 11	[]	Ranma 1/2 (2-in-1 Edition), Vol. 11	Pantyhose Taro's back, and so is his thirst for vengeance! Hoping to get his name changed to something less embarrassing, he plans to dunk Happosai in some water from the "Spring of the Drowned Pious Man." Unfortunately, that water isn't the water he thinks it is, it's worse...twice as worse! One Happosai is bad enough—is the world ready for two?! Later, Ranma meets his next nemesis: Herb of the legendary Musk Dynasty, a Chinese warrior tribe with the powers of animals. Herb and his companions, Lime and Mint, have come to Japan in search of a particular treasure—but they have to go through Ranma, Ryoga and Mousse first!	01KGBFXQJZWY6A0XG0HDBR58XR	11.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 11	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3EBF9GJMS290	CNT_22HQ2BMEZPMG	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 7	[]	Ranma 1/2 (2-in-1 Edition), Vol. 7	Ranma learns what being a loser feels like for once when Happosai applies a strength-sapping technique that leaves him weak as a baby! The humiliation continues for our emasculated hero when the only way Ryoga can rid himself of the "Mark of the Gods" (actually nothing more than a martial arts calligraphy doodle on his stomach) is by losing a fight to Ranma. Fox-Fu...Cat-Fu...Flat-Frog Fu...nothing seems to work against Ryoga! Has Ranma lost his edge for good?	01KGBFXMG1N1DX1FD10QHXAM1X	7.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 7	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3J3X4RBQF86G	CNT_3VFFSV876WE0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 4	[]	Ranma 1/2 (2-in-1 Edition), Vol. 4	Back when Ranma's father, Genma, and Akane's father, Soun, were young martial artists, they learned the secrets of Anything-Goes Martial Arts from one of the greatest masters of all time. Unfortunately, he's also someone they would do just about anything to get away from, and the entire Tendo household is about to find out why. Followed by a stirring rendition of Romeo and Juliet...and Juliet...and Romeo...	01KGBFX5DF8PR7SNRPXPH0XQ0P	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 4	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3PGDPB5SBQ5G	CNT_1TSWS6YFNVF0	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 2	[]	Ranma 1/2 (2-in-1 Edition), Vol. 2	Being a martial artist, Ranma just can't resist the call to combat and takes on one opponent after another: Ryoga, a lone-wolf fighter with no sense of direction; Shampoo, a Chinese Amazon who has pledged to kill him; and finally Shampoo's suitor Mousse, a martial arts master of hidden weapons. Is there such a thing as TOO much fighting spirit?	01KGBFX35XMK3AJTWX4K88N3E0	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 2	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08:00:00.000Z
PRD_3W12P4VW9650	CNT_21833JXDBT8G	Ranma 1/2 (2-in-1 Edition) CNT_00TV5JA72540	CNT_00TV5JA72540	2	1	1	Volume 16	[]	Ranma 1/2 (2-in-1 Edition), Vol. 16	Ryoga + new disciple Akari + Akane + a magical umbrella = a complicated equation of dueling love. Next there's a swimming contest between Akane and Miss Hinako that leaves one of them taking a dive. Then, a legendary dôgi—armor said to endow its wearer with ultimate power—is given to Ranma, Genma and Soun. But when the dôgi picks Akane to be its wearer, it soon comes between her and Ranma! It's now or never for Ranma to confess his true feelings for Akane, but will he?	01KGBFXT1DR4EG16G770MH5CTA	16.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Ranma 1/2 (2-in-1 Edition), Vol. 16	RANMA1/2 © 1988 Rumiko TAKAHASHI/SHOGAKUKAN	2024-11-26T08: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);