products

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

20 rows where series_id = "CNT_3D53QFY3JVCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, description_short, listed_at, copyright, on_sale_at, listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_037MAK79EV00 CNT_1907FKNFHE30 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 2 []   LDK 2   LOVE RIVALS Aoi appears to finally be coming to terms with her feelings for Shusei. But before she can come to a conclusion, she witnesses a shocking scene between Shusei and a beautiful woman. However, it turns out that Shusei is not the only one who’s popular with the opposite sex, as a younger rival enters the fray and vies for Aoi’s attention. One boy is enough headache, but what will Aoi do with two gorgeous boys as love interests?   01KG98Z6YHKCQ0CR13FC3B71N1 2.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 2 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_0JB6VY1YZBG0 CNT_3RDN6YK0HXM0 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 19-20 []   LDK 19-20   LOVE TRIANGULATION Unable to hide his feelings for Aoi any longer, Leon finally confronts Shusei, and the situation in the shared household becomes tense. Meanwhile, the relationship between Shusei and Aoi comes to light, threatening to shake the very foundation of their once peaceful cohabitation! Will the three of them be able to come to an agreement, or will their love force them apart?   01KGB690NH44FBYPQJBAHYBC4S 19.0 2023-04-11T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 19-20 Ayu Watanabe/Kodansha Ltd.   2023-05-02T07:00:00.000Z   0 0
PRD_0R0NCDBX6X20 CNT_0PBXCPAYMG10 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 6 []   LDK 6   THREE’S A CROWD Things get complicated for Aoi and Shusei when Wataru, a fellow classmate, moves into the apartment building. Aoi wishes things could go back to how they used to be, but Shusei’s attitude is colder than ever… There’s also a special bonus story chock full of Shusei in sexy cosplay!   01KG98ZAGPBAG95QY72A0JD0E6 6.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 6 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_0WH5Z0572W10 CNT_39PAC1Z72F20 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 4 []   LDK 4   OH, BROTHER Having acknowledged her own feelings for Shusei, Aoi must now muster the courage to tell him that she likes him. But with Shusei’s popularity, will she be able to do anything before someone else snatches him up? Luckily, Shusei’s older brother comes into the picture and comes up with a way to light the flame of romance in Shusei’s heart, but his older brother’s unconventional plan may take things too far…   01KG98Z87N43CSJZCWKAEAH5YE 4.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 4 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_10XK15MRC1PG CNT_36VWZCEQ25WG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 12 []   LDK 12   Aoi and Shusei have overcome their latest hurdle, and the distance between their bodies and hearts is drawing closer! Both of them are more attracted to each other than ever, but the promise they made to Aoi's father continues to stand in their way...! CLOSE CONTACT 01KGA5DSGC3WT1PGVHFB41JKDH 12.0 2018-11-06T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 12 (C) Ayu Watanabe / Kodansha Ltd.   2018-11-13T08:00:00.000Z   0 0
PRD_13VD3KBYE070 CNT_3R5K80KTMCFG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 13 []   LDK 13   Despite some turbulent times, Aoi and Shusei's relationship is going well. Each day, they forge new memories together, and their love grows even stronger. One day, their neighbor Wataru gets a knock on the door..It's Shusei's older sister Eri, and she's in trouble! She’s on the run from a persistent ex and needs a place to crash. Wataru takes her in, and the two just might hit it off! SAFE HAVEN 01KGA5R2KVFKNCT50BETN1XN9G 13.0 2019-07-24T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 13 (C) Ayu Watanabe / Kodansha Ltd.   2019-08-27T07:00:00.000Z   0 0
PRD_1JZH85WEQNW0 CNT_0VR7P0PKYFZ0 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 21-22 []   LDK 21-22   THREE'S A CROWD Leon's departure from the apartment he shared with Aoi and Shusei leaves a noticeable hole in the couple's daily life, leading them to make a surprisingly serious decision. As rumors abound through the halls of their high school, the two decide it best to end their cohabitation until graduation, though all it does is lead to loneliness on Aoi's part. Noticing this, Soju (partially forces) Aoi out on a date to cheer her up while playing the part of the caring older brother to Shusei, only leading to more chaos.   01KH3GYBNAM39Y3SHVGB7FTT1Z 21.0 2023-09-26T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 21-22 Ayu Watanabe/Kodansha Ltd.   2023-10-17T07:00:00.000Z   0 0
PRD_1PGMWSJ9KJZ0 CNT_3QF197RHRWQG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 16 []   LDK 16   It's back to school after a summer full of love for Aoi and Shusei! While they keep up the charade of hiding their relationship and living arrangement, an unexpected player joins in on the game. Shusei's cousin, Leon, from America surprises them—and it's to the delight of all the girls at school, too! The boys have a score to settle and the stakes are high for Aoi. Will Shusei up his game to prove his love for Aoi—and can she meet Leon's high standards for acceptance?   01KG9FGEBAN0P307GB0QJ2EE2A 16.0 2021-05-19T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 16 Ayu Watanabe / Kodansha Ltd.   2021-07-20T07:00:00.000Z   0 0
PRD_1XKHZTG8BCEG CNT_2SH5XBX9D71G LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 23-24 []   LDK 23-24   RULES ARE MADE TO BE BROKEN Things are heating up as graduation approaches! Aoi and Shusei are still madly in love despite being forced to live separately as they spend their very first Christmas together as a couple. The two end up going to an amusement park on a date, and afterwards, Shusei makes a shocking decision in order to ensure they stay together-forever. As their story winds to a close, Aoi and Shusei will discover the true meaning of the word "family."   01KGASZYE1D03TPWSDVSZ3PEVF 23.0 2023-10-17T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 23-24 Ayu Watanabe/Kodansha Ltd.   2023-11-07T08:00:00.000Z   0 0
PRD_21CW3XPECVQG CNT_28NXZMGKQXWG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 1 []   LDK 1   LIVING, DINING, KITCHEN…LOVE? Aoi Nishimori is a high school girl who lives alone in her own apartment, but to her surprise, she discovers that the prince of her school, Shusei Kugayama, has moved in next door! To add to this, a series of crazy happenings result in the two living together under a single roof! Shusei is known to be a heartless guy and Aoi particularly hates him after he coldly rejected her best friend, so a life of cohabitation seems like a recipe for disaster. And yet, Aoi somehow can’t stop her heart from pounding when she’s with Shusei…   01KG9362GEFXWG8NC0MPDSS8CR 1.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 1 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_22YDGAM40WGG CNT_09B0WATB8YKG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 3 []   LDK 3   OH, BROTHER Having acknowledged her own feelings for Shusei, Aoi must now muster the courage to tell him that she likes him. But with Shusei’s popularity, will she be able to do anything before someone else snatches him up? Luckily, Shusei’s older brother comes into the picture and comes up with a way to light the flame of romance in Shusei’s heart, but his older brother’s unconventional plan may take things too far…   01KG98Z7RQNAX6WK0WNNZ2ZW5X 3.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 3 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_26A4YK70X7G0 CNT_2Y86E822DBWG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 15 []   LDK 15   After simmering in the pot of indecision, Aoi can wait no longer and lets go, unleashing her rage on Shusei. The warm, lovey-dovey summer of blissful, unspoken arrangements now gives way to the white hot hour of decision. However, Aoi's and Shusei's lover's spat is not the only romantic entanglement that needs resolution before summer's end...   01KGA97QSST20GH3NMWYW7RK71 15.0 2020-05-27T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 15 Ayu Watanabe / Kodansha Ltd.   2020-06-02T07:00:00.000Z   0 0
PRD_2HGT9FQ4FZB0 CNT_2ZT275KZ34F0 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 11 []   LDK 11   Shusei is the most handsome and popular boy at his high school -- and he's turned down almost every girl there, including Aoi's best friend. But when his apartment catches fire, he has to move in with his neighbor: Aoi! What will these unwilling roommates become to each other when forced to share an LDK?   01KGA3FTAZCYRNJ1NZF2ZNR3AR 11.0 2018-05-29T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 11 (C) Ayu Watanabe / Kodansha Ltd.   2018-06-26T07:00:00.000Z   0 0
PRD_2JZQATPNS93G CNT_2YNQ5W1WSXC0 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 17-18 []   LDK 17-18   IT TAKES THREE Aoi continues to hide her relationship and secret living arrangement with Shusei. Their love nest now includes Shusei's cousin, Leon. The three of them live together to convince Leon that Aoi is worthy of being Shusei's girlfriend. Tensions mount at home while the competitive spirit extends to their school's cultural festival where students vie for top rankings and social clout. Leon continues to capture the hearts of all the girls—but there's one special person who eludes him. Can Aoi reckon with her true feelings and manage what has truly become a love triangle?   01KG9H93QTAN2KXVYMTC57X0M7 17.0 2021-10-13T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 17-18 LDK Ayu Watanabe/Kodansha Ltd.   2021-11-16T08:00:00.000Z   0 0
PRD_2P9FDDNT8AVG CNT_12PCFGMBZCRG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 8 []   LDK 8   Shusei is the most handsome and popular boy at his high school ? and he’s turned down almost every girl there， including Aoi’s best friend. But when his apartment catches fire， he has to move in with his neighbor: Aoi! What will these unwilling roommates become to each other when forced to share an LDK?   01KG9YQF6VXXZ1Y6JQCH5VFSHD 8.0 2016-12-12T15:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 8 (C) AyuWatanabe / Kodansha Ltd.   2016-12-26T15:00:00.000Z   0 0
PRD_2VV2V4RZRYJG CNT_3PP6XDFTE0HG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 7 []   LDK 7   REBOUND TIME After Shusei’s troubling response to Aoi’s confession, she’s doing her best to adjust to life apart from him. In the space left by Shusei, Wataru is there to comfort Aoi and try to make her smile despite the heartbreak. But Wataru is struggling with his own feelings for Aoi, and his patience for being just a friend is wearing thin. Will Aoi be able to move on from Shusei and see a future with Wataru, or is her love for her former roommate just too strong?   01KG98ZB89QHG4NFBXFFECYGF9 7.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 7 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_2Y9X6QT24XHG CNT_1P0KWZ42XZJG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 5 []   LDK 5   BOY NEXT DOOR Aoi still secretly pines for Shusei’s affection but constantly worries that revealing her feelings to him will bring their living situation to an end. Meanwhile, a new neighbor moves into Aoi and Shusei’s building?and it’s a student from their high school! Will this new resident bring big changes to Aoi and Shusei’s secret cohabitation?   01KG98Z8SPAFKHASYEZTYPYWHJ 5.0 2016-10-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 5 (C) Ayu Watanabe / Kodansha Ltd.   2016-10-25T07:00:00.000Z   0 0
PRD_3HFC1ERW1EH0 CNT_14W477A8S7C0 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 10 []   LDK 10   FROM ROOMMATES TO CLASSMATES Although Aoi's father found out about their housing situation, Aoi and Shusei are still allowed to live together, but on one particular condition...Before long, the two of them begin their final year of high school, and end up in the same class. Now the couple will be together around the clock! However, with Shusei as a classmate, Aoi is disappointed to see a side of him that she's never seen before. She must balance her friendships, both new and old, but what will she do about her own roommate?!   01KG9Z8FEKPX7HKEQ7MEH5ZRXE 10.0 2017-07-24T15:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 10 (C) Ayu Watanabe / Kodansha Ltd.   2017-08-08T04:00:00.000Z   0 0
PRD_3K9ZJV103BW0 CNT_37JTK4699Y70 LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 9 []   LDK 9   FATHER KNOWS BEST? Aoi and Shusei have finally admitted their feelings openly and have decided to be together as a couple. In the midst of trying to balance their living situation with the added romance, the pair gets an unexpected visit from Aoi's father, a towering former bodybuilder! He is shocked by their cohabitation and threatens to put an end to the comfortable life she's gotten used to with Shusei. With all she holds dear on the line, will the couple be able to convince Aoi's father that this is a relationship worth fighting for?   01KG9YXX1GRW23RXPRC1X5VE0F 9.0 2017-03-13T15:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 9 (C) Ayu Watanabe / Kodansha Ltd.   2017-03-28T05:00:00.000Z   0 0
PRD_3KZPCPT4JS80 CNT_3P23Z4TWVVCG LDK CNT_3D53QFY3JVCG CNT_3D53QFY3JVCG 2 1 1 Volume 14 []   LDK 14   LOVEY-DOVEY DRAMA Aoi and Shusei's bond becomes ever stronger, adding to their already airtight love! But as the two of them grow closer, the lives of the people around them get turbulent. As Shouta pushes the brother he never wanted away, he stumbles upon Yudai's diary and makes a startling discovery. Meanwhile, Eri kisses Wataru as he pines over Aoi, leading to a night of releasing pent-up anger and passion. Eri finally decides to confess her love to Wataru, but there is no telling what he might do...   01KGA7QWB55CJFXK1X9CGNG9JM 14.0 2019-11-19T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG LDK 14 Ayu Watanabe / Kodansha Ltd.   2019-12-03T08:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);