What do readers think of The Original Daughter by Jemimah Wei? Write your own review.

Summary | Reviews | More Information | More Books

The Original Daughter by Jemimah Wei

The Original Daughter

A Novel

by Jemimah Wei

  • Critics' Consensus (5):
  • Readers' Rating (31):
  • Published:
  • May 2025, 368 pages
  • Rate this book

About this book

Reviews

Page 2 of 2
There are currently 16 reader reviews for The Original Daughter
Order Reviews by:

Write your own review!

Dee D. (Cleveland, OH)

Immersive read of Singapore culture
A compelling debut filled with emotion as it examines a dysfunctional family life. The writing is propulsive, and the chapters are short encouraging the reader to read just one more chapter! The description of Singapore life with the demanding pressures to be successful are heart wrenching. The characters were fully developed and felt real.

A terrific book for book clubs who may not be aware of Singapore culture and who want a character driven book. I am already looking forward to the next book by Jemimah Wei.
Connie_K

Grim and Surprisingly Relatable
The sansevieria plant is native to dry desert. The mother in The Original Daughter struggles to nurture and maintain her beloved sansevieria plant in the unbearably hot, humid, suppressive conditions of Singapore. This challenging effort parallels her relationship with her daughter Genevieve, the title child. By the same token, the sansevieria illustrates Gen's ever-growing belief that she was not where she belonged even though she was the original daughter.

Gen, her mother, father and paternal grandmother lived in a tiny one-bedroom flat in poverty-stricken Singapore. The atmosphere of hopelessness and lost autonomy is established early on when Gen tell us "There was no arguing with my grandmother, the apartment was hers." And it was ill-gotten at that...Gen found no inspiration in her family tree. Things only got more heated in the tiny apartment when Arin, an unknown granddaughter (child of a grandfather who was thought dead long ago) came to live with them. Arin's presence is the catalyst for the rest of the book.

The story is a character study of Gen as we live inside her thoughts, experiencing her impressions of her family members, and how she is mistreated by them. Her inability to forgive or accept imperfection and successes of those she wants to love is self-defeating and self-destroying. A sensitive reader will not escape unscathed.
Throughout the telling, descriptions of the environment and emotions are tactile and brilliant and bare. Its grim and relatable all at once.
Charlene H. (Dallas, TX)

Book Club Discussion Delight
There is so much in this story for a group to discuss. Is Genevieve the villain of her own life? Will she ever realize it? At what point does she stop being the parent-pleasing achiever and become a cruelly jealous failure? Is it Arin's injection into her family when Gen is 8 or her envy at Arin's later drive for achievement? Did the mother's ambition coupled with her father's lack of ambition send mixed messages of family loyalty? Is this story unique to Singapore or could it be set anywhere? "Who knows." (p.346)
Wei is off to a great start....It takes a really good writer to keep the reader in company with a truly obnoxious person for 346 pages! This reader just wanted someone to slap Gen and tell her to get over it long before the end.
One comment: A glossary is needed for terms (e.g., void deck?).
Eileen_Burmester

A Great Debut
"The Original Daughter" is a story that explores themes of friendship, sisterhood, competition, jealousy, and grief. The story is told from the perspective of Genevieve, who believed she was an only child until she discovered she had a younger half-sister named Arin. The novel follows the journey of the two sisters as they navigate their lives together. Although the story starts slowly, it gains momentum as the reader progresses. Writing character-driven stories can be challenging, and the author did a great job developing the characters in her debut novel.
I look forward to reading her next novel.
Melanie B. (Desoto, TX)

Thoughtful and Realistic
Gen and Arin's sibling relationship begins with a childhood "contract of sisterhood" that is constantly tested through young adulthood. Their desire to succeed within Singapore's highly competitive educational system and their mother's efforts to better herself and her daughters' lives creates lingering tension.

The author delivered an intriguing, honest depiction of the effects of sibling rivalry perpetuated by parental expectations and societal pressures. This is a thoughtful and realistic story. The characters are well -developed and believable. I recommend this book for group discussions.
Ellen C. (Boca Raton, FL)

Great for discussion
I can't say I liked this book because it is a disturbing story of a family ruined by jealousy and guilt. The author develops the reasons and outcomes using words thoughtfully. Such as, "…I felt like we were falling endlessly from a great height, our desperate arms locked around each other, both snare and salvation."

The twists of personalities and their actions will provide multiple topics and nuances to be interpreted and discussed. I've found that often my most stimulating book discussions come from books I didn't enjoy, but made me think about subjects often avoided. For this reason I give 4 stars.
Power Reviewer
Catharine L. (Petoskey, MI)

The Original Daughter
Living with her parents and grandmother in a one room flat in Singapore, Genevieve learns she has an unexpected sister, Arin, coming to live with them. The novel is about their sisterhood and the demands Singapore culture places on academic perfection. The girls become close and support each other in their studies. But when Genevieve drops out of the university, Arin continues to excel, and eventually betrays Genevieve's trust in her. The book revolves around their relationship with each other and mother and father.

I found the novel stressful and intense; yet, I couldn't put it down. I will remember the family for a long time.
Stephanie K. (Glendale, AZ)

Origins in the Original Daughter
The Original Daughter by Jemimah Wei is a chronicle of a "first" child who has trouble reconciling with the second one, another daughter. Many will be able to identify with being the "original" (elder) child in the family until a usurper for the parents'/grandparents' affections comes along. In this novel, I appreciated the raw honesty of feelings between the Singaporean sisters.

Their uncertainties and jealousies provide the drama and impetus for the story as they each struggle in their own way to cope and succeed. Those readers with either a younger or older sister will both laugh and cry over the broad range of emotion displayed between the two girls. As with most families, the hurts and differences they have only expand, rather than contract, as they grow older.

I liked that the author didn't try to hide or diminish the bad feelings between the sisters but brought them forward such that we nod our heads in recognition. This is certainly a universal tale in that we all move toward our siblings and then away, uneasy with both complete hatred or total love.
  • Page
  • 1
  • 2

More Information

Read-Alikes

BookBrowse Book Club

Book Jacket
The Cover Girl
by Amy Rossi
Find them early enough, and they will always be her girls.

Members Recommend

  • Book Jacket
    The Sister's Curse
    by Nicola Solvinic
  • Book Jacket
    The Lost Story of Eva Fuentes
    by Chanel Cleeton
    A mysterious book links three women across generations in this novel by New York Times bestselling author Chanel Cleeton.
  • Book Jacket
    The Vanishing Place
    by Zoë Rankin
Who Said...

Beliefs are what divide people. Doubt unites them

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /reader_reviews/index.cfm
Time Stamp 01-Jun-26 01:55 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780322102968 ms 1.78032210297E+012 ms 1 /root/website/app_server.cfm
1564 ms 1564 ms 1 /root/website/reader_reviews/index.cfm
434 ms 434 ms 1 /root/website/app_layout.cfm
418 ms 418 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
278 ms 278 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
254 ms 127 ms 2 /root/website/adsystem/adsystem_mod.cfm
187 ms 187 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
156 ms 156 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
153 ms 153 ms 1 /root/website/app_globals.cfm
129 ms 129 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
128 ms 128 ms 1 /root/website/adzones/AdZone6.cfm
127 ms 127 ms 1 /root/website/adzones/showcase_track.cfm
71 ms 71 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
71 ms 71 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
70 ms 70 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
57 ms 57 ms 1 /root/website/queries/qry_get_active_obc.cfm
52 ms 52 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
42 ms 42 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
40 ms 40 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
32 ms 32 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
27 ms 27 ms 1 /root/website/act_check_login.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_member_info.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
18 ms 18 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
14 ms 14 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_obc_number.cfm
10 ms 10 ms 1 /root/website/act_libraryIPLogin.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_competition.cfm
5 ms 5 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
3 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/Application.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/reader_reviews/dsp_views.cfm
0 ms 0 ms 1 /root/website/site/blocks/act_book_view_tracking.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1565 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:55:02.002
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 13:55:03.003
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

adactive (Datasource=bookbrowse_com_new, Time=13ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:55:03.003
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 13:55:03.003
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:55:03.003
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:55:03.003
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:55:03.003
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 13:55:03.003
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:55:03.003
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:55:03.003
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=44ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:55:03.003
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()
get_book_number (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/reader_reviews/index.cfm @ 13:55:03.003
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_reader_reviews_power_reviewers (Datasource=bookbrowse_com_new, Time=0ms, Records=50, Cached Query) in /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm @ 13:55:03.003
SELECT 		top 50 reader_review_reviewer_email_address, count(reader_review_reviewer_email_address) as "count"
	FROM 		reader_reviews
	WHERE 		reader_review_reviewer_email_address like '%@%'
	AND 		reader_review_reviewer_email_address <> 'reviews@bookbrowse.com'
	GROUP BY 	reader_review_reviewer_email_address
	
	
	ORDER BY 	count desc
get_preview_by_id (Datasource=bookbrowse_com_new, Time=37ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 13:55:03.003
select 			a.ezine_preview_number,
				a.ezine_number, 
				a.ezine_preview_category_number, 
				a.ezine_preview_title, 
				a.ezine_preview_subtitle, 
				a.ezine_preview_author, 
				a.ezine_preview_publisher,
				a.ezine_preview_publish_dt,
				a.ezine_preview_number_of_pages, 
				a.ezine_preview_jacket_image,
				a.ezine_preview_reviews,
				a.ezine_preview_short_summary,
				a.ezine_preview_jacket_desc,
				a.ezine_preview_reading_guide,
				a.ezine_preview_bb_comments, 
				a.ezine_preview_isbn,
				a.ezine_preview_isbn13,
				a.ezine_preview_rating,
				a.ezine_preview_bb_link,
                a.ezine_preview_bb_author_link,
                a.ezine_preview_firsts_flag,
                a.ezine_preview_reading_level,
                a.ezine_preview_paperback_flag,
				b.*,
                c.ezine_dt, c.ezine_description
,(select publisher_holding_company from publishers where ezine_preview_publisher like publisher_imprint AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
 				
from ezine_previews a 
inner join ezine_preview_categories b ON b.ezine_preview_category_number = a.ezine_preview_category_number
left join ezines c ON c.ezine_number = a.ezine_number

where ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 13:55:03.003
select a.book_award_number, a.book_award_name, a.book_award_image, c.book_award_dt
    from book_awards a 
    inner join book_awards_category b on b.book_award_number = a.book_award_number
    inner join book_awards_mapping c on c.book_awards_category_number = b.book_awards_category_number
    where ezine_preview_number =  ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=156ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 13:55:03.003
SELECT	(CAST(AVG(CAST(rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) >= 50 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
			ELSE 0
			END) AS "avrating",
            count(rating) as "ratcount"
            
	FROM (
		SELECT reader_review_rating AS rating
		FROM reader_reviews
		WHERE ezine_preview_number = ?
		
		AND reader_review_rating > 0
		
		UNION ALL
		
		SELECT reading_list_book_rating AS rating
		FROM reading_lists
		WHERE book_number LIKE 'p%'
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) = ?
		AND reading_list_book_rating > 0
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) IS NOT NULL
	) combined_ratings
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189
Parameter #2(CF_SQL_INTEGER) = 21189

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=187ms, Records=16) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 13:55:03.003
SELECT 		a.reader_review_number, a.book_number, a.ezine_preview_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.ezine_preview_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    FROM 		reader_reviews a
    INNER JOIN	ezine_previews b ON a.ezine_preview_number = b.ezine_preview_number
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number
	WHERE 		a.ezine_preview_number = ?
    AND			a.book_number = 0
    AND 		a.reader_review_approved_flag = 1
    

	ORDER BY a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_arc_idfk (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:55:03.003
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 21189

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=28ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:55:03.003
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1 AND a.discourse_flag = 0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 21189

obc_discussions (Datasource=booktalk_new, Time=266ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:55:03.003
SELECT 		t.name,
                m.title, m.body,
                u.username, t.id,
				(SELECT COUNT(*) from booktalk_messages where threadidfk = t.id) AS	"responses"
                
    FROM 		booktalk_forums f
    INNER JOIN	booktalk_threads t on t.forumidfk = f.id
    INNER JOIN	booktalk_messages m on m.posted = t.lastpostcreated
    INNER JOIN	booktalk_users u on u.id = m.useridfk
    
    WHERE 	f.id = ?
    AND 	f.active = 1
	AND		t.active = 1
    
    ORDER BY t.name, t.messages DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

searchResults (Datasource=bookbrowse_com_new, Time=105ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:55:03.003
SELECT book_number, post_id, topic_id, blurb, username, topic_title
					FROM DiscourseSearchResults
					
        WHERE 		book_number = ? 
                    AND topic_id IS NOT NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p21189

ya_check (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 13:55:03.003
select ezine_preview_reading_level 
from ezine_previews 
where ezine_preview_number = ?
and ezine_preview_reading_level = 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_books_by_brief (Datasource=bookbrowse_com_new, Time=32ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 13:55:03.003
select 			top 20
				a.ezine_preview_reading_level,
				b.category_name,
				c.category_number, 
				d.book_number, d.book_title,
				f.author_number, f.author_first_name, author_middle_initial, author_last_name
				
from 			ezine_previews a 
inner join		categories b on b.ezine_preview_category_number = a.ezine_preview_category_number
inner join		category_book_mapping c on c.category_number = b.category_number
inner join		books d on d.book_number = c.book_number
inner join		book_author_mapping e on e.book_number = d.book_number
inner join		authors f on f.author_number = e.author_number

where			a.ezine_preview_number = ? 

order by 		d.book_number DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 21189

get_author_bookcount (Datasource=bookbrowse_com_new, Time=32ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 13:55:04.004
select		b.book_title as "title", 1 as "bb_flag", b.book_number as "number"
        from		book_author_mapping a
		inner join	books b on b.book_number = a.book_number
        where		a.author_number = ?
union
    	select		c.ezine_preview_title as "title", 0 as "bb_flag", c.ezine_preview_number as "number"
        from		ezine_previews c
        where		c.ezine_preview_bb_author_link = ?
        and			c.ezine_preview_bb_link = 0
		and 1=0
order by title DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0

get_obc_number (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_obc_number.cfm @ 13:55:04.004
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 21189.0

IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'ddriscole@bakerlaw.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'crk.sck@verizon.net'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'howellcw@gmail.com'
IsPowerReviewer (Datasource=, Time=8ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'eileen@booksrusonline.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'melabold@aol.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'ellenredmax@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'cam.lowe1945@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 13:55:04.004
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'stephaniekana@aol.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:55:04.004
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1
and getdate() <= dateadd(day,1,a.arc_off_ad_dt)

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=49ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:55:04.004
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=83ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=70ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:55:04.004
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=14ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 13:55:04.004
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112
Parameter #3(CF_SQL_VARCHAR) = 0
Parameter #4(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=23ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=86ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:55:04.004
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/reader_reviews/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D4102614%26CFTOKEN%23%3Dd3790db3587582d7%2D22A5E48C%2DBE3A%2D1FD7%2D53755E1DA9F7B775%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A55%3A02%27%7D%23hitcount%3D154%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A54%3A33%27%7D%23cftoken%3D7ad58afe30f3459c%2D22A5DA26%2DD94D%2D5006%2D5C69CC155708315B%23cfid%3D4102611%23; CFID=4102614; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0; CFTOKEN=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/ezine_preview_number/21189/page/2/the-original-daughter
PATH_TRANSLATED=/root/website/reader_reviews/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/reader_reviews/index.cfm
SERVER_NAME=dev.bookbrowse.com
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=4102611
cftoken=7ad58afe30f3459c-22A5DA26-D94D-5006-5C69CC155708315B
hitcount=161
lastvisit={ts '2026-06-01 13:55:04'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:54:33'}
urltoken=CFID=4102614&CFTOKEN=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
view=books
Cookie Variables:
CFCLIENT_BOOKBROWSE=order=p#member_number=0#member_active_flag=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4102614&CFTOKEN#=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775#lastvisit={ts '2026-06-01 13:55:02'}#hitcount=154#timecreated={ts '2026-06-01 13:54:33'}#cftoken=7ad58afe30f3459c-22A5DA26-D94D-5006-5C69CC155708315B#cfid=4102611#
CFID=4102614
CFTOKEN=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
FREEACCESSCOUNT=0
Session Variables:
cfid=4102614
cftoken=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
sessionid=BOOKBROWSE_4102614_d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
urltoken=CFID=4102614&CFTOKEN=d3790db3587582d7-22A5E48C-BE3A-1FD7-53755E1DA9F7B775
URL Parameters:
ezine_preview_number=21189
page=2
the-original-daughter=
Debug Rendering Time: 17 ms