database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_0V85TJQXDESG"

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_01V401EAG540	CNT_14WMSWPNGGFG	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 1	[]	Samurai Girl Real Bout High School, Vol. 1	In a school where martial arts are standard curriculum, Ryoko Mitsurugi, the Samurai Girl, is the top fighter and the most popular student around. This changes when the uncouth Shizuma Kusanagi transfers in from Kansai. He may not have the grace of Ryoko, but with his amazing fighting abilities, he could soon be the most dominant martial artist at Daimon High. Principal Todo encourages the rivalry between the competitors, setting up an exciting K-fight tournament where even the teachers can join in and settle once and for all who's the top dog on campus.	01K5G9RKZ10HB1EPXEC613SWJ9	1.0	2015-07-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 1	(C) REIJI SAIGA 1999 (C) SORA INOUE 1999	2015-07-30T15:00:00.000Z
PRD_02R0NBDK1YZ0	CNT_1KG4SYRZ1S4G	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 3	[]	Samurai Girl Real Bout High School, Vol. 3	With Tatsuya's transfer imminent, Azumi frets, Shiori shudders, and Ryoko is struck with a sudden dizziness that interferes with her ability to fight. Her feelings for the Kendo Team Captain run deep, and his departure means that her reason for fighting is going to have to shift from making him proud to building confidence in herself. And Principal Todo longs to turn Ryoko's misery into K-Fight entertainment by having her next bout filmed by stalker-in-training Daisaku. Daimon High School, where brawn beats brains, may very well get turned upside down.	01K5GAMDZRKPWQAB8JDKJRNHKB	3.0	2015-10-04T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 3	(C) REIJI SAIGA 2001 (C) SORA INOUE 2001	2015-10-04T15:00:00.000Z
PRD_050NJBCMXB90	CNT_2Y18VKJKK6AG	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 6	[]	Samurai Girl Real Bout High School, Vol. 6	The Daimon High School spectacular will be concluded mano y mano in a group of magnificent melees and explosive exchanges: After stopping Project Z, Ryoko loses her memory; the battle between "Shinsen-gumi" and "G-gumi" goes to the second round; and the battle of Ryoko vs Shizuma just might go the distance. Nobody pulls a punch in the no-holds-barred final installment of this butt-kicking-and-name-taking series!	01K5GAVK8B3TW60TTY1N0NBWXY	6.0	2015-12-21T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 6	(C) REIJI SAIGA 2003 (C) SORA INOUE 2003	2015-12-21T15:00:00.000Z
PRD_1B0HWEWJY82G	CNT_1MVYW9PH8K00	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 4	[]	Samurai Girl Real Bout High School, Vol. 4	Daimon High School's student council president Isozaki asks martial arts expert and fellow classmate Ryoko to collaborate on an effort to sweep the streets clean of troublemaking scum. But his hidden agenda is clear: he wants to expand the K-Fight program beyond the school's campus, and does so by pitting Ryoko and four other women warriors against Shizuma and his band of brawny brawlers. Surprisingly, Ryoko not only accepts the challenge but agrees to head the group of lady fighters as well, hoping the experience helps her attain her ultimate goal of becoming a great woman. The battle of the sexes is, literally, at hand.	01K5GB616HYG8CNTJ5S1TWDQE8	4.0	2015-10-26T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 4	(C) REIJI SAIGA 2001 (C) SORA INOUE 2001	2015-10-26T15:00:00.000Z
PRD_1W0P5SH8DZEG	CNT_0FZWDK2X8AM0	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 2	[]	Samurai Girl Real Bout High School, Vol. 2	With Tatsuya's transfer imminent, Azumi frets, Shiori shudders, and Ryoko is struck with a sudden dizziness that interferes with her ability to fight. Her feelings for the Kendo Team Captain run deep, and his departure means that her reason for fighting is going to have to shift from making him proud to building confidence in herself. And Principal Todo longs to turn Ryoko's misery into K-Fight entertainment by having her next bout filmed by stalker-in-training Daisaku. Daimon High School, where brawn beats brain, may very well get turned upside down.	01K5GAHN9ZZD0S9YWAT23372TT	2.0	2015-08-24T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 2	(C) REIJI SAIGA 2000 (C) SORA INOUE 2000	2015-08-24T15:00:00.000Z
PRD_2TNWFPJANYV0	CNT_38JZ1K299RRG	Samurai Girl Real Bout High School CNT_0V85TJQXDESG	CNT_0V85TJQXDESG	2	1	1	Volume 5	[]	Samurai Girl Real Bout High School, Vol. 5	Ryoko Mitsurugi and Shinsengumi are expected to kick some serious ass at Dragon Land, but they're nowhere to be found. All wait in baited anticipation: the K-fight news team, the Daimon High School student body, Principal Todo, the Isozaki triplets, and the ominous "G" who has already given Ryoko one thorough pummeling and now plans to video tape her K-fight matches to sell ont he black market. With the arena set and the opponents ready to rumble, all Shinsengumi has to do now is show up!	01K5GASWQY7J1B7HVA05YZQ9RM	5.0	2015-12-01T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Samurai Girl Real Bout High School, Vol. 5	(C) REIJI SAIGA 2002 (C) SORA INOUE 2002	2015-12-01T15: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);