products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
4 rows where series_id = "CNT_1W7K4FP55540"
This data as json, CSV (advanced)
Suggested facets: 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_11MQWTS7WY50 | CNT_3DDGRZ4PXHE0 | Tale of the Waning Moon CNT_1W7K4FP55540 | CNT_1W7K4FP55540 | 2 | 1 | 1 | Volume 2 | [] | Tale of the Waning Moon, Vol. 2 | Enchanted by the Spirit of the Last Quarter Moon to follow in his footsteps, the beleaguered young Ryuka discovers en route that all kinds of men (with varying degrees of morality) are attracted to his body like bees to honey. But despite Ryuka's initial resentment of and rage at his fate, his feelings for the moon spirit Ixto are softening into something like...possibly...love? That said, finer feelings won't make his trials and tribulations on this lengthy journey any easier! Standing between Ryuka and Ixto is the door to the moon, a stolid, unmoving thing said to open only if certain conditions are met. However, completing this quest will put the chastity of both Ryuka and his traveling companions on the line! At this rate, will Ryuka even make it to the moon in one piece? | 01KG986BXWZW2T641Z190WXCYN | 2.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Tale of the Waning Moon, Vol. 2 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1X64H7ZXGZ60 | CNT_1A33SDEEEJD0 | Tale of the Waning Moon CNT_1W7K4FP55540 | CNT_1W7K4FP55540 | 2 | 1 | 1 | Volume 4 | [] | Tale of the Waning Moon, Vol. 4 | For breaking the rules and lending a helping hand to his beloved Ryuka, who is en route to the moon, the Moon Spirit, Ixto, finds himself a jailbird, imprisoned by the powers that be! And far from being understanding of his lover's sacrifice, Ryuka is hopping mad that Ixto took it upon himself to make such a drastic decision without consulting him first! Though Ryuka stubbornly continues on his celestial destination, do caustic words await these enchanted lovers at the end of the quest instead of sweet kisses?! | 01KG986GSV73T6HMDD9Q8F72ZW | 4.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Tale of the Waning Moon, Vol. 4 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_33FFBGE2YZNG | CNT_2DRT8P9JQ1YG | Tale of the Waning Moon CNT_1W7K4FP55540 | CNT_1W7K4FP55540 | 2 | 1 | 1 | Volume 3 | [] | Tale of the Waning Moon, Vol. 3 | Bewitched by a spell that makes him popular to individuals of the same sex (!!) and leads him to chase his enchanter - the moon spirit Ixto - the chagrined Ryuka persecutes himself for being unable to make his body do what he wants it to! Instead, his convoluted romance with Ixto rollicks to the next level! The two play at being lovers to obtain a treasure that just might help them break the curse that further complicates the relationship between Aldin and Ral, whose master-servant love is already troubled by the pair's difference in status! How far will the merry band of misfits have to go to make sure that love prevails?! | 01KG986F6WC613GG8E374SDC54 | 3.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Tale of the Waning Moon, Vol. 3 | 2016-08-18T15:00:00.000Z | 0 | 0 | ||||||
| PRD_37XZN384TYMG | CNT_0D2Q81ZV20ZG | Tale of the Waning Moon CNT_1W7K4FP55540 | CNT_1W7K4FP55540 | 2 | 1 | 1 | Volume 1 | [] | Tale of the Waning Moon, Vol. 1 | After a night of serious boozing, a jilted young man named Ryuka speakshis wish for true love atop a starlit hill. His words reach the ears ofIxto, the spirit of the last quarter moon, who decides to grant Ryuka'swish. Unfortunately for Ryuka, Ixto's handpicked selections to be theyoung man's lover are all men themselves! And when his rejection ofthese choices leads to an unexpected night of passion that casts aspell on him, will Ryuka give in to his enchanted body's urge to chaseafter Ixto and journey through worlds unknown, or will his mind winover his heart?Critically-acclaimed boys' love mangaka Hyouta Fujiyama lends hercopious talents to this wacky, role-playing fantasy-romance that willtickle your funny bone and tug at your heart! | 01KG6ZHJM3Y88XJ29KZBP36GXB | 1.0 | 2016-08-18T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | Tale of the Waning Moon, Vol. 1 | 2016-08-18T15:00:00.000Z | 0 | 0 |
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);