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

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_01X7HBKWJGBG	CNT_1YAZ6KX0N38G	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 6	[]	xxxHOLiC Omnibus 6	AS YOU WISH Yuko is gone and only remembered by a small few. Because of her disappearance, Watanuki takes it upon himself to run Yuko's wish-granting shop and vows to never leave it. Still inexperienced, he dedicates himself to helping everyone that stops by his shop-including the one that ate his right eye. Watanuki also must take special care not to get himself punished for assigning the wrong price for granting a wish. How long will he allow himself to perform Yuko's work? Will she ever return? This omnibus edition includes volumes 16-17 of XXXHOLiC!	01KG999K8FTZ0DG39MNEKPJNCW	6.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 6	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_04KPWYD6YZAG	CNT_3HNC6XK9029G	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 4	[]	xxxHOLiC Omnibus 4	FATAL ATTRACTION Watanuki just can't seem to get a break. Whenever he makes efforts to spend time with his beloved Himawari, he's given an excuse-or worse yet, he ends up alone with Domeki. But when Watanuki finally gets a little more quality time with the girl of his dreams, he comes to discover the reason behind her constant avoidance and personally experiences the disastrous consequences of getting too close to her. From the Trade Paperback edition.	01KG999J9G31WDQZ72QCWH49P8	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 4	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_0B01FHF8TY9G	CNT_1GZS6F9HF1AG	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 2	[]	xxxHOLiC Omnibus 2	THE SPIRIT OF VALENTINE'S It's Valentine's Day-and while Domeki is showered with chocolates and cards from girls, Watanuki has been tasked by Yuko to make chocolate cakes for her to give out as gifts, one of which is gifted to Watanuki himself. Watanuki takes this opportunity to express his feelings to Himawari through his culinary creations but through a strange turn of events finds out that his chocolates can be more than just sweets. This omnibus edition contains volumes 4, 5, and 6 of xxxHOLiC. From the Trade Paperback edition.	01KG999H4HYWAEBQYFR0V6D6RF	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 2	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_23NZR10ZMHM0	CNT_0YNRQ93WCKZ0	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 7	[]	xxxHOLiC Omnibus 7	CAGED BUTTERFLY The longer Watanuki resides over the shop, the stronger he gets and the more he learns to rely on his friends in the way his friends have relied on him. But as his powers grow with the passing of years, his memories of Yuko also grow distant. Will the current shop master ever be reunited with its former owner and will Watanuki ever be able to leave the shop? Find the answers to these questions and more in the final omnibus of xxxHOLiC.	01KG999ME41DNNWT8P5HGPZS4K	7.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 7	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_26AEBM21GGV0	CNT_2HZNPMR4VJR0	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 5	[]	xxxHOLiC Omnibus 5	WAKING DREAMS Unable to understand spirits' attraction towards him nor the names of his own parents, Kimihiro is an enigma even to himself. His boss, the dimension witch Yuko, may hold the answers Kimihiro seeks. However, his missing past has a price. Kimihiro must uncover his memories to continue moving forward, but his future under Yuko's tutelage grows uncertain. The secrets of Kimihiro's existence are revealed, while the mysteries that surround Yuko's continue to grow. From the Trade Paperback edition.	01KG999JSCTPGCKB8VZQASJQ11	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 5	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_29990VYDRYS0	CNT_2GMZHG4NNGT0	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 1	[]	xxxHOLiC Omnibus 1	Kimihiro Watanuki is haunted by visions of ghosts and spirits. He seeks help from a mysterious woman named Yuko, who claims she can help. However, Watanuki must work for Yuko in order to pay for her aid. Soon Watanuki finds himself employed in Yuko's shop where he sees things and meets customers that are stranger than anything he could have ever imagined.	01KG98DW8PGNTDFQN8PDCSNY8E	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 1	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2ARYN8WBWZT0	CNT_0HA2P6ED6HS0	xxxHOLiC Omnibus CNT_1V1TJ1E4V4S0	CNT_1V1TJ1E4V4S0	2	1	1	Volume 3	[]	xxxHOLiC Omnibus 3	AN EYE FOR AN EYE Working in the shop of the dimension witch Yuko, Kimhiro Watanuki has yet to see a mundane moment. The good, evil, and just plain weird all seem to have an unwavering attraction towards Watanuki, though the feeling is not mutual. These daily troubles can vary from crushes by pretty house spirits like the Zashiki-Warashi to cursed grudges, mysterious evils, and man-eating nightmares. Luckily, Watanuki has begrudgingly found an unlikely ally in his rival Domeki, but could this bring even more chaos than he's bargained for? From the Trade Paperback edition.	01KG999HN45XTHZKSBYYRKWZV4	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	xxxHOLiC Omnibus 3	(C) CLAMP / Shigatsu Tsuitachi CO., LTD. / Kodansha Ltd.	2016-10-25T07: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);