What do readers think of The Secret Lives of Baba Segi's Wives by Lola Shoneyin? Write your own review.

Summary | Reviews | More Information | More Books

The Secret Lives of Baba Segi's Wives by Lola Shoneyin

The Secret Lives of Baba Segi's Wives

A Novel

by Lola Shoneyin

  • Critics' Consensus (0):
  • Readers' Rating (42):
  • Published:
  • Jun 2010, 256 pages
  • Rate this book

About this book

Reviews

Page 3 of 3
There are currently 24 reader reviews for The Secret Lives of Baba Segi's Wives
Order Reviews by:

Write your own review!

Martha L. (Warner, NH)

Secrets and Struggles
The Secret Lives of Baba Segi's Wives was a First Impressions book from BookBrowse. It is by a Nigerian author, Lola Shoneyin and about a family in Nigeria. A man, Baba Segi has four wives. Each wife is name Iya and then the name of their oldest child, Iya Segi, Iya Tope, Iya Femi and his newest wife Bolanle. She is not named for a child as she has not had a child yet. The story is about the family and its struggles. Each wife have a secret that is part of the story. The secrets come out in various chapters as you read the book. Each secret is hidden from Baba Segi while he nominally knows all as the father. With the addition of the newest wife, previous secrets are exposed. Each step taken by a wife has ramifications that cause a whole series of other secrets to be exposed. The ending has a kick, which always makes a novel more interesting.

Lola Shoneyin's debut novel is one of passion and secrecy, fear and love, strength and weakness. Each characteristic played out over time in equal amounts in all characters.

I found the parts about the Nigeria that were shown in the books to be fascinating and horrifying. The accepted treatment of women in another culture never fails to make me grateful for the culture I have been raised in.
Beth K. (New York, NY)

A family of secrets
The Secret Lives of Baba Segi’s Wives takes place in present day Nigeria and tells the story of Baba Segi and his four wives and seven children. Much of the novel is narrated by Bolanle, the last wife. Her entrance into the family causes turmoil above and beyond the usual upheaval that occurs when a new wife is taken, as it exposes a secret that will change the family forever.

While the novel is set in an unfamiliar world, both geographically and culturally, the author makes you feel as though you know these people because the stories they live out and the emotions they display are common to people the world over. And because each of the women has a fully developed back-story that explains how they came to participate in the marriage, the reader easily understands why they act the way they do. Apart from the fact that the characters seem to jump off the page, the machinations of the family are fascinating. In particular, the first wife, Iya Segi, is wickedly Machiavellian in her running of the household, although her attempt to insure her place of superiority amongst the wives ultimately ends in tragedy for her.

Apart from the richly drawn characters, the author spins a gripping story that kept my attention throughout until the poignant ending. When I finished this book, I felt as though I were returning from a far-off world and while I’m glad to be home, I thoroughly enjoyed the journey.
Carol J. (Isle, MN)

Lives and Secrets
Lola Shoneyin's The Secret Lives of Baba Segi's Wives provided a realistic peek into the lives of 4 Nigerian women and the husband they share. I enjoyed getting to know the 4 women and their stories; how they each ended up married to Baba Segi and why. I also felt I received a small insight into the everyday Nigerian's life. Although, I found the use of local terms and language a little difficult to follow.
I felt myself loosing interest in the middle of the book. But I was glad that I finished the book in order to discern the secrets of each woman.

Overall, I would recommend the book. It did make me want to read some more books about Nigeria and the lives of the people there.
Pamela B. (Monona, WI, WI)

The Secret Lives of Baba Segi's Wives
The story surrounds the impact the addition of a fourth wife, Bolanle, has on Baba Segi's household. Bolanle is university educated, something the other wives are not. Not all is as it seems as jealousy and a family secret threaten them all. The book was a little difficult to read, as the chapters are written in first person from the view of each of the wives, and it is not always easy to determine which wife is "speaking".
Barbara B. (Alta Loma, CA)

Lies & Deception--Not Good Bedfellows
As I was initially introduced to the first three wives of Baba Segi, I did not really like them or care about them. Once they each told their story and how they became a wife of Baba Segi, I found some compassion for them, especially Iya Tope, who showed kindness to Bolanle.

The attitude toward Bolanle by the wives was not well developed enough for me and the "secrets" were too predictable.

I think book clubs would have much to discuss with this book with the different emotional themes.
Nikki M. (Fort Wayne, IN)

Desperate Housewives of Nigeria
Although enjoyable, this book didn't provide enough depth of the characters--it left me feeling rather unattached. It was a quick read which left me wishing that I had gotten more emotionally invested in the story. Some book clubs may enjoy it for a light summer read, but I prefer a little more to chew on!
Kathryn K. (Oceanside, CA)

The Real Housewives of Nigeria
The women who tell the story in The Secret Lives of Baba Segi’s Wives seem vaguely familiar! They demonstrate some of the worst traits that women can have – not unlike the TV reality series that some enjoy. As a huge fan of Chimamanda Ngozi Adichie and her unforgettable novels (Purple Hibiscus and Half a Yellow Sun), I looked forward to discovering another great African writer and learning more about Nigeria. What disappointed me about this book, although at times amusing, was how very little I learned. I also found it a tad difficult to identify the various ‘voices’ telling the story. Although not a bad read, to me it bordered on being ‘pulp’fiction. It’s not a book I would chose for the book discussion groups I lead.
Ann L. (Arnold, MD)

The Secret Lives of Baba Segi's Wives
The author presents the story of Baba Segi and his four wives by having each chapter narrated from the point of view of the different characters. It was interesting the way all the different narratives wove into an over all story. The author writes in a very descriptive, lyrical style. I especially liked her description of Baba Segi as a “flatulent pig”. It fitted him perfectly. However, there was way too much other detailed description of the workings of the characters’ digestive systems and bodily fluids. I think this book would have been better condensed into a short story form.
  • Page
  • 1
  • 2
  • 3

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...

The silence between the notes is as important as the notes themselves.

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 10:51 AM
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
1780311077586 ms 1.78031107759E+012 ms 1 /root/website/app_server.cfm
731 ms 731 ms 1 /root/website/reader_reviews/index.cfm
197 ms 197 ms 1 /root/website/app_layout.cfm
172 ms 172 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
123 ms 123 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
120 ms 60 ms 2 /root/website/adsystem/adsystem_mod.cfm
100 ms 100 ms 1 /root/website/app_globals.cfm
97 ms 97 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
88 ms 88 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
87 ms 87 ms 1 /root/website/adzones/showcase_track.cfm
68 ms 68 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
51 ms 51 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_active_obc.cfm
34 ms 34 ms 1 /root/website/adzones/AdZone6.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
14 ms 5 ms 3 /root/website/actions/act_spider_tracker.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_current_competition.cfm
12 ms 12 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
10 ms 10 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
9 ms 9 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_member_info.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_obc_number.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.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/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.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/queries/qry_get_reader_reviews_power_reviewers.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_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_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
733 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 10:51:17.017
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=8ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 10:51:17.017
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=8ms, Records=2) in /root/website/actions/adstatus.cfm @ 10:51:17.017
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 @ 10:51:17.017
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=9ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 10:51:17.017
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=6ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 10:51:17.017
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 10:51:17.017
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 @ 10:51:17.017
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=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 10:51:17.017
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=18ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 10:51:17.017
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=12ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 10:51:17.017
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=11ms, Records=1) in /root/website/reader_reviews/index.cfm @ 10:51:17.017
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5091

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 @ 10:51:17.017
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=7ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 10:51:17.017
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) = 5091

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 10:51:17.017
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) = 5091

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=171ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 10:51:17.017
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) = 5091
Parameter #2(CF_SQL_INTEGER) = 5091

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=67ms, Records=24) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 10:51:17.017
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) = 5091

get_arc_idfk (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:51:17.017
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) = 5091

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:51:17.017
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) = 5091

obc_discussions (Datasource=booktalk_new, Time=83ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:51:18.018
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=24ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:51:18.018
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) = p5091

ya_check (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 10:51:18.018
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) = 5091

get_books_by_brief (Datasource=bookbrowse_com_new, Time=8ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 10:51:18.018
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) = 5091

get_author_bookcount (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 10:51:18.018
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=6ms, Records=1) in /root/website/queries/qry_get_obc_number.cfm @ 10:51:18.018
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 5091.0

IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'm_lawton@conknet.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'Bethbaker406@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'carol1stmate@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'atomicranch23@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'bjbocan@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'nikkimcclain@hotmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'k.kupka@sbcglobal.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 10:51:18.018
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'annleipold@comcast.net'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 10:51:18.018
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=40ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 10:51:18.018
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=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=8ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 10:51:18.018
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=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 10:51:18.018
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=57ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:51:18.018
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=CFTOKEN=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8; CFID=4095820; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4095820%26CFTOKEN%23%3Ddccdbef06297075e%2D1C17A396%2DC984%2D2D85%2D0D24A74706DEBAC8%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2010%3A51%3A17%27%7D%23hitcount%3D10%23timecreated%3D%7Bts%20%272026%2D06%2D01%2010%3A51%3A14%27%7D%23cftoken%3D11c36d0a52756912%2D1C1792C3%2DD627%2D700C%2D57A27BE301DE789B%23cfid%3D4095816%23
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/5091/page/3/the-secret-lives-of-baba-segis-wives
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=4095816
cftoken=11c36d0a52756912-1C1792C3-D627-700C-57A27BE301DE789B
hitcount=16
lastvisit={ts '2026-06-01 10:51:18'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 10:51:14'}
urltoken=CFID=4095820&CFTOKEN=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8
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#=4095820&CFTOKEN#=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8#lastvisit={ts '2026-06-01 10:51:17'}#hitcount=10#timecreated={ts '2026-06-01 10:51:14'}#cftoken=11c36d0a52756912-1C1792C3-D627-700C-57A27BE301DE789B#cfid=4095816#
CFID=4095820
CFTOKEN=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8
Session Variables:
cfid=4095820
cftoken=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8
sessionid=BOOKBROWSE_4095820_dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8
urltoken=CFID=4095820&CFTOKEN=dccdbef06297075e-1C17A396-C984-2D85-0D24A74706DEBAC8
URL Parameters:
ezine_preview_number=5091
page=3
the-secret-lives-of-baba-segis-wives=
Debug Rendering Time: 110 ms