database: products: 13 rows where series_id = "CNT

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

13 rows where series_id = "CNT_0ZYVF29RDHB0"

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_05E72E8YP6Y0	CNT_1Q441P803T2G	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 6	[]	Saint Cecilia and Pastor Lawrence 6	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Volume Six features "The Story of the Girls Party," "How They Spent Their First Night Back in the Church Alone," and "The Trials of Saying Goodbye"!!	01KG9HCH2WMM1VQH4P0NVEEX2Z	6.0	2021-11-04T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 6	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-11-23T08:00:00.000Z
PRD_0AQ691XBTNK0	CNT_1XX19ZZQNZ3G	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 2	[]	Saint Cecilia and Pastor Lawrence 2	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a cozy little church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! The Saint wants to be a regular girl too! She spends her days giving guidance to those with doubts and worries, but she has a secret of her own: she has feelings for the priest she lives with... You won't want to miss this oblivious romantic comedy set in a world tinged with fantasy!! Highlights of the second volume include "the Saint in a ponytail," "the oblivious priest's jealousy," and "the appearance of a mysterious new character"!!	01KG9FQ3VYW0QZJB48XT7PY7F9	2.0	2021-07-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 2	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-07-27T07:00:00.000Z
PRD_0FT1RX32GXY0	CNT_2ZZ76EEV812G	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 5	[]	Saint Cecilia and Pastor Lawrence 5	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Volume five includes the short story "A Tale of Braiding and Flirting," and the largest scale story yet, "The Tale of Those Involved with the Tragic Saint," and even "The One Where They End Up in Swimsuits for Some Reason"!!	01KG9H7DM56XRWQETCQGNKB2KQ	5.0	2021-10-06T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 5	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-10-26T07:00:00.000Z
PRD_0G4K3BQ1R54G	CNT_0G10D4MQQS0G	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 13	[]	Saint Cecilia and Pastor Lawrence 13	At long last, Lawrence has declared that he wants to delve deeper into the Saint's life. Now that they've made that little bit of progress, what will happen to the happy pair...?! Volume 13 features "How Everyone Spends Their Time," "A Long-Awaited Reunion," and many more joyous tales!! The story that follows where the anime left off is even sweeter and more tantalizing! The two grow ever more precious to one another by the day in the latest volume of this unaware romantic comedy!	01KGBBTGDP200V73NGWGQCSTZT	13.0	2024-07-11T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 13	Hazano Kazutake/Kodansha Ltd.	2024-07-30T07:00:00.000Z
PRD_0MTMNNT95N2G	CNT_3T958AC2BQT0	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 9	[]	Saint Cecilia and Pastor Lawrence 9	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Now that these two have progressed to the point of "holding hands" (which is progress to them!), what lies ahead?! Volume 9 contains "The Tale of the Hidden Talent," "The Yet-Another Anxious Valentine's Day Story," and "The Time She Called Him 'Sensei,'" among others!!	01KGAGW2ERXW94KVMZ12D5YM66	9.0	2022-06-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 9	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2022-07-19T07:00:00.000Z
PRD_11A5MQ3J3PBG	CNT_1EX7N4XCSV8G	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 8	[]	Saint Cecilia and Pastor Lawrence 8	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Volume Eight features "The Making of a New Acquaintance," "Another Outing by Themselves," "All about Fortune Telling," and more!!	01KGAEDP1M51ZSJ2F236TE5RHN	8.0	2022-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 8	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2022-01-25T08:00:00.000Z
PRD_1Y2VD72KRX60	CNT_01TJHBR6R1AG	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 4	[]	Saint Cecilia and Pastor Lawrence 4	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! It's overprotectiveness vs. overprotectiveness! The saint cares so much for the priest that she secretly grants him holy protection after holy protection, and the priest cares so much for the saint that he does pretty much everything for her. In the fourth volume of the smash-hit oblivious romantic comedy, the sweetness gets even crazier!!	01KG9GY52H3435Y9V3Y573W8E5	4.0	2021-09-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 4	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-09-28T07:00:00.000Z
PRD_2871BDDCR08G	CNT_085M68HFD5BG	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 7	[]	Saint Cecilia and Pastor Lawrence 7	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Volume Seven features "When a Saint Becomes a Waitress," "The Case of the Haunted Habitation," "A Moving Story," and more!!	01KGADXWTMQTSBFB7X2TTXXF90	7.0	2021-12-15T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 7	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-12-28T08:00:00.000Z
PRD_2A0V76BDMFAG	CNT_38PJM36BX3N0	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 3	[]	Saint Cecilia and Pastor Lawrence 3	Once upon a time, there was a small church where a cute but lazy saint and an overprotective, oblivious priest who's a good cook lived. Please watch warmly over them as they don't get too close, but don't get too far from each other either. This unconsciously lovey-dovey romantic comedy set in a fantasy word now begins!! Sometimes people tease them, sometimes they watch over them warmly, but no one can just leave these two alone—not in this usually super sweet, sometimes serious fantasy romantic comedy! The third volume contains stories such as "her first exciting excursion," "the secret girls-only evening party," and "the super-sweet Valentine's chapter"!!	01KG9GQMK5NYF6MQ3C9AZKGR4Q	3.0	2021-08-19T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 3	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-08-31T07:00:00.000Z
PRD_2JA2WS5B78HG	CNT_0T56ZEAKC2EG	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 12	[]	Saint Cecilia and Pastor Lawrence 12	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Called by a prophetic dream, Cecilia returns to the home she shared with her grandmother. There, she speaks of the time when she was compelled to travel to the town where Lawrence lives... Contains the rest of the "Cecilia and the Saint" arc!!	01KGASZVSV45VEZSTJ69Q9YSHS	12.0	2023-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 12	Hazano Kazutake/Kodansha Ltd.	2023-10-31T07:00:00.000Z
PRD_2TT9RD6E5P00	CNT_3G0BMXYZHKE0	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 10	[]	Saint Cecilia and Pastor Lawrence 10	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! After a multitude of miracles, Lawrence's obliviousness is now a thing of the past...?! Volume 10 collects such stories as "How to Sort Your Heart with Flower Beds," "The Gang's Thorough Search for a Cat," "The One Where They Think Very Hard about Feelings," and many more!	01KGB4APJAKG00J0Y5XZM9DY8C	10.0	2023-01-20T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 10	Hazano Kazutake/Kodansha Ltd.	2023-01-31T08:00:00.000Z
PRD_2WHZVTDJQ0ZG	CNT_11SSZMJD1TP0	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 1	[]	Saint Cecilia and Pastor Lawrence 1	Saint Cecilia is beloved by the townspeople—not only is she elegant and composed, she benevolently shares her wisdom with all who seek it. That is, until the last person has left—at which point she becomes totally hopeless! Only Pastor Lawrence, is keeping the Saint put together enough to do her duties...and though she may test him, it's all in a day's work!	01KG9E90ZG0P0492J93JJ8RJ1V	1.0	2021-06-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 1	Saint Cecilia and Pastor Lawrence Hazano Kazutake/Kodansha Ltd.	2021-06-22T07:00:00.000Z
PRD_38XWFZCQ3ZBG	CNT_01Q9M622WZ70	Saint Cecilia and Pastor Lawrence CNT_0ZYVF29RDHB0	CNT_0ZYVF29RDHB0	2	1	1	Volume 11	[]	Saint Cecilia and Pastor Lawrence 11	A cute but lazy saint and an overprotective, oblivious priest who is a good cook live together in a small, out of the way church. Please warmly watch over their relationship that never gets too close or too distant. The curtain has been raised on this unaware romantic comedy in a fantasy-tinged world!! Lawrence realizes it's perfectly fine if he and the saint have their own definition of "family," but his troubles aren't over yet!! Volume Eleven features "That Time They Got Trapped," "The Tale of How They Met," and more!!	01KH3FN6T8S0EY51YECEJVQHVA	11.0	2023-07-12T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Saint Cecilia and Pastor Lawrence 11	Hazano Kazutake/Kodansha Ltd.	2023-07-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);