Karen Joy Fowler Interview, plus links to author biography, book summaries, excerpts and reviews

Karen Joy Fowler
Photo: Nathan Quintanilla

Karen Joy Fowler

An interview with Karen Joy Fowler

In two interviews, Karen Joy Fowler discusses: Booth (2022), a novel exploring the family of Abraham Lincoln's infamous assassin, and her 2004 novel, The Jane Austen Book Club.

Booth

You touch upon this in your author's note: What did you want to explore in a book in which John Wilkes Booth is a prominent figure?

The United States is a very complicated place with regard to guns. A whole lot of people share responsibility for this dysfunctionality–those founders who were unclear when writing the Second Amendment, those people who make guns and also those who buy them, voting with their dollars to keep the whole bloody business lucrative, the NRA and their politicians, and, of course, the shooters.

I am not the first writer to wonder if the families of the shooters should be added to that guilty list (and clearly the answer is sometimes yes and sometimes no). But this is what made me think there might be a novel in the brothers and sisters of John Wilkes Booth.

Why did you choose to tell this story through the perspectives of Rosalie, Edwin, and Asia —and notably not through John's?

Wouldn't it be swell, I thought, if we felt the same fascination for people who don't kill presidents as we feel for those who do? Edwin, in particular, has a well-documented life filled with color and adventure, from the Wild West coast of the Gold Rush to the theaters of New York City.

Asia's difficult personality comes so vividly to us through her letters and books. She can be hard to like, but there is such a person there.

So little remains of Rosalie that I had to mostly make her up. But the things she lived through are real enough–her father's fits and spells, the death of so many siblings, the strange arrival of the Mitchell cousins, her lion-tamer love. I was overwhelmed with riches.

So why not John? I'm aware that some will read through the first sections in anticipation of finally getting to John's point of view. I know this because some of these readers are in my very own family.

But this is not a book about John Wilkes Booth.

Who remains a mystery to me. He was a fanatical white supremacist, utterly unmoved by the suffering of Black people under slavery, and quite undone by the suffering of white people during the war. As the bloody war progressed, as Lincoln moved towards emancipation and then on to certain rights of citizenship for the freed people, Booth's passionate hatred for him grew. But there were many such and none of them killed Lincoln.

So maybe he was also crazy. His oldest brother wrote of the "family taint" of insanity long before the assassination and John is not the only Booth to commit murder. Maybe he was drunk. He appears to have been drunk most of the week of the assassination. He was a member of the terrible Knights of the Golden Circle. So maybe he was just a tool in the hands of older, smarter men.

Other writers have made much of his jealous rivalry with his older brother Edwin, whose star was rising as his own fell. Maybe he was bidding on an immortality beyond Edwin's reach.

He certainly had an outsized sense of his own destiny. Maybe there was too much Shakespeare in his life. Maybe anyone whose mother claims a magical fire foretold his magical destiny when he was only a baby grows up believing it. Who can say what was in his head? It wasn't a place I wanted to visit.

And anyway, this is not a book about John Wilkes Booth.

How do Rosalie's, Edwin's, and Asia's points of view differ, and what do they all have in common?

Among these characters, Edwin spent the most time outside the family circle. He had years on the road with their sometimes benevolent, sometimes cruel father. It's ironic that Edwin, the boy with the hard-knock childhood, grew up so much less angry than John, the cosseted, favored son. Still, all the Booths had a powerful investment in their father's legacy and a particular need to protect and burnish the family name. They were all very proud of being Booths.

Rosalie, Edwin, and Asia identified with the Union. John's fanaticism isolated him inside his family, but the sisters, at least, seem to have chosen to ignore his politics. He did argue furiously with Edwin, creating a deep rift, which the sisters worked hard stay clear of. Asia knew more than the rest about the ways in which John worked for the Confederacy. This doesn't mean she expected what happened.

The main thing they had in common is that they all loved John.

The Booths were one of the country's leading theatrical families, and the novel explores But this is not a book about John Wilkes Booth. their world both onstage and behind the curtain. How did the Booths' celebrity influence their lives and beliefs?

The Booth boys were early examples of celebrity culture. Although their father was as, or more, famous in his time, the boys' fame was more Byronic. Stage managers didn't have to appear before their father's performances to beg the ladies in the audience to behave themselves. Their father didn't have hair torn from his head, his clothing ripped by crowds of women wanting souvenirs. There is no evidence that he had the casual strings of affairs his sons did.

I think that both boys eventually tired of this sort of celebrity. Edwin responded by working hard to be taken seriously for his art, John by finding his passions elsewhere.

Why do you think so many people are fascinated by John Wilkes Booth and this family?

The family is just irresistible. I came to them slowly. I first wrote a short story, a time travel story, about Lincoln's assassination. While doing the research for that, I found myself reading about Edwin's return to the stage after Lincoln's death. I wrote another short story. I wrote a third short story about Junius Booth Sr., their father, and a funeral he once held for passenger pigeons. By then I was reading every-thing I could find. I was hooked before I knew I was hooked.

But of course it remains a sad fact that most of this interest is sparked by the assassin in their midst. In my reading, I found no end of fascinating theatrical personalities, but none of them garnered the end-less books and articles of the Booths. I can't exempt myself from this. I was so determined not to write a book about John Wilkes that the not-writing-about-him became my organizing principle, which means, of course, that he controlled every page. It's a sort of Zen koan and much as I find the siblings' stories more compelling, and infinitely more sympathetic, still I know that John Wilkes is the train we all come in on.

Your book jacket is decorated with a garden motif—flowers, birds, and a snake. What do these images symbolize?

Gardens, even without snakes, always represent Eden. Add a snake and the symbolism is inescapable. In one way or another, Eden lost appears to be a theme in nearly every book I write. In this book, Eden is the end of the war and all the hopes of creating a more just society. Eden lost is the murder of Lincoln before those hopes could even be felt much less realized.

More literally, it is impossible now to read about the landscape of the U.S. a hundred years ago—or twenty, or five—and not notice how much of the wilderness has vanished, how diminished and threatened our wild brothers and sisters are. What would it be like to feel, as the Booths and their neighbors must have felt, that the American wilderness was inexhaustible? I have lived fifteen years now in the path of the monarch butterflies' annual migration. Year by year, I am watching them disappear.

So while it may not be an explicit theme in this book, it is always in my heart. It is, I feel, one of the particular hallmarks of the American writers who live in the West, that the project of owning and occupying, controlling, and destroying the landscape is very visibly present and ongoing in our lives. Me, I don't like to write about cities. I always want more birds.

Did anything surprise you while you were researching and writing Booth?

I was surprised to learn that, given John Wilkes' opinions, most of the family was opposed to slavery. Their grandfather, who'd grown up in England, was appalled by it, their father and mother also op-posed. The children mostly adopted their parents' views, but they'd never known a society without slavery; they weren't shocked by it in the same way. They grew up in the midst of it—their closest friends were a white family, the Rogerses, who were slave owners, and a Black family, the Halls. Joe Hall was a free Black man who ran the Booth farm, and was eventually able to buy the freedom of his wife, Ann. The Halls had several children and the ones born when Ann was enslaved remained enslaved (some of them by the Rogerses) while those born after she gained her freedom were born free. The Booth children would have seen all of this, but they rarely, if ever, spoke of it. I wish they'd said more. It seems that John's opinions were not forged in the family, but in his (relatively brief ) time at a boarding school attended by the sons of wealthy slavers.

I was also surprised that, with all the attention paid to this family over so many years, new information is still being uncovered. I believe their grandfather's involvement in the Underground Railroad was unknown not so very many years ago. For decades, little Frederick was believed to have died of cholera along with his sisters until his death certificate was suddenly found, but lot of the new research does not add new facts so much as it questions established ones. There is a great deal of mythology surrounding this family. Take the unreliability of eyewitness accounts of any event and complicate that with the passage of 150 years. Of course, the ground is spongy. One story contradicts the next.

Finally, I was surprised to learn that, during the very hours of Edwin Booth's funeral, Ford's Theater collapsed catastrophically, killing more than twenty people and injuring a hundred more. I would have liked to mention this strange fact, but couldn't make it work with the tone I wanted at the book's end. Besides, Edwin is still seen occasionally in the prop room of the Springer Opera House in Columbus, Georgia, and he's never been a vengeful ghost. On the contrary, he is described as playful and even helpful.

As Abraham Lincoln says, there is no escaping history. How do the events and themes in Booth mirror our current time?

From the blog of the great Ursula K. Le Guin, this incontrovertible truth: "The election of 2016 was one of the battles of the American Civil War. The Trump voters knew it, if we didn't, and they won it." If there was ever any doubt of this, it vanished on January 6, 2021.

Did you draw inspiration from any other historical generational sagas while writing your novel? What are some of your favorite historical fiction books?

I did sometimes think about the Brontës. The Booths seem to have been a similarly insular set of siblings. (I'm somewhat embarrassed to admit that I've always liked books about the Brontës just a little bit better than books by the Brontës.) But I didn't think about other generational sagas. As to my favorite historical novels, that is far too big a category, far too long a list; I wouldn't know where to stop. Plus, I find lists problematic since I always leave something out that clearly should have been in.

But with that caveat, here are ten novels I love that deal with the same general Civil War period as my own book. (Okay, it's eleven.)

The obvious:
Beloved by Toni Morrison, of course, of course
Little Women by Louisa May Alcott

But also:
Cane River by Lalita Tademy
Cloudsplitter by Russell Banks
Cold Mountain by Charles Frazier
Enemy Women by Paulette Jiles
The Good Lord Bird by James McBride
Grace by Natashia Deón
March by Geraldine Brooks
The Underground Railroad by Colson Whitehead
Woe to Live On/Ride with the Devil by Daniel Woodrel

Karen Joy Fowler discusses The Jane Austen Book Club

In interviews, what is the question you are most frequently asked?
Whose point of view is the novel written from.

What's the answer?
You need to think of the book club as a kind of seventh character.  It's a very flexible voice because sometimes all the other characters are in the collective, but at other times someone is disapproved of and therefore not in it.

Which of the characters in your novel are you most like?
Sylvia, because she is the one character whose children are present – and children are omnipresent in my life.  I also share her sense of impending doom!

Sony have bought the film rights to your book.  Who would you cast, and why?
I have such a strong image of the characters that I can't begin to imagine who would play them.  No one actor matches.  If business considerations could be put aside most writers would prefer unknowns.

What are you reading at the moment?
One of the wonderful things about being a writer is that it's part of my job to read.  Most recently I read a book called Mother Nature by Sarah Hardy.  The author is a biologist who looks at evolutionary theory, focusing on maternal strategies to keep offspring alive.  The chapter on insects was very distressing!  Recently I also read Lord Byron's Novel by John Crowley.  I became so caught up in it that I then read The Bride Of Science, a biography of Ada Lovelace who was Byron's daughter.  It's wonderful that I can follow my obsessions, whatever is interesting me.  Now I must read Don't Let's Go To The Dogs Tonight because that is the next book club choice.

So you're a member of a book club?
Yes.

Do you discuss your own books?
Yes, my fellow book club members insist.  It's lovely of them but not always comfortable because they're very smart and highly critical of other books – but when they get to me they always think it's really nice.  I can't go to the bathroom because I'm worried they'll be telling each other what they really think.

What did you read as a child?
Lots of the children's books I loved had fantastical elements.  I remember a book called Castles And Dragons, which was a collection of fairy tales from different cultures.  I also loved Mistress Masham's Repose and The Once And Future King by T.H. White.  The Once And Future King is the most important model I have as a writer, because it persuaded me early on that there were no rules, that you can write whatever you like so long as you are enjoying yourself, that it's fine to digress.  And The Lord Of The Rings, long before those books became what they are now, and which I loved.  Also the Nesbit books, The Wind In The Willows and Mary Poppins.

Which authors do you most admire?
There are so many.  Being a writer has made me less critical – mostly when I read books I like them.  Ursula Le Guin and Molly Gloss are absolutely fantastic.  Kelly Link is a short story writer who writes unlike anyone else.  My favourite book of the last few years was Kevin Brockmeier's The Truth About Celia.  I loved Cloud Atlas by David Mitchell.  Also The Hamilton Case, by Michelle de Kretser, about the independence movement in Ceylon.  And The Woman Warrior by Maxine Hong Kingston.

Which of Austen's characters would you choose to be stranded on a desert island with?
There's good company, and then there's competence in the wild.  Maybe Captain Wentworth to make a sail.  But I don't think he's the person whose company I'd enjoy the most.  For company I'd like to be with Elizabeth Bennett, just like everybody else.

And which of your own?
I'll never write a group of characters that I'll love as much as in my first novel – because they were the first. 

Austen's books often leave you wondering whether all of her matches are good ideas. Do any of the matches in The Jane Austen Book Club create disquiet?
My New York editor was very distressed that Allegra went back with Corinne at the end.  I do feel that they are not a match and it will all explode again very soon.  And I don't think Bernadette's marriage will last.  But I think the others will.  I think Jocelyn and Grigg is a nice combination of a bossy woman and a man who likes bossy women.

Austen lovers feel a particularly intense connection to books. Are there more book communities you know of that engage with a like passion?  Why these and not others?
I don't know the answer but will say that when the book came out I was expecting many emails about mistakes to do with Austen.  There were none.  However there are about five lines in the book to do with Patrick O'Brian and there were lots of emails about him.  In Kansas they thought I was lucky not to have chosen Dickens, as the Dickens people are much harder to please.  And, of course, there's Sherlock Holmes.  I read recently that the Sherlock Holmes people are in two camps – those who want to believe in Sherlock Holmes as a real person, and don't want to hear anything about Conan Doyle, and those who want to talk about Conan Doyle as well.  They can't be in the same room together.  This demonstrates a passionate attachment to books that I highly approve of.

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 Karen Joy Fowler at BookBrowse
Booth jacket We Are All Completely Beside Ourselves jacket Wit's End jacket The Jane Austen Book Club 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 Karen Joy Fowler 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

We recommend 27 similar authors


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

Choose an author as you would a friend

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 04:01 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
1780286517009 ms 1.78028651701E+012 ms 1 /root/website/app_server.cfm
564 ms 564 ms 1 /root/website/author_interviews/full/index.cfm
226 ms 226 ms 1 /root/website/app_layout.cfm
191 ms 191 ms 1 /root/website/author_interviews/full/dsp_main.cfm
189 ms 63 ms 3 /root/website/adsystem/adsystem_mod.cfm
182 ms 182 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
120 ms 120 ms 1 /root/website/adzones/AdZone6.cfm
96 ms 48 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
90 ms 90 ms 1 /root/website/app_globals.cfm
44 ms 44 ms 1 /root/website/adzones/AdZone2.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_active_obc.cfm
37 ms 37 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
34 ms 34 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
27 ms 27 ms 1 /root/website/adzones/showcase_track.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
19 ms 6 ms 3 /root/website/site/blocks/membership_advantages.cfm
18 ms 6 ms 3 /root/website/queries/qry_get_member_account_types.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
13 ms 13 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_current_competition.cfm
11 ms 11 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
7 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_member_info.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_current_wordplay.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/site/blocks/dsp_top_author_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/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_free_newsletters.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_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/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
9 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
573 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 04:01:57.057
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 04:01:57.057
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=4ms, Records=2) in /root/website/actions/adstatus.cfm @ 04:01:57.057
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 @ 04:01:57.057
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 04:01:57.057
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:01:57.057
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 @ 04:01:57.057
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 @ 04:01:57.057
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 04:01:57.057
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=9ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 04:01:57.057
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=19ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 04:01:57.057
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=7ms, Records=3) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 04:01:57.057
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) = 1018

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 04:01:57.057
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) = 1018

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=13ms, Records=4) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 04:01:57.057
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) = 1018
Parameter #2(CF_SQL_INTEGER) = 1018

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 04:01:57.057
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) = 1018

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=9ms, Records=27) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 04:01:57.057
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) = 1018

get_ads (Datasource=bookbrowse_com_new, Time=31ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 04:01:57.057
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=4ms, Records=1) in /root/website/actions/udfs.cfm @ 04:01:57.057
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) = 4410

get_book_image (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/actions/udfs.cfm @ 04:01:57.057
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) = 2887

get_book_image (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/udfs.cfm @ 04:01:57.057
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) = 1422

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 04:01:57.057
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=71ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:01:57.057
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) = 2117
Parameter #2(CF_SQL_INTEGER) = 2117
Parameter #3(CF_SQL_INTEGER) = 2117

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:01:57.057
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) = 2117

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:01:57.057
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) = 1587
Parameter #2(CF_SQL_INTEGER) = 1587
Parameter #3(CF_SQL_INTEGER) = 1587

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:01:57.057
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) = 1587

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

get_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=12ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 04:01:57.057
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 @ 04:01:57.057
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:01:57.057
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=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%3D4084978%26CFTOKEN%23%3D74ea7d9130454c21%2D0D6F6CFE%2DE706%2D5991%2D0D5B23DDE46FC3C8%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2004%3A01%3A56%27%7D%23hitcount%3D178%23timecreated%3D%7Bts%20%272026%2D06%2D01%2004%3A01%3A24%27%7D%23cftoken%3D2d9715aa36f91912%2D0D6F6460%2DDF6A%2D62E0%2DEE364286843C9C12%23cfid%3D4084976%23; CFID=4084978; CFTOKEN=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8; FREEACCESSCOUNT=0
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/1018/author/karen-joy-fowler
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=4084976
cftoken=2d9715aa36f91912-0D6F6460-DF6A-62E0-EE364286843C9C12
hitcount=183
lastvisit={ts '2026-06-01 04:01:57'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 04:01:24'}
urltoken=CFID=4084978&CFTOKEN=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8
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#=4084978&CFTOKEN#=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8#lastvisit={ts '2026-06-01 04:01:56'}#hitcount=178#timecreated={ts '2026-06-01 04:01:24'}#cftoken=2d9715aa36f91912-0D6F6460-DF6A-62E0-EE364286843C9C12#cfid=4084976#
CFID=4084978
CFTOKEN=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8
FREEACCESSCOUNT=0
Session Variables:
cfid=4084978
cftoken=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8
sessionid=BOOKBROWSE_4084978_74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8
urltoken=CFID=4084978&CFTOKEN=74ea7d9130454c21-0D6F6CFE-E706-5991-0D5B23DDE46FC3C8
URL Parameters:
author=karen-joy-fowler
author_number=1018
Debug Rendering Time: 134 ms