Manil Suri Interview, plus links to author biography, book summaries, excerpts and reviews

Manil Suri

Manil Suri

How to pronounce Manil Suri: Ma-neel Soo-ree

An interview with Manil Suri

Manil Suri discusses The Death of Vishnu and religion, and compares being a mathematician to a fiction writer.

I’m Michael Cunningham, and I have the privilege of talking to Manil Suri about his remarkable first novel, The Death of Vishnu. Who are some of your literary influences? Do you identify yourself particularly as an Indian writer?
Both of these questions are kind of loaded questions, because first of all I’m never quite clear in my mind what is meant by a literary influence. How do you interpret that?

I would say, any piece of writing that stays with you, and in some way influences the kind of writer you are, whether it be Henry James or Jacqueline Susann, both of whom I claim as influences.
OK, well that’s good, because I certainly grew up on a lot of Jacqueline Susann-type novels. But more serious writers I would have to say, the one that comes to mind is V. S. Naipaul. I’ve just read one book of his, A House for Mr. Biswas, and the thing that stayed with me out of that novel was the way his characters speak. And they speak in English, but you can tell they are speaking an Indian language. It’s their intonation, or, I don’t know how he does it, and that’s certainly something I would love to be able to do. So that’s something that definitely did stay with me. I’ve read several Indian authors, naturally, growing up in India, Rabindranath Tagore comes to mind, R. K. Narayan. Both of those, I don’t know if they were influences, but certainly I liked them a lot. Another person I would say, completely different, is Paul Bowles, and the journey that Mr. Jalal makes might have been influenced by something I read of his. You also asked about whether I consider myself an Indian writer, and again that requires some sort of definition. Being a mathematician, I’m always looking for definitions. But, I think yes, I think I am, certainly I’m writing about India in this book, writing as an Indian I think. There are some books written by Indians which go overboard, bend over backwards trying to explain things to foreign readers. I certainly have tried to make things clear, but on the other hand I think I’ve resisted the temptation to, what should I say, be too careful about what I put in and what I don’t put in, so that people aren’t unduly disturbed by anything that they might not understand. So yes, but I don’t want to say anything more, because there’s this raging controversy as to what constitutes an Indian writer and what doesn’t. But I think I am, yes.

Well, you are in fact a mathematician, you’re a professor of mathematics. Do you find that mathematics and fiction writing are complementary?
I think one helps the other, because certainly when I write a math paper, I spend an extraordinarily long amount of time trying to make it understandable. On the other hand, I think being a mathematician has its pros and cons. When I first started writing, I would not really pay too much attention to the characters. In other words, I would say: this is a character X, and now I will let X do this, this, this. And the reader can fill in whatever he or she wants, as their favorite character would be X. So there’s this abstraction that goes on, which might not be good in terms of character development, but on the other hand is very useful when you’re trying to keep strands in place. For instance in this book I see it as a very vertical novel, there’s this real mathematical structure, where there’s this constant sense of things rising, so I think of it as a type of -- a very vertical type of structure. Did I use mathematics in the book? Well, I did use calculus in it, I actually had to squeeze that word in, and I think it’s on page 137 or something. [Laughter] There had to be some way of doing it. I was at a conference recently, just last week in fact, and I actually did a reading to a group of mathematicians, toughest group you’ll find to read to. One of them came up with this interesting idea. He said that all fiction can basically be broken up into several components, much like a signal or any kind of wave can be broken up into components. So he said that he looked at my story, he looked at what I read out, and he said, "Well you have this element, this element, this element, this element, and if I look at all the other pieces of fiction I’ve read, they’re also composed of similar elements." And so I can imagine him going back -- he’s from Finland -- going back to Helsinki thinking: well, he’s solved this central problem of 2,000 years of fiction. [Laughter].

Good for him.
Good for him. He’s probably waiting for the Pulitzer, or whatever. [Laughter]

As a writer myself, I ask only out of curiosity, not in the least out of envy, of course, how you managed to do such a remarkable job of keep the voices of the different characters so distinct.
Well, I don’t know, how did I do that? [Laughter].

I always think that from a writer, “I have no idea” is an entirely acceptable answer. [Laughter]. Now, The Death of Vishnu is part of a trilogy that will also comprise The Life of Shiva and The Birth of Brahma. Did you conceive it as a whole while you were writing this first third?
Well that kind of appeared after the third chapter. I’d been stuck for a long time, I had this horrible writer’s block. There’s this ambulance that comes, and it had to leave without taking Vishnu away with it. And it took me a year and a half to figure out how to make it do that. Once I was writing again, I thought, death, life, birth. There seemed to be these three words, and then there is this Hindu trinity: Vishnu, Shiva, and Brahma. Shiva is of course the destroyer, and Brahma is the creator, and Vishnu is the preserver, and so I just matched these words with the three gods in the trinity and I came up with three titles. And so I do see myself doing these other two books. The next one is going to be The Life of Shiva. And that will be followed on something on Brahma. And Brahma of course will be a lot about creation and creativity, and that’s where I think that by the third book maybe I’ll be bold enough to actually have a mathematician as a character. I don’t know, maybe the world isn’t ready for that yet. [Laughter].

I’m ready for it, I can’t speak for the world.
Great.

Could you describe your process as a writer? Where did the inspiration for the novel come from? And how did you work on it.
There actually was a person named Vishnu. The novel is set in Bombay. And it’s the story of this man who lives on a landing in an apartment building. When I was growing up Vishnu used to live on this landing below the floor that I grew up on. One year when I went back, I think it was 1995, Vishnu was very ill. And he actually died that year. I thought at that point: here’s the person who’s just died. I started writing a short story about a year later, and that was a story that I tried to end but I couldn’t end it. So it just kept progressing. I actually wrote the end right in the beginning and tried to finish it, first in one chapter, then in two, then it became a novel. So that’s how it grew, from that death.

One of the most fascinating things about the book to me is the use of the apartment as a sort of metaphor and as the dying Vishnu crawls from floor to floor his journey resembles the stations of the Hindu ascension. Could you talk a little bit more about that?
I think that was the one idea I had in the outline. In the sense that here was this apartment building -- each floor represents a different stage in life. In Hinduism, you’re familiar with the idea of reincarnation, where you go through several lifetimes and each time you ascend a little bit more. Parallel to that idea in Hinduism is there is also this idea that a person is supposed to perform different things in one or perhaps several lifetimes. You might start with a stage where the thing that propels you most is searching for money or for bodily comfort or fame or whatever, and that’s supposed to be the basic stage, and then when you’ve sated yourself with that, then you go on to the next stage, where you might look for more spiritual things, perhaps you serve other people spend your life doing charity work and so on. And after that then there is a still more spiritual stage, and at the top a kind of grand prize is enlightenment, or where you’re actually free of all these constraints. And if you look at the book there are these different people who live on different floors. There are the Pathaks and the Asranis who are contantly fighting over their creature comforts and so on. Then there is Mr. Jalal, who is sort of just embarked on his journey to look for other things. And then there is Vinod Taneja on the third floor and he has sort of progressed perhaps the most of all. And then there is Vishnu who is climbing these various stations. And he also meetings some other people along the way who live on the landings. So that’s the representation of the Hindu philosophy.

Were you raised Hindu?
Up to a certain age. My father is actually quite religious, he practices and everything. I think there are several types of Hinduism in India. Some of it is very cultural, you do certain things, and you perform certain rites and so on. And then there is the more theoretical side, the Bhagavad Gita and so on. I never had the theoretical side. I was never taught, this is what this represents, this god represents this and so on. So up till about thirteen or so I was quite busy doing the same things my father was. And then I went through this stage, where, you know, rebellion and so on, so I stopped doing all that. I think right now I would call myself an agnostic more than a Hindu. But just writing the book has been very interesting because some of that material, that theoretical side, has really come into this book. And I actually went searching for it. And that’s been very eye-opening. I read the Bhagavad Gita somewhere in the middle, you know that figures quite prominently in the book, and after reading it, it was a true eye-opener, and for a while I was wondering if I might start passing out Gitas at the airport like some other people. In fact a strange thing happened. I was reading this book in an airplane once and I forgot it in the seat pocket. And I can just imagine someone later on pulling it out and saying, "Those Hare Krishnas, they’re been here as well!" [Laughter]. So I don’t know where this is going to end. It’s very interesting. I still call myself an agnostic. I don’t know. Previous to this I would always look with great skepticism at these people who suddenly find religion and go back to their roots, and now, horrors, it might even happen to me. [Laughter]. It’s very scary.

Vishnu seems like an odd combination of power and powerlessness, in Mr. Jalal’s vision he crushes people in his many mouths and yet as he ascends the steps can’t even crush an ant. What are we to make of this incongruity?
I guess that’s another type of contradiction almost, in the sense of there’s this branch of Hindu philosophy that says that each person not only contains God but is a part of God. But of course, Vishnu reflects both these natures: that of a human being and that of a god. He appears as something supernatural and very powerful to Mr. Jalal in his vision but on the other hand this could also be a person who’s dying and who’s spirit or soul is rising through these floors and does not have any kind of corporeal substance to it. So I guess that’s the conflict that you see there.

Do ghosts have any place in a religion based on reincarnation?
I would say they aren’t ghosts, they’re more like spirits or souls. And that’s what’s supposed to go from life to life. It’s the soul this is indestructible. In fact in the Bhagavad Gita -- that’s how the Gita starts -- where Krishna tells Arjun that he should go out and fight the battle and kill people, even his relatives, because in fact you cannot kill anyone. All that happens is that the soul goes from one body to another. So in that sense, Vishnu isn’t really dying, it’s just the soul that is going perhaps on to another existence.

In addition to the fabric of Hindu mythology that runs through the book there is a second fabric, based on an equally powerful body of myths: the movies. Could you talk a little bit about how these two religions, one sacred and one profane, each pervade the other?
Movies are a big factor in India. When I was growing up, they were practically the only form of entertainment that people really watched. There was no TV really, and movies were everything. I see them as something that really ties together the whole of society, whether you are rich or poor or whatever, that’s a common frame of reference. Everyone sees movies and knows about them. And so in terms of how they interact with religion, first of all I guess one way of thinking about them is that there are all these movies about religious characters. There was one movie called Jai Santoshi Ma some years back I guess about twenty years ago or thirty years ago and that was about this little-known goddess, I guess she was an incarnation of either Lakshmi or Durga. But after that suddenly people discovered this goddess, and suddenly overnight there were thousands of temples to Santoshi Ma all over the country and to this day people perform fasts in her honor which they wouldn’t twenty years ago because no one knew who Santoshi Ma was. So they’re really powerful. That’s one kind of movie, that’s the mythological dramas you occasionally get. What’s more common are the entertainment movies -- in fact my father, he was assistant music director, he’s retired now, but he worked in the movies as an assistant music director. So I certainly have just been completely brainwashed by Hindi cinema. So that certainly comes true, because I think when you’re talking about India, and talking about social life and so on there, I think that’s really one of the key issues, one of the things that lies at the heart of society there.

Would you describe in a little bit more detail the movies produced by Bombay cinema? Most of us here in the U.S. are only familiar with the movies of Satyajit Ray who obviously is not typical of the vast output of the Indian movie industry.
Yes, he isn’t, and I have to admit that when I was growing up, I think I must have been about -- I don’t know -- sixteen or seventeen before I saw a Satyajit Ray movie. Most of the movies are what are called "masala" films. Masala is basically curry powder. So it’s something that’s a mixture of all these spices, and that’s the word that people use to differentiate serious cinema and "masala" cinema. The masala films typically have -- people say -- that there are only three plots to these movies. One big plot is: there are two brothers, and they are somehow separated at birth, and they reunite at the last scene. Another plot is one grows up to be a police officer and one is a thief, and the police officer shoots the thief and the mother cries and so on. So that’s one. And then the third one perhaps is there’s a rich girl and a poor boy or some such thing and they can’t marry. In fact in the book there is this one line that one of the characters says, "This wedding cannot take place." And that truly is the most repeated line in Hindi movies. Because almost every movie has that line. There’s some dramatic point where a wedding cannot take place. But the nice thing about these is that you go to one of these movies, you can really count on certain things. You can count on four or five or six or eight or now even ten or fourteen songs, each one nicely choreographed, half of them with dances, half romantic songs, and so on. You can count on maybe three or four fights, you know, a nice villain whom you can hate. And some comedy. In fact the typical trailer of a Hindi movie goes pretty much like that. It will flash things like COMEDY and then show you these people and then there’ll be MELODRAMA, in fact melodrama is considered good, so it’s actually called that, melodrama, and then there will be these people weeping. So they are entertaining. I recently rented a Hindi movie and called a bunch of friends from this country -- Americans -- to watch it, and they all enjoyed it. But of course there was another movie too, and we could barely watch ten minutes of it because it was so bad. But that’s something that everyone watches. And the people in this book are similarly entranced by Hindi movies. I think just about all the characters, maybe not all but pretty much all of them have something to do with movies. Vinod Taneja -- his wife has been through this, I mean his whole life pretty much mirrors a Hindi movie tragedy. And Visnhu himself has this vision at the end about his life reeling back like a Hindi movie. So I think certainly Hindi movies dominate or pervade all of society and that’s one of the threads that I’ve played with here.

Let’s just finish up by talking about the book’s ending. That haunting scene with the impish blue-tinged boy. What do we think of that?
That’s of course Krishna. Krishna is not just an avatar of Vishnu. By avatar what is meant is someone who descends to earth. So he’s not just a avatar, but he really is Vishnu. And in fact Krishna, out of the ten avatars, has a special place, because everything is Krishna and Vishnu is Krishna and Krishna is Vishnu. Krishna actually grew up as a boy. So in that sense he hasn’t descended, he’s an incarnation. So when Vishnu actually meets Krishna, it’s in some sense part of him that he’s seeing. And the presence of Krishna, for me, actually seems to say that, well, here is Krishna, he’s the central character of the Gita, everything is in his hands, and he is in control of everything. So whatever has happened -- in some sense there is this supreme being who’s controlling it. That’s one interpretation. This all might be in Vishnu’s mind of course, because we are just seeing everything through his mind. So that’s one interpretation of that.

It’s an amazing scene, it’s an amazing book. Thank you.
Thank you.

Reproduced with the permission of the publisher - WW Norton

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 Manil Suri at BookBrowse
The City of Devi jacket The Age of Shiva jacket The Death of Vishnu 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 Manil Suri 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

  • Aravind Adiga

    Aravind Adiga

    Aravind Adiga is the author of The White Tiger, which was awarded the 2008 Man Booker Prize, Last Man in Tower, and a collection of stories, Between the Assassinations. He was born in India and attended Columbia and Oxford ... (more)

    If you enjoyed:
    The Death of Vishnu

    Try:
    The White Tiger
    by Aravind Adiga

  • Sonny Brewer

    Sonny Brewer

    Sonny Brewer is the author of the novels, The Poet of Tolstoy Park, A Sound Like Thunder, Cormac - The Tale of a Dog Gone Missing, and The Widow and the Tree. Brewer also edited the anthology series Stories from the Blue Moon... (more)

    If you enjoyed:
    The Death of Vishnu

    Try:
    The Poet of Tolstoy Park
    by Sonny Brewer

We recommend 9 similar authors

View all 9 Read-Alikes

Non-members can see 2 results. Become a member
Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

BookBrowse Book Club

Book Jacket
The Cover Girl
by Amy Rossi
Find them early enough, and they will always be her girls.

Members Recommend

  • Book Jacket
    The Sister's Curse
    by Nicola Solvinic
  • Book Jacket
    The Lost Story of Eva Fuentes
    by Chanel Cleeton
    A mysterious book links three women across generations in this novel by New York Times bestselling author Chanel Cleeton.
  • Book Jacket
    The Vanishing Place
    by Zoë Rankin
Who Said...

Too often we enjoy the comfort of opinion without the discomfort of thought.

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 03:59 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
1780286369488 ms 1.78028636949E+012 ms 1 /root/website/app_server.cfm
719 ms 719 ms 1 /root/website/author_interviews/full/index.cfm
297 ms 297 ms 1 /root/website/app_layout.cfm
252 ms 252 ms 1 /root/website/author_interviews/full/dsp_main.cfm
237 ms 79 ms 3 /root/website/adsystem/adsystem_mod.cfm
200 ms 200 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
185 ms 93 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
129 ms 129 ms 1 /root/website/adzones/AdZone6.cfm
104 ms 104 ms 1 /root/website/app_globals.cfm
88 ms 88 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
85 ms 85 ms 1 /root/website/adzones/showcase_track.cfm
56 ms 56 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
55 ms 55 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_active_obc.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
26 ms 9 ms 3 /root/website/site/blocks/membership_advantages.cfm
25 ms 25 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_current_competition.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
6 ms 6 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
5 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
4 ms 4 ms 1 /root/website/act_check_login.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/Application.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_author_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/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/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
11 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
731 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 @ 03:59: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=3ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:59: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=5ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:59: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 @ 03:59: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=14ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:59: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=5ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:59: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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:59: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 @ 03:59: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=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:59: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=15ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:59: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=12ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:59: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=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:59: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) = 559

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:59: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) = 559

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=3) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 03:59: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) = 559
Parameter #2(CF_SQL_INTEGER) = 559

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:59: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) = 559

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=7ms, Records=9) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:59: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) = 559

get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59: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=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59: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=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:59: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_book_image (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 03:59:29.029
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) = 723

get_member_account_types (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:59: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=79ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:59: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) = 1552
Parameter #2(CF_SQL_INTEGER) = 1552
Parameter #3(CF_SQL_INTEGER) = 1552

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:59: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) = 1552

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

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=41ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:59: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) = 1104

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:59: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=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:59: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=35ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:59: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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59: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=106ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:30.030
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:30.030
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:59:30.030
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 @ 03:59:30.030
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=42ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:30.030
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=30ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:30.030
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=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:30.030
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=4084933; 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%3D4084933%26CFTOKEN%23%3Dcaba144ee8dc9975%2D0D581F60%2DC6F8%2DA057%2DA8EA51EE7EA977B9%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A59%3A29%27%7D%23hitcount%3D259%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A58%3A52%27%7D%23cftoken%3Dcaba144ee8dc9975%2D0D581F60%2DC6F8%2DA057%2DA8EA51EE7EA977B9%23cfid%3D4084933%23; CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9; FREEACCESSCOUNT=1
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/559/manil-suri
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=4084933
cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
hitcount=263
lastvisit={ts '2026-06-01 03:59:30'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:58:52'}
urltoken=CFID=4084933&CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
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#=4084933&CFTOKEN#=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9#lastvisit={ts '2026-06-01 03:59:29'}#hitcount=259#timecreated={ts '2026-06-01 03:58:52'}#cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9#cfid=4084933#
CFID=4084933
CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
FREEACCESSCOUNT=1
Session Variables:
cfid=4084933
cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
sessionid=BOOKBROWSE_4084933_caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
urltoken=CFID=4084933&CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
URL Parameters:
author_number=559
manil-suri=
Debug Rendering Time: 47 ms