Lee Child Interview, plus links to author biography, book summaries, excerpts and reviews

Lee Child
Photo: Sigrid Estrada

Lee Child

An interview with Lee Child

Lee Child answers many questions including why he takes the time to answer reader's questions himself and what he thinks of the movie adaptations of his books.


Your latest book, Persuader, is one of your best yet. Was there anything in particular that energized you while writing it? Perhaps the return to the first-person narrative?
Thanks for the compliment! I guess I find each new book a very energizing experience, but for this one the return to first-person coupled with a powerful idea for the opening couple of sequences gave it extra momentum early in the process. Certainly it was fun to write -- really very linear, and very focused.

Almost all the reviews for Persuader have been dazzling. How do you come off that high and buckle down for the next book? Or is your confidence strong enough that fear no longer enters into it?
Fear is always a part of it. Graham Greene once said "Success for a writer is merely failure delayed." But really, the thing is that a book-a-year writer like me works so far ahead that by the time, say, Persuader comes out, I've already written the following book and am starting the one after that. So in response to Persuader reviews, I'm thinking, what, that old thing? And in general I'm pretty self-confident, for a writer. By now I know I can do this.

Let's talk about the movie deal. Some very well-known writers have been less than thrilled with the movie adaptations of their books. With Reacher, especially, the movie must rise and fall on its casting. Will you have input? If not, why not?
I won't have any input, and I don't really want any. I'm a firm believer in "horses for courses." I write the novels, the graphics people design the jackets, the marketing people write the ads, the movie writers produce the script. We all focus on what we're good at. But I try to avert problems by being very choosy about who I sell the rights to -- I look for people with fine track records. Then I trust them. The pre-selection process means the movie will be at least OK, in my opinion, with the very good chance that it'll be excellent. But you're right, casting is everything. But the thing about acting is that it's never totally predictable. Go back a decade and you'll find Thomas Harris fans puzzled over Anthony Hopkins as Lecter. But that worked out OK, didn't it? Sometimes you just have to let the pros make their choices and work their magic.

Your many fans are known to be a gregarious bunch, easily expressing their opinions on your official website. You seem to be one of the more accessible authors. This interaction has always struck me as a kind of fearlessness on your part. Many authors don't bother. Why do you?
I do it because I want to. I like interacting with people. And all my life I have enjoyed quizzing people that I'm briefly in contact with. Like, a guy comes to paint my house ... I'm asking him about his job, how he does it, what's fun, what isn't, what are the tricks, and so on. I figure other people are the same. They want to ask me things. I don't see writing as a grand profession. It's like being a house painter. It's something I do, like the painting is something he does. So let's indulge our mutual curiosity.

In a way, Jack Reacher represents an ideal most men might find hard to live up to. How much of Lee Child exists in Reacher? In the beginning, were you surprised to find that women flocked to your books? In fact, are you surprised at all by the wide variety of your reading audience?
There's a lot of me in Reacher. If I had his physical invulnerability, I would be him. Absent that physical prowess, I don't think he's hard to live up to. He's just a decent guy who tries to do the right thing. That's something we would all do, I think. I am a little surprised that women love him so much -- I thought he was too uncivilized. That shows how much I know about women! I think two factors are in play: I find women more than men get upset about injustice and unfairness, down at a gut level, so the way Reacher rights wrongs in an old fashioned way must appeal. And he moves on ... much easier to contemplate a mental affair when the reader knows he'll be gone in a week -- thanks for the memories! I am amazed by the spread of my readership. I have fan letters from a 101-yr-old woman and a 10-yr-old boy. That's quite a range. The books have no bad language and Reacher is a classic hero, which I think helps explain it.

Jack Reacher is very much an American hero. Though you live and write in the US, does being British help in some odd way to clarify your insight into American myth and behavior?
Being an outsider with a fresh eye helps, for sure. I feel sometimes I see things that are obscured by familiarity for those that have always been here.

It's no secret that you are a vociferous reader. To what do you attribute your love of reading in general? What is the first book you ever remember reading?
I started reading early, and I can remember why: lack of alternative entertainment sources, and a need to escape a humdrum and boring life. Same for everybody, probably. The first "proper" book I read -- all writing, no pictures -- was Five on Kirrin Island from the Enid Blyton Famous Five series. Classic escapist reading. It was a series about three siblings with no parents who hooked up with their tomboy cousin and had adventures. Years later I was involved in a TV parody called "Five Go Mad on Mescaline." I felt a little bad about it because I had loved the originals so much. They meant a lot to me back then.

How do you avoid being influenced by other genre writers? Or is not something you worry about?
I don't worry about it. Generally writing is such a personal thing that even if you gave ten of us the same outline and the same opening paragraph, the resulting ten books would be totally different from each other.

Commercial fiction seems to have more cachet now than ever. What excites or distresses you about the mystery/thriller genre today?
I'm excited by the way that it's kind of "out of the closet" ... whoever you are, it seems it's now okay to read John Sandford or Michael Connelly (or even a Reacher novel) in the front of the plane. And quite right, I say, because the narrative arc in these books is the fundamental narrative arc going way back in the human brain: the thrill of danger, peril, and then resolution and safety. It's why we learned to tell stories in the first place. The only thing that worries me is a slipshod tendency to make violence sicker and grosser, as a way of trying to be more cutting-edge. It's a poor substitute for genuine suspense.

What's the last book you read? Would you name a few of your favorite authors?
Last book I read was One Last Hit by Nathan Walpow -- outstanding book. I read everybody in the genre. Unfair to mention favorites, but I love Joe Kanon's stuff. Outside the genre, William Styron maybe.

Do you have any thoughts you wish to reveal on what the future holds for Jack Reacher?
The next book is a prequel, which takes place seven years before the events of my first book, Killing Floor. Reacher is 29, serving as a military policeman, the Berlin Wall is coming down, his brother is still alive, his mother is still alive. After that will come more present-day books, with maybe another prequel if people like the first one. Reacher will continue until readers get sick of him, and then he'll go out in a blaze of glory. The final title will be Die Lonely -- but I hope I'm not writing it too soon.

What's next for Lee Child?
Same old same old, except my daughter has moved out and gotten a job and an apartment, so my wife and I might move house for the next phase of our lives. But basically I don't plan anything. I just see what turns up. So far, it's been a great ride.

Lee Child was interviewed by Yvette Banek and David Montgomery. This interview was first published at http://www.mysteryinkonline.com in 2003. It is reproduced with the permission of mysteryinkonline.

An Interview with Lee Child, April, 2002.


When I first saw the cover for Killing Floor, I knew it would be a book I should read. And I was right. I was hooked from page one. I immediately told my friends and soon they were hooked too. I look forward to each and every book and drop whatever I’m reading to read the latest adventure with Jack Reacher. As far as I’m concerned, he owns the action thriller genre. I’ve been lucky enough to meet Lee a few times at conventions and signings. He is such a nice guy that whatever words I use won’t do him justice. But I can say that if you get the chance to meet him at an event, do it. Let the Reacher Creature in you out!

Interview

When I interviewed you last, in the spring of 2000, you had three books out, and Running Blind on its way. The series was generating a following then, but now it seems like everyone is reading your books. Are you gratified by the success?
You bet I am. That was a significant year - maybe your interview was what made the difference! But it all seemed to take off real big around that time. Now I can't tell you how good it feels to have so many new readers every year. Very, very exciting.

With the large fan base you have, I would imagine that there is a lot of feedback from readers. Do you get a lot of requests for things to do in the books? Like "Can you have Reacher come to Seattle?"
Seattle, and California, and Britain, and Australia, and just about everywhere else. Problem is, there would have to be a really good, organic reason. I don't want to turn the series into a travelog just for the sake of it. I get requests to bring characters back, too, like Roscoe or Jodie or Harper. But equally I don't want to turn the series into a pure soap opera.

Little by little we are getting glimpses into Jack's past. Is this going to continue? Will we ever know everything?
It's a process that will definitely continue, and it might even include an actual "prequel" as one of the upcoming books. It's really the only way we can get to know Reacher better - he's so much of a solo drifter in the present day that his emotional resonance has to come from the past. Will we ever know everything? I hope not, because that would imply the end of the series.

Usually books that come out in the UK don't come out until a year later in the US. Yours are almost at the same time. Why is that?
Because they're really American publications, with the US publisher owning the primary rights. It's actually just a technicality that they appear in the UK first, even by a matter of a few weeks - my contract states that they should be published in the US first, but back in 1999 Putnam merged with Penguin and the new amalgamated company re-jigged its list and moved me back a little, thereby accidentally exposing the UK date as the true first publication. So it's really just a glitch.

With all the traveling you do with touring and such, do you have a favorite city to stay in? A favorite hotel?
I've got a lot of favorite places, mostly connected with how good the local book scene is. Some of them are a lot of fun. I don't care much about hotels - in fact I often ask to be "down-graded" because I like cheap anonymous dives much better than the kind of place that has a dozen obsequious doormen in your face all the time.

Are you working on any other projects besides the Jack Reacher novels?
No, one Reacher a year plus all the attendant promotional hoopla is enough for me. Anything more would start to feel like serious hard work!

These books scream movie to me. Are you getting any interest from Hollywood? Any buzz you could share?
We get constant buzz and interest. I was riding on a train the other day, from Manchester to Norwich on the English tour for "Without Fail", and my cell phone rang and it was Warner Brothers asking about the rights. I'm sure there'll be a movie within a year or two. It's like publishing itself - it takes a long time for momentum to build to the point where something actually happens.

Have you read any books recently that you would recommend?
Lots, some that need no recommendation from me, and maybe some that do. I filled in the gaps in my Michael Connelly reading with "The Concrete Blonde" the other day and loved it. And "The Good German" by Joseph Kanon, and "Tarmac" by Lynne Heitman, and "Flashover" by Suzanne Chazin, and Robin Burcell's new book. All excellent. That's what's so great about this genre - everywhere you look there's talent, be it knew, old, or in-between.

Reacher's Creatures..... What was your first reaction to this group of people? Did you ever think you would see a creation of yours on T-Shirts and spawning fan clubs?
http://www.ReacherCreatures.com is a fan site, nothing to do with me, but of course I'm incredibly flattered. I've seen fans wearing the Reacher fatigue T shirt and camouflage pants at signings. I think it's terrific, because it's about the character passing into public ownership, and there's nothing more flattering than that for a writer.

Where are some of the places you would like to take Jack to?
That depends on the feel and the mood of the story idea. It's got to fit right. I never really have any idea until I catch the "key" of the next book. Ideally I'd like to take him all over the place, a book a year for the rest of my life.

Do you put a lot of effort into getting the title just right for each book?
I think the title is vital (how about that for a catchphrase?) So yes, I put a lot of effort in. But that's not to say I succeed every time. In fact I think a couple of my titles are pretty weak. And there have been compromises with the publishers, which never helps, because a good title is like love, you can't explain it or talk about it. It's either there or it isn't. I'm happy with "Without Fail", even though it contains two negative words and therefore isn't technically ideal as an eye-grabber. Next year's book is a one-worder: "Persuader." I like that, too.

The website is beautiful, and nowadays it's almost a given that most authors have one. Do you find it to be a good way of keeping in touch with the fans?
It's an excellent way. Web site e-mail has totally revolutionized author fan mail. Easy for the reader, easy for the author. And as you say, a web site is now a given, anyway. People just reflexively enter "Author'sName.com" and you better have something waiting there for them. Mine is done by a genius fireball called Maggie Griffin, who shoulders the whole load, which is just as well, because I wouldn't have the time or the skill to do it myself.

What's the coolest part of being an author?
Being on a plane or a beach and seeing somebody reading your book. Being called up on your cell phone on a train by movie producers. Seeing your name in the best-seller lists.

Will we be seeing any more of Frances Neagley in the future?
Like I said, I'm wary of doing the soap-opera thing, and I'm wary of formula, but she was a great character. So yes, maybe she deserves to come back.

Is there anything you won't do in your writing? Any subjects that you just wouldn't write about?
I won't write about gratuitous sexual abuse of children. I'm a tough guy, I'm not squeamish or prudish, but there are some places we don't need to go.

What's the most outrageous thing you've encountered at a signing?
People who follow me from town to town, night after night. I mean, I'm flattered and all, but I'm not that interesting! And there was a woman in New York last year who upbraided me mercilessly for using what she called an old author photo that made me look younger than I really was. Problem was, it wasn't an old photo! Made me feel like I should consider plastic surgery!

The more involved I get in the mystery/thriller/crime genre, the more I can appreciate the writers who do the work. And yet I keep reading on different forums little nit picks about the tiniest things. Do you think it is a safe assumption for an author to expect the readers to remember that they are reading fiction and that certain liberties need to be taken? Because truthfully, a book that was totally absorbed in realism and fact would be pretty dull.
Good point. I joke that the days when nothing happens to Reacher, I still write the books, but the publisher rejects them. But what I learned from my years in TV is that whatever you do, there are people who will write in with objections. Often I find they write with complaints about the parts that are carefully researched and absolutely true! So I trust that most of the audience is responding in the right spirit, and I use the complainers as a rough gauge to how many people I'm actually reaching. Twenty serious complainers as a percentage implies a million satisfied customers, in my experience.

Can you talk about what Jack Reacher is up to in the follow-up to Without Fail?
Next year's book is "Persuader" and it's written in the first-person, like "Killing Floor" was. So it's back to an intensely personal story from Reacher's own point of view - it's a resonance from a disaster ten years ago in his past. A real "this time it's personal" type of thing. It's been a fun book to write.
BookBrowse note: The Enemy was published in the USA in May 2004

How far before publication are the books written?
Usually about a year. I try to hand in next year's final draft just as this year's book comes out. But I'm a little late this year ... 9/11 delayed me somewhat.

And, is raspberry danish still the one thing always in your refrigerator?
I just checked, and there's plenty of Peruvian Organic Shade-Grown coffee in there too. Coffee and danish ... all a writer needs.


Lee Child was interviewed by Jon Jordan in 2003. This interview is reproduced with the permission of MysteryOne and Jon Jordan. Interviews may not be used without permission of Mystery One or Jon Jordan

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 Lee Child at BookBrowse
Blue Moon jacket Never Go Back jacket A Wanted Man jacket The Affair 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 Lee Child 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

  • Jeff Abbott

    Jeff Abbott

    Jeff Abbott is a suspense novelist. He is published in twenty languages and has been a bestseller in the US, the UK, Ireland, France, Germany, Australia and Portugal. His novels Panic and Collision have been optioned for film... (more)

    If you enjoyed:
    Echo Burning

    Try:
    Panic
    by Jeff Abbott

  • David Baldacci

    David Baldacci

    David published his first novel, Absolute Power, in 1996. A major motion picture adaptation followed, with Clint Eastwood as its director and star. In total, David has published 32 novels for adults; all have been national ... (more)

    If you enjoyed:
    Tripwire

    Try:
    The Simple Truth
    by David Baldacci

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

I like a thin book because it will steady a table...

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 12:32 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
1780273955229 ms 1.78027395523E+012 ms 1 /root/website/app_server.cfm
570 ms 570 ms 1 /root/website/author_interviews/full/index.cfm
269 ms 269 ms 1 /root/website/app_globals.cfm
95 ms 95 ms 1 /root/website/queries/qry_get_active_obc.cfm
94 ms 94 ms 1 /root/website/author_interviews/full/dsp_main.cfm
93 ms 93 ms 1 /root/website/app_layout.cfm
82 ms 27 ms 3 /root/website/adsystem/adsystem_mod.cfm
67 ms 67 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
47 ms 47 ms 1 /root/website/queries/qry_get_current_competition.cfm
38 ms 38 ms 1 /root/website/actions/adstatus.cfm
37 ms 19 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
35 ms 35 ms 1 /root/website/adzones/AdZone6.cfm
32 ms 32 ms 1 /root/website/act_check_login.cfm
31 ms 31 ms 1 /root/website/queries/qry_get_member_info.cfm
30 ms 30 ms 1 /root/website/adzones/AdZone2.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
24 ms 6 ms 4 /root/website/actions/act_spider_tracker.cfm
22 ms 7 ms 3 /root/website/site/blocks/membership_advantages.cfm
21 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
20 ms 20 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
18 ms 18 ms 1 /root/website/adzones/showcase_track.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
13 ms 13 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
6 ms 6 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/queries/qry_get_current_ezine.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
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.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_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
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
572 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=23ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 00:32:35.035
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=31ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 00:32:35.035
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=37ms, Records=2) in /root/website/actions/adstatus.cfm @ 00:32:35.035
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 @ 00:32:35.035
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 @ 00:32:35.035
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=24ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:32:35.035
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=22ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:32:35.035
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 @ 00:32:35.035
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=17ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 00:32:35.035
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=22ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 00:32:35.035
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=53ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 00:32:35.035
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=18ms, Records=6) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 00:32:35.035
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) = 329

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 00:32:35.035
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) = 329

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=16) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 00:32:35.035
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) = 329
Parameter #2(CF_SQL_INTEGER) = 329

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=50ms, Records=10) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 00:32:35.035
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) = 329

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=14ms, Records=29) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 00:32:35.035
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) = 329

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
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=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
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=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:32:35.035
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=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:32:35.035
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=24ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:32:35.035
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) = 1204
Parameter #2(CF_SQL_INTEGER) = 1204
Parameter #3(CF_SQL_INTEGER) = 1204

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:32:35.035
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) = 1204

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=4) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:32:35.035
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) = 181
Parameter #2(CF_SQL_INTEGER) = 181
Parameter #3(CF_SQL_INTEGER) = 181

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:32:35.035
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) = 181

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:32:35.035
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=6ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:32:35.035
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=5ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:32:35.035
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=23ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
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=8ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 00:32:35.035
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 @ 00:32:35.035
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:32:35.035
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4078283%26CFTOKEN%23%3Dfb44fd7389dbf580%2D05F4CA01%2D9BCB%2DF82F%2DB20C25D52947ABF6%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2000%3A32%3A35%27%7D%23hitcount%3D137%23timecreated%3D%7Bts%20%272026%2D06%2D01%2000%3A32%3A17%27%7D%23cftoken%3Dfb44fd7389dbf580%2D05F4CA01%2D9BCB%2DF82F%2DB20C25D52947ABF6%23cfid%3D4078283%23; CFID=4078283; FREEACCESSCOUNT=0; CFTOKEN=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
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/329/lee-child
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=4078283
cftoken=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
hitcount=145
lastvisit={ts '2026-06-01 00:32:35'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 00:32:17'}
urltoken=CFID=4078283&CFTOKEN=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
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#=4078283&CFTOKEN#=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6#lastvisit={ts '2026-06-01 00:32:35'}#hitcount=137#timecreated={ts '2026-06-01 00:32:17'}#cftoken=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6#cfid=4078283#
CFID=4078283
CFTOKEN=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
FREEACCESSCOUNT=0
Session Variables:
cfid=4078283
cftoken=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
sessionid=BOOKBROWSE_4078283_fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
urltoken=CFID=4078283&CFTOKEN=fb44fd7389dbf580-05F4CA01-9BCB-F82F-B20C25D52947ABF6
URL Parameters:
author_number=329
lee-child=
Debug Rendering Time: 12 ms