David Ebershoff Interview, plus links to author biography, book summaries, excerpts and reviews

David Ebershoff
Photo: Edith Sanchez

David Ebershoff

An interview with David Ebershoff

David Ebershoff discusses The 19th Wife, which explores the controversial early life of the Church of Latter-day Saints and in particular Ann Eliza Young, 19th wife to Brigham Young, who was instrumental in ending the legal practice of polygamy in the USA.

David Ebershoff discusses The 19th Wife

How did you first encounter the story of Ann Eliza Young, the 19th wife of Brigham Young, and what drew you to her story?

I first heard about Ann Eliza Young seven years ago while editing a book for the Modern Library. I had hired a scholar — a specialist in 19th century women's history — to write a set of endnotes for a classic we were reissuing. History geek that I am, one afternoon I was gabbing with her about all sorts of 19th-century arcana when she mentioned the 19th Wife. I told her I'd never heard of her and she gave a me brief introduction. Needless to say, my writer's ears stood up.

At the time I was working on another novel, one that I would ultimately put aside to write The 19th Wife. And so for a few years, while my attention was elsewhere, that nickname — the 19th Wife — continued to ring in my head. The 19th Wife? Who was that? What does it even mean to be a 19th wife? After a few years I started looking into that question. As I read more about Ann Eliza Young, I recognized how remarkable she was: intelligent, outspoken, declarative, contradictory, somewhat unreliable, a tad melodramatic, very beautiful (and a little bit vain) — she possessed a number of traits that can make a character in a novel unpredictable, and therefore interesting. I found myself torn between the novel I was working on and a nearly overwhelming desire to throw myself into the world of Ann Eliza and polygamy. Then one night I woke up — literally sat up in bed — and I knew I had to write this book. Just one problem: What book was I going to write? How would I tell her story? And how to make it relevant to today? It took a long, unsettling year of research before I could begin actually writing.


This book intertwines a historical narrative of Ann Eliza's life and a contemporary narratives set on a polygamous compound in Utah. How did you research both the historical narrative and the contemporary story?

The research for the historical narrative started with Ann Eliza herself. She wrote two autobiographies, Wife No. 19 (1875) and Life in Mormon Bondage (1908). Wife No. 19 was a hugely successful book in its day and helped shape the national debate about polygamy. It would also become an important part of Ann Eliza's legacy. By the time she published her second book, she had fallen into obscurity. That book had a very small printing (less than 1,000 copies as far as I can tell) and received little notice — a pity because the second book in some ways shows Ann Eliza as more thoughtful and self-aware. These books are the inevitable place to begin when thinking about Ann Eliza and her life, and I couldn't have written my novel in its present form without them.

But Ann Eliza's record doesn't stop with her memoirs. In fact, it doesn't even begin with them. After leaving her husband and apostatizing from the LDS Church, she went on a national speaking tour that lasted more than a decade. She wrote a suite of three long lectures about her life as a Latter-day Saint and her experiences as a plural wife. By the time she had published her first book, tens of thousands of people (including members of Congress and President Grant) had heard her story, or read about it in the newspapers, which followed her closely. From 1873-1875 Ann Eliza Young was national news. The beautiful, strong-willed, articulate young woman who had defied her husband and prophet fascinated Americans everywhere. Many newspapers covered her story and her divorce with tabloid interest. Some of the news stories about Ann Eliza remind me of some of the recent reporting on the polygamists in Eldorado, Texas.

After spending a lot of time reading about Ann Eliza, I saw that there are three essential parts to her story: her life; her book; and her legacy. I wanted to write about her in a way that captures those three elements: to tell the story of the life she lived; to give the reader a sense of Wife No. 19's impact on her life and the national debate; and to contemplate her legacy by rendering what she did and did not achieve. This is why I wrote a part of the novel as her "memoir" — and why there is a "book" within the book. (Forgive me, I'm usually not this meta.) This is why I start The 19th Wife with a title page similar to Ann Eliza's actual title page, but just as you think you are settling into one kind of story, the novel cuts sharply into something else.

I wrote the contemporary narrative — "Wife # 19" or Jordan's story — with a phone, a notebook, and a rental car. I spent as much time as possible in Hildale/Colorado City in Utah, which is to say, not very much time. Every time I went there something happened that told me I needed to clear out quickly. The first time I visited I was driving around the neighborhoods, looking at the unusually large houses and the vegetable patches and the horse corrals, just taking it all in, when I looked up in my rear view and noticed a police cruiser behind me. I turned down a side street and he turned as well. Was he following me? I turned again, and he turned again, and then again. I instinctively knew the cop wanted me to leave. He tailed me all the way back to Highway 59, and as I drove off he idled on the side of the road, making sure I was gone. I could hardly believe it: in the United States in the twenty-first century I had just been driven out of town.

I ended up interviewing several people who had once been part of polygamous families — women who had left their husbands and boys and young men who had been excommunicated. Each told a variation of the same story — a dominant theology, a bounty of wives, a life of neglect and fear. It was fascinating and heartbreaking, and each time I heard one of these stories I thought of Ann Eliza — how she thought she had brought an end to polygamy in the United States, but in fact had not. It's worth noting that not all American polygamists today live in the notorious isolated compounds that we've seen in the news lately. I even interviewed one woman who lived in suburban Pennsylvania with her husband, two sister wives, and their ten children.


Some say Ann Eliza Young was not Brigham Young's 19th wife, but actually the 27th or possibly even the 52nd or 56th wife. Why the confusion?

The confusion comes from the shifting definition of wife. Ann Eliza thought of herself as the 19th wife, and this was where she fell on Brigham's count as well. In her day, she was widely known as the 19th wife. That's why I call her this. But the tally of wives has always been fluid and I believe will never be settled. Some lists do not count as wives Brigham's spouses who died before him or who had left him (Ann Eliza was not the first). Some historians don't count, or count separately, women Brigham married but who bore him no children. In some cases, the marriage (or sealing) ceremonies were highly secretive and there is little documentation: some women claimed to have been sealed to Brigham but he denied this, or some of his family members denied this. I believe he had more than fifty wives, although certainly some of these were elder widows whom he married in order to provide them with a home, a secure place in society, and spiritual comfort.

When I started writing the novel I was determined to solve the question — how many wives did Brigham really have? But after a lot of searching, and an excel spread sheet that got more and more confused, I eventually concluded no one can answer that question with utter, case-closed certainty. At first this frustrated me, but then I realized I could use this mystery as part of the novel's plot. As one character in the novel says, "Indeed, there are some mysteries that must exist without answer. In the end we must accept them for what they are: complex and many-sided, ornamented with clues and theories, yet ultimately unknowable — like life itself."


What really happened to Ann Eliza?  Did she really disappear? 

As far as I know, it remains a mystery. A reliable record ends after she published her second memoir in 1908. It's hard to believe that someone once so famous and influential could disappear. But 100 years later, Ann Eliza's ultimate fate remains unknown.

Of course it's possible with the publication of The 19th Wife someone will emerge with a letter, a newspaper clipping, a death certificate, or a photo of a gravestone. I would welcome this as much as anyone. A few months ago, while I was editing the galley pages, I got an email from a woman in Alaska who said cryptically, I am a descendent of Ann Eliza and I know what happened to her. Immediately I called her and said, "What do you know?" As it turned out she knew very little about Ann Eliza, and nothing accurate about her fate, but she was in fact one of Ann Eliza's descendants and she took an understandable pride in her heritage.


You've touched on this, but can you tell us why you decided to write this as a novel instead of as non-fiction?

The short answer is I'm a novelist, and that's the form I think in. The long answer has to do with the reliability of facts, memory, and point of view. From the moment she left the Mormon Church, Ann Eliza faced challenges to her credibility. Hurt by her attacks, some of Brigham's supporters disputed her version of events, claiming she was lying or at least exaggerating. But at the same time, other plural wives who had apostatized told similar stories of abuse and neglect. So who can a writer — and a reader — trust? Fiction — especially a novel with many disparate voices — can accommodate these conflicting points of view. This is one of the reasons the novel is almost entirely in the first person. I wanted to make it clear that each person is voicing his or her point of view, with all the wonders and limits that entails. In The 19th Wife, Ann Eliza's son remarks in a letter to a historian many years after his mother's apostasy, "I must say a few words about memory. It is full of holes. If you were to lay it out upon a table, it would resemble a scrap of lace. I am a lover of history. . . .[but] history has one flaw. It is a subjective art, no less so than poetry or music. . . The historian writes a truth. The memoirist writes a truth. The novelist writes a truth. And so on. My mother, we both know, wrote a truth in The 19th Wife — a truth that corresponded to her memory and desires. It is not the truth, certainly not. But a truth, yes…. Her book is a fact. It remains so, even if it is snowflaked with holes."


This novel merges several voices and formats — autobiography, letters, a cartoon, a poem, and even a Wikipedia entry. Why did you decide to tell the story in this way?

As I mentioned earlier, I believe history is subjective. Even the most meticulous historians work subjectively. The historian's point of view, his or her selection of subject and sources, the emphasis, the tone — all of these lead to subjective history, inevitably so. I do not say this as a criticism, merely as an observation. I love to read history; at its best, it is an art. And art is — has to be! — subjective. I decided to include a number of fictional documents or sources (many of them of course inspired by actual documents and sources) because I wanted to give the reader the sense of what it's like to delve into this history and to sort through the record and the different points of view. The novel's historical sections focus on Ann Eliza's story, of course, but I wanted to enrich that in a way that recreates, for the reader, the experience of digging deeper and deeper into the archives. The 19th Wife has a number of mysteries within it — the mystery of what happened to Ann Eliza is one, and the genre-style mystery of Jordan's story is another. The novel intentionally plays with the metaphor of mystery in a number of ways. I hope these different documents and sources bring another kind of mystery to the book and ask, in a different way, how and why we solve mysteries. Already a number of readers have told me that they've read the book with their browser open to Google. That's exactly what I'd love to happen — readers figuring out a lot for themselves, in their own way. I hope the novel's structure makes it clear that I do not believe this to be the final word on Ann Eliza, Brigham, or polygamy in the United States. I always love novels that open up a subject to me — like raising a window to a beautiful, mysterious world outside.


You have Ann Eliza Young state in the book that "our response to the moral and spiritual enslavement of Utah's women and children will define us in the years to come." What do you think she would make of the current state of polygamy in the US?

I believe she would be surprised to see it still practiced in the United States. She took pride in her role in bringing an end to plural marriage in the LDS Church. Of course, she did not do this alone and more than fifteen years passed from her apostasy until the Latter-day Saints officially renounced polygamy. But one of the wonderful ironies of her story is that in one sense she helped save the LDS Church and steer it toward its future. If the Latter-day Saints had not abandoned plural marriage, they would have remained a fringe religion and would never have moved into mainstream American culture. Today, the Church of Jesus Christ of Latter-day Saints thrives. It is one of the fastest growing religions in the country and is the most successful American-born religion. I believe none of this would be true had the Church held onto the doctrine of plural marriage. Even today, some people dismiss Ann Eliza as a gadfly or write her off as an angry ex-wife. In my opinion, she played an indirect, but important role in the Church's history, although certainly one no one could have predicted it in the heated days of her divorce from Brigham Young.


The majority of women in your novel are unhappy in their plural marriages and jealous of the other wives. Did you come across any accounts of women who were happy in their plural marriage?

The historical record contains numerous accounts — diaries and letters and other documents — of 19th-century women writing of the many comforts they found in plural marriage. Primarily, these women celebrated plural marriage because they believed it ensured their salvation. Yet other women found more practical comforts: companionship, the sharing of household chores, child care, as well as a relief from what they might have described as conjugal duty. I allude to this in certain parts of the novel. For example, the poem "In Our House" is a sincere expression of the joy one plural wife found in her marriage. Yet we cannot read these documents and testaments without remembering that if a plural wife had spoken out against polygamy she would have faced ostracism, excommunication, and, according to her faith, would have been denied salvation.

My experience researching twenty-first-century polygamy was similar. The women I interviewed loathed their experiences in plural marriage, speaking out forcefully against it. When I asked them about women who said they cherished being a plural wife, inevitably they said these women were either lying out of fear or were deluded. Each time I visited Hildale/Colorado City I asked several women for an interview. No one would say more than a few words. Were they silent because they feared the repercussions of speaking the truth, or because they simply had no interest in speaking to me? Of course in recent months we have seen several plural wives speak about their experiences on television. But who among us can say what is really in their hearts?

Spoiler alert: if you don't want to find out what happens at the end of the novel jump to the next question. With that warning, I want to add that the book ends with Jordan taking his mom back to Mesadale. She wants to return to her former life. Just as important, Jordan has to accept this. His mom wants to be a plural wife. Despite everything, that is what she believes. The novel purposefully ends on this note of ambiguity.


The story of the FLDS group in the Yearning for Zion Ranch in Texas has captured the attention of the media for months. Why are we still fascinated by polygamy?

I believe it's one part titillation (there's a sexual component to it, of course), and one part profound ambiguity. This is America: if a man and nineteen women want to live together, who has the right to say they cannot? Yet that scenario gets more complicated when children are involved, which inevitably they are. In the sad instances of physical and/or sexual abuse, the answer is a lot more straightforward: society has a responsibility to protect abused children. But physical and sexual abuse are not always present. And that's where the questions become a lot murkier: Should children be protected from households of emotional abuse and neglect? But how do you determine emotional abuse and neglect? Don't parents have the right to raise their children according to their own beliefs? Or does that right end when those beliefs fall far outside cultural norms? And who can, or should, determine that? And doesn't every American have the right to religious freedom? Yes, but not at the expense of another person's freedom or well-being. But how do you determine, in these circumstances, if someone is acting and thinking freely? Who can really say if the thousands of plural wives in Utah, Arizona, Idaho, and Texas need society's assistance, or have the right to be left alone? These are some of the difficult questions that the United States has grappled since the 19th century, and will continue to do so for many years.


Two of your novels — The Danish Girl and now The 19th Wife — have been inspired by the lives of real people. What is it about retelling true stories that appeals to you?

I love to read (and edit) biographies. For me, one of biography's many appeals is seeing how a life can be retold again and again artfully and freshly. Currently I'm editing a major biography of Abraham Lincoln — A. Lincoln by Ronald C. White, Jr., which will come out in early 2009. Some people might ask, What can possibly be left to say about Lincoln? In fact, a lot. Ron has unearthed new facts about the evolution of Lincoln's political thinking and his moral development, which shed light on his presidency. Just as important, Ron writes in a clear, simple, poignant voice — one that suits Lincoln perfectly, and even at times echoes Lincoln's own prose. Finally, Ron has reinterpreted Lincoln for our day. All of this makes the book new, exciting, and relevant. And this is how I came to look at Ann Eliza Young and American polygamy. True, she wrote her own memoirs, and, true, Irving Wallace wrote a biography of her in 1961. If anyone wants to know more about her, I recommend these books. Yet as we all have seen recently, the story does not end there. I hope that The 19th Wife can illuminate a set of questions, perhaps inform a little, and maybe even entertain. But I'll be the first to tell you I have not written the last word. As Jordan says on the novel's last page: "Endings are beginnings."

Unless otherwise stated, this interview was conducted at the time the book was first published, and is reproduced with permission of the publisher. This interview may not be reproduced or reprinted without permission in writing from the copyright holder.

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!

Books by this Author

Books by David Ebershoff at BookBrowse
The 19th Wife jacket
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

All the books below are recommended as read-alikes for David Ebershoff but some maybe more relevant to you than others depending on which books by the author you have read and enjoyed. So look for the suggested read-alikes by title linked on the right.
How we choose readalikes

  • David Czuchlewski

    David Czuchlewski

    David Czuchlewski studied English at Princeton University under Joyce Carol Oates, and later studied medicine at Mount Sinai School of Medicine. He has published two books - The Muse Asylum and Empire of Light. (more)

    If you enjoyed:
    The 19th Wife

    Try:
    Empire of Light
    by David Czuchlewski

  • Jon Krakauer

    Jon Krakauer

    Jon Krakauer is an American writer and mountaineer, primarily known for his writings about the outdoors, especially mountain-climbing. He is the author of best-selling non-fiction books: Into the Wild, Into Thin Air,Under ... (more)

    If you enjoyed:
    The 19th Wife

    Try:
    Under the Banner of Heaven
    by Jon Krakauer

We recommend 8 similar authors

View all 8 Read-Alikes

Non-members can see 2 results. Become a member
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...

The secret of freedom lies in educating people, whereas the secret of tyranny is in keeping them ignorant

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 /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 01:44 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
1780278248462 ms 1.78027824846E+012 ms 1 /root/website/app_server.cfm
503 ms 503 ms 1 /root/website/author_interviews/full/index.cfm
228 ms 228 ms 1 /root/website/author_interviews/full/dsp_main.cfm
160 ms 80 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
129 ms 129 ms 1 /root/website/app_layout.cfm
92 ms 92 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
82 ms 27 ms 3 /root/website/adsystem/adsystem_mod.cfm
72 ms 72 ms 1 /root/website/app_globals.cfm
35 ms 12 ms 3 /root/website/site/blocks/membership_advantages.cfm
34 ms 11 ms 3 /root/website/queries/qry_get_member_account_types.cfm
32 ms 32 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
31 ms 31 ms 1 /root/website/adzones/AdZone6.cfm
31 ms 31 ms 1 /root/website/adzones/showcase_track.cfm
31 ms 31 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_active_obc.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
26 ms 26 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
20 ms 20 ms 1 /root/website/adzones/AdZone2.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
9 ms 9 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_competition.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
7 ms 7 ms 1 /root/website/act_check_login.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
4 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
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/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
505 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 01:44:08.008
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=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 01:44:08.008
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 @ 01:44:08.008
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 01:44:08.008
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=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 01:44:08.008
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:44:08.008
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=5ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:44:08.008
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 01:44:08.008
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 @ 01:44:08.008
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=7ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 01:44:08.008
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=13ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 01:44:08.008
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 01:44:08.008
select	a.book_number, a.book_title, a.book_sub_title, book_short_summary,
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
        left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0 
   		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1 
		
       	where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)

		order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1601

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 01:44:08.008
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1601

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 01:44:08.008
select	a.book_number, 
        		'' AS ezine_preview_number,
                a.book_title, 
                a.book_sub_title, 
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt",
                '' as "jacket"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
		left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
		
        where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)        
        UNION

		select	'' AS book_number,
        		ezine_preview_number, 
				ezine_preview_title AS "book_title", 
				ezine_preview_subtitle AS "book_sub_title",
                ezine_preview_publish_dt AS "publish_dt",
                ezine_preview_jacket_image as "jacket"
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		ezine_preview_bb_link < 1
        
        order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1601
Parameter #2(CF_SQL_INTEGER) = 1601

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 01:44:08.008
select	ezine_preview_number, 
				ezine_preview_title, 
				ezine_preview_subtitle,
                ezine_preview_publish_dt ,
                ezine_preview_jacket_image
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		(ezine_preview_bb_link IS NULL
				 or ezine_preview_bb_link < 1)
        and		ezine_number > 0
        
		order by ezine_preview_publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1601

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=15ms, Records=8) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 01:44:08.008
SELECT		a.author_number,
			CASE	WHEN datalength(a.author_middle_initial) > 0 
					THEN a.author_first_name + ' ' + a.author_middle_initial + ' ' + a.author_last_name
					ELSE a.author_first_name + ' ' + a.author_last_name
					END AS "author_full_name",
			b.book_number, 
			f.book_title as "book",

			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 "liked_author_full_name",
			e.author_number as "liked_author_number", 
			g.book_title as "liked_book",
			c.liked_book_number as "liked_book_number" 

FROM		authors a
INNER JOIN	book_author_mapping b ON b.author_number = a.author_number
INNER JOIN	liked c ON c.book_number = b.book_number
INNER JOIN	book_author_mapping d ON d.book_number = c.liked_book_number
INNER JOIN	authors e ON e.author_number = d.author_number
INNER JOIN	books f on f.book_number = b.book_number
INNER JOIN	books g on g.book_number = c.liked_book_number

WHERE		a.author_number = ?

ORDER BY 	e.author_last_name, e.author_first_name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1601

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone2
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:44:08.008
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_book_image (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 01:44:08.008
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) = 2165

get_member_account_types (Datasource=bookbrowse_com_new, Time=20ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:44:08.008
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=70ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 01:44:08.008
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 615
Parameter #2(CF_SQL_INTEGER) = 615
Parameter #3(CF_SQL_INTEGER) = 615

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 01:44:08.008
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 615

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=64ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 01:44:08.008
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 123
Parameter #2(CF_SQL_INTEGER) = 123
Parameter #3(CF_SQL_INTEGER) = 123

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 01:44:08.008
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 123

get_member_account_types (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:44:08.008
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=16ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:44:08.008
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=9ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:44:08.008
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
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 @ 01:44:08.008
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
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=30ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 01:44:08.008
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=1ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 01:44:08.008
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
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=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:44:08.008
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/author_interviews/full/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=4081400; CFGLOBALS=urltoken%3DCFID%23%3D4081400%26CFTOKEN%23%3D899436cdcb1659ea%2D0884623E%2DE7DC%2DC729%2D67F63F3A7428DFB7%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2001%3A44%3A08%27%7D%23hitcount%3D87%23timecreated%3D%7Bts%20%272026%2D06%2D01%2001%3A43%3A53%27%7D%23cftoken%3Dd86ece50356f7754%2D0884553B%2DFF9F%2DA9C3%2DE5769E3A09BF09BC%23cfid%3D4081397%23; CFTOKEN=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/1601/david-ebershoff
PATH_TRANSLATED=/root/website/author_interviews/full/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/author_interviews/full/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=4081397
cftoken=d86ece50356f7754-0884553B-FF9F-A9C3-E5769E3A09BF09BC
hitcount=90
lastvisit={ts '2026-06-01 01:44:08'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 01:43:53'}
urltoken=CFID=4081400&CFTOKEN=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7
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#=4081400&CFTOKEN#=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7#lastvisit={ts '2026-06-01 01:44:08'}#hitcount=87#timecreated={ts '2026-06-01 01:43:53'}#cftoken=d86ece50356f7754-0884553B-FF9F-A9C3-E5769E3A09BF09BC#cfid=4081397#
CFID=4081400
CFTOKEN=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7
Session Variables:
cfid=4081400
cftoken=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7
sessionid=BOOKBROWSE_4081400_899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7
urltoken=CFID=4081400&CFTOKEN=899436cdcb1659ea-0884623E-E7DC-C729-67F63F3A7428DFB7
URL Parameters:
author_number=1601
david-ebershoff=
Debug Rendering Time: 13 ms