Saving Elijah Reading Guide & Discussion Questions

Summary |  Excerpt |  Reading Guide |  Reviews |  Read-Alikes |  Genres & Themes |  Author Bio

Saving Elijah by Fran Dorf

Saving Elijah

by Fran Dorf
  • Critics' Consensus (5):
  • First Published:
  • Jun 1, 2000, 384 pages
  • Rate this book

About this Book

Book Club Discussion Questions

Print PDF



Please be aware that this discussion guide will contain spoilers!

Plot Summary

Psychologist Dinah Rosenberg Galligan is living every mother’s nightmare: her youngest child, Elijah, has fallen into a life-threatening coma. Faced with a seemingly hopeless situation, Dinah meets the mysterious Seth Lucien, a spirit with a surprising connection to her past. Lucien promises to help Elijah emerge from his coma but at a devastating cost: the miracle comes only after Dinah enters into a Faustian bargain; her son is saved, but her entire world begins to crumble

At its core, Saving Elijah is a gripping literary tale of a mother’s love set against a struggle with faith. Laced with humor and passion, the novel confronts a multitude of psychological and philosophical issues, from the forces that bind a family together, to the nightmarish underside of modern life-saving technology, to what it means to be human.


About The Title

Fran Dorf on Saving Elijah
After I lost my son in 1994, I was incapacitated with grief. I was convinced I’d never be capable of writing another novel. At some point, however, I decided that I needed to write another book, because I didn’t know what else to do with myself. But how was I going to find a theme other than grief, when my grief was so huge? Yet grief it was, and I vowed I would try to be true to the psychological devastation that serious bereavement produces, as I felt and observed it in myself, and saw it in others.

Through many early drafts, I struggled to write a conventional novel about a woman whose marriage had broken up after the loss of a child, telling her story mostly in flashback. Perhaps contrary to conventional wisdom, I found that the more I fictionalized, separating my own experience from my characters’, the more cathartic the writing became. Several years into the process, an acquaintance, after hearing that I had lost a child, stared for a moment, then muttered, "Anything but that, anything but that." Many people had that reaction, as if the parent were given a choice in the matter. But the fact is you do try to bargain with God. I can’t imagine who wouldn’t, even a nonbeliever. My life for my child’s.

I turned my plot inside out, and before long the ghost called Seth Lucien appeared, in all his taunting grandeur, as the vehicle for a Faustian bargain, in a story that takes the reader, and my character Dinah, into the very heart of grief and loss and faith.

While on one level Saving Elijah is a supernatural thriller, the ghost doesn’t just walk into the story to scare us. The reader is already terrified by the situation. The ghost is Dinah’s disembodied self, her wrecked "ego" in psychological terms, playing her life back to her, blocking her normal coping mechanisms, personifying the grief and guilt that any parent would feel in such a situation: "Where did I go wrong? What could I have done differently?"

With his running commentary on the action, the ghost—who shares certain qualities with the dybbuk (evil spirit) of Jewish folk legend— also functions as a Greek chorus, albeit a lunatic one. Since a ghost doesn’t have to observe human rules of decorum, he can tease, play mind-games, philosophize, joke, and shock, which seems about right in the surreal world of a pediatric intensive care unit. I put the ghost into competition with the horrific events of the story. True life wins for horror, and Seth is the comic relief—sort of.

I hope that Saving Elijah, while moving readers and compelling them to turn the pages, makes them think. As Seth might say, "Let the play begin."


Discussion Questions
  • Saving Elijah opens with three quotations that are intimately tied to the themes of the novel. In what ways do they enhance the story being told? Which quotation do you feel has the greatest impact on the reader in relation to Dinah’s story, and why?

  • Why does the author juxtapose the ghost with the real-life horrors that Dinah faces in the PICU? How does the ghost’s attack on Dinah personify the bereavement process? How does his voice alter the mood of the novel?

  • The idea that every human being has decisions to make in life is a significant theme in all literature, including Saving Elijah. In addition to the Faustian bargain proposed by the ghost, what other decisions is Dinah faced with? How do her experiences or personality influence the choices she ultimately makes?

  • Life support is a complicated question about which there are diverse opinons, as is evident in the novel. How do the background and beliefs (religious, political, ethical, medical) of each of the characters influence their opinions about this question? Are you surprised by any of these opinions? What are your views, and how have they been shaped by your background or beliefs? Does the novel as a whole take a stand on the question of life support, and if so, what is it?

  • What effect is achieved by the author’s decision to tell the story from Dinah’s point of view? How might the novel differ if it were told by an impartial narrator or in alternating voices?

  • In your opinion, is Dinah’s encounter with the ghost a figment of her imagination or an actual religious experience? Can an outside observer differentiate between the two?

  • What impact does Dinah’s mother have on her daughter’s actions? To what extent is Dinah’s marriage influenced by her severed relationship with Julie? To what degree does guilt play a role in their separation?

  • Why do you think Dinah reacts so strongly and negatively to Dr. Moore? Did the diverse temperaments and approaches of the physicians in the book surprise you?

  • The psychiatrist Dr. Kessler defines compassion as "willingness to be close to suffering." Why do you think Dinah can’t see it this way at that moment, focusing instead on the "babblers, advice-givers and pain-minimizers," as she calls them? In your own experience, as either a recipient or giver of compassion, are people mostly willing to be "close to suffering"?

  • Why does Dinah reject the traditional trappings of her own profession, such as grief support or personal therapy? Do you think that such a character would eventually seek help from these sources?

  • The word "closure" is often used to express the resolution of grief. Do you think Dinah has achieved it or will achieve it? Does "closure" accurately describe the most desirable outcome for anyone’s grief?<

  • What is the function of the various life stories presented in the narrative, particularly those of Dinah’s mother and the elderly writers? Why do you think the author chose not to reveal the details of Ellen Shoenfeld’s Holocaust experience?
  • 📖

    Get the full reading guide

    Join BookBrowse free to unlock all 12 discussion questions, author background, themes, and more for Saving Elijah.

    Join free — it takes 30 seconds

    Already a member? Log in →

    1. How does the author develop themes of identity and belonging throughout the narrative?
    2. What role does the setting play in shaping the characters' decisions and relationships?
    3. Discuss how the ending reframes the events of the story. Were you surprised?


    Unless otherwise stated, this discussion guide is reprinted with the permission of G.P. Putnam's Sons. Any page references refer to a USA edition of the book, usually the trade paperback version, and may vary in other editions.

    Membership Advantages
    • Reviews
    • "Beyond the Book" articles
    • Free books to read and review (US only)
    • Find books by time period, setting & theme
    • Read-alike suggestions by book and author
    • Book club discussions
    • and much more!
    • Just $60 for 12 months or $20 for 3 months.
    • More about membership!

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

    Life is the garment we continually alter, but which never seems to fit.

    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 /reading_guides/detail/index.cfm
    Time Stamp 01-Jun-26 02: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
    1780279938706 ms 1.78027993871E+012 ms 1 /root/website/app_server.cfm
    398 ms 398 ms 1 /root/website/reading_guides/detail/index.cfm
    219 ms 219 ms 1 /root/website/reading_guides/detail/dsp_main.cfm
    68 ms 68 ms 1 /root/website/app_layout.cfm
    50 ms 17 ms 3 /root/website/adsystem/adsystem_mod.cfm
    41 ms 41 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
    39 ms 39 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
    35 ms 35 ms 1 /root/website/app_globals.cfm
    24 ms 24 ms 1 /root/website/adzones/AdZone2.cfm
    15 ms 15 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
    14 ms 14 ms 1 /root/website/adzones/AdZone6.cfm
    14 ms 14 ms 1 /root/website/adzones/showcase_track.cfm
    14 ms 14 ms 1 /root/website/queries/qry_get_active_obc.cfm
    14 ms 14 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
    13 ms 13 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
    11 ms 11 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
    9 ms 9 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
    8 ms 8 ms 1 /root/website/queries/qry_get_member_account_types.cfm
    8 ms 8 ms 1 /root/website/site/blocks/membership_advantages.cfm
    7 ms 7 ms 1 /root/website/queries/qry_get_book_by_id.cfm
    6 ms 6 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
    5 ms 5 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
    4 ms 4 ms 1 /root/website/actions/adstatus.cfm
    4 ms 4 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
    4 ms 4 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
    3 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
    3 ms 3 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
    3 ms 3 ms 1 /root/website/queries/qry_get_current_competition.cfm
    3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
    3 ms 3 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
    2 ms 2 ms 1 /root/website/act_check_login.cfm
    2 ms 2 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
    2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
    2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
    2 ms 2 ms 1 /root/website/site/blocks/layout/main_menu.cfm
    1 ms 1 ms 1 /root/website/formurl2attributes.cfm
    1 ms 1 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
    1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.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/js/fbjavascriptsdk.cfm
    0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
    0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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_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_closed_reviews.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/head.cfm
    0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
    2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
    400 ms  TOTAL EXECUTION TIME
    red = over 250 ms average execution time


    Exceptions

    02:12:18.018 - 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=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 02:12:18.018
    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=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:12:18.018
    select 	a.*, 
        		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
                c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
    	
        from members a, member_account_types b, member_chargetype c
    	
        where a.member_account_type_number = b.member_account_type_number
    	and a.payment_method_id = c.member_chargetype_number
    	and a.member_number = ?
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_INTEGER) = 0

    adactive (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:12:18.018
    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 @ 02:12:18.018
    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=1ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:12:18.018
    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 @ 02:12:18.018
    SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
    	from			competitions x
    	
    		WHERE	x.competition_dt <= getdate()
    		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
    get_current_competition (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:12:18.018
    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 @ 02:12:18.018
    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=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:12:18.018
    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 @ 02:12:18.018
    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=5ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:12:18.018
    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_by_id (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 02:12:18.018
    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) = 532

    get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=3ms, Records=6) in /root/website/queries/qry_get_book_by_id.cfm @ 02:12:18.018
    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) = 532
    Parameter #2(CF_SQL_INTEGER) = 532
    Parameter #3(CF_SQL_INTEGER) = 532
    Parameter #4(CF_SQL_INTEGER) = 532

    get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 02:12:18.018
    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_dt DESC
    Query Parameter Value(s) -
    Parameter #1(CF_SQL_INTEGER) = 532

    get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 02:12:18.018
    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) = 532

    get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 02:12:18.018
    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) = 532
    Parameter #2(CF_SQL_INTEGER) = 532

    get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=2ms, Records=5) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 02:12:18.018
    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) = 532

    get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=2ms, Records=5) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 02:12:18.018
    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) = 532

    bb_review (Datasource=, Time=0ms, Records=0) in /root/website/reading_guides/detail/index.cfm @ 02:12:18.018
    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=3ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 02:12:18.018
    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) = 532

    get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 02:12:18.018
    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) = 532

    obc_discussions (Datasource=booktalk_new, Time=16ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 02:12:18.018
    SELECT 		t.name,
                    m.title, m.body,
                    u.username, t.id,
    				(SELECT COUNT(*) from booktalk_messages where threadidfk = t.id) AS	"responses"
                    
        FROM 		booktalk_forums f
        INNER JOIN	booktalk_threads t on t.forumidfk = f.id
        INNER JOIN	booktalk_messages m on m.posted = t.lastpostcreated
        INNER JOIN	booktalk_users u on u.id = m.useridfk
        
        WHERE 	f.id = ?
        AND 	f.active = 1
    	AND		t.active = 1
        
        ORDER BY t.name, t.messages DESC
    Query Parameter Value(s) -
    Parameter #1(cf_sql_varchar) =

    searchResults (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 02:12:18.018
    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) = 532

    get_ezine_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 02:12:18.018
    SELECT a.ezine_type_number
    	FROM ezines a
    	WHERE a.ezine_number = 1
    get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 02:12:18.018
    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) = 532

    check_permalink (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    check_free_ezine (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    check_cat_73 (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    get_ezine_status (Datasource=bookbrowse_com_new, Time=0ms, Records=0) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    check_old_ezine (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    get_ezine_status (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 02:12:18.018
    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) = 532

    get_coauthor (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    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) = 532

    existingResults (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    SELECT id, last_updated
            FROM DiscourseSearchResults
            WHERE book_number = ?
            ORDER BY last_updated DESC
    Query Parameter Value(s) -
    Parameter #1(cf_sql_varchar) = 532

    (Datasource=bookbrowse_com_new, Time=47ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    DELETE FROM DiscourseSearchResults
                    WHERE book_number = ?
    Query Parameter Value(s) -
    Parameter #1(cf_sql_varchar) = 532

    (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    INSERT INTO DiscourseSearchResults (book_number, post_id, topic_id, blurb, last_updated)
                        VALUES (
                            ?,
                            NULL,
                            NULL,
                            ?,
                            GETDATE()
                        )
    Query Parameter Value(s) -
    Parameter #1(cf_sql_varchar) = 532
    Parameter #2(cf_sql_nvarchar) = No results found

    get_coauthor (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    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) = 532

    get_book_image (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    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) = 532

    get_book_image (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    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) = 532

    get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 02:12:18.018
    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) = 532

    get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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) = adzone2
    Parameter #2(CF_SQL_VARCHAR) = 0
    Parameter #3(CF_SQL_VARCHAR) = 0

    get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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) = adzone2

    get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:12:19.019
    select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
    from member_account_types
    where member_account_type_number = (select top 1 member_account_type_number
    									from member_account_types
    									where member_account_type_months = 12
    									and member_account_type_public = 1
    									order by member_account_type_charge ASC)
    									
    or member_account_type_number =		(select top 1 member_account_type_number
    									from member_account_types
    									where member_account_type_months = 3
    									and member_account_type_public = 1
    									order by member_account_type_charge ASC)
    									
    order by member_account_type_sort_order ASC
    get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:12:19.019
    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=5ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:12:19.019
    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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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=4ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:12:19.019
    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=1ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 02:12:19.019
    SELECT 	*
        FROM 	free_newsletters
    get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:12:19.019
    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/reading_guides/detail/index.cfm
    CONTENT_LENGTH=
    CONTENT_TYPE=
    CONTEXT_PATH=
    GATEWAY_INTERFACE=
    HTTPS=
    HTTPS_KEYSIZE=
    HTTPS_SECRETKEYSIZE=
    HTTPS_SERVER_ISSUER=
    HTTPS_SERVER_SUBJECT=
    HTTP_ACCEPT=*/*
    HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
    HTTP_ACCEPT_LANGUAGE=
    HTTP_CONNECTION=upgrade
    HTTP_COOKIE=CFID=4081861; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A; CFGLOBALS=urltoken%3DCFID%23%3D4081861%26CFTOKEN%23%3D63eeec3d0d9f7de7%2D0987C1DB%2DF802%2D9167%2D1EECF64FE128032A%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2002%3A12%3A18%27%7D%23hitcount%3D15%23timecreated%3D%7Bts%20%272026%2D06%2D01%2002%3A12%3A13%27%7D%23cftoken%3D63eeec3d0d9f7de7%2D0987C1DB%2DF802%2D9167%2D1EECF64FE128032A%23cfid%3D4081861%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=/book_number/532/saving-elijah
    PATH_TRANSLATED=/root/website/reading_guides/detail/index.cfm
    QUERY_STRING=
    REMOTE_ADDR=127.0.0.1
    REMOTE_HOST=127.0.0.1
    REMOTE_USER=
    REQUEST_METHOD=GET
    SCRIPT_NAME=/reading_guides/detail/index.cfm
    SERVER_NAME=dev.bookbrowse.com
    SERVER_PORT=8500
    SERVER_PORT_SECURE=0
    SERVER_PROTOCOL=HTTP/1.1
    SERVER_SOFTWARE=
    WEB_SERVER_API=
    
    Client Variables:
    cfid=4081861
    cftoken=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    hitcount=15
    lastvisit={ts '2026-06-01 02:12:18'}
    library_user_flag=0
    member_active_flag=0
    member_logged_in_flag=0
    member_number=0
    order=p
    timecreated={ts '2026-06-01 02:12:13'}
    urltoken=CFID=4081861&CFTOKEN=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    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#=4081861&CFTOKEN#=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A#lastvisit={ts '2026-06-01 02:12:18'}#hitcount=15#timecreated={ts '2026-06-01 02:12:13'}#cftoken=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A#cfid=4081861#
    CFID=4081861
    CFTOKEN=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    
    Session Variables:
    cfid=4081861
    cftoken=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    sessionid=BOOKBROWSE_4081861_63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    urltoken=CFID=4081861&CFTOKEN=63eeec3d0d9f7de7-0987C1DB-F802-9167-1EECF64FE128032A
    
    URL Parameters:
    book_number=532
    saving-elijah=
    
    Debug Rendering Time: 11 ms