What readers think of Unsheltered, plus links to write your own review.

Summary |  Excerpt |  Reading Guide |  Discuss |  Reviews |  Beyond the book |  Read-Alikes |  Genres & Themes |  Author Bio

Unsheltered by Barbara Kingsolver

Unsheltered

A Novel

by Barbara Kingsolver
  • BookBrowse Review:
  • Critics' Consensus (6):
  • Readers' Rating (28):
  • First Published:
  • Oct 16, 2018, 480 pages
  • Paperback:
  • Oct 2019, 480 pages
  • Reviewed by BookBrowse Book Reviewed by:
    Rebecca Foster
  • Genres & Themes
  • Publication Information
  • Rate this book

Reviews

Page 1 of 2
There are currently 9 reader reviews for Unsheltered
Order Reviews by:

Write your own review!

Power Reviewer
Cathryn_Conroy

When the World as You Know It Inexorably Changes, What Would You Do?
What happens when the world view you have always known inexorably shifts? Do you embrace the change as forward-thinking or fight it for all you're worth? If you simply deny that the change is real, will those words be enough to bring back the good old days? That is the fascinating premise of this remarkable novel by Barbara Kingsolver that is, more than anything else, a philosophical statement about the sociopolitical times in which we live now.

A beleaguered house in Vineland, New Jersey is the backdrop of this book that alternates between two families who have the great misfortune to live on that site. Thatcher Greenfield lives there with his family in 1874-1875. He is newly hired as the high school science teacher, but when he professes the new theories of evolution as espoused by Charles Darwin, his world is shattered when virtually everyone around him objects, insisting the Bible is the only valid reference for scientific thought. Fast forward to 2015-2016 when Willa Knox and Iano Tavoularis, both recently laid off, move into the home she inherited from her aunts. Their family's life is awash in tragedy and troubles, while they watch horrified as a man only identified as "the Bullhorn" appears destined for the presidency and global warming shifts from scientists' dire warning to real-life consequences.

The book is a fascinating exposition on the power of cultural change—change that feels uncertain and threatening, but is so deep-seated and long-lasting that it is called a paradigm shift—and how we as a society adapt to it or not.

Because Kingsolver is a creative genius, the chapters on Thatcher are written in the style of a Victorian novel, while the chapters on Willa are written in a modern-day tone. And here is fun tidbit that took me several chapters to notice: The last words of each chapter are the title of the next chapter.

Bonus: Iano Tavoularis very creatively swears in Greek, and translations are helpfully provided. Some of this is hilarious! (Beware, in case you are offended by such language in books.)
Camille

I love ALL of Kingsolvers fiction.
There isn't a book by Barbara Kingsolver that I didn't like. Her writing style and command of the language always amaze me. She creates vivid, accurate descriptions I can identify with. The thoughts and dialogue of the characters are always reflective of the depicted era, insightful and often quite humorous. Just loved back and forth between Willa and other people.
Christine_Schaefer

Loved it!
I very much enjoyed this book on many different levels. Our family lived in an 1880’s historical home that we lovingly named “the money pit,” as everything was in disrepair. The modern day story that was told was very similar to our family - especially the mother/daughter relationship. I so could relate to Willa. Now that my husband and I are of retirement age, going through the boxes of family history was exact - down to owning a Navajo rug that was my grandparents. I love BK and her stories. She’s one of the best writers of our generation.
John

Excellent read.
Great book. The drama of this novel is enhanced in its telling by its setting in the world of nature and scientific inquiry. As a nature lover, gardener, and one who esteems science I couldn't have stumbled upon a better choice when perusing the books at my small town local library.
Power Reviewer
Cloggie Downunder

an interesting, thought-provoking and eminently enjoyable read
Unsheltered is the ninth novel by best-selling, prize-winning American novelist, essayist, and poet, Barbara Kingsolver. Now in her fifties, Willa Knox never expected to be living in a run-down house in Vinelands, New Jersey, still the hub of a family that includes her two adult children, her new grandson, her debilitated, demanding father-in-law and an ageing dog.

Virtually unemployed, Willa is writing some freelance articles; her university professor husband Iano has a low-paid teaching job; her recently-widowed son Deke is juggling single fatherhood with setting up a personal financial advice company; her daughter Tig has abandoned college for protest action; her father-in-law Nick needs urgent medical care; and due to a lack of foundations, the house she inherited is literally starting to fall apart. Any sort of windfall, though not expected, would be helpful.

Some hundred and forty years earlier, Thatcher Greenwood has moved from Boston to teach science at Vinelands High School. Newly married to Rose, he has taken on the responsibility of both his late father-in-law’s family and house. His bright young sister-in-law, Polly is a bonus, whereas Rose’s mother, Aurelia falls into quite a different category. The house is not as sound as Aurelia believes, and his teaching position is a source of great frustration, as the school’s principal undermines his every attempt to infuse his students with current scientific knowledge.

The timelines alternate between chapters with the events of the 1870s told from Thatcher’s perspective, while Willa narrates the story set in 2015/6. Kingsolver uses a clever device to bridge the chapter: the final words of one chapter form the heading of the next. Between the narratives, parallels and echoes abound, and not just the residency at 744 East Plum Street. And with them, Kingsolver deftly demonstrates that many of the challenges we think we’re facing for the first time are by no means unique or new phenomena.

Kingsolver is highly skilled at creating believable characters: she writes about ordinary people facing everyday challenges, and yet, the reader can’t help but be enthralled. These are people who face hardships yet still worry about the greater good, about their country and the world. Their dialogue is credible, their relationships, realistic, and while there is naturally some friction between certain characters, their interactions (between couples, friends, siblings, parents/children, in-laws) are often entertaining.

Kingsolver’s depiction of these pre-Trump-era characters who have made good decisions, doing the right thing and working hard all their lives, and still ending up effectively on the poverty line, is absolutely spot-on. Her analysis of the mindset of those who support Trump (who remains unnamed herein) is astute and insightful. “…we’re overdrawn at the bank, at the level of our species, but we don’t want to hear it. So if it’s not this exact prophet of self-indulgence we’re looking to for reassurance, it will be some other liar who’s good at distracting us from the truth. Because of the times we’re in.”

Kingsolver gives Tig the voice of caution, making her intelligent, perceptive and articulate. If some readers feel this has a preachy tone to it, well, perhaps that’s because nothing else has worked and the situation is truly becoming dire. But it’s not all doom and gloom: there are also plenty of laugh-out-loud moments in the conversations; and if those nations that consider themselves highly developed could take a leaf out of the book of a country that has had no choice but to curb their consumerism/materialism, then Cuba apparently has much to teach us all.

As always, Kingsolver’s descriptive prose is exquisite, and her love of nature is apparent throughout, as is her concern for the state of the nation and of the world. Again, she gives the reader an interesting, thought-provoking and eminently enjoyable read.
Doris

I feel lectured
Barbara kingsolver crafts wonderful tales and interesting characters. But she hits the reader over the head with her views on social issues. I am sure she is passionate, but I feel lectured. And the more accomplished she becomes, the more she abuses (in my view) her bully pulpit. My grandparents lived in Vineland from 1904 and I know the town well. It was fun to connect images and experiences from growing up to the names and places in the stories. I appreciate the research that goes into her books. My cousins and I learned many things about Vineland history, even though my cousins were schooled there.
Catherine

Disappointed
Took a long time to grab my interest and get past the political diatribes.
Susan_C

A disappointment from one of my favorites
This book could have been much better without all of the editorializing regarding the 'state of the union past and present.' I agree with Ms. Kingsolver's political views and yet I felt I was being reprimanded by the author. We are all getting plenty of that in our daily lives. I might have liked this more if I were in a different state of mind. It wasn't my time to read this book, sad to say.
  • Page
  • 1
  • 2

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

A library, to modify the famous metaphor of Socrates, should be the delivery room for the birth of ideas--a place ...

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 31-May-26 10:32 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
1780266758665 ms 1.78026675867E+012 ms 1 /root/website/app_server.cfm
1397 ms 1397 ms 1 /root/website/reader_reviews/index.cfm
554 ms 554 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
326 ms 326 ms 1 /root/website/queries/qry_get_book_by_id.cfm
147 ms 147 ms 1 /root/website/app_layout.cfm
106 ms 106 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
76 ms 38 ms 2 /root/website/adsystem/adsystem_mod.cfm
73 ms 73 ms 1 /root/website/app_globals.cfm
70 ms 70 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
55 ms 55 ms 1 /root/website/reader_reviews/dsp_bookshell.cfm
47 ms 47 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
42 ms 42 ms 1 /root/website/adzones/AdZone6.cfm
41 ms 41 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
36 ms 36 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
36 ms 36 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
35 ms 35 ms 1 /root/website/adzones/showcase_track.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_active_obc.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
12 ms 4 ms 3 /root/website/actions/act_spider_tracker.cfm
12 ms 12 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_current_competition.cfm
8 ms 8 ms 1 /root/website/act_check_login.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/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/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_closed_about.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_awards.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_btb.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_readalikes.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1399 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

22:32:39.039 - Expression Exception - in /root/website/site/blocks/dsp_top_book_block.cfm : line 237
	    Variable BOOK_NUMBER is undefined.
	    


SQL Queries

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

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 @ 22:32:38.038
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_book_by_id (Datasource=bookbrowse_com_new, Time=42ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 22:32:38.038
SELECT		a.book_number, a.book_title, a.book_sub_title, a.book_url, a.book_entry_dt, a.book_short_summary, a.book_excerpt, a.book_jacket_info, a.book_reading_guide, a.book_copyright_info, a.book_notes,
            	b.author_number, b.author_first_name, b.author_last_name, b.author_middle_initial,
            	f.edition_publish_dt AS "hardcover_publish_dt", f.edition_number_of_pages AS "hardcover_number_of_pages", f.edition_isbn AS "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13", f.edition_jacket_image as "hardcover_jacket_image", f.edition_publisher as "hardcover_publisher",
            	g.edition_publish_dt AS "paperback_publish_dt", g.edition_number_of_pages AS "paperback_number_of_pages", g.edition_isbn AS "paperback_isbn", g.edition_isbn13 "paperback_isbn13", g.edition_jacket_image as "paperback_jacket_image", g.edition_publisher as "paperback_publisher",
            	i.author_info_interview, i.author_info_biography,i.author_info_image,
            	CASE WHEN datalength(author_middle_initial) = 1 THEN author_first_name + ' ' + author_middle_initial + ' ' + author_last_name
            		 ELSE author_first_name + ' ' + author_last_name
            		 END "author_name",
            	CASE WHEN 
					(select count(*) from editions where book_number = 4364) = 1
					AND
					(select count(*) from editions where book_number = 4364 and edition_paperback_flag = 1) = 1
				THEN 1
				ELSE 0
				END AS "po_flag",
				(select count(*) from book_author_mapping m where m.author_number = b.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = b.author_number and ezine_preview_bb_link =0)
				 as 'author_bookcount',
            	(SELECT CAST(AVG(CAST(rating AS decimal(12,0))) AS decimal(12,1))
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) "savrating",
			(SELECT COUNT(rating)
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) as "savrating_count",
            	(select top 1 media_review_rating from media_reviews where book_number = a.book_number and media_review_type_number = 9) as "bbrating",
            	(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,1)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating",
				(SELECT COUNT(media_review_rating) FROM media_reviews WHERE book_number = a.book_number AND media_review_type_number <> 7 AND media_review_rating > 0) as "scritrating_count",
            	(select top 1 gg.ezine_number from ezine_edition_mapping aa, editions bb, books cc, ezines gg            	
            	where aa.edition_number = bb.edition_number and bb.book_number = cc.book_number and aa.ezine_number = gg.ezine_number 
            	and cc.book_number = a.book_number and gg.ezine_bbsays_flag = 1 and gg.ezine_active_flag = 1) as "ezine_number",
				cgm.category_number,
				cgya.category_number AS "ya_flag"
				
,(select top 1 publisher_holding_company from publishers where (publisher_imprint like f.edition_publisher OR publisher_imprint like g.edition_publisher) AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
        
    FROM		books a 
    INNER JOIN	book_author_mapping c ON c.book_number = a.book_number
    INNER JOIN	authors b ON b.author_number = c.author_number  
    INNER JOIN	author_info i ON i.author_number = b.author_number
    
    LEFT JOIN	editions f ON f.book_number = a.book_number AND f.edition_paperback_flag = 0
    LEFT JOIN	editions g ON g.book_number = a.book_number AND g.edition_paperback_flag = 1
    LEFT JOIN	category_book_mapping cgm on cgm.book_number = a.book_number AND cgm.category_number = 48
    LEFT JOIN	category_book_mapping cgya on cgya.book_number = a.book_number AND cgya.category_number = 40
          
    WHERE 		a.book_number = ?
         
    ORDER BY	c.book_author_mapping_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=282ms, Records=6) in /root/website/queries/qry_get_book_by_id.cfm @ 22:32:39.039
SELECT		a.media_review_number, 
				a.book_number, 
				a.media_review_type_number, 
				a.media_review_title, 
				a.media_review_rating, 
				a.media_review, 
				a.media_review_old,
	
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 (case when dbo.WordCount(c.ezine_review_2) > 0 then dbo.WordCount(c.ezine_review_2) + dbo.WordCount(c.ezine_extras) 
                                                                                    else dbo.WordCount(c.ezine_review) 
                                                                                    end)
                                                                from ezine_edition_mapping c
                                                                INNER JOIN editions d ON (d.edition_number = c.edition_number)
                                                                INNER JOIN ezines e ON e.ezine_number = c.ezine_number
                                                                WHERE d.book_number = ?
                                                                
                                                                ORDER BY e.ezine_number ASC)
	 			ELSE 0 
	 			END  "wordc",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_number
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			ELSE 1
				END "reviewer_number",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_first_name + ' ' + reviewer_last_name AS "reviewer_name"
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
																 INNER JOIN reviewers r on r.reviewer_number = c.reviewer_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			END "reviewer_name"
	
	FROM		media_reviews a, media_review_types b
	
	WHERE		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
	AND			a.book_number = ?
	AND			a.media_review_type_number = b.media_review_type_number
	
	ORDER BY	b.media_review_type_sort_order ASC, media_review_rating DESC, media_review_title ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823
Parameter #2(CF_SQL_INTEGER) = 3823
Parameter #3(CF_SQL_INTEGER) = 3823
Parameter #4(CF_SQL_INTEGER) = 3823

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=70ms, Records=9) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 22:32:39.039
select 		a.reader_review_number, a.book_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.book_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    from 		reader_reviews a
    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,
    			books b
    where 		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
    and 		a.book_number = ?
    and 		a.reader_review_approved_flag = 1
    and 		a.book_number = b.book_number
    

	order by a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 22:32:39.039
select 		c.book_awards_category_number, c.book_awards_category_name, c.book_awards_category_sort_order,
				m.book_awards_mapping_number, m.book_award_dt,
                a.book_award_number, a.book_award_image, a.book_award_name
                
                
	from 		book_awards_mapping m
	inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    inner join	book_awards a on a.book_award_number = c.book_award_number
    
	where 		m.book_number = ?
    
    order by	c.book_awards_category_sort_order ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 22:32:39.039
select	book_number
    
    from	category_book_mapping a, categories b, top_categories t
    
    where	t.top_category_number = b.top_category_number
    and		b.category_number = a.category_number
    and		t.top_category_number = 9
    and		a.book_number = ?
    and		b.category_visible_flag = 1
	and		a.book_number not in (	select book_number 
    									from 		book_awards_mapping m
													inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    												inner join	book_awards a on a.book_award_number = c.book_award_number
                                    	where m.book_number = ? 
                                    	and a.book_award_number = 7)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823
Parameter #2(CF_SQL_INTEGER) = 3823

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=34ms, Records=12) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 22:32:39.039
SELECT 		b.book_title, b.book_number,
    			c.book_title "referenced_book_title", c.book_number AS "liked_book_number", c.book_short_summary as "liked_short_summary",
            	e.*,
                CASE WHEN datalength(e.author_middle_initial) > 0 
                	 THEN e.author_first_name + ' ' + e.author_middle_initial + '. ' + e.author_last_name
					 ELSE e.author_first_name + ' ' + e.author_last_name
					 END AS "author_name",
				(select top 1 edition_publish_dt from editions where editions.book_number = c.book_number order by edition_publish_dt DESC) as 'sortdate',
				(select count(*) from book_author_mapping m where m.author_number = d.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = d.author_number and ezine_preview_bb_link =0)
				 as 'liked_author_bookcount'
                
	FROM 		liked a
	INNER JOIN	books b ON b.book_number = a.book_number
	INNER JOIN	books c ON c.book_number = a.liked_book_number
	INNER JOIN	book_author_mapping d ON c.book_number = d.book_number
	INNER JOIN	authors e ON d.author_number = e.author_number
    
    WHERE 		a.book_number = ?
    
	ORDER BY 	sortdate desc, c.book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=9ms, Records=12) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 22:32:39.039
select 		distinct a.category_number, a.top_category_number, a.category_name, a.category_description, a.category_meta_keywords, a.category_active_flag, a.category_visible_flag, a.category_member_only_flag, a.category_qry_template, a.category_sort_order, a.category_tag_size,
    			b.*
	
    from 		categories a
	left join	top_categories b on a.top_category_number = b.top_category_number
	left join	category_book_mapping c on c.category_number = a.category_number
	
    where 		a.category_active_flag = 1
    and 		a.category_visible_flag = 1
	and 		c.book_number = ?
	

    order by 	b.top_category_sort_order, b.top_category_name, a.category_sort_order, a.category_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

bb_review (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/index.cfm @ 22:32:39.039
SELECT media_review, reviewer_number from get_media_reviews_by_book_id where media_review_type_number = 9
get_arc_idfk (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:32:39.039
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_bb_link = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3823

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:32:39.039
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_bb_link = ? 
    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) = 3823

obc_discussions (Datasource=booktalk_new, Time=496ms, Records=32) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:32:39.039
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) = E2D902B2-FDD6-7686-E38589C5A94261E4

searchResults (Datasource=bookbrowse_com_new, Time=33ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:32:39.039
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) = 3823

get_ezine_type (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 22:32:39.039
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=35ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 22:32:39.039
SELECT TOP 1  
                a.ezine_short_title, a. ezine_boxed_content_title, a.ezine_boxed_content, a.ezine_review, a.ezine_review_2,
                b.edition_paperback_flag, b.edition_publish_dt, b.edition_isbn,
                c.book_title, c.book_sub_title, c.book_reading_guide, c.book_excerpt, c.book_number,
                e.author_first_name, e.author_middle_initial, e.author_last_name, e.author_number, 
                f.author_info_biography, 
                g.ezine_number, g.ezine_dt, g.ezine_bbsays_flag,
				i.article_category_number, i.article_category_name
		
	FROM    	ezine_edition_mapping AS a 
		
	INNER JOIN 	editions AS b ON (a.edition_number = b.edition_number)
	INNER JOIN 	books AS c ON (b.book_number = c.book_number )
	INNER JOIN 	book_author_mapping AS d ON (c.book_number = d.book_number )
	INNER JOIN 	authors AS e ON (d.author_number = e.author_number )
	INNER JOIN 	author_info AS f ON (e.author_number = f.author_number)
	INNER JOIN 	ezines AS g ON (a.ezine_number = g.ezine_number)
	LEFT JOIN	article_ezine_edition_mapping h ON h.ezine_edition_mapping_number = a.ezine_edition_mapping_number
	LEFT JOIN	article_categories i ON i.article_category_number = h.article_category_number

	WHERE		c.book_number = ?
	AND			g.ezine_bbsays_flag = 1
	AND			g.ezine_active_flag = 1
	
	
	ORDER BY 		g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

check_permalink (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

check_editors_choice (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
    AND		book_number IN (SELECT		top 4 a.book_number
                            FROM		editors_choice a 
                            WHERE		editors_choice_dt < getdate()
                            ORDER BY	editors_choice_dt DESC)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

check_free_ezine (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			ezine_edition_free_review_flag = 1
	AND			dateadd(ww,4,b.ezine_dt) > getdate()
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

check_cat_73 (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 		count(*) as "count"
    FROM    	books AS b
    INNER JOIN 	category_book_mapping AS c ON c.book_number = b.book_number
    WHERE 		b.book_number = ?
	AND			c.category_number = 73
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_ezine_status (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

check_old_ezine (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			datediff(mm,b.ezine_dt,getdate()) > 12
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_ezine_status (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 22:32:39.039
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_author_bookcount (Datasource=bookbrowse_com_new, Time=6ms, Records=8) in /root/website/queries/qry_get_author_bookcount.cfm @ 22:32:39.039
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) = 258
Parameter #2(CF_SQL_INTEGER) = 258

get_coauthor (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 22:32:39.039
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_book_image (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/udfs.cfm @ 22:32:39.039
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	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 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_book_image (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/udfs.cfm @ 22:32:39.039
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	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 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

get_coauthor (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/actions/udfs.cfm @ 22:32:39.039
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3823

IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'CathrynConroy@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'cmiille@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'kokochrispy@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'johng09@windstream.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'cloggie.downunder@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'Denverdklein@msn.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'cdsrolfe@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 22:32:39.039
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'scoene@groupc.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 22:32:39.039
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=25ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 22:32:39.039
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=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:39.039
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:39.039
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=26ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:40.040
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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 22:32:40.040
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 @ 22:32:40.040
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:40.040
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:40.040
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:32:40.040
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=CFID=4075756; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4; CFGLOBALS=urltoken%3DCFID%23%3D4075756%26CFTOKEN%23%3D5636432b9793abdb%2D01AC1002%2DF2F0%2D49B3%2DA18DC08A7576ECB4%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2022%3A32%3A38%27%7D%23hitcount%3D42%23timecreated%3D%7Bts%20%272026%2D05%2D31%2022%3A32%3A29%27%7D%23cftoken%3D5636432b9793abdb%2D01AC1002%2DF2F0%2D49B3%2DA18DC08A7576ECB4%23cfid%3D4075756%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=/start_id/1/book_number/3823/unsheltered
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=4075756
cftoken=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
hitcount=52
lastvisit={ts '2026-05-31 22:32:40'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 22:32:29'}
urltoken=CFID=4075756&CFTOKEN=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
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#=4075756&CFTOKEN#=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4#lastvisit={ts '2026-05-31 22:32:38'}#hitcount=42#timecreated={ts '2026-05-31 22:32:29'}#cftoken=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4#cfid=4075756#
CFID=4075756
CFTOKEN=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
Session Variables:
cfid=4075756
cftoken=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
sessionid=BOOKBROWSE_4075756_5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
urltoken=CFID=4075756&CFTOKEN=5636432b9793abdb-01AC1002-F2F0-49B3-A18DC08A7576ECB4
URL Parameters:
book_number=3823
start_id=1
unsheltered=
Debug Rendering Time: 10 ms