Book Summary and Reviews of French Braid by Anne Tyler

French Braid by Anne Tyler

French Braid

A novel

by Anne Tyler

  • Critics' Consensus (3):
  • Readers' Rating (14):
  • Published:
  • Feb 2023, 256 pages
  • Rate this book

About this book

Book Summary

From the beloved best-selling, Pulitzer Prize–winning author - a funny, joyful, brilliantly perceptive journey deep into one Baltimore family's foibles, from a boyfriend with a red Chevy in the 1950s up to a longed-for reunion with a grandchild in our pandemic present.

The Garretts take their first and last family vacation in the summer of 1959. They hardly ever leave home, but in some ways they have never been farther apart. Mercy has trouble resisting the siren call of her aspirations to be a painter, which means less time keeping house for her husband, Robin. Their teenage daughters, steady Alice and boy-crazy Lily, could not have less in common. Their youngest, David, is already intent on escaping his family's orbit, for reasons none of them understand. Yet, as these lives advance across decades, the Garretts' influences on one another ripple ineffably but unmistakably through each generation.

Full of heartbreak and hilarity, French Braid is classic Anne Tyler: a stirring, uncannily insightful novel of tremendous warmth and humor that illuminates the kindnesses and cruelties of our daily lives, the impossibility of breaking free from those who love us, and how close—yet how unknowable—every family is to itself.

First published March 2022. Paperback reprint Feb 2023

Please be aware that this discussion guide will contain spoilers!
  1. Revisit the novel's first chapter, now that you know the full story. What did you originally predict for Serena? What were your notions about why her family was so disconnected?
  2. Which images stand out most clearly to you from the Garretts' summer vacation? What lifelong pursuits were set in motion for Alice, Lily, and David during their time at the lakeside cabin? Share your defining memories from a childhood trip.
  3. How did your perceptions of Mercy and Robin shift as the details of their marriage unfolded? Though Robin's proposal included the plea, "If you can imagine us ever, ever divorcing, then I don't want you to accept" (page 146), was there ever a time when he felt truly secure with Mercy, and with his in-laws?
  4. ...
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

"Anne Tyler's French Braid is entirely familiar, and that's just perfect... Late in the novel, David's wife reminds him: "This is what families do for each other — hide a few uncomfortable truths, allow a few self-deceptions. Little kindnesses." "And little cruelties," David adds. Who captures that poignant paradox so well as Anne Tyler, our patron saint of the unremarked outlandishness of ordinary life?" - Ron Charles, The Washington Post

"French Braid is a novel about what is remembered, what we're left with when all the choices have been made, the children raised, the dreams realized or abandoned. It is a moving meditation on the passage of time...For all its charm, it is a quietly subversive novel, tackling fundamental assumptions about womanhood, motherhood and female aging." - Jennifer Haigh, New York Times

"[A]ny Tyler book is a gift. Funny, poignant, generous, not shying away from death and disappointment but never doomy or overwrought, it suggests there's always new light to be shed, whatever the situation, with just another turn of the prism." - Anthony Cummins, The Guardian

"Lushly imagined, psychologically intricate, virtually inhalable...At every leap, Tyler balances gracefully between tenderness and piquant humor, her insights into human nature luminous. Tyler is a phenomenon, each of her novels feels fresh and incisive, and this charming family tale will be honey for her fans." - Booklist (starred review)

"Tyler returns with a dry and well-crafted look at a family that inexplicably comes apart over several decades...Tyler's focus on character development proves fruitful; a reunion organized by the wistful Robin in the '90s is particularly affecting, as is a coda with David during the Covid-19 pandemic. As always, Tyler offers both comfort and surprise." - Publishers Weekly

"Tyler draws her characters and their interactions in such specific and revealing detail...More lovely work from Tyler, still vital and creative at 80." - Kirkus Review

This information about French Braid 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

Cathryn_Conroy

Gorgeously Written! A Brilliant Novel About Families Told with Insight, Compassion, and Wry Humor
There is a reason Anne Tyler is one of my favorite authors, and this book is Exhibit A. Her novels speak to our quotidian lives, but instead of being boring, it's brilliant. Her characters are quirky, but their emotions are universal.

Taking place in Baltimore, Maryland, this is the story of the Garrett family beginning with a flash-forward to 2010 and then going back in time to 1959 when the Garretts went on their only family vacation, traveling to Deep Creek Lake on the other side of the state. It spans four generations, continuing for more than 60 years. It all starts with Robin and Mercy, two very different souls, who marry and have three children—two girls and then years later a boy. The girls, Alice and Lily, never get along, while David is remote and tries to distance himself from the family, much to their confusion. Mercy is an artist and once the children are grown, she does something radical, something that hurts Robin so much he tries to hide it from everyone else. It is here that the novel shines as it subtly and gently takes on what it really means to be a woman, a mother, a wife and still have a genuine life. The New York Times book reviewer (author Jennifer Haigh) called it "a quietly subversive novel," and that is a perfect description.

The title of the book is pure genius because of the metaphor of the French braid that is revealed near the end of the book. When a French braid is undone from a woman's hair, it leaves crimped ripples—just as the ripples our families imprint on us whether we like it or not.

As gorgeously written as all the rest of Anne Tyler's novels, this is a story that is defined by the characters. Plot is not the point. Instead, insight, compassion, sympathy, and a wry humor for the human condition is the point. This is a book about family…about life…about truth.

PhyllisE

Brilliantly written family portrait
Thanks to NetGalley & Knopf Doubleday Publishing Group for a digital advance reader's copy. All comments and opinions are my own.

I couldn't wait for this latest title of Anne Tyler's. I've read and enjoyed almost all of her books, and this one was just as wonderful as the others. As usual, it's about a family - starting in 1959 when the Garretts take a family vacation and continuing to the present. Parents, children, grandchildren. There are many characters, but I didn't have trouble keeping track of them as the names and personalities were distinct and memorable. Once more, Tyler writes expertly of family relationships - children and their parents, and those children grow up to become parents themselves and then grandparents. For instance, it was sweet to read about David as a grandfather, and remember when he had been first a child with his toys and songs, then a college student bringing home a girlfriend, and then also as a parent. When his son Nicholas and young grandson Benny return home during the pandemic, I marveled along with David at how Benny was so similar to the young David.

But don't expect this to be an overwrought, epic, multi-generational saga. This 256-page novel features only the significant conversations, actions, and thoughts of the various characters. Yet when I finished reading it I felt that I knew exactly what Tyler was trying to convey, as Greta explains, "So this is how it works...this is what families do for each other - hide a few uncomfortable truths, allow a few self-deceptions. Little kindnesses...and little cruelties."

No one can write about family dynamics like Tyler. How people really interact with each other. What they think, what they say, and actually do. As one character notes, "Oh, the lengths this family would go to so as not to spoil the picture of how things were supposed to be!"

Some people complain that Tyler's books don't have a plot, but they're missing the point of her brilliant writing. "French Braid," like her other novels, is a family portrait containing insightful observations, portraying their relationships with each other, the love and the irritations, the miscommunications and misunderstandings. And it's Tyler's observations, descriptions, and what she chooses to focus on that make this another amazing book that I highly recommend.

Cloggie Downunder

Wonderful, as always!
“So this is how it works. This is what families do for each other - hide a few uncomfortable truths, allow a few self-deceptions. Little kindnesses. And little cruelties.”

French Braid is the twenty-fourth novel by best-selling, award-winning American author, Anne Tyler. The Garrett family, people would tell you, is fairly unremarkable. They’re living what they see as fairly unremarkable lives Baltimore. Yes, there are little quirks, minor grudges, small resentments, as in every family. But also love in its many manifestations.

To pique our initial interest, there’s Serena Drew, meeting her (newish) boyfriend’s Philadelphia parents. A chance encounter, on the journey home to Baltimore, with her cousin, draws attention to the fact that the Garretts don’t see each other very much, unlike the boyfriend’s sprawling family. To understand why, we need to go back to the late 1950s.

The Garret family on their one and only vacation, at Deep Creek Lake: Robin demonstrates his inexperience with relaxing; Mercy gets out her sketchbook and pencils and indulges in her art; seventeen-year-old Alice takes over the responsibility of feeding the family and watching over her siblings; at fifteen, Lily is quickly distracted from her sulk about leaving one boy behind by the attentions of another, older one, from whom she seems to expect a proposal; and David, to his father’s frustration, is uninterested in the water, or learning to swim.

It is always such a pleasure to read a book by Anne Tyler, and this one has you chickling all the way through, unless you are laughing out loud or saying “oh, dear” or “oh, my”, and once or twice, choking up or shedding a tear. Nothing terribly dramatic happens: readers wanting action and excitement need to look elsewhere; but Tyler’s special talent is making ordinary lives shine.

Tyler is wonderful at character description: “It always puzzled Alice, how boys would flock to Lily. Oh, she was pretty enough, in a round-faced, dimply sort of way, but that didn't explain why they grew so alert when she walked into a room. It seemed she gave off some kind of high-pitched signal that only male ears could detect. (Grown men as well as boys. Alice had noticed more than one friend's father sending Lily the same sharp arrows of awareness.)”

As always, many of her characters are a little eccentric, but their observations on life are insightful at the same time as being amusing. Serena illustrates “I can criticise my family, but you can’t”; Mercy tells her granddaughter “Sometimes people live first one life and then another life... First a family life and then later a whole other kind of life. That's what I'm doing” but she does it subtly to spare feelings from being hurt; Alice considers herself the sensible one, even if some see her as a killjoy.

Each of eight chapters is from the perspective of a different family member, giving their particular view of certain events or circumstances. If Lily’s husband sees the Garretts as narrow and unfriendly and judgemental, it’s not how they see themselves.

And Tyler’s prose is a joy: “The only sounds in the studio were the whiskery strokes of their two brushes. She'd grown used to hearing old-people music but evidently Mercy preferred to work in silence, and Candle saw her point. Silence made what she was doing seem more important, somehow - more purposeful, almost like praying.” Wonderful, as always!

CarolT

Good afternoon's read
I'm not sure why, but this was my first Anne Tyler. I was pleasantly surprised and will be looking for more.

lani

shattering examination of a family
French Braid."That's it. And then when she undid them,(her braids) her hair would still be in ripples, little leftover squiggles, for hours and hours afterward."
"Yes..."
"Well," David said, "that's how families work, too. You think you are free of them, but you're never REALLY free; the ripples are crimped in forever."
What a perfect metaphor for a family that specializes in distance from one another, secrets of their lives untold, where communication is stifled, even as their lives are enter-twined or braided with one another.
To be transparent, I kept getting knots in my stomach reading this novel as I identified my own family with its secrets, aloofness and silence. This story begins in 1959,a time when housewives generally acted like "Leave it to Beaver" and expressing their secret desires was not the norm. After several decades(60 years) we see the evolution of this family from grandparents, children and grandchildren. Though the family was cracked and detached from one another, love was expressed in small intricate waves. An insecure father, married to a woman who secretly wanted to be an artist, a daughter who was prim and proper, another one wild and contrary, and the unknowable son who distanced himself from the family. After the kids move out, the wife subtlely ships her items to a rented studio proceeding daily to set it up, bringing her clothes, beginning to spend nights there until she moves out completely while her husband refuses to acknowledge the truth. And..typical in this family, the truth is never spoken out loud to the children. The children have their own clandestine adventures in this character driven novel expressed by the minutiae of families every day lives. However, one gets to witness the unraveling which I found sad but not bleak, with the ending showing there is light at the end of the tunnel.
Although this was not my favorite of Anne Tyler's books, Tyler fans will not be disappointed. Themes are consistent with many of her other novels and you know she will pilot you safely forward.

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

Anne Tyler Author Biography

Photo: Diana Walker

Anne Tyler was born in Minneapolis, Minnesota, in 1941 and grew up in Raleigh, North Carolina. She is the author of more than twenty novels. Her twentieth novel, A Spool of Blue Thread, was short-listed for the Man Booker Prize in 2015. Her eleventh novel, Breathing Lessons, was awarded the Pulitzer Prize in 1989. She is a member of the American Academy of Arts and Letters. She lives in Baltimore, Maryland.

Author Interview

Other books by Anne Tyler at BookBrowse
  • Three Days in June jacket
  • The Amateur Marriage 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...

You can lead a man to Congress, but you can't make him think.

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 31-May-26 10:39 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780267152803 ms 1.7802671528E+012 ms 1 /root/website/app_server.cfm
1420 ms 1420 ms 1 /root/website/bb_briefs/detail/index.cfm
446 ms 446 ms 1 /root/website/bb_briefs/detail/dsp_main.cfm
426 ms 426 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
190 ms 190 ms 1 /root/website/app_layout.cfm
178 ms 45 ms 4 /root/website/adsystem/adsystem_mod.cfm
136 ms 136 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
131 ms 131 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
101 ms 101 ms 1 /root/website/app_globals.cfm
62 ms 62 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
61 ms 61 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
57 ms 57 ms 1 /root/website/adzones/AdZone3.cfm
56 ms 56 ms 1 /root/website/adzones/AdZone6.cfm
56 ms 14 ms 4 /root/website/site/blocks/membership_advantages.cfm
53 ms 13 ms 4 /root/website/queries/qry_get_member_account_types.cfm
49 ms 49 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
38 ms 38 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
37 ms 37 ms 1 /root/website/adzones/showcase_track.cfm
29 ms 29 ms 1 /root/website/adzones/AdZone11.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_active_obc.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_obc_number.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_competition.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
13 ms 13 ms 1 /root/website/act_check_login.cfm
13 ms 3 ms 5 /root/website/actions/act_spider_tracker.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_member_info.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_liked_by_brief_id.cfm
9 ms 9 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
7 ms 7 ms 1 /root/website/site/blocks/layout/main_menu.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/formurl2attributes.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1421 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

adactive (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 22:39:12.012
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 22:39:12.012
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=10ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 22:39:12.012
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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 22:39:12.012
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 22:39:12.012
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 22:39:12.012
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 22:39:12.012
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=6ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 22:39:12.012
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=14ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 22:39:12.012
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=6ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 22:39:12.012
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) = 16576

get_author_name (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 22:39:12.012
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) = 313

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 22:39:12.012
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) = 16576

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=135ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 22:39:13.013
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) = 16576
Parameter #2(CF_SQL_INTEGER) = 16576

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=49ms, Records=5) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 22:39:13.013
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) = 16576

get_arc_idfk (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:39:13.013
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) = 16576

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:39:13.013
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) = 16576

obc_discussions (Datasource=booktalk_new, Time=189ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:39:13.013
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=208ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 22:39:13.013
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) = p16576

ya_check (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 22:39:13.013
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) = 16576

get_books_by_brief (Datasource=bookbrowse_com_new, Time=9ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 22:39:13.013
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) = 16576

get_author_bookcount (Datasource=bookbrowse_com_new, Time=12ms, Records=12) in /root/website/queries/qry_get_author_bookcount.cfm @ 22:39:13.013
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) = 313
Parameter #2(CF_SQL_INTEGER) = 313

get_obc_number (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_obc_number.cfm @ 22:39:13.013
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 16576.0

existingResults (Datasource=bookbrowse_com_new, Time=52ms, Records=1) in /root/website/actions/udfs.cfm @ 22:39:13.013
SELECT id, last_updated
        FROM DiscourseSearchResults
        WHERE book_number = ?
        ORDER BY last_updated DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p16576

get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:13.013
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=39ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:13.013
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=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 22:39:13.013
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=19ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 22:39:13.013
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=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:13.013
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=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:13.013
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=90ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 22:39:13.013
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) = 313

get_jacket_info (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 22:39:13.013
SELECT ezine_preview_jacket_image
                                    FROM ezine_previews
                                    WHERE ezine_preview_number =?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 11643

get_book_image (Datasource=bookbrowse_com_new, Time=28ms, Records=1) in /root/website/actions/udfs.cfm @ 22:39:13.013
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) = 4959

get_jacket_info (Datasource=bookbrowse_com_new, Time=36ms, Records=1) in /root/website/bb_briefs/detail/dsp_main.cfm @ 22:39:13.013
SELECT ezine_preview_jacket_image
                                    FROM ezine_previews
                                    WHERE ezine_preview_number =?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7100

get_book_image (Datasource=bookbrowse_com_new, Time=52ms, Records=1) in /root/website/actions/udfs.cfm @ 22:39:13.013
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) = 1368

get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 22:39:14.014
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=9ms, Records=0) in /root/website/queries/qry_get_liked_by_brief_id.cfm @ 22:39:14.014
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) = 16576
Parameter #2(CF_SQL_INTEGER) = 16576

get_member_account_types (Datasource=bookbrowse_com_new, Time=15ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 22:39:14.014
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=39ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 22:39:14.014
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=20ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 22:39:14.014
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=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
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=29ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 22:39:14.014
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 22:39:14.014
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 22:39:14.014
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=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4075895%26CFTOKEN%23%3Dfdaf4288648ce65a%2D01E974F8%2DC7E7%2D8ADD%2D9BAFC043DFFC6E0D%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2022%3A39%3A12%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D05%2D31%2022%3A39%3A11%27%7D%23cftoken%3Dfdaf4288648ce65a%2D01E974F8%2DC7E7%2D8ADD%2D9BAFC043DFFC6E0D%23cfid%3D4075895%23; CFTOKEN=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D; CFID=4075895
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/16576/french-braid
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=4075895
cftoken=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
hitcount=6
lastvisit={ts '2026-05-31 22:39:14'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 22:39:11'}
urltoken=CFID=4075895&CFTOKEN=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
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#=4075895&CFTOKEN#=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D#lastvisit={ts '2026-05-31 22:39:12'}#hitcount=2#timecreated={ts '2026-05-31 22:39:11'}#cftoken=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D#cfid=4075895#
CFID=4075895
CFTOKEN=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
Session Variables:
cfid=4075895
cftoken=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
sessionid=BOOKBROWSE_4075895_fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
urltoken=CFID=4075895&CFTOKEN=fdaf4288648ce65a-01E974F8-C7E7-8ADD-9BAFC043DFFC6E0D
URL Parameters:
ezine_preview_number=16576
french-braid=
Debug Rendering Time: 38 ms