What do readers think of Of Women and Salt by Gabriela Garcia? Write your own review.

Summary | Discuss | Reviews | More Information | More Books

Of Women and Salt by Gabriela Garcia

Of Women and Salt

by Gabriela Garcia

  • Critics' Consensus (1):
  • Readers' Rating (78):
  • Published:
  • Jan 2022, 224 pages
  • Rate this book

About this book

Reviews

Page 2 of 5
There are currently 38 reader reviews for Of Women and Salt
Order Reviews by:

Write your own review!

Gloria_Kelly

Of Women and Salt
My first encounter with Maria Isabel occurred in Chapter One while she was working in a cigar factory in Cuba. This vision catapulted me into Bizet's opera, Carmen. In my mind I was able to smell the tobacco and hear the voices of the factory workers as they tightly rolled tobacco into cigars. This book is a powerful narrative of women sharing their generational memories, secrets, and survival strategies. I was raised by my maternal grandmother who immigrated from Eastern Europe to the US. Like the characters in the book she told me bits and pieces of her life story. She survived two World Wars and the Great Depression. She told me of the hardships she endured as an immigrant living thousands of miles away from her family and country of origin .What she didn't tell me was what notions she had to give up in order to move ahead in her new role of wife, mother, grandmother and US citizen.. I often ponder what gave her comfort and support, as I ponder the issues and secrets of the generations of women in Of Women and Salt. It is my hope that you, the Reader will be challenged to research and examine the lives of the women in your family who came before you and contributed to the person you are to today.
Amy W. (Annapolis, MD)

Short Stories told together
I really enjoyed this book even though it was not a linear novel. Usually I do not like books that jump around in both points of view and time periods but the author made this one work. I enjoyed each snippet of each person's story. Just enough information was provided to hold my interest, keep the story together, and provide a backdrop of Cuba that made me want to learn more. I would recommend this book.
Kathleen_K

Lyrical Novel of Latina Women
Of Women and Salt is a book about unseen forces and how they shape us. For a relatively short book, it covers a lot of ground - two families and a timeline that crosses through many generations. We see the effects of generational trauma on several women, and witness the loss and gain of fortunes. Despite all of this, I never felt there was anything missing or any confusion while reading this lyrical novel. The settings are rich, from Cuba to the U.S., and the characters are complex and interesting. Readers should be aware that Garcia does tackle some difficult topics that may not be for everyone - addiction, sexual abuse, and death, to name a few. Still, there is hope and beauty in this book, and the beginning and ending of the story have a wonderful (yet realistic) symmetry. I highly recommend this novel and I look forward to reading more from this fabulous debut author.
Martha S. (Mentor, OH)

Of Women and Salt
This is the first book written by the author. I felt each chapter of the book seemed to read like a part of a group of short stories. A brief genealogy chart was in the front of the book and the chapters were written about each of these women. I confess I would have been a little lost without this chart to use as a reference. I also had difficulty with the use of words in Spanish or a Spanish dialect. Never less, I enjoyed the story and appreciated the difficulty of the lives of this family. Interesting characters these women were, brave and persistent in living their own lives as they felt they should. I would recommend the book for book clubs as I think it would spark discussion and it is a short book.
Katharine Phenix

Cuba, Miami, Mexico, Oh My
There are women and there is salt in this story, or should I say stories. The structure reminds me of a shawl I am knitting. It’s made of leftover yarn, so there are strong stripes of bright colors against rows of bland timeless yarn which are woven in by chance and happenstance. The stories of these generations of women are the bright stripes. It is made of moments that became momentous. These stories, like the lives of the five generations of Cuban and two of El Salvadoran women told here, could have been so much more. Their lives, and this book, fell short of potential.
She knows the geography of her topics. Cuba, Miami, the borderlands of Mexico and the Rio Grande, and even the terrain of Jeannette’s descent into addiction are depicted with beautifully wrought detail. The writing is uneven, but in places, gripping. It is the secrets that the women kept from each other and themselves that are unfortunately kept from us as well.
Garcia takes us places we need to go. Cuban history is checkered with violence and bravery. Central American immigration is also violent and brave. Tell us more, Gabriela, I’ll go back with you again in your next book.
Valerie_C

A tale of mothers and daughters
While I did not find this book overwhelmingly engaging, the issues touched upon were real. Gentler than American Dirt, the issues of immigration into the US formed an educational back drop for the mother’s and daughters relationship issues.
Power Reviewer
Doris_K

Of Women and Salt
This book tells of the agony of women who fought for a better life. The importance of family ties is illustrated throughout the book. The author writes very well and gives an excellent picture of life first in Cuba then on to Mexico and finally back to Florida. Conditions in all of these areas are well described. Especially with the insight into the drug culture and how it affects people it is at times difficult to read. It reminded me of American Dirt which also told of how and why people are so desperate to get to the United States. Overall this is worth reading.
Power Reviewer
Beth_B

Familial Connections
I commend Gabriela Garcia on her first novel that is indeed unique and haunting. It is evident that she spent a hefty amount of time researching pertinent topics regarding immigration, holding facilities, laws, and the struggle to survive. Central to the book are the relationships of mothers and daughters and the manner in which they connect or disconnect. Oh, the secrets that abound, some better left untold and others that would have provided a healthy balance. There are heartwarming moments and disturbing ones as well. Why the title? I urge you to read and ponder. I look forward to reading more reviews of this novel.

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

They say that in the end truth will triumph, but it's a lie.

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


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


Execution Time

Total Time Avg Time Count Template
1780276321204 ms 1.7802763212E+012 ms 1 /root/website/app_server.cfm
1595 ms 1595 ms 1 /root/website/reader_reviews/index.cfm
720 ms 720 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
293 ms 293 ms 1 /root/website/app_layout.cfm
213 ms 213 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
148 ms 74 ms 2 /root/website/adsystem/adsystem_mod.cfm
137 ms 137 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
130 ms 130 ms 1 /root/website/app_globals.cfm
100 ms 100 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
99 ms 99 ms 1 /root/website/adzones/AdZone6.cfm
70 ms 70 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
61 ms 61 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
60 ms 60 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
57 ms 57 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
54 ms 54 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
52 ms 52 ms 1 /root/website/adzones/showcase_track.cfm
44 ms 44 ms 1 /root/website/queries/qry_get_obc_number.cfm
38 ms 38 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_active_obc.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_competition.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
17 ms 17 ms 1 /root/website/act_check_login.cfm
17 ms 6 ms 3 /root/website/actions/act_spider_tracker.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_member_info.cfm
15 ms 15 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
12 ms 12 ms 1 /root/website/actions/adstatus.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
10 ms 10 ms 1 /root/website/site/blocks/layout/main_menu.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm
0 ms 0 ms 1 /root/website/reader_reviews/dsp_views.cfm
0 ms 0 ms 1 /root/website/site/blocks/act_book_view_tracking.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
6 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1601 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 01:12: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=16ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 01:12: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 @ 01:12: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 @ 01:12: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=19ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 01:12: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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:12: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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:12: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 @ 01:12: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=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 01:12: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=16ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 01:12: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=7ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 01:12: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_book_number (Datasource=bookbrowse_com_new, Time=23ms, Records=1) in /root/website/reader_reviews/index.cfm @ 01:12:01.001
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 15474

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 @ 01:12:01.001
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=17ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 01:12: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) = 15474

get_author_name (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 01:12:01.001
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) = 3481

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

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=137ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 01:12: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) = 15474
Parameter #2(CF_SQL_INTEGER) = 15474

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=99ms, Records=38) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 01:12:01.001
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) = 15474

get_arc_idfk (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:12: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) = 15474

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=106ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:12: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) = 15474

obc_discussions (Datasource=booktalk_new, Time=499ms, Records=25) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:12:02.002
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) = 26823526-D75F-22FB-0FBA2AA37ABEDB19

searchResults (Datasource=bookbrowse_com_new, Time=97ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:12:02.002
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) = p15474

ya_check (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 01:12:02.002
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) = 15474

get_books_by_brief (Datasource=bookbrowse_com_new, Time=18ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 01:12:02.002
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) = 15474

get_author_bookcount (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_author_bookcount.cfm @ 01:12:02.002
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) = 3481
Parameter #2(CF_SQL_INTEGER) = 3481

get_obc_number (Datasource=bookbrowse_com_new, Time=42ms, Records=2) in /root/website/queries/qry_get_obc_number.cfm @ 01:12:02.002
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 15474.0

IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'gloriakelly14@gmail.com'
IsPowerReviewer (Datasource=, Time=17ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'amywilson56@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'kclermont@msn.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'matstahre@sbcglobal.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'kjphenix@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'vcaruso19@live.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'dodokos13@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 01:12:02.002
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'brooksbb33@gmail.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=29ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:12: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=30ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:12: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=60ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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=19ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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=37ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 01:12: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 @ 01:12:02.002
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=24ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:12: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/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=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB; FREEACCESSCOUNT=0; CFGLOBALS=urltoken%3DCFID%23%3D4080765%26CFTOKEN%23%3Dc2a51011c0d9da82%2D075F8531%2D911F%2DC0E5%2D01DE90DAFCDABBFB%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2001%3A12%3A01%27%7D%23hitcount%3D29%23timecreated%3D%7Bts%20%272026%2D06%2D01%2001%3A11%3A54%27%7D%23cftoken%3Dc2a51011c0d9da82%2D075F8531%2D911F%2DC0E5%2D01DE90DAFCDABBFB%23cfid%3D4080765%23; CFID=4080765; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%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/15474/page/2/order/bw/of-women-and-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=4080765
cftoken=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
hitcount=38
lastvisit={ts '2026-06-01 01:12:02'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 01:11:54'}
urltoken=CFID=4080765&CFTOKEN=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
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#=4080765&CFTOKEN#=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB#lastvisit={ts '2026-06-01 01:12:01'}#hitcount=29#timecreated={ts '2026-06-01 01:11:54'}#cftoken=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB#cfid=4080765#
CFID=4080765
CFTOKEN=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
FREEACCESSCOUNT=0
Session Variables:
cfid=4080765
cftoken=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
sessionid=BOOKBROWSE_4080765_c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
urltoken=CFID=4080765&CFTOKEN=c2a51011c0d9da82-075F8531-911F-C0E5-01DE90DAFCDABBFB
URL Parameters:
ezine_preview_number=15474
of-women-and-salt=
order=bw
page=2
Debug Rendering Time: 14 ms