Anne Rice Interview, plus links to author biography, book summaries, excerpts and reviews

Anne Rice
Photo: Becket M. Ghioto

Anne Rice

An interview with Anne Rice

Anne Rice discusses her controversial book, Christ The Lord Out of Egypt, her own faith and whether she plans to write a sequel.

A Conversation with Anne Rice about Christ The Lord Out of Egypt

What led you to the idea of writing this book, and then to the actual writing of it?
Obsession led me to write this book, and it's been that way with every book I've ever written. I become completely consumed by a theme, by characters, by a desire to meet a challenge, and the book begins to grow. With Christ the Lord, the obsession began in my earliest childhood in pure religious devotion. Though I broke with my religion in college, I was still obsessed with religious questions, the basics–Why are we here? Why is the world so beautiful? Why is it so important that we lead good lives, even when we don't believe in an afterlife? I never stopped with this obsessive thinking and exploring, and the idea for the book–Jesus in his own words–was always there. I went back to the Catholic Church in 1998, completely. In 2002, when I was sitting in church before Mass one Saturday evening, I made the declaration to Christ that I would do this book and nothing else. And the entire purpose, shape, tone–all of that came together.

Those familiar with your work will immediately recognize this subject matter as a departure for you. Assuming you agree, why head down this particular road?
This subject is in no way a departure from that of my previous works; no one who knows my work could possibly think so. The whole theme of Interview with the Vampire was Louis's quest for meaning in a godless world. He searched to find the oldest existing "immortal" simply to ask "What is the meaning of what we are?" I was always compelled to seek the "big answers."

Jesus Christ narrates this book. Explain your decision to make him the narrator.
Jesus is the first-person narrator of this book because the use of first-person narrators is the way I know how to write a book with the greatest power and chance of artistic success. The intimate voice of the narrator in earlier novels worked powerfully for me. My first novel was written that way. Though I've written many novels in the third person, I've never felt as close to the characters as I felt to Louis, Lestat, Marius, and, finally, to this character, this fictional "creation" of Christ the Lord.

The Author's Note in the book touches on the research that you did. What did that research comprise? What types of texts did you consult?
Research was as total as I could make it. As I explain in the Author's Note, I explored the ancient authors–Josephus, Philo of Alexandria, the writings of the sages, the rabbis, the Evangelists, the Bible itself relentlessly. But I also studied as much as I could of current archaeology having to do with first-century Palestine. I read as much as I could in New Testament scholarship, reading books by cynical critics of Christ, skeptics who wanted to debunk Him, and also great scholars. I read the great Catholic scholars Meier and Brown, and others. The field is far too vast for me to be comprehensive, and my work is ongoing. I do not read the ancient languages, but I am beginning to study Greek.

How did you sort out issues of artistic license when it came to a story the basics of which are almost universally known (if not universally believed to be true)?
When it comes to this book, artistic license does not really exist. What I did was take the Jesus of the Gospels, the Son of God, the Son of the Virgin Mary, and sought to make Him utterly believable, a vital breathing character. Of course I created fictional scene and dialogue. But it is all within an immense and solid frame. This was a huge challenge. I had to move in His world, and know His world, and that took the immense research. But license? I took as little as possible. I worked within the strictures of what we have been taught about Christ the Lord. That's why I used the title.

Would you hope that readers would come away from this book understanding and knowing more about Christianity and the figure of Christ, or did you write it for people to simply enjoy as a novel?
I wrote this book to make Christ real to people who had never thought about Him as real. I wrote this book to make the readers care so much about Him that they see him perhaps as never before. I wrote it for all my readers and for all readers.

Re-telling the Christian story is the essence of my vocation. And we re-tell that story so that it can be heard anew. That has been going on since the Evangelists in one form or another. I am no Evangelist. But I am an artist who wants to make the most significant art I can make. And for this art to have value, it must be utterly true to the spirit of Christ as I have received it from multiple sources: the Gospels, my church, my prayers, my meditation.

For people who are not coming to the book from any particular religious background, what do you hope they'll take away from it? Put another way, do you think an atheist could ever like this book?
I hope readers will come away caring passionately about this character, Jesus Christ, and wanting to know infinitely more about Him. We have become so desensitized to language pertaining to Jesus. I've tried to reinvent Jesus for those who don't want to think about Him or know Him. I hope that readers who do not come from a religious background will take away a sense of Jesus, the Jew, and Jesus, the child of miracles. And I hope that the book will give pleasure and satisfaction for those who do know Him and care about Him, and that does seem to be happening. I hope biblical scholars will see something here they can recommend. I hope atheists will feel a part of the world inside the book, and say "I was there!" I hope my oldest readers will embrace this character as they have Marcel, or Tonio, or Lestat or Louis in the past.

Of course I think an atheist could like this book, because it brings to life the period, the milieu, the people who brought about one of the greatest religious revolutions in history.

I tried to do justice to Jesus in every conceivable way I knew in this book. I can't give any more to anything than what I've given to this book.

Were you nervous about writing this story, either from a personal standpoint or because of any concern about how closely or intensely it would be scrutinized?
No, I wasn't nervous. I was scared to death. I was so scared I couldn't do it, yet I felt so compelled to. I went almost out of my mind as I sank into this material and as I prayed and studied and wrote. I was terrified. But I knew I had to do this. I felt strongly that no one had done it in the way that I was doing it. There have been many novels about Jesus Christ, but there has not, to my knowledge, been one like this, one that accommodated entirely all the knowledge we are given about Jesus while maintaining that Jesus is who He said He was: The Son of God.

I was scared to death of being attacked and misunderstood, and pre-judged. Above all, I was and am scared of being dismissed. But it does not matter. I will go on writing the best books I can possibly write about this subject no matter what happens to me.

Will you ever write another Vampire novel?
I can't see myself doing that. My vampires were metaphors for the outsiders, the lost, the wanderers in the darkness who remembered the warmth of God's light but couldn't find it. My wish to explore that is gone now. I want to meet a much bigger challenge.

The book ends when Jesus is still a boy. Is there a sequel on the way?
Yes, there are sequels on the way. I feel that keenly and can't deny it–I don't want to deny it. But this book must stand on its own. And I did what I set out to do in so far as I talked and walked and saw with my character within the Gospel framework, and in light of the latest research in many fields. I feel a great satisfaction in having done that.

What do you make of the current religious climate in this country?
I wish that we had more visible Christian and Catholic leaders who talked about love. We have many, but we could use more. It is tragic that many in America think of us–the Christians–as being people who hate others. We need leaders who open their arms to others. We need leaders like Fulton Sheen and Billy Graham and Rick Warren and N. T. Wright. We need to love one another; we need to acknowledge the goodness and the good intentions of our brothers and sisters; we need to stop fighting Christian against Christian. I have no time now for anything but trying to love other people. That is a full-time job. To fill my writing with that will take everything I have. I want to love all the children of God–Christian, Jew, Moslem, Hindu, Buddhist–everyone. I want to love Gay Christians and straight Christians.

But the point is, we need people to make visible the great embracing and compassionate message of Christianity, people to continue the revolution started by Christ Himself, people to bear witness that the story of Jesus Christ is going on and on without end, gaining power with each century, and reaching more and more people. We need saints. We have to become saints. We have to become like Christ. Anything less is simply not enough. The world doesn't need any more mediocrity or hedged bets.

Reproduced by permission of Random House, 2005



A Fan's Interview with Anne Rice

What areas of classical mythology are you most interested in, and how do you go about incorporating them into a new novel?
Well, the answer is that I'm fascinated by almost any mythology that I can get my hands on, but I guess Greek and Roman mythology really enchants me. And I don't know that I've consciously incorporated mythology into my novels--I did explore very deeply Egyptian lore when I created the characters of Akasha and Akeel, the eldest of the vampires. But I'm usually working on my own mythology, my own realm of created characters. But again, I'm in love with all sorts of mythology, and obviously stories in mythology inspire my though I may not be conscious of it.

What literary works do you believe most influenced your novels?
That is a very difficult question to answer, because I read so widely and so much--even for a non-reader. I think the Brontë sisters--Wuthering Heights and Jane Eyre, two books that I read before I ever wrote Interview with the Vampire--I think they had a terrific influence on me. I recently reread both of those books and I loved them, and I think they continue to have an influence on me. I am in love with Emily Brontë's Heathcliff--I absolutely adore him. But I did a lot of reading when I was in college. I read Virginia Woolf, and Hemingway, and Shakespeare, and Sir Arthur Conan Doyle's Sherlock Holmes stories, and I read some very pure horror fiction from England that I really loved--in particular, J. Sheridan LeFanu's Carmilla, a vampire story that was written in the 1870s and is a very wonderfully sensuous vampire story. I think it's influenced many movies. And I also read the stories of Algernon Blackwood, a very distinguished Englishman--I believe before he died he was reading ghost stories on BBC radio. And I also read the stories of M.R. James, a very distinguished English gentleman. And I loved all that fiction--I absolutely loved it. So everything went into the mix. I'm definitely more influenced by European writers than I am by American writers, there's no doubt about that. I lean toward English writers. And for Merrick the novel that's going to be published in October of 2000, I read a lot of Conan Doyle to get the British voice that David needs to tell that story.

Your attitude toward Christianity seemed pretty dim in your early Vampire books, almost as if you were saying God doesn't exist. However, in your more recent books--especially Memnoch the Devil--that view seems to have changed. Has your outlook on religion changed?
Well the answer to that is I'm always looking, and I'm always asking questions. I mean, if you go all the way back to Interview with the Vampire, which was published in 1976, the vampires are really talking a lot about God and the Devil. Louis's quest--my tragic hero Louis--his quest is to find the oldest vampire in the world, and to find out if that vampire knows anything about God and the Devil. The answer was, of course, rather tragic in Interview with the Vampire, but I go on asking, I go on seeking answers. Now in Memnoch the Devil, which happens by the way to be my favorite of all The Vampire Chronicles, we don't know really whether Memnoch told the truth to Lestat or not--it's left as a mystery, and that's very deliberate. I'm going to keep on asking these questions, I'm going to keep on dealing with the supernatural in a lot of ways, and I can't get very far away from Christianity, I can't get very far away from the angels and the saints. I work them in always, in some way. In Merrick, Merrick's voodoo incorporates Catholic saints and statues of the virgin--it's in my blood, all of this, and there's no pun intended there.

After hearing of the time you were transported in a coffin in a horse-drawn carriage across New Orleans, I was wondering what plans, in any, you might have for your own funeral when your time comes. I'm fascinated to know!
Well, my own funeral! All I know is that I'd like to be laid out in a coffin in my own house, right here where I live. I would like my coffin to be put in the double parlor, and I would like all the flowers that are brought to the funeral to be white. And that's about it. If I could then be transported to the nearby cemetery, Lafayette #1, that would be wonderful--that's the cemetery where all my fictional Mayfairs are buried, but I don't actually own a plot or a grave in Lafayette #1, so I don't know how far that hearse is going to have to carry me. It may be to someplace out in the suburbs--the rest is unknown. Of course I would want the most joyous music at my funeral--I'd love people to sing a hymn called "I Am the Bread of Life", but after that hymn is sung, then it can be Dixieland bands, all the way. And merriment. And lots of wine served, certainly.

With all the talent in your family--your husband being an artist and poet, your son a published novelist--is living in your house different from any other American household? Do the three of you ever sit around and share ideas? I would love to be at the dinner table with the three of you and listen to the conversation.
You know, I don't know if our conversation is all that exciting. We do talk about what we are doing to each other. We do, I don't know--kind of report to each other what we're doing. And at this point of course I am so proud of my son Christopher. I am so proud of his novel A Density of Souls--I thought it was really, absolutely wonderful. If I didn't think it was wonderful I just wouldn't mention it, so I can assure you I'm telling the truth. I was just blown away that he could write something at the age of twenty-one that was so intense and so good. But many times our conversation is just about family matters, just trivial things: where are we going to go out to dinner? What's the food like? When are we going to have a family reunion? What's going on with my mother-in-law? What's happening with our cousins? It can be very mundane, very ordinary.

How does the beautiful artwork for your book covers come about? Are you involved in choosing them?
Well, it's a pleasure to answer this question. The artwork on the book covers is chosen by my editor Victoria Wilson. Victoria Wilson has been my editor for twenty-five years. She has a knack for coming up with absolutely beautiful artwork. She just has a real intuition where that's concerned. She finds exactly the right thing. I think that the readers of the books very much appreciate the artwork that she chooses. I've loved it.
I've been excited about every cover that Victoria has ever created. And I'm very glad that I'm at a publishing house that allows Victoria to have a free hand with that and to choose what she thinks is good.

I've read: Rice fans identify with the Vampires because we feel like outsiders. Do you see yourself as an outsider after all these years of your writing and your fantastic success?
First of all, thank you for referring to my success as fantastic. Yes, I feel like an outsider, and I always will feel like one. I've always felt that I wasn't a member of any particular group. And I think that writers in particular as they gain success feel like outsiders because writers don't come together in real groups. You can look at the New York Times Bestseller List and you can be pretty sure that the writers on that list don't know each other very well. Maybe two or three know each other, but it isn't like we all go to a party every weekend and we talk about our experience as best selling authors. That doesn't happen. I also think that process by which you become a writer is a pretty lonely one. We don't have a group apprenticeship like a violinist might training for an orchestra, or a ballet student might being in a company that does ballets. We don't have any of that. We write on our own time, we write when we can. There may be writing groups where people meet but its occasional. You really do it all at your own computer or your own typewriter by yourself.

Thank you for all your wonderful stories. Do you personally visit the places you write about, such as Brazil or England or Paris? Or do you just extensively research. I love reading about all the places visited by the Vampires and Witches in your books, every location just seems so alive and I feel like I'm really there too.
I do visit most of the places that I write about. I have been to Brazil and I have been not only in Rio de Janeiro but also in the Amazon, and I really loved it. I wrote about it with great passion afterward in the book Violin. And I have been to England and to Paris. I love both places. In England I went to Glastonbury and I visited the supposed tomb of King Arthur. I also went to Canterbury because I wanted to see the cathedral there. I went to Stonehenge of course. I wish I had spent more time in England. I really do. I've been to Paris more than once, I'm not sure if it's three times or twice. The Paris that I describe in my books is something of course that I have to envision because it is the Paris of the eighteenth century, but when Lestat goes to Paris now, and he sees things, those are the things that I saw. Some of the places I've written about I have not been. I have not been to India yet, and I hope to go to India, I want very much to do it, and so there's some research involved when I describe those places. In Merrick, for example, I describe the Guatemalan jungle. I haven't been there. But as I've said, I've been to the Amazon and I've been to the rainforest in the middle of the city of Rio, and that prepared me very much I think to write about that Safari in Merrick. By the way, I hope that safari was a lot of fun for readers. It was fun for me.

What is the most difficult novel you have had to write to date?
The most difficult novel I have had to write in terms of just getting it done was The Vampire Lestat. That's the second one in the Chronicles. It took a year to write. I had a very difficult time with it. Right up to a little over halfway through. Then, when the character of Marius entered the novel, I wrote the last 300 pages in eleven days. So I really felt terrific about that. But that novel was very hard. Now, there's another way of looking at this question. The most painful novel for me to write was probably the novel Violin, which involved a ghost named Stefan and a heroine named Triana. And was about the supernatural and also about music. All of the novels involve some kind of pain and some kind of special difficulty. But I think those were the two most difficult.

The atmosphere and history of wonderful New Orleans imbues your work and setting. It feels so essential to the story of the Mayfair witches. Do you feel any of it could unfold in any other location?
Well, I am not sure. The Mayfair witches really were born to be in New Orleans. And I do love New Orleans with my whole soul. And I wrote The Witching Hour, Lasher, and Taltos, the three novels in that trilogy right in the house in New Orleans. It's in this house that the Mayfair witches live. This house on Chestnut and First Street is the home of the Mayfair witches, and people know that. And I don't mind people knowing that at all. This house is a character in the novel. The setting of Merrick had to be New Orleans, and I feel that Merrick is a very special New Orleans character.

Reproduced by permission of the publisher, 2000.

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 Anne Rice at BookBrowse
Of Love and Evil jacket Angel Time jacket Called Out of Darkness jacket Christ the Lord 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 Anne Rice 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

  • Thomas Cahill

    Thomas Cahill

    Thomas Cahill was the author of the bestselling Hinges of History series (a planned seven part series) including How The Irish Saved Civilization: The Untold Story of Ireland's Heroic Role from the Fall of Rome to the Rise of... (more)

    If you enjoyed:
    Christ The Lord Out of Egypt

    Try:
    Desire of the Everlasting Hills
    by Thomas Cahill

  • Amanda Craig

    Amanda Craig

    Amanda Craig was born in South Africa in 1959, and brought up in Italy and Britain. After reading English at Clare College Cambridge, she became an award-winning young journalist in the 1980s. She is the author of Foreign ... (more)

    If you enjoyed:
    Vittorio The Vampire

    Try:
    In A Dark Wood
    by Amanda Craig

We recommend 19 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...

These are not books, lumps of lifeless paper, but minds alive on the shelves

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


Execution Time

Total Time Avg Time Count Template
1780321109169 ms 1.78032110917E+012 ms 1 /root/website/app_server.cfm
544 ms 544 ms 1 /root/website/author_interviews/full/index.cfm
207 ms 207 ms 1 /root/website/author_interviews/full/dsp_main.cfm
169 ms 169 ms 1 /root/website/app_layout.cfm
159 ms 80 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
120 ms 40 ms 3 /root/website/adsystem/adsystem_mod.cfm
119 ms 119 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
114 ms 114 ms 1 /root/website/app_globals.cfm
68 ms 68 ms 1 /root/website/adzones/AdZone6.cfm
45 ms 45 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
44 ms 44 ms 1 /root/website/adzones/showcase_track.cfm
36 ms 36 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
31 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_active_obc.cfm
30 ms 10 ms 3 /root/website/queries/qry_get_member_account_types.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
14 ms 14 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
13 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
12 ms 12 ms 1 /root/website/adzones/AdZone2.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
10 ms 10 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_member_info.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_all_books_by_author_id.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/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/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/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/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
546 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

adactive (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:38:29.029
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 @ 13:38:29.029
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=15ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:38:29.029
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:38:29.029
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=18ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:38:29.029
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 @ 13:38:29.029
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=7ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:38:29.029
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 @ 13:38:29.029
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 @ 13:38:29.029
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=11ms, Records=4) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:38:29.029
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) = 294

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:38:29.029
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) = 294

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=8) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 13:38:29.029
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) = 294
Parameter #2(CF_SQL_INTEGER) = 294

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=20ms, Records=4) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 13:38:29.029
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) = 294

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=10ms, Records=19) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 13:38:29.029
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) = 294

get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=6ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=9ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:38:29.029
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_member_account_types (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:38:29.029
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=56ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:38:29.029
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) = 87
Parameter #2(CF_SQL_INTEGER) = 87
Parameter #3(CF_SQL_INTEGER) = 87

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:38:29.029
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) = 87

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=52ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:38:29.029
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) = 721
Parameter #2(CF_SQL_INTEGER) = 721
Parameter #3(CF_SQL_INTEGER) = 721

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=33ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:38:29.029
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) = 721

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

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=20ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:38:29.029
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=27ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=13ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:38:29.029
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 @ 13:38:29.029
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:38:29.029
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=4102252; CFGLOBALS=urltoken%3DCFID%23%3D4102252%26CFTOKEN%23%3Db76f64170a2353ef%2D220F93ED%2DB4C2%2DAE6C%2D245448B41EEFFA8A%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A38%3A29%27%7D%23hitcount%3D145%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A38%3A08%27%7D%23cftoken%3Db76f64170a2353ef%2D220F93ED%2DB4C2%2DAE6C%2D245448B41EEFFA8A%23cfid%3D4102252%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
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/294/anne-rice
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=4102252
cftoken=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
hitcount=150
lastvisit={ts '2026-06-01 13:38:29'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:38:08'}
urltoken=CFID=4102252&CFTOKEN=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
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#=4102252&CFTOKEN#=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A#lastvisit={ts '2026-06-01 13:38:29'}#hitcount=145#timecreated={ts '2026-06-01 13:38:08'}#cftoken=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A#cfid=4102252#
CFID=4102252
CFTOKEN=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
Session Variables:
cfid=4102252
cftoken=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
sessionid=BOOKBROWSE_4102252_b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
urltoken=CFID=4102252&CFTOKEN=b76f64170a2353ef-220F93ED-B4C2-AE6C-245448B41EEFFA8A
URL Parameters:
anne-rice=
author_number=294
Debug Rendering Time: 10 ms