Read advance reader review of Above the Salt by Katherine Vaz, page 4 of 4

Summary | Reviews | More Information | More Books

Above the Salt by Katherine Vaz

Above the Salt

A Novel

by Katherine Vaz

  • Critics' Consensus (12):
  • Readers' Rating (59):
  • Published:
  • Nov 2023, 432 pages
  • Rate this book

About this book

Reviews


Page 4 of 4
There are currently 28 member reviews
for Above the Salt
Order Reviews by:
  • Kay D. (Strongsville, OH)
    Slow Start to a Beautiful Read
    Overall, I enjoyed this book. The beginning was a bit tough for me and didn't catch me into the storyline, however, that soon changed. This is an epic book with a long and winding story that is beautifully written. Sometimes confusing due to the construction of the novel with bounding around between characters and time, I did find myself paging back to catch a detail that I missed. It is an ode to love in the purest forms and focuses on the powers that kind of love can hold. Well worth reading. Recommended for book clubs as there is a lot of potential for discussion points throughout.
  • Stephanie K. (Glendale, AZ)
    Above the Ordinary Novel
    Above the Salt by Katherine Vaz acquaints us with Madeirans John Alves and Mary Freitas, two refugees from the Catholic and Protestant conflicts who flee to the U.S. This lyrical, poignant story relates in touching detail how John and Mary are separated time and time again yet reunite several times. Set during the time of Abraham Lincoln's ascent to the Presidency and the Civil War, it ties in the suffering of two individuals with the angst of an entire nation. Readers will laugh and cry at the humanity and the depravity of the characters in this story.
  • Ilene M. (Longmont, CO)
    Too long and too scattered
    I have to agree with the other reviewers who wrote that this book is too long and too scattered. While I was interested in the religious differences of people on Madeira, which is the basis of the book, I found that the writing was average and the subject matter too scattered. I would not recommend this book to readers.
  • Lynne Z. (San Francisco, CA)
    Where is the Editor?
    Although there are things to like about Katherine Vaz's novel, After the Salt, it is an overly ambitious novel in need of major editing. As historical fiction, the descriptions of the Civil War, the religious hatred between Protestants and Catholics, and the racial and class struggles of Portuguese immigrants enrich the plot. However, the author's overuse of figurative and poetic language is disconcerting. These "lyrical" passages are often long and rambling and appear
    at inappropriate moments.

    In an epic novel, the passage of time needs smooth transitions. Moving back and forth with John and Mary's lives is detailed and well-written early in the book, but after Mary becomes pregnant with John's child and commits to her marriage with Edward, the time sequences do not flow. Long periods of time pass with little detail in between. For example, after the 1906 earthquake the story jumps to 1919 with Catherine and Zachary. For some time, it's not known know how they relate to the story or if they are connected to Mary and Edward. This is distracting.

    The characters are well-developed initially, but as time moves on less so. Mary's relationship with Edward is initially interesting because of their class differences. The dialogue between them is crisp. Edward is a contentious character, who always has excuses for his actions, but presents them convincingly. However, there seems to be an unexplained disconnect between someone who is always defending himself and later becoming the loving and devoted father and husband. The references to real people (e.g., Abraham Lincoln, Thomas Edison, Mary Pickford, etc.) feels contrived even if the novel is based on a true story that loosely connects these figures. The ending is heartwarming but seems rushed with a multitude of unbelievable coincidences.
  • Darra W. (Mendocino, CA)
    Too Much of a Good Thing
    On the plus side: In "Above the Salt," the author presents an interesting, well-researched (and to me, largely unknown) slice of 19th century history, particularly about the Catholic/Protestant unrest on the isle of Madeira and the mid-century Portuguese settlement of the American Midwest. But alas, the plot meanders, frequently overwhelmed by an overabundance of "poetic" language. This, plus a surprising lack of depth and motivation in a potentially intriguing cast of characters, lands "Salt" solidly--and sadly--in "average" territory.
  • Nancy K. (Perrysburg, OH)
    Mixed feelings about this book
    I had trouble getting into the rhythm of this book. There were many what I would call run on sentences. Such as, "Essays were invited to suggest a building, opus, or installation that might convert a lot in downtown Jacksonville, a gift from an anonymous donor, "into another manifestation of our aspirations, which are to infuse the future with charity, education, and civic vigor, not only in our fair town, but as an example to our country, in need of defining its soul. All this in one sentence! I other places there were some very short sentences. Example- "It is now." "It isn't " "It is not".
    Once I was able to get a rhythm with the varied sentences I enjoyed the book. There were some beautiful descriptions of the gardens. It also was fun to read the mentions of Lincoln and his wife and of Harriet Beecher Stowe. All in all I would give the book a 3.5.
  • Mary Jane D. (Arlington Heights, IL)
    Not impressed
    The summary of Above the Salt states it is an irresistible and sweeping love story that follows two refugees who flee religious persecution and reignite their romance in Civil-War America. It seemed like a good match for the type of story I like.

    However I was not impressed with the book. It was slow moving and had too many extraneous details. I found it confusing and cumbersome. I did not relate to the characters or their emotions and situations.

    Some of the descriptions of the Civil War were well written and presented some facts I didn't know.

    I can truthfully say I was not interested in finding out how John and Mary were able to reunite and I skimmed the last fourth of the book.

    Supposedly it was based on true facts but I think the story would have been better told in a shorter format without the extra verbiage.

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

He who opens a door, closes a prison

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 31-May-26 11:19 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
1780269541283 ms 1.78026954128E+012 ms 1 /root/website/app_server.cfm
883 ms 883 ms 1 /root/website/arc/arc_reviews/detail/index.cfm
186 ms 186 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
183 ms 183 ms 1 /root/website/app_layout.cfm
171 ms 171 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
157 ms 157 ms 1 /root/website/app_globals.cfm
141 ms 141 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
99 ms 50 ms 2 /root/website/adsystem/adsystem_mod.cfm
87 ms 87 ms 1 /root/website/queries/qry_get_active_obc.cfm
68 ms 68 ms 1 /root/website/adzones/AdZone6.cfm
68 ms 68 ms 1 /root/website/queries/qry_get_reviews_by_arc_id.cfm
47 ms 47 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
46 ms 46 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
34 ms 34 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
32 ms 32 ms 1 /root/website/adzones/showcase_track.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
23 ms 23 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_arc_by_id.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_competition.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
10 ms 3 ms 3 /root/website/actions/act_spider_tracker.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_obc_number.cfm
7 ms 7 ms 1 /root/website/act_check_login.cfm
7 ms 7 ms 1 /root/website/arc/arc_reviews/detail/dsp_briefshell.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_member_info.cfm
5 ms 5 ms 1 /root/website/arc/arc_reviews/detail/dsp_reviews.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/Application.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/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.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/queries/qry_get_current_ezine.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
884 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 23:19:01.001
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=6ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 23:19:01.001
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=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 23:19:01.001
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 @ 23:19:01.001
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=11ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 23:19:01.001
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 @ 23:19:01.001
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 23:19:01.001
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 @ 23:19:01.001
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=13ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 23:19:01.001
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=58ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 23:19:01.001
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=14ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 23:19:01.001
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=20ms, Records=1) in /root/website/queries/qry_get_arc_by_id.cfm @ 23:19:01.001
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) = 1075
Parameter #2(CF_SQL_INTEGER) = 1075
Parameter #3(CF_SQL_INTEGER) = 1075

get_reviews_by_arc_id (Datasource=bookbrowse_com_new, Time=67ms, Records=28) in /root/website/queries/qry_get_reviews_by_arc_id.cfm @ 23:19:01.001
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) = 1075

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=185ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 23:19:01.001
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) = 17979
Parameter #2(CF_SQL_INTEGER) = 17979

get_preview_by_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 23:19:01.001
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) = 17979

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 23:19:01.001
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) = 17979

get_arc_idfk (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 23:19:01.001
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) = 17979

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 23:19:01.001
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) = 17979

obc_discussions (Datasource=booktalk_new, Time=106ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 23:19:01.001
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=34ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 23:19:01.001
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) = p17979

ya_check (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 23:19:01.001
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) = 17979

get_books_by_brief (Datasource=bookbrowse_com_new, Time=14ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 23:19:01.001
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) = 17979

get_author_bookcount (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 23:19:01.001
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 @ 23:19:01.001
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 17979.0

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 23:19:02.002
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=33ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 23:19:02.002
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=37ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=22ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 23:19:02.002
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 @ 23:19:02.002
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 23:19:02.002
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=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%3D4076615%26CFTOKEN%23%3D6026eceb7c213ede%2D0355CF9E%2DBADE%2D6B6F%2DF1A2F9C2F31F7952%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2023%3A19%3A01%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D05%2D31%2023%3A18%3A59%27%7D%23cftoken%3D6026eceb7c213ede%2D0355CF9E%2DBADE%2D6B6F%2DF1A2F9C2F31F7952%23cfid%3D4076615%23; CFID=4076615; CFTOKEN=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
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/1075/page/4/above-the-salt
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=4076615
cftoken=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
hitcount=2
lastvisit={ts '2026-05-31 23:19:01'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 23:18:59'}
urltoken=CFID=4076615&CFTOKEN=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
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#=4076615&CFTOKEN#=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952#lastvisit={ts '2026-05-31 23:19:01'}#hitcount=2#timecreated={ts '2026-05-31 23:18:59'}#cftoken=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952#cfid=4076615#
CFID=4076615
CFTOKEN=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
Session Variables:
cfid=4076615
cftoken=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
sessionid=BOOKBROWSE_4076615_6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
urltoken=CFID=4076615&CFTOKEN=6026eceb7c213ede-0355CF9E-BADE-6B6F-F1A2F9C2F31F7952
URL Parameters:
above-the-salt=
arc_number=1075
page=4
Debug Rendering Time: 30 ms