database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_19YGS3WVAAM0"

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_02PWXA7M1J0G	CNT_2B1CEJ31TPF0	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 9	[]	Alice & Zoroku Vol. 9	After Zoroku is overly harsh with Sana, Sana runs away from home. Now, Zoroku and his granddaughter Sanae must scour the city looking for Sana. Trying to find one little girl in all of Tokyo is tough...until Sana starts using her psychic powers to cause a scene!	A FAMILY EMERGENCY	01KGAD3G2JTYZP87FXJ88C3Q8C	9.0	2021-10-21T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 9	Tetsuya Imai 2020	2021-11-30T08:00:00.000Z
PRD_0MQWBGJWHMY0	CNT_04SGEEPMC940	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 4	[]	Alice & Zoroku Vol. 4	Sana's looking forward to hanging out with her friends, but before the fun can begin, the world turns strange and scary. Not only are the people around her acting creepy, but her Looking Glass won't come out, either! What will she do when she crosses paths with the kids who made everything go weird? Will reality ever go back to normality?	It's a Mad World!	01KGA3H7HMS2TX6Q7S8ZRFYQPD	4.0	2018-06-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 4	Tetsuya Imai 2014	2018-08-28T07:00:00.000Z
PRD_1QAWFV4EATC0	CNT_1H4DEMR0TN2G	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 8	[]	Alice & Zoroku Vol. 8	Long before Sana became a member of Zoroku's family, he had a wife named Chloe. Chloe was a mysterious woman who had powers very similar to Sana's. When a strange girl named Noemi shows up, she may just hold the key to what happened to Chloe.	A MYSTERY FROM THE PAST	01KG9F2H79VV2VR05AA4PR7YXR	8.0	2021-04-06T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 8	Tetsuya Imai 2017	2021-04-27T07:00:00.000Z
PRD_27QGC63SM3AG	CNT_2MPAEVCHPZB0	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 6	[]	Alice & Zoroku Vol. 6	Japan has been rocked by the revelation that powerful psychic children exist. While everyone else is trying to come to terms with the news, Sana is more concerned about starting at her new school with her new friends! Can Sana stay upbeat in a world that's terrified of her?	BRAVE NEW WORLD	01KGA7KQFJPF2MTN5ZFNBM32TJ	6.0	2019-09-25T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 6	Tetsuya Imai 2016	2019-10-29T07:00:00.000Z
PRD_2DF9JX5STCTG	CNT_32SMXHZRFGS0	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 7	[]	Alice & Zoroku Vol. 7	When Sana returns to check on Wonderland, she's surprised to find someone else living there. King is a near exact copy of Sana, except the mysterious boy has even more power and no sense of right or wrong. Can Sana stop him before he escapes Wonderland and is unleashed on the world?	KING VS. QUEEN!	01KG9D5AG86V4XYGVCGAFQPP4X	7.0	2020-09-09T07:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 7	Tetsuya Imai 2016	2020-10-20T07:00:00.000Z
PRD_2TTP0DXE8PVG	CNT_0DJGB9J83TZG	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 5	[]	Alice & Zoroku Vol. 5	Sana has the power to make anything she imagines a reality, but slowly she's been learning how to keep that power in check. Maybe that's why it ticks her off so much when she meets Hatori, a girl who lets her power run wild. When Sana tries to teach Hatori a lesson by trapping her in another world, Sana ends up trapped alongside her! Can the two girls work together to escape?	TRAPPED IN THE UNDERGROUND!	01KG9B09PVJ8S9STM5CY1A64A0	5.0	2019-01-20T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 5	Tetsuya Imai 2015	2019-02-26T08:00:00.000Z
PRD_2Y2SFXNVAH5G	CNT_24VXWKJGWARG	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 2	[]	Alice & Zoroku Vol. 2	Sana may have psychic powers, but she has a lot to learn about everyday reality! Luckily, she's got a stubborn old man named Zoroku at her side to help her figure out right from wrong. Life's still hard, though--and the appearance of Minnie C, a woman with amazing powers, has Sana backed into a corner. Trapped in a web of ruthless government organizations, it's getting harder and harder for Sana and Zoroku to know just which path to take.	When the Going Gets Tough	01KG9VREB5QC6PNPM9ZPV7M3T5	2.0	2017-10-01T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 2	(C) Tetsuya Imai 2013	2017-10-17T07:00:00.000Z
PRD_3KRR7KJRZJV0	CNT_16CZPGZD1VA0	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 1	[]	Alice & Zoroku Vol. 1	A group of young girls possesses a mysterious power known as “Alice's Dream,” which gives them the ability to turn their thoughts into reality. Detained and experimented upon, these youths are locked away in secret until one of them manages to escape. Her name is Sana - a girl with the power to ignore the very laws of physics. When this willful powerhouse crosses paths with a stubborn old man named Zoroku, his carefully-ordered life will never be the same again!		01KG9VMPR9FQ2QZB4AQY6N1W0H	1.0	2017-09-04T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 1	(C) TETSUYA IMAI 2013	2017-09-11T15:00:00.000Z
PRD_3WTK710F1EV0	CNT_3MW9WRF7DSW0	Alice & Zoroku CNT_19YGS3WVAAM0	CNT_19YGS3WVAAM0	2	1	1	Volume 3	[]	Alice & Zoroku Vol. 3	It has been almost six months since Sana was captured. Though she is getting used to life with Zoroku and Sanae, trying to be a normal little girl is proving hard. She's not the only one having trouble, either--not only has another young girl awakened to the power of “Alice's Dream,” but the twins from the Lab are on the loose in the city.	Normal is Relative	01KGA1B0ZHQ00DKETMGWBG8H2C	3.0	2018-01-08T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Alice & Zoroku Vol. 3	(C) Tetsuya Imai 2014	2018-02-13T08: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);