database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_2MMQ5WJ31BTG"

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_03SA1B4ZGNZ0	CNT_2JGQH1JRST5G	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 3	[]	Tarot Cafe Volume 3	More paranormal tales from the Tarot Cafe, including a sultan who wishes for nothing more than to learn what has become of his first love... an impoverished student falls in love with a lake fairy... two 700 year old dragons attempt to rekindle an ancient friendship...	01KG9CNPE8N1PA46N1S6T9QWM2	3.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 3	2020-06-30T07:00:00.000Z
PRD_0M5RTJF9C8T0	CNT_0GHGPTHZGWTG	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 6	[]	Tarot Cafe Volume 6	Alecto receives a dark prophecy from an old three-headed fortune teller. If he wants to tell Pamela the truth about his feelings, there will be dangerous consequences! While Pamela and Belus search for Alecto, Berial plays a game of chess with their lives--and Alecto and Pamela face a disaster from which neither can run...	01KG9CNVF71NNMHEK88SMQW502	6.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 6	2020-06-30T07:00:00.000Z
PRD_0RTB458K8QS0	CNT_2KWDP467ZVVG	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 5	[]	Tarot Cafe Volume 5	Pamela journeys to Scotland searching for the truth about her past. After using a perfume that reveals memories, she is repeatedly relives her most painful memory. Will she ever wake from this nightmare? Only Ash holds the answer, but Belus is the only one capable of getting it out of him before it is too late.	01KG9CNS339SXD73HQ77PWX4C3	5.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 5	2020-06-30T07:00:00.000Z
PRD_0Z8VQRANMPR0	CNT_0K6THQWGAV4G	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 2	[]	Tarot Cafe Volume 2	Meet Aaron, an accidental werewolf with a painful past of abuse and abandonment, seeking an answer to his problem. He decides to take a position as an assistant with Pamela at the Tarot Cafe while he searches for a solution. A glimpse into Pamela's life before the Tarot Cafe is laden with prejudice and persecution. 700 years ago Pamela's mother made the ultimate sacrifice for her daughter... but even now, is the fear that doomed her mother really gone?	01KG9CNR68E9N0K65YQM08A2Q9	2.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 2	2020-06-30T07:00:00.000Z
PRD_18B6RF6NTB5G	CNT_1YX34AM22GE0	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 1	[]	Tarot Cafe Volume 1	Meet Pamela, a tarot card reader who helps supernatural beings living in the human world. She'll help anyone, whether they're a love-stricken cat, a vampire spending eternal life running from his one true love, an unattractive waitress looking for the man of her dreams, or even a magician who creates a humanoid doll to serve the woman he loves. Although she is good-natured, there is a deep dark secret that she must deal with before she can move on to the next life.	01KG9C759P1TDCTFDG0JHJ97H7	1.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 1	2020-06-30T07:00:00.000Z
PRD_2KE1PN2229BG	CNT_1HJD760JZE80	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 4	[]	Tarot Cafe Volume 4	The spirit of Shandy visits Pamela's dreams in hopes of reconciling with his sister, Fay, before he leaves the earth forever. With a tragic past of betrayal, cruelty and eventual friendship, Shandy will do whatever it takes to make peace with the sister who's the cause of his unexpected death. Amongst these cries of lost love and unfinished business from visiting spirits, the poignant past of our Tarot Cafe owner unfolds. In a life rich with aiding spirits caught in her human world, is Pamela's only solace found in death?	01KG9CNXNC4ZG1CZHAHGFV6XKG	4.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 4	2020-06-30T07:00:00.000Z
PRD_2QWG09W4E8AG	CNT_3GWT6HPVAD90	The Tarot Cafe CNT_2MMQ5WJ31BTG	CNT_2MMQ5WJ31BTG	2	1	1	Volume 7	[]	Tarot Cafe Volume 7	In order to save a dying Belus, Pamela must travel to the Belial Dark Castle and end their feud once and for all. Reaching the castle will require the help of some old friends, but waiting for her there will be something she never expected.	01KG9CNWNS3JJNKN17SQF291HR	7.0	2020-06-25T07:00:00.000Z	Tokyopop LAB_2C2B4XAHKSHG	GEO_1PQM5BDYSMG0	Tarot Cafe Volume 7	2020-06-30T07: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);