Read advance reader review of A Thousand Pardons by Jonathan Dee, page 2 of 5

Summary | Reviews | More Information | More Books

A Thousand Pardons by Jonathan Dee

A Thousand Pardons

by Jonathan Dee

  • Critics' Consensus (0):
  • Readers' Rating (69):
  • Published:
  • Feb 2013, 224 pages
  • Rate this book

About this book

Reviews


Page 2 of 5
There are currently 35 member reviews
for A Thousand Pardons
Order Reviews by:
  • Elisabeth W. (Durham, NC)
    Landing On Her Feet
    I enjoyed A Thousand Pardons which is about a woman putting herself together professionally after being a stay-at-home mom knocked back by an unexpected divorce. A Thousand Pardons has a similar, contemporary feel to Freedom by Jonathan Franzen, but with less morose undertones. One of the reasons I related to this book is because it points up the financial vulnerability of the stay-at-home mom. It takes a lot of trust and courage to give up the ability to support yourself by letting go of your career to take care of children for the long term. I do think this book is targeted toward women 40-60 and would promote some interesting book club discussions!
  • Barbara W. (Watertown, NY)
    Confession is good PR
    Themes of transgression, confession and forgiveness are woven throughout this novel. The author also nimbly demonstrates how people in the most intimate of relationships can be so clueless about what the other person is really like. The fact that one character works in a public relations agency gives an uneasy picture of how character and truth can manipulated to fit our ideas of remorse and redemption.
  • Mimi F. (North Venice, FL)
    A Thousand Pardons
    I always am fascinated by the ability of a male writers to develop a plausible female character and I believe that Jonathan Dee accomplished that task. Helen was believable and likeable as the main character who faced with adversity copes and indeed excels as she recreates herself by being true to her basic tenets. I thought that Sara reacted as a teenager caught in that situation would and I found it easy to dislike Ben, but I did understand Helen's feelings at the end. I felt that the disjointed tableau involving Hamilton weakened a novel that was otherwise strong in character development.
  • Charles T. (Asheville, NC)
    Admit You're Wrong
    An engaging book where a woman, whose family has fallen apart because of her husband's attempted fling, finds herself working for a Public Relations firm and, through her personal honesty and candor, becomes an expert in crisis management for corporate accounts. The main theme of the book, and the title, revolves around the concept that if a company or an individual simply admits their wrongdoings there is a good chance they will be pardoned. The tactic is difficult for many of her clients to accept. Their first reaction is to bluff and stonewall and refuse to admit any responsibility for what has gone wrong. But the main character's sincere and calm advise, to admit mistakes and ask for forgiveness, convinces them to give it a try and it works. The theme of the book is clear but in most instances the characters glide through crisis and catastrophe without suffering appropriate consequences.
  • Viqui G. (State College, PA)
    A Thousand Pardons - Two Pardons in this Novel
    Helen Armstead, the housewife, mother turned PR expert is the main character of this novel. She is part of the two main overlying themes of the novel. First there is the theme of acceptance of blame and subsequent redemption. Both Helen's husband, Ben, and her old classmate, Hamilton, have severe breakdowns which cause them to behave badly. The breakdowns themselves are not the important part of the novel, but their mutual but separate need for redemption and even absolution and Helen's role in their achiving this redemption is the topic the author explores. Both these men find it necessary to clear their conscious and Helen helps them achieve this in different ways. The second theme is Helen's outstanding success at becoming independent and financially successful in the business world with no formal training. In her new job she also deals with her clients' blame and their acceptance of blame I applauded Helen's success and felt that Jonathan Dee wrote convincingly of her struggles and good fortune. Sub themes of teenage Sara's difficult adjustments and disappointments were interesting. The weakness in the novel was the incomplete resolution of Helen's challenge in her last assignment with the Catholic church. Her assignment was sensitive and extremely difficult (and perhaps too sensational to be believable) and Dee did not bring this part of the story to a reasonable conclusion. Overall, the novel was readable and enjoyable and Dee really brought the character of Helen to life.
  • Lauren T. (Orlando, FL)
    A Thousand Pardons by Jonathan Dee
    I haven't read any of Dee's other books, but I was expecting something stellar based on his previous success. I wouldn't say I found this book stellar, but it is a compelling read. The characters are, for the most part, ordinary people (albeit ordinary people who have jobs, a house in the suburbs, and plenty to eat). I found the subject of male midlife crisis interesting because of things that are happening in my life currently. There are some characters I felt could have been fleshed out a bit more to make the story more well rounded, but all in all I would recommend this book to anyone looking for a relatively quick, entertaining read about a family dealing with major life changes.
  • J W. (Davis, CA)
    Forgiveness
    This is a book of self forgiveness and forgiveness of others. It begins with a family - father, mother, daughter - living a typical suburban life. And then, because of boredom, that life falls completely apart. It's interesting that in the beginning the family unit is just existing in the house and, in the end, they are beginning to 'live' in the house.
    I found Helen's transformation authentic in the beginning. As it progressed, I found myself wanting to tell her to wake up! But, she is who she is and Hamilton explains that better than anyone else.
    All of the characters learned much about themselves and each other. In the end, all were changed in degrees and began to forgive each other and themselves. A good read.

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

Read the best books first...

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 /arc/arc_reviews/detail/index.cfm
Time Stamp 01-Jun-26 01:00 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
1780318832373 ms 1.78031883237E+012 ms 1 /root/website/app_server.cfm
1053 ms 1053 ms 1 /root/website/arc/arc_reviews/detail/index.cfm
327 ms 327 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
233 ms 233 ms 1 /root/website/app_layout.cfm
152 ms 152 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
149 ms 149 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
144 ms 144 ms 1 /root/website/app_globals.cfm
109 ms 55 ms 2 /root/website/adsystem/adsystem_mod.cfm
74 ms 74 ms 1 /root/website/adzones/AdZone6.cfm
62 ms 62 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
62 ms 62 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
53 ms 53 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
49 ms 49 ms 1 /root/website/queries/qry_get_active_obc.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
37 ms 37 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
36 ms 36 ms 1 /root/website/adzones/showcase_track.cfm
36 ms 36 ms 1 /root/website/queries/qry_get_reviews_by_arc_id.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_obc_number.cfm
20 ms 20 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
19 ms 6 ms 3 /root/website/actions/act_spider_tracker.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_competition.cfm
18 ms 18 ms 1 /root/website/act_check_login.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_member_info.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_arc_by_id.cfm
13 ms 13 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/site/blocks/layout/head.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
5 ms 5 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
3 ms 3 ms 1 /root/website/arc/arc_reviews/detail/dsp_briefshell.cfm
1 ms 1 ms 1 /root/website/arc/arc_reviews/detail/dsp_reviews.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_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/arc/arc_reviews/detail/dsp_views.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/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/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
13 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1066 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:00:32.032
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=16ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 13:00:32.032
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=10ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:00:32.032
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:00:32.032
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=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:00:32.032
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:00:32.032
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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:00:32.032
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:00:32.032
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=9ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:00:32.032
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=15ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:00:32.032
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=22ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:00:32.032
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_arc_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_arc_by_id.cfm @ 13:00:32.032
SELECT		a.arc_client_url,
			a.bc_active_flag,
			a.arc_forumidfk,
			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_number_of_pages, b.ezine_preview_isbn, b.ezine_preview_isbn13, b.ezine_preview_bb_link, b.ezine_preview_bb_author_link, b.ezine_preview_firsts_flag, b.ezine_preview_rating, b.ezine_preview_reading_level,
			c.ezine_preview_category_name,
			(select count(arc_allocator_review_rating) from arc_allocator	where arc_number = ? and arc_allocator_review_approved_flag = 1) AS arccount,
            
            (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 = ? 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
INNER JOIN	ezine_preview_categories c on c.ezine_preview_category_number = b.ezine_preview_category_number

WHERE		a.arc_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 347
Parameter #2(CF_SQL_INTEGER) = 347
Parameter #3(CF_SQL_INTEGER) = 347

get_reviews_by_arc_id (Datasource=bookbrowse_com_new, Time=36ms, Records=35) in /root/website/queries/qry_get_reviews_by_arc_id.cfm @ 13:00:32.032
SELECT		arc_number, arc_allocator_number, arc_allocator_review_dt, arc_allocator_reviewer_name, arc_allocator_review_title, arc_allocator_review, arc_allocator_review_rating,
			member_cc_city, member_cc_state

FROM		arc_allocator a
inner join	members m on m.member_number = a.member_number

WHERE		arc_number = ?
AND			arc_allocator_review_approved_flag = 1


	ORDER BY arc_allocator_review_rating DESC, arc_allocator_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 347

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=148ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 13:00:32.032
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) = 7716
Parameter #2(CF_SQL_INTEGER) = 7716

get_preview_by_id (Datasource=bookbrowse_com_new, Time=25ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 13:00:32.032
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) = 7716

get_author_name (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 13:00:32.032
SELECT author_number, 
        CASE WHEN datalength(author_middle_initial) > 0 then author_first_name + ' ' + author_middle_initial + '. ' + author_last_name
            ELSE author_first_name + ' ' + author_last_name
            END "author_name"
        FROM authors 
        WHERE author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2980

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 13:00:32.032
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) = 7716

get_arc_idfk (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:00:32.032
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) = 7716

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:00:32.032
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) = 7716

obc_discussions (Datasource=booktalk_new, Time=222ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:00:33.033
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=77ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 13:00:33.033
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) = p7716

ya_check (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 13:00:33.033
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) = 7716

get_books_by_brief (Datasource=bookbrowse_com_new, Time=44ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 13:00:33.033
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) = 7716

get_author_bookcount (Datasource=bookbrowse_com_new, Time=13ms, Records=4) in /root/website/queries/qry_get_author_bookcount.cfm @ 13:00:33.033
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
		
order by title DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2980
Parameter #2(CF_SQL_INTEGER) = 2980

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

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:00:33.033
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 @ 13:00:33.033
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=36ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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=26ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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=11ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:00:33.033
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 @ 13:00:33.033
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:00:33.033
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/arc/arc_reviews/detail/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=FREEACCESSCOUNT=0; CFGLOBALS=urltoken%3DCFID%23%3D4101136%26CFTOKEN%23%3D53ff486fd93ab57d%2D20B3F0BD%2DFEDF%2D691A%2D13443D6FCA10313D%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A00%3A32%27%7D%23hitcount%3D63%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A00%3A11%27%7D%23cftoken%3Dcb4b66cb776af61f%2D20B40990%2D0291%2DF421%2DFA5EF3CDF013A3A9%23cfid%3D4101142%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4101136; CFTOKEN=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
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=/arc_number/347/page/2/a-thousand-pardons
PATH_TRANSLATED=/root/website/arc/arc_reviews/detail/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/arc/arc_reviews/detail/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=4101142
cftoken=cb4b66cb776af61f-20B40990-0291-F421-FA5EF3CDF013A3A9
hitcount=68
lastvisit={ts '2026-06-01 13:00:33'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:00:11'}
urltoken=CFID=4101136&CFTOKEN=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
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#=4101136&CFTOKEN#=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D#lastvisit={ts '2026-06-01 13:00:32'}#hitcount=63#timecreated={ts '2026-06-01 13:00:11'}#cftoken=cb4b66cb776af61f-20B40990-0291-F421-FA5EF3CDF013A3A9#cfid=4101142#
CFID=4101136
CFTOKEN=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
FREEACCESSCOUNT=0
Session Variables:
cfid=4101136
cftoken=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
sessionid=BOOKBROWSE_4101136_53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
urltoken=CFID=4101136&CFTOKEN=53ff486fd93ab57d-20B3F0BD-FEDF-691A-13443D6FCA10313D
URL Parameters:
a-thousand-pardons=
arc_number=347
page=2
Debug Rendering Time: 57 ms