Book Summary and Reviews of After Annie by Anna Quindlen

After Annie by Anna Quindlen

After Annie

A Novel

by Anna Quindlen

  • Critics' Consensus (8):
  • Readers' Rating (10):
  • Published:
  • Feb 2024, 304 pages
  • Rate this book

About this book

Book Summary

Written in Quindlen's emotionally resonant voice and with her deep and generous understanding of people, After Annie is about hope, and about the unexpected power of adversity to change us in profound and indelible ways.

When Annie Brown dies suddenly, her husband, her children, and her closest friend are left to find a way forward without the woman who has been the lynchpin of all their lives. Bill is overwhelmed without his beloved wife, and Annemarie wrestles with the bad habits her best friend had helped her overcome. And Ali, the eldest of Annie's children, has to grow up overnight, to care for her younger brothers and even her father and to puzzle out for herself many of the mysteries of adult life.

Over the course of the next year what saves them all is Annie, ever-present in their minds, loving but not sentimental, caring but nobody's fool, a voice in their heads that is funny and sharp and remarkably clear. The power she has given to those who loved her is the power to go on without her. The lesson they learn is that no one beloved is ever truly gone.

Please be aware that this discussion guide will contain spoilers!
  1. Annie, like all people, has many different selves: Everyone in her life knows one aspect of her extremely well, but only by looking at all of those parts together can we truly see the whole. Discuss the different, similar, and occasionally opposing views the people in Annie's life have of her. Who was she truly?
  2. "I didn't lose my mother," Ali says. "I hate it that people say that. I didn't lose her, and she's not gone, and she didn't pass away. She's dead." Discuss the language and euphemisms we use to talk about death. Do you prefer to use "softer" language like "lost" and "passed away," or more straightforward words like "died"? Why do you think this is?
  3. With which character do you feel you have the most in common? The ...
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!

Reviews

Media Reviews

"A master of exploring human frailty and resilience in the face of domestic tragedy, best-selling Anna Quindlen plumbs the depths of Annie's survivors' individual and collective grief in scenes that are both subtle and sharp. Exquisite in its sensitivity, breathtaking in its compassion, Quindlen's exploration of loss and renewal will provoke both weeping and wonder." —Booklist (starred review)

"Quindlen makes the magnitude of her characters' loss feel palpable to the reader. It's another acute portrait of family life from a virtuoso of the form." —Publishers Weekly

"While Quindlen may lean too hard on the hope motif at the end, this is an emotionally satisfying, absorbing story." —Kirkus Reviews

"Throughout her career, Quindlen's fiction and nonfiction alike have showcased her attention to detail and ability to weave compelling narratives from the common experiences that comprise life. After Annie is a heartfelt, nuanced portrait of life after loss." —BookPage

"After Annie is Anna Quindlen's new wise and heartfelt novel of connection, of loss and love and the power of both. It celebrates the friends and family we have, mourns our great and small losses, and helps us find the unexpected light in the dark places we all have." —Amy Bloom, New York Times bestselling author of In Love: A Memoir of Love and Loss

"After Annie is a novel about loss—and yet its pages are full of life and heart. With her deft interiority and spot-on depiction of the small moments that bring characters to life, Anna Quindlen tells a family story that's at once candid and complex—and ultimately quite hopeful." —Claire Lombardo, New York Times bestselling author of The Most Fun We Ever Had

This information about After Annie was first featured in "The BookBrowse Review" - BookBrowse's membership magazine, and in our weekly "Publishing This Week" newsletter. Publication information is for the USA, and (unless stated otherwise) represents the first print edition. The reviews are necessarily limited to those that were available to us ahead of publication. If you are the publisher or author and feel that they do not properly reflect the range of media opinion now available, send us a message with the mainstream reviews that you would like to see added.

Any "Author Information" displayed below reflects the author's biography at the time this particular book was published.

Reader Reviews

Write your own reviewwrite your own review

She Treads Softly

outstandinbreathtaking and heartbreaking depiction of a family
After Annie by Anna Quindlen is an outstanding breathtaking and heartbreaking depiction of a family dealing with the untimely death of a wife and mother over the span of a year. It is a very highly recommended, exceptional literary family drama and not to be missed. One of the best. I loved this book.

When Annie Brown, 37, dies suddenly, she leaves behind her husband Bill, who is a plumber, and four children Ali (Alexandra)13, Ant (Anthony) 11, Benjy (Benjamin) 8, and James 6. She also leaves behind her best friend since childhood, Annemarie. No one knows how they can move forward without Annie. Bill is overwhelmed and forfeits much of his parental responsibility to Ali, who tries to step up and care for everyone as best she can. Ali carries the weight and tries to keep her family going. Ant is angry and acting out, Benjy begins wetting the bed, and James thinks his mom will still be coming home. Annemarie, a recovering addict due to Annie's help, is struggling with staying clean and sober.

Quindlen is an extraordinary writer who can deftly handle the subject matter accurately and with compassion. Anyone who has had an untimely death in their family will understand the emotional struggles this family is going through while trying to keep living their day to day lives. It is a deeply moving, emotionally charged story. Even when it seems not a lot of action is going on in the plot, those who have experienced this will know moving on after a death is like climbing a mountain every day. It is exhausting and overwhelming.

The narrative is broken up into seasons, winter, spring, summer, and autumn, and explores the inner life and practicalities of how each character is handling the loss of a person who held them all together. The characters are portrayed as fully-realized, complex, and realistic individuals who are trying to continue living. Annie is present in their thoughts and her backstory is told through them. The story is primarily told through Bill, Annmarie, and Ali. They are all faced with imagining life without Annie when she was a central part of their lives.

Be prepared to cry as the characters learn to live life without someone they loved. Yes, it is very sad, but there is hope in their memories as well as their struggles. This is a very emotionally satisfying story. It is okay and good to grieve those you love. Thanks to Random House for providing me with an advance reader's copy via NetGalley. My review is voluntary and expresses my honest opinion.

Janie-Hickok-Siess

Relatable & Compassionate Exploration of Grief/Mourning
Anna Quindlen is known for crafting relatable stories about ordinary people who find themselves facing unexpected challenges that leave them profoundly and irrevocably changed. The strength of her writing style is its understated simplicity and humanity.

“Bill, get me some Advil, my head is killing me,” thirty-seven-year-old Annie Brown says to her husband as she is serving dinner — meatloaf, mashed potatoes, and peas — to him and their four children on an otherwise unremarkable evening. “Bill,” she said again, “and then she went down, hard,” on the kitchen floor. Bill ran to her, scooped her into his arms, and carried her to the living room floor as he yelled to thirteen-year-old Ali to call 911. He took the telephone from her and began explaining what happened to the dispatcher as Ant, Benjy, and Jamie also watched helplessly from their seats at the kitchen table. Bill accompanied the ambulance to the hospital, leaving Ali, bewildered and frightened, to look after the younger children. Eventually, the two little boys ate some dinner, and Ali cleaned up the kitchen and got them into bed. She finally dozed off on the living room couch but was awakened at 3:11 a.m. by the sound of someone opening the back door.

Bill saw Ali on the couch and collapsed on the floor, crying. Neither of them was able to move. Finally, Bill said, “Oh, my God. What the hell am I going to do?” And any hope Ali still held out, dissipated. Bill did not need to say the words. She knew her mother was dead.

In After Annie, Quindlen examines the life of Annie’s family during the first year after her sudden death from a brain aneurysm as they grapple with loss, grief, and a future that looks nothing like it did immediately before that one pivotal moment. From her characters’ perspectives, Quindlen reveals their turbulent emotions, examines their search for peace and acceptance, and explores their efforts to adapt to a new sense of normalcy and routine.

For Bill, Annie’s death is overwhelming and, for a time, paralyzing. And not just because he loved her completely, even though they married “too fast and too young.” He depended upon her. He needed her. She was the center of his world, as well as his children’s. “Annie had been a natural mother” who was happy and content with her “lovely reliable life that went on day to day with the occasional occasion, a party, a new baby, dinner out, vacations.” She worked hard at the local nursing home where she was beloved by residents and staff alike. She adored her children and husband, as well as her best friend, Annemarie, with whom she had an unbreakable bond despite conflicts, resentments, and times that called for unyieldingly tough love. The life she and Bill shared was "enough," a fact that Annemarie could not always relate to or understand.

Even though Bill tries to “pull himself together” – he felt as though he was “leaving pieces of himself wherever he went, in every room, like he was dismembered by loss” – he has no idea how to do so. He must keep working to provide for his family – he is a plumber and Annie’s income was necessary to keep their household running – and take care of his children. He doesn’t know any of the details he relied upon Annie to remember and manage: the names of the kids’ teachers, doctors, and friends, their clothing and shoe sizes, when appointments are or need to be scheduled. He increasingly foists responsibility upon Ali and feels guilty about it, but incapable of handling things himself. And as his overbearing, self-centered mother, Dora, who owns the house in which they reside and with whom Annie had a fractious relationship, pressures him to “move on,” only making things worse, he reconsiders his life. “Was his life a choice or an accident?” Dora never liked Annie because she thought Bill could have fared better by marrying his high school girlfriend, Liz, a perky real estate agent who is eager to take Annie’s place . . . with Dora’s blessing. But a new relationship, along with all of the other changes Liz attempts to impose on the Brown family, is not what Bill – or his grieving children – need. He feels as though is life is “bring run by women” –wasn’t it always? – and he recognizes that he must find his own voice and be assertive, make appropriate choices for himself and his family, and stand on his own for the first time in his life.

Ali finds returning to school after her mother’s death difficult and Annemarie observes that Annie would be heartbroken that Ali seems to have become “a grownup in an instant.” Ali does not want to cry because that will make it “all true,” and she is displeased when forced to participate in sessions with the school counselor. Her best friend, Jenny, a secretive girl from a wealthy, overprotective family, reminds Ali not to share her feelings with the counselor. No good could come from it. Rather, the counselor would “become your extracurricular activity, and you would become that kid.” “I didn’t lose my mother,” Ali explains to Ms. Cruz, who is new to the school. “I hate it that people say that. I didn’t lose her, and she’s not gone, and she didn’t pass away. She’s dead.” Ali isn’t eating and is bothered by the fact that her father and brothers have stopped talking about her mother. She resents her father’s attempts to move on with his life, particularly the time he spends with Liz instead of at home, noting that he can find a new wife, but she and her brothers can never have another mother. Over the course of the next few months, Ali does open up to Ms. Cruz as she grows taller, developing into a young woman. Her understanding of the adults in her life and their shortcomings expands as she learns to trust her own instincts, forgive, and appreciate that although her mother may not be physically present any longer, their connection to each other can never be severed.

At the age of eleven, Annie’s death exacerbates Ant’s already-simmering anger. Unsure how to respond to his outbursts or comfort his oldest son, Bill proceeds with Annie’s plan to send him to camp where his behavioral problems amplify. With each passing day, Ant becomes crueler, hurling vile insults at others. Benjy requires a tutor because he is having difficulty learning to read and six-year-old Jamie just wants to know when his mother is coming home. He insists that she is “being patched up at the hospital.”

For Annemarie, the magnitude of the loss of the woman who has been her best friend since first grade defies description. Annie was Annemarie’s life compass. She knew the real Annemarie and, unlike others, was never fooled by her. Annemarie recalls how Annie literally saved her life, but accepted no excuses and threatened to turn her back on Annemarie forever if she failed to match Annie’s belief in her and efforts on her behalf. Fear of how desolate her life would be without her best friend and most stalwart supporter kept Annemarie clean and sober. But losing Annie has destroyed Annemarie’s equilibrium, and her already prickly relationship with Bill is “curdling” without Annie there to mediate. She is reeling, spiraling out of control, and veering toward abusing prescription drugs again. Will anything stop her from destroying her marriage, business, and life?

The story opens in winter and Quindlen’s narrative moves forward through the seasons until it is winter again and the first anniversary of Annie’s death. Quindlen’s riveting story compassionately details how the Brown family becomes utterly lost when Annie dies, unequipped to navigate the shocking and unspeakably profound departure of their wife, mother, and irreplaceable friend. Quindlen’s depiction of how they find their way through the haze of grief and sorrow that descends upon them is compelling and credible. Every one of Quindlen’s fully developed characters is flawed and vulnerable, their imperfections magnified in the wake of Annie’s absence. They are also sympathetic and, largely, likeable. Even Dora, pushy and domineering, is empathetic because she loves her son and wants the best for him and her grandchildren, and her worldview is the culmination of her own life experiences. So there are no villains in this story. Rather, the characters are a group bound together by their love for and relationships with Annie who must reevaluate and redesign their connections to and interactions with each other, and their own lives, without her. Once again, Quindlen, who the New York Times aptly alls an “anthropologist of domesticity,” probes the nuances of everyday life – shock, grief, mourning, and finding happiness again – with quiet, eloquent insight and tenderness. Small details, like the way characters continue calling Annie’s phone just to hear her voice and how scents evoke memories and longing, resonate. After Annie is a richly emotional story populated with characters about whom readers will care deeply as they contemplate their own reaction to and capacity to navigate loss and rebuilding.

Thank you to NetGalley for an Advance Reader's Copy of the book.

Marc Eichsteadt

Not bad, but
The author should have done more research on extended care facilities. There are so many people going in and out of even supposedly empty rooms, that Ann Marie 's presence would have been quickly noted. Also, where did an aquire medications? Many facilities have certified nursing assistants who dispense medications. From the description of Ann's duties, she was clearly not one of them. Believe me, missing narcotics would be noticed.
Quindlen's description of 12 step programs indicated a lack of research as well. Ann Marie described them a "rotating group of not really frinds"(I paraphrase ) Entirely untrue, the people who work these programs are the best friends one could possibly have

Old RN

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!

Author Information

Anna Quindlen Author Biography

Anna Quindlen is a novelist and journalist whose work has appeared on fiction, nonfiction, and self-help bestseller lists. She is the author of many novels: Object Lessons, One True Thing, Black and Blue, Blessings, Rise and Shine, Every Last One, Still Life with Bread Crumbs, and Miller's Valley. Her memoir Lots of Candles, Plenty of Cake, published in 2012, was a #1 New York Times bestseller. Her book A Short Guide to a Happy Life has sold more than a million copies. While a columnist at The New York Times she won the Pulitzer Prize and published two collections, Living Out Loud and Thinking Out Loud. Her Newsweek columns were collected in Loud and Clear.

Author Interview
Link to Anna Quindlen's Website

Name Pronunciation
Anna Quindlen: kwind-len

Other books by Anna Quindlen at BookBrowse
  • Rise and Shine jacket
  • Loud and Clear jacket

12 more...

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!

Read-Alikes

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

To limit the press is to insult a nation; to prohibit reading of certain books is to declare the inhabitants to be ...

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 /bb_briefs/detail/index.cfm
Time Stamp 01-Jun-26 10:28 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
1780309691561 ms 1.78030969156E+012 ms 1 /root/website/app_server.cfm
886 ms 886 ms 1 /root/website/bb_briefs/detail/index.cfm
244 ms 244 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
185 ms 185 ms 1 /root/website/bb_briefs/detail/dsp_main.cfm
159 ms 159 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
94 ms 94 ms 1 /root/website/app_layout.cfm
76 ms 76 ms 1 /root/website/app_globals.cfm
75 ms 19 ms 4 /root/website/adsystem/adsystem_mod.cfm
72 ms 72 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
62 ms 62 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_active_obc.cfm
31 ms 31 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
30 ms 30 ms 1 /root/website/adzones/AdZone6.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone3.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
18 ms 18 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
18 ms 5 ms 4 /root/website/site/blocks/membership_advantages.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
16 ms 16 ms 1 /root/website/adzones/showcase_track.cfm
13 ms 3 ms 4 /root/website/queries/qry_get_member_account_types.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_obc_number.cfm
9 ms 9 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/adzones/AdZone11.cfm
8 ms 8 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
6 ms 6 ms 1 /root/website/act_check_login.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_member_info.cfm
5 ms 1 ms 5 /root/website/actions/act_spider_tracker.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_current_competition.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_liked_by_brief_id.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
1 ms 1 ms 1 /root/website/formurl2attributes.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.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/site/blocks/act_book_view_tracking.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
889 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 10:28:11.011
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 @ 10:28:11.011
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=9ms, Records=2) in /root/website/actions/adstatus.cfm @ 10:28:11.011
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 @ 10:28:11.011
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 @ 10:28:11.011
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 10:28:11.011
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 @ 10:28:11.011
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 @ 10:28:11.011
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=6ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 10:28:11.011
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=5ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 10:28:11.011
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=26ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 10:28:11.011
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_preview_by_id (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 10:28:11.011
select 			a.ezine_preview_number,
				a.ezine_number, 
				a.ezine_preview_category_number, 
				a.ezine_preview_title, 
				a.ezine_preview_subtitle, 
				a.ezine_preview_author, 
				a.ezine_preview_publisher,
				a.ezine_preview_publish_dt,
				a.ezine_preview_number_of_pages, 
				a.ezine_preview_jacket_image,
				a.ezine_preview_reviews,
				a.ezine_preview_short_summary,
				a.ezine_preview_jacket_desc,
				a.ezine_preview_reading_guide,
				a.ezine_preview_bb_comments, 
				a.ezine_preview_isbn,
				a.ezine_preview_isbn13,
				a.ezine_preview_rating,
				a.ezine_preview_bb_link,
                a.ezine_preview_bb_author_link,
                a.ezine_preview_firsts_flag,
                a.ezine_preview_reading_level,
                a.ezine_preview_paperback_flag,
				b.*,
                c.ezine_dt, c.ezine_description
,(select publisher_holding_company from publishers where ezine_preview_publisher like publisher_imprint AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
 				
from ezine_previews a 
inner join ezine_preview_categories b ON b.ezine_preview_category_number = a.ezine_preview_category_number
left join ezines c ON c.ezine_number = a.ezine_number

where ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451

get_author_name (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 10:28:11.011
SELECT author_number, 
        CASE WHEN datalength(author_middle_initial) > 0 then author_first_name + ' ' + author_middle_initial + '. ' + author_last_name
            ELSE author_first_name + ' ' + author_last_name
            END "author_name"
        FROM authors 
        WHERE author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 293

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 10:28:11.011
select a.book_award_number, a.book_award_name, a.book_award_image, c.book_award_dt
    from book_awards a 
    inner join book_awards_category b on b.book_award_number = a.book_award_number
    inner join book_awards_mapping c on c.book_awards_category_number = b.book_awards_category_number
    where ezine_preview_number =  ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=159ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 10:28:11.011
SELECT	(CAST(AVG(CAST(rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) >= 50 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
			ELSE 0
			END) AS "avrating",
            count(rating) as "ratcount"
            
	FROM (
		SELECT reader_review_rating AS rating
		FROM reader_reviews
		WHERE ezine_preview_number = ?
		
		AND reader_review_rating > 0
		
		UNION ALL
		
		SELECT reading_list_book_rating AS rating
		FROM reading_lists
		WHERE book_number LIKE 'p%'
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) = ?
		AND reading_list_book_rating > 0
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) IS NOT NULL
	) combined_ratings
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451
Parameter #2(CF_SQL_INTEGER) = 18451

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=62ms, Records=3) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 10:28:11.011
SELECT 		a.reader_review_number, a.book_number, a.ezine_preview_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.ezine_preview_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    FROM 		reader_reviews a
    INNER JOIN	ezine_previews b ON a.ezine_preview_number = b.ezine_preview_number
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number
	WHERE 		a.ezine_preview_number = ?
    AND			a.book_number = 0
    AND 		a.reader_review_approved_flag = 1
    

	ORDER BY a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451

get_arc_idfk (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:28:11.011
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18451

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:28:11.011
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1 AND a.discourse_flag = 0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 18451

obc_discussions (Datasource=booktalk_new, Time=123ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:28:12.012
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=88ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 10:28:12.012
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) = p18451

ya_check (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 10:28:12.012
select ezine_preview_reading_level 
from ezine_previews 
where ezine_preview_number = ?
and ezine_preview_reading_level = 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451

get_books_by_brief (Datasource=bookbrowse_com_new, Time=12ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 10:28:12.012
select 			top 20
				a.ezine_preview_reading_level,
				b.category_name,
				c.category_number, 
				d.book_number, d.book_title,
				f.author_number, f.author_first_name, author_middle_initial, author_last_name
				
from 			ezine_previews a 
inner join		categories b on b.ezine_preview_category_number = a.ezine_preview_category_number
inner join		category_book_mapping c on c.category_number = b.category_number
inner join		books d on d.book_number = c.book_number
inner join		book_author_mapping e on e.book_number = d.book_number
inner join		authors f on f.author_number = e.author_number

where			a.ezine_preview_number = ? 

order by 		d.book_number DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451

get_author_bookcount (Datasource=bookbrowse_com_new, Time=5ms, Records=12) in /root/website/queries/qry_get_author_bookcount.cfm @ 10:28:12.012
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) = 293
Parameter #2(CF_SQL_INTEGER) = 293

get_obc_number (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_obc_number.cfm @ 10:28:12.012
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 18451.0

existingResults (Datasource=bookbrowse_com_new, Time=57ms, Records=1) in /root/website/actions/udfs.cfm @ 10:28:12.012
SELECT id, last_updated
        FROM DiscourseSearchResults
        WHERE book_number = ?
        ORDER BY last_updated DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p18451

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

get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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) = adzone3

get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 10:28:12.012
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_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 10:28:12.012
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_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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) = adzone11
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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) = adzone11

get_bio (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 10:28:12.012
SELECT 	a.author_number, author_info_biography, author_info_image, author_info_copyright_info, author_info_interview, author_pronunciation, author_info_url
                        FROM 	author_info a
                        inner join authors b on b.author_number = a.author_number
                        WHERE 	a.author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 293

get_jacket_info (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 10:28:12.012
SELECT ezine_preview_jacket_image
                                    FROM ezine_previews
                                    WHERE ezine_preview_number =?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9256

get_book_image (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/actions/udfs.cfm @ 10:28:12.012
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) = 1869

get_jacket_info (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 10:28:12.012
SELECT ezine_preview_jacket_image
                                    FROM ezine_previews
                                    WHERE ezine_preview_number =?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11398

get_book_image (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/udfs.cfm @ 10:28:12.012
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) = 1398

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 10:28:12.012
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_liked_by_brief_id (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_liked_by_brief_id.cfm @ 10:28:12.012
SELECT
		ep.ezine_preview_title AS book_title,
		'p' + CAST(ep.ezine_preview_number AS VARCHAR) AS book_number,
		b.book_title AS "referenced_book_title",
		CAST(b.book_number AS VARCHAR) AS "liked_book_number",
		b.book_short_summary AS "liked_short_summary",
		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 = b.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',
		0 AS 'is_brief'

	FROM 		liked a
	INNER JOIN	ezine_previews ep ON ep.ezine_preview_number = ?
		AND a.book_number = ep.ezine_preview_number
	INNER JOIN	books b ON b.book_number = a.liked_book_number
	INNER JOIN	book_author_mapping d ON d.book_number = b.book_number
	INNER JOIN	authors e ON e.author_number = d.author_number

	UNION

	
	SELECT
		ep.ezine_preview_title AS book_title,
		'p' + CAST(ep.ezine_preview_number AS VARCHAR) AS book_number,
		b.book_title AS "referenced_book_title",
		CAST(b.book_number AS VARCHAR) AS "liked_book_number",
		b.book_short_summary AS "liked_short_summary",
		CASE
			WHEN datalength(auth.author_middle_initial) > 0
			THEN auth.author_first_name + ' ' + auth.author_middle_initial + '. ' + auth.author_last_name
			ELSE auth.author_first_name + ' ' + auth.author_last_name
		END AS "author_name",
		(select top 1 edition_publish_dt from editions where editions.book_number = b.book_number order by edition_publish_dt DESC) AS 'sortdate',
		0 AS 'liked_author_bookcount',
		0 AS 'is_brief'

	FROM 		readalikes_cache rc
	INNER JOIN	ezine_previews ep ON ep.ezine_preview_number = ?
		AND rc.source_book_number = 'p' + CAST(ep.ezine_preview_number AS VARCHAR)
	INNER JOIN	books b ON b.book_number = rc.recommended_book_number
	INNER JOIN	book_author_mapping bam ON bam.book_number = b.book_number
	INNER JOIN	authors auth ON auth.author_number = bam.author_number

	ORDER BY 	sortdate desc, referenced_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 18451
Parameter #2(CF_SQL_INTEGER) = 18451

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 10:28:12.012
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=3ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 10:28:12.012
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 @ 10:28:12.012
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=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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=7ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 10:28:12.012
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 @ 10:28:12.012
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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 @ 10:28:12.012
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 10:28:12.012
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/bb_briefs/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=4095031; CFTOKEN=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0; CFGLOBALS=urltoken%3DCFID%23%3D4095031%26CFTOKEN%23%3D1ad2d85a71b779a4%2D1B3EC133%2DBF4F%2DE973%2D8A1E1491BBD9B3C8%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2010%3A28%3A11%27%7D%23hitcount%3D233%23timecreated%3D%7Bts%20%272026%2D06%2D01%2010%3A27%3A33%27%7D%23cftoken%3D1142e63133115e7a%2D1B3EB86D%2DB81F%2D16BA%2D2D20A2ADE518BFDD%23cfid%3D4095029%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/ezine_preview_number/18451/after-annie
PATH_TRANSLATED=/root/website/bb_briefs/detail/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/bb_briefs/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=4095029
cftoken=1142e63133115e7a-1B3EB86D-B81F-16BA-2D20A2ADE518BFDD
hitcount=237
lastvisit={ts '2026-06-01 10:28:12'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 10:27:33'}
urltoken=CFID=4095031&CFTOKEN=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8
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#=4095031&CFTOKEN#=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8#lastvisit={ts '2026-06-01 10:28:11'}#hitcount=233#timecreated={ts '2026-06-01 10:27:33'}#cftoken=1142e63133115e7a-1B3EB86D-B81F-16BA-2D20A2ADE518BFDD#cfid=4095029#
CFID=4095031
CFTOKEN=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8
FREEACCESSCOUNT=0
Session Variables:
cfid=4095031
cftoken=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8
sessionid=BOOKBROWSE_4095031_1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8
urltoken=CFID=4095031&CFTOKEN=1ad2d85a71b779a4-1B3EC133-BF4F-E973-8A1E1491BBD9B3C8
URL Parameters:
after-annie=
ezine_preview_number=18451
Debug Rendering Time: 14 ms