What do readers think of Above the Salt by Katherine Vaz? Write your own review.

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 2 of 4
There are currently 31 reader reviews for Above the Salt
Order Reviews by:

Write your own review!

Molly O. (Aurora CO, CO)

A Must Read
What an astonishing novel this is. To describe its parts almost seems to diminish the whole that is so much more than the sum of its qualities. Beginning in the mid-19th century and continuing to the end, it is a chronicle of the vast changes taking place America and the turmoil of the Civil War. Ostensibly a love story between John and Mary that survives many obstacles, it is truly a love story of the power forgiveness. Mary's husband, Edward, is the archetype for that, continually displaying a capacity for infinite forgiveness and being rewarded with a lasting love. This saga is wrapped in such beautiful prose that I had to stop and reread so many passages. I can't recall such writing with so many original metaphors. What a treat it was to receive and read this book.
Dianne_Y

The story is good and the writing is spellbinding.
Above the Salt, a novel by Katherine Vaz, is a story of enduring love between two people. It is a complex story with related and tangential subplots focusing on religious strife, immigrants, inventions, war, horticulture, betrayal, loyalty, and family.

I found the title intriguing. "Salt" is referred to a number of times throughout the novel, and without giving anything away, the explanation of the phrase "Above the Salt" was fascinating.

Ms. Vaz is an excellent writer. She has a poetic and lyrical style. Her writing is descriptive, and she uses various short and interesting vignettes to keep the story moving.

The civil war is an important part of this novel, and I credit the author for providing authentic descriptions of the horrors of war, without being overly graphic or gratuitous.

I would compare this book to a movie where viewers say it is a good story and the cinematography is breathtaking. I would say this novel is a good story and the poetic and lyrical writing is spellbinding. There were times I simply savored the writing by reading it slowly or even twice in order to enjoy it as much as possible.

I would definitely recommend this book. I also believe it could be a good book club choice, as long as the members are willing to take the time to read a book over 400 pages and accept that they may want to read slowly or even go back and reread some of the passages. That being said, I do believe book club members would find the book lends itself to a great discussion.
Joyce_Montague

Exceptional novel highly recommended!
Above the Salt is a wonderful novel about Portuguese immigrants who migrated to America in the mid-19th century for a better life. It is an incredible love story that is full of commitment, romance, and respect for community. It is historical fiction based on a real person, John Alves, and incorporates many actual events such as Lincoln's presidency, the Civil War, racial prejudice, inventions, the earthquake in San Francisco, the plague in early the early 20th Century, and the beginning of World War I.

The manner in which the book is written, told mostly through the eyes of Mary and John, enables the reader to be in their shoes. All of the historical references serve as background information, giving the reader a sense of what ordinary people were going through on a daily basis during challenging times. The intense descriptive prose makes it easy to visualize and feel what the various characters were experiencing. Considering all the "ups and downs" in the story, I'm glad the author ended the book way she did.

I thoroughly enjoyed this book. It reminded me of Cutting for Stone by Abraham Verghese which I also really liked and look forward to reading his current novel. However, this book is even better! I give it 6 stars!!
Marie_Webb

Many Stories in One
This novel holds many stories. Stories of nature, love and loss, of old and new lands. Stories of slavery and war, poverty and wealth, loyalty and betrayal. The book is timely. Immigrants sail to America, fleeing religious war on the Portuguese island of Madeira. It has a magical quality, at times verging on the supernatural, as some events happen almost- but not quite- out of the realm of the possible.

The book is lyrical. The senses play a major role without detracting from the story. It is rich and many-layered, but not difficult to follow the characters or storyline. The characters feel real. At times I wanted to warn or admonish them for their decisions, just as I would in real life.

The book is set in the 1800's. The writing is gorgeous, the times and places vividly portrayed. The story could be described as a saga of lives coming together and apart, striving to reconcile their heart's desire with sober, sometimes cruel, reality.

If I have one criticism it would be that at times the author waxes lyrical when I would have preferred prose to poetry. But I truly enjoyed this novel, and I think book clubs with serious readers would find a lot to like and discuss.
Catherine_O_Callagha

Epic Novel
Above the Salt is unlike any novel I have ever read. The author creates a tale that follows the main characters across oceans and continents, through wars and disasters. The writing style was a bit difficult at first, but soon became almost like a lullaby with its vivid descriptions and lyrical rhythms. The world inside this novel is so encompassing that even after over 400 pages, I was sad to turn the last page. This is a magical tale that will stay with me. I believe that Above the Salt will appeal to anyone who likes fiction full of engaging characters, wound through with accurate historical details, and an unpredictable but believable plot.
Francine E. (Shirley, NY)

The Pursuit of Love
On the Portuguese island of Madeira, in the year 1840, five year old John Alves starved in jail alongside his mother, Serafina. She was a Presbyterian who refused to denounce her faith. "Music would feed them, they would feast upon sounds...".

Augusto Freitas, a Catholic, led the protest to free John. Augusto was head gardener of a Botanical Garden owned by aristocrats. He lovingly cared for the plants and was devoted to his daughter, Maria.

Sparks of friendship ignited between John and Maria, however, contact was lost when unrest between Catholics and Protestants caused each family, separately, to seek refuge in America.

Maria had a gift for Madeiran needlepoint work. "Maria plies threads..." She and her father cultivated plants. "On days dedicated to the trees, he wears a bowtie, because in Portuguese it is called a butterfly and the trees appreciate that...he grows a shrub with glossy dark pointed leaves and red berries...the miracle-berry or miracle-fruit plant." The father-daughter team would try to transplant the miracle shrubs in America.

New beginnings in Springfield, Illinois. John Alves studied sign language. He worked on his Sound Machine. "If only the Sound Machine could capture the gestures and swaying of his students and let the music be felt through the floor so deafness is not a prison...they would feast upon sounds...music would feed them...the melody of birds...to my listening ears all nature sings...Men are studying about capturing sounds...".

Augusto Freitas was a "maestro" of plants with a specialty in grafting. He was employed as head gardener on Edward Moore's estate. Edward's motto was "A WISHBONE ain't as likely to get ye as far as a BACKBONE." Augusto and Maria, worked side by side, trying to coax the transplant to root in this foreign soil. Success as master botanists would not entitle them to truly mix with Edward and his inner circle. They would always be viewed as "below the salt".

"Above the Salt" by Katherine Vaz is ultimately about the ebb and flow of love. Is love enough? Perhaps not, when hindrances were religious or societal. The outbreak of the Civil War compounded the obstacles and added the dimension of the plight of soldiers on both sides of the conflict in this all encompassing work of historical fiction. Altered communications and betrayals created twists and turns that were heartwrenching, if a tad soap opera-like. Highly recommended.

Thank you Flatiron Books and BookBrowse for the print ARC in exchange for an honest review.
Carrie_Marlowe

Above The Salt
An absorbing and engaging historical fiction covering multiple historic events. First, the Portuguese anti-Protestant movement on the island of Madeira that provides the back setting of the two main characters, John Alves and Mary (Maria) Freitas, who by chance meet and a make lasting connection, but both must flee the country to America. Thus, the premise of the plot is set, will they meet again? The reader follows the life adventures of all the characters, especially John as an American soldier and inventor working with Thomas Edison and Mary as the obedient wife of Edward, a wealthy businessman, and her work with her father, a famous botanist, plus her passion for fabric design, but many others as well. Not an easy read because of the multitude of storylines, subplots that one must follow, internal narratives and interactions between the characters, but it is essential for the plot development, and so that the reader can identify more readily with and feel for the characters, especially John and Mary, their supporters and enemies, and some famous people, including not only Thomas Edison but also Abraham Lincoln. These plot twists give the reader hope and wonderment of the destiny of characters during the other historic events the author interweaves so well: the American Civil War, the San Francisco earthquake, and other, more minor ones as well. What are their secrets for survival? Is it only marriage for Mary, and being a teacher for the deaf for John, and where and who will provide them support, and who must they support? Yes, John and Mary maintain contact, although not always successfully, but do they meet again and if so, is there a reason and who would orchestrate it? Overall, a highly recommended read, one which the reader receives a different understanding of historic events and some people’s contribution and view of these.
Linda_Z

An Amazing Historical Fiction Novel
Katherine Vaz, the author of "Above the Salt," has written a captivating, poignant, and memorable novel. The genres for this novel are Historical Fiction, Romance, Civil War, and Fiction. Katherine Vaz puts a magical feel in her prose, and this well-written story vividly describes the scenery, landscape, plot, and colorful and dramatic characters. John Alves and Mary Freitas are Portuguese refugees from childhood to late adulthood. Much of the background history deals with Catholics and Protestants friction and the time before, during, and after the Civil War. John spent part of his childhood with his mother, a Protestant martyr, in a jail in Madeira. John spent his young life in poverty and met Mary Freitas, an adopted daughter of a famous Botanist. As conflict and war between the two religions intensifies, both find themselves headed to America at different times. John becomes an educator for deaf students and experiments with ways to improve the student's learning mode. Mary and her father bring some "magical" plants to the United States and work as gardeners for Edward Moore, a wealthy landowner. Edward does help Mary with her business and would like to be engaged to her. Mary has not forgotten John Alves. When they do meet again, many things have changed. Some people are jealous and cause betrayal. The Start of the Civil War complicates the relationships. I appreciate how the author discusses the tragedies of the Civil War, the brutality, and the cost of lives. There were twists and turns and some unexpected and emotional surprises. I love the poetic images the author describes of nature and the symbolism of the characters. I highly recommend this thought-provoking and heartfelt novel to other readers. I found much of the background educational and became aware of some things I didn't know.
I look forward to reading more books from this author.

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

Experience is not what happens to you; it's what you do with what happens to you

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 05:21 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
1780334459598 ms 1.7803344596E+012 ms 1 /root/website/app_server.cfm
771 ms 771 ms 1 /root/website/reader_reviews/index.cfm
339 ms 339 ms 1 /root/website/app_layout.cfm
219 ms 219 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
156 ms 78 ms 2 /root/website/adsystem/adsystem_mod.cfm
115 ms 115 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
113 ms 113 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
104 ms 104 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
101 ms 101 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
92 ms 92 ms 1 /root/website/app_globals.cfm
85 ms 85 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
82 ms 82 ms 1 /root/website/adzones/showcase_track.cfm
81 ms 81 ms 1 /root/website/adzones/AdZone6.cfm
61 ms 61 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
57 ms 57 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
36 ms 36 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_active_obc.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
7 ms 7 ms 1 /root/website/act_check_login.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_competition.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_obc_number.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
4 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
3 ms 3 ms 1 /root/website/Application.cfm
3 ms 3 ms 1 /root/website/actions/adstatus.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_ezine.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.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/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_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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
776 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 17:20:59.059
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 @ 17:20:59.059
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=2ms, Records=2) in /root/website/actions/adstatus.cfm @ 17:20:59.059
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 @ 17:20:59.059
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=21ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 17:20:59.059
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 17:20:59.059
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 17:20:59.059
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 @ 17:20:59.059
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=4ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 17:20:59.059
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=4ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 17:20:59.059
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=6ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 17:20:59.059
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=1ms, Records=1) in /root/website/reader_reviews/index.cfm @ 17:20:59.059
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 17979

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 @ 17:20:59.059
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=3ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 17:20:59.059
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=2ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 17:20:59.059
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_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=57ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 17:20:59.059
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_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=42ms, Records=31) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 17:20:59.059
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) = 17979

get_arc_idfk (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 17:20:59.059
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=5ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 17:20:59.059
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=71ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 17:20:59.059
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 @ 17:20:59.059
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=1ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 17:20:59.059
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=3ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 17:20:59.059
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=4ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 17:20:59.059
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 @ 17:20:59.059
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 17979.0

IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:20:59.059
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'moconn1030@comcast.net'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:20:59.059
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'dyflorida@bellsouth.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'Atlanta22209@yahoo.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'marietwebb@yahoo.com'
IsPowerReviewer (Datasource=, Time=9ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'skippyoc@aol.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'mybeartoby2@yahoo.com'
IsPowerReviewer (Datasource=, Time=3ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'cmarlowe3@verizon.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 17:21:00.000
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'lzagon@yahoo.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=36ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 17:21:00.000
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=19ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 17:21:00.000
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=45ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 17:21:00.000
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 @ 17:21:00.000
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 17:21:00.000
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 @ 17:21:00.000
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 @ 17:21:00.000
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=28ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 17:21:00.000
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=34ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 17:21:00.000
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 17:21:00.000
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=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B; CFID=4109481; 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%3D4109481%26CFTOKEN%23%3Dafc7b1b2052e5078%2D2A07942D%2DA69B%2DFDBF%2D525D021038717D4B%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2017%3A20%3A59%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D06%2D01%2017%3A20%3A58%27%7D%23cftoken%3Dafc7b1b2052e5078%2D2A07942D%2DA69B%2DFDBF%2D525D021038717D4B%23cfid%3D4109481%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/17979/page/2/above-the-salt
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=4109481
cftoken=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
hitcount=2
lastvisit={ts '2026-06-01 17:20:59'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 17:20:58'}
urltoken=CFID=4109481&CFTOKEN=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
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#=4109481&CFTOKEN#=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B#lastvisit={ts '2026-06-01 17:20:59'}#hitcount=2#timecreated={ts '2026-06-01 17:20:58'}#cftoken=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B#cfid=4109481#
CFID=4109481
CFTOKEN=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
Session Variables:
cfid=4109481
cftoken=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
sessionid=BOOKBROWSE_4109481_afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
urltoken=CFID=4109481&CFTOKEN=afc7b1b2052e5078-2A07942D-A69B-FDBF-525D021038717D4B
URL Parameters:
above-the-salt=
ezine_preview_number=17979
page=2
Debug Rendering Time: 35 ms