Lindsay Hunter Interview, plus links to author biography, book summaries, excerpts and reviews

Lindsay Hunter
c. Wandy Lyon

Lindsay Hunter

An interview with Lindsay Hunter

The author discusses her novel, Hot Springs Drive, with Brendan Dowling of Public Libraries Online.

I wanted to start by asking what sparked the idea for Hot Springs Drive. Did you begin with a character or a specific relationship?

I'm just going to go ahead and use spoilers because it's hard to talk about it otherwise. it was definitely the relationship between Jackie, the main character, and her son Douglas. This book is based on a real murder that I heard about on a "Dateline NBC" episode that completely shocked me, because I couldn't imagine a son killing for his mother and, you know, probably prompted by her in some way. I had been thinking a lot about codependent relationships between parents and children. I thought, "Oh, this is an opportunity for me to write about that, to see how far I can push it and try to understand it better. And to try to understand what in the world happened in this home with this mother and her son that led to him violently killing his mother's best friend." So it started with that relationship. The murder was secondhand in the first draft I was really just interested in that [relationship) and who Jackie was. In revision, it became more about the central act of violence and everything leading up to it and everything that comes after. But yeah, it was Jackie and her strange relationship with her son.

Thinking about that there's so much of the book is like characters observing each other whether it and I guess it comes into play with kind of like this symphony of voices that that narrate the book. How did that part come into it? Did you always know that you wanted to have the story, told by this huge swath of people?

Yeah, I did. I wanted to give people everything all at once, because that's how I felt when I was done listening to the ["Dateline"] episode, trying to process what I had just heard. I was thinking of everything all at once. I was thinking of the family. I was thinking of the victim and her family. I was thinking of the relationship. I was thinking of the violence itself. I was thinking of the community. I was thinking of the neighborhood. I wanted people to be able to grasp that all at once.

Another thing is that Jackie is honest with you as much as she's able, but we need other glimpses of her, because she's not telling the actual truth—and people rarely do. (laughs) I wanted to give as much of [the story] as I could by offering perspectives to everyone involved, even if they're fourth in line—not secondary, not tertiary, but completely outside everything. Because I think those are really informative viewpoints. I think those can add to this feeling of collective humanity, and that was the feeling I was trying to create.

I'm fascinated by how you play with time in the book. The second chapter gives us this very concise, sweeping description of Theresa's life the reader frequently gets these glimpses into the future of different characters' lives. How did the element of playing with time come into the book?

In my initial draft, I was jumping around in time a lot more so. Theresa would be alive, she'd be dead, she'd be alive again. The boys would be grown up, they'd be boys again. What I thought it was doing was showing you how time can collapse. That's something that I think about a lot. Prior to this I had written what I thought was my motherhood novel and what I was also calling was my collage novel. I'm not sure if this was just aging or if it was becoming a parent, but time had started to change for me. I could feel myself being a child at the same moment that I'm a mother at the same moment that I'm suddenly able to access my future self, looking back. And all of it was happening all at once. It was this uncanny, meaningful, sometimes terrifying feeling. So I had this this novel that I had written that moved forward in time for two of the characters and backward in time for the other character. Time and our perception of time was just really interesting to me. When I moved on to this novel, I was still really processing that. I wanted to be able to capture that feeling, that our perception of time is limited. It's much deeper than then we know. These little feelings we get sometimes—and I think we all get them—they matter and they're informative.

But in the first draft, it was much less chronological. I honestly thought at times, "Oh, people can just shuffle the pages together and reread it in a different order." In revision, it wasn't as meaningful. After having some time and space away from the book and coming back to it and reading it in a more objective way, I was like, "Oh, this is actually distancing me from what the core of this narrative is." So I had to go back and rework it in a more chronological way. But I always want to give this feeling—like those little glimpses into the future that you mentioned—that what's happening now is meaningful now and it's going to be meaningful later.

That makes me think of how the reader knows  early on that Theresa will be brutally murdered, and then you spend time in the first half of the book interacting with her and for me, at least, just falling in love with her. I think that creates an immediacy that's counter to that distancing you were talking about.

Yeah, and that chapter that you referenced—the chapter of Theresa's life in, I don't know, five pages—that came about in the revision. It wasn't there at first. I think it was my feeling that counter to my intention of moving away from like the sort of tropey, formulaic true crime episode, I had put her into this sort of stereotypical silent victim [role]. And so I thought, "I don't even know as much about her as I want to." That was my way of giving that to myself and giving that to the book.

Stylistically, that chapter reminded me of your first collection of stories and your background in flash fiction. Is that something that you're still playing with in in the novel form?

Definitely. I think that my skills in flash fiction help me in every novel, because it's forced me to be as efficient as possible and to get the heart of what I'm trying to write. That doesn't always work. I mean, there's a lot of times when I'm writing and I'm just spinning my wheels. Later, I see, "Oh, it was actually this one sentence that I was trying to get out and there's 1000 words here." (laughs) But it's helped me write these longer things in small achievable bites. It's helped me take confidence in the fact that I can do this. I do have a method. I definitely use my flash fiction background all the time when I'm writing. Now, having said that, I haven't been able to write a very short story in so long. (laughs) The last short story I wrote was 1000 words. I just lost that skill. I need to teach myself again, because I do miss it.

In your acknowledgments you talk about how you wrote this book during the pandemic, and that meant writing in your car or while one of your kids was in virtual school. You also mention that this is the first book that you've written in your forties. Can you talk more about what the process was like and what it means to you to write this novel at this moment in your life?

It's everything. It's a miracle, is what I feel. When I first started pursuing a writing career, I thought, "I've got to write a novel and publish it before I'm twenty-five or I'm a failure." I remember I even had like a blogspot that I titled, "Trying To Finish Before I'm Twenty-Five." I would challenge myself to write a chapter and you could watch me write my novel in real time. With that writing, I got into grad school, so at least it wasn't a waste, but I've always felt this pressure of producing and making. There has always felt like there's these arbitrary age goals. I think that's because there's so much publicity for young writers, there's so many awards for young writers. It's this weird thing that we really laud in the in the publishing industry, youth and beauty. I beat myself up about that all the time. I'm forty-three and I tell myself that I'm going to have to fight tooth and nail to stay relevant.

Those are things that come from inside my own self-doubt. They come from my interpretation of the industry. They come from my brain lying to me, my brain telling me the truth, it's all of it. But when I sit down and just focus on making something, all of that goes away. The pandemic was a really scary, sad time and at the time, I couldn't even process how sad and scary it was. All those feelings are coming back now and realizing how sad and scary it was. But if I could carve out an hour—if it was early, early, early in the morning, if it was sitting in the car pretending to use the bathroom, whatever it was—if I could keep working on this thing I was making that meant a lot to me, then I was holding on to this really essential part of myself.

I've come to realize as an adult—and that's funny that I'm saying I'm an adult as if I wasn't in my twenties, but I do think I was kind of an idiot then—I've come to realize that as much as it's important for me to move my body and work on my strength for my mental health, it's really important for me to write. Because if I'm not writing, that stuff starts to build up in me like kidney stones. So that's how I care for myself, by making sure that I'm honoring that part of myself.

Given the vantage point that the book has in terms of looking back on people's lives and the relationship that these two women have, does this feel like a book you could only have written now? 

I mean, I hate admitting that. I never want to say, "So-and-so can't write from whatever perspective." I was just thinking about Rumaan Alam's That Kind Of Mother. I remember reading his description of childbirth and thinking, "I've never read someone who understands it so fully," and he's a man! He's never given birth. He does have children, but I would never want to say, "Well, he's a man so he shouldn't write that," right? Or "I shouldn't have tried to write this when I was in my twenties. But I do think that there has been some seasoning. (laughs) I remember telling one of my professors way back when I was in grad school, "I know that I can write, I just don't feel like I have something." And he was like, "You don't have the chops yet." And I thought, "Yes, exactly. I need the chops." (laughs) I think those are what you get when you live and you challenge yourself and you have to continually convince yourself to do it and that you can do it. So I would say it would have been a very different book if I had tried to write this in my twenties.

I look back on my first collection Daddy's. There are a lot of monstrous babies in that book.  I must have really been thinking about having children in a way that I wasn't aware of. I would never probably write babies like that now that I'm a mother, but I also hate admitting that because again, I don't ever want to say, "Oh, you're not a fully formed person until XYZ," right? But yeah, I think it just would have been really different.

The first half of the novel leads us up  to the murder and then the second half explores all the characters' lives afterwards. Can you talk about how that structure  emerged? 

I think that's what's really interesting to me about events like this. Of course, in the moment and in the immediate afterward, it's traumatizing and chaotic and horrible and confusing, but I wanted to know what the lasting effects are. I wanted to stay with these characters as much as possible. Like I said, in my first draft, there were those jumps forward in time but they were in different orders. When I smoothed it out in revision and put everything chronologically, that's when it kind of fell into that part one, part two, and there's a part three that has a present and it also goes back into the past, right around the time for violence happens.

I just wanted to give everything. I wanted to give the crime and the affair. I wanted to give how it affected everybody later. I knew people would want to see what Jackie was up to. They would want to know what the boys were up to, what Cece was up to. It was hard for me to accept that it was okay for it to be chronological, because it felt like I was giving up something. But actually, as I started to shape it that way, [I found] it was really enhancing it and opening up these other opportunities for characters to speak in the future. I've heard from some readers that they love part one and they don't understand part two, or they love part two and part one was too slow. It's fun to see it be all over the board like that. But I think the overall effects that I was going for was just this intense view of the consequences.

This book made me think about our culture's fascination with true crime, especially how the second half really seems to be examining the realities of these events that are featured in podcasts or a "Dateline" episode.

And, you know, there are some really, really great true crime podcasts that do that. they kind of like it's something you have the podcasts that that are reexamining unsolved crimes, and some of those are real garbage because it's just like a dude driving around and being like, "I guess I'll pull up to the trailer. Let's see if they'll let me in." And then the person doesn't let him in. It's a lot of that, but there's also these other really great ones that show you who the person is now and then reveal who they were at the time of the crime. And I love that. I really love that.

I love the notion in any form of literature, or any form of art, that the end is not the end, that it's going to linger. As a reader, you're going to be thinking about these things and going back over them. Even getting frustrated, I think, is a very valuable feeling as a reader. I know I'm not in the majority there, but I think it offers a chance to stay a little longer with the story.

Based on reactions that you've posted on Instagram, a lot of readers seem to be talking about the sex scenes. Especially in a time where we talk about how sex scenes are not being shown in movies or TV as much anymore, what was it like for you to explore how these characters are revealing about themselves in the sex scenes?

I always love this question, because did you listen to You Must Remember This — Erotic 80s and Erotic 90s?

Yes!

Karina Longworth's amazing. I had never really pondered that sex or eroticism is kind of disappearing [from pop culture] and trying to figure out why or the political reasons for it. I know there's been some talk about how the younger generation is kind of icked by sex scenes, and why that might be. But this is a book very much about bodies, like a literal dead body and then just bodies. I think one of the most informative tools a writer has is a sex scene. You can really show where the character is, what the character is trying to come off like, what the character is searching for, what the character needs, what they're demanding, what the characters are together.

Also the kind of affair that Jackie and Adam have, it can scramble your brain. That was an important part of Jackie's arc: she was in this very physical, torrid affair and she was getting something important out of it, but it was also changing into this other thing. It was crucial for us to see that so that we could understand what comes later. Theresa finds them and they're tearing at each other. They don't really want it anymore, but they don't know how to back out of it. I just I think those are really important, base human interesting things to explore in literature and film.

Also, those scenes illuminate their world. There's something so visceral about them.

My editor Roxane Gay when she read the first draft—poor Roxane, it was very rough, very raw, and it was not finished, so God bless her for still wanting to buy it. But that scene [where Jackie and Adam are] in the front seat, it's one of the grossest, most carnal of the sex scenes. They've just had it with each other, but they also still really want each other. She just highlighted that and was like, "More of this." I mean, Roxane herself is a very good writer of sex scenes, but just she got it. She understood.

I recently interviewed Laura Sims, and while How Can I Help You and Hot Springs Drive are totally different books, they are both compact, economical novels. When I interviewed her she talked about her love of the "short, weird novel,." I wanted to hear from you about what you enjoy about working in such an economical frame?

I am also a big proponent of short novels. There are a lot of long books that I enjoy, but I think you can do less and make more. It goes hand in hand with that feeling I'm trying to create where not every question is answered, not every door is closed. I've heard from so many readers who were like, "But what about [these two characters]? Did they end up together?" I don't want to answer that. I want you to think about it. I want to give you just enough. I want your imagination to work. I want your life experience to be working hand in hand with what you're reading. I just think it can create a more efficient sense of ambivalence almost. I know that's got a negative connotation, but I think it's so great when a book sticks with you like that, and I think short books often do because they don't give you everything.

I think it makes the reader work harder in terms of,filling in the gaps based on what's been presented.

I think also, in some cases, when a book is really polished, I can see too clearly the writer's contrivances. I think that's because of being in the industry for so long. I remember when I was a theater kid and taking classes, they said, "You'll never be able to watch a movie again in a normal way, because you'll constantly be thinking about the choices that everyone made." And they were right. (laughs) And that's how it is to become a writer. Even though reading is my life and I read all the time, I'm always thinking of those kinds of things. I want there to be space for me. I know that lots of readers don't feel that way. But that's what feeds me, and that's what I'm thinking of when I'm writing.

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 Lindsay Hunter at BookBrowse
Hot Springs Drive 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 Lindsay Hunter 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

  • Angie Kim

    Angie Kim

    Angie Kim moved as a preteen from Seoul, South Korea, to the suburbs of Baltimore. After graduating from Interlochen Arts Academy, she studied philosophy at Stanford University and attended Harvard Law School, where she was ... (more)

    If you enjoyed:
    Hot Springs Drive

    Try:
    Happiness Falls
    by Angie Kim

  • Celeste Ng

    Celeste Ng

    Celeste Ng grew up in Pittsburgh, Pennsylvania, and Shaker Heights, Ohio, in a family of scientists. She attended Harvard University and earned an MFA from the University of Michigan (now the Helen Zell Writers' Program at ... (more)

    If you enjoyed:
    Hot Springs Drive

    Try:
    Little Fires Everywhere
    by Celeste Ng

We recommend 3 similar authors

View all 3 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...

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

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 08:18 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
1780301936849 ms 1.78030193685E+012 ms 1 /root/website/app_server.cfm
324 ms 324 ms 1 /root/website/author_interviews/full/index.cfm
121 ms 121 ms 1 /root/website/app_layout.cfm
100 ms 100 ms 1 /root/website/app_globals.cfm
93 ms 31 ms 3 /root/website/adsystem/adsystem_mod.cfm
78 ms 78 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
74 ms 74 ms 1 /root/website/author_interviews/full/dsp_main.cfm
41 ms 41 ms 1 /root/website/adzones/AdZone6.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_active_obc.cfm
34 ms 34 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
33 ms 17 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
32 ms 32 ms 1 /root/website/adzones/showcase_track.cfm
20 ms 20 ms 1 /root/website/adzones/AdZone2.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_competition.cfm
19 ms 19 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
15 ms 15 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
10 ms 3 ms 3 /root/website/site/blocks/membership_advantages.cfm
8 ms 8 ms 1 /root/website/act_check_login.cfm
8 ms 3 ms 3 /root/website/queries/qry_get_member_account_types.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_member_info.cfm
6 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/formurl2attributes.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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_header_newsletter.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
325 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

adactive (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 08:18:56.056
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 @ 08:18:56.056
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=9ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 08:18:56.056
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 08:18:56.056
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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 08:18:56.056
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 @ 08:18:56.056
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=10ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 08:18:56.056
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=18ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 08:18:56.056
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=8ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 08:18:56.056
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=12ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 08:18:56.056
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) = 3873

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 08:18:56.056
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) = 3873

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 08:18:56.056
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) = 3873
Parameter #2(CF_SQL_INTEGER) = 3873

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 08:18:56.056
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) = 3873

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=2ms, Records=3) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 08:18:56.056
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) = 3873

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

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

get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 08:18:56.056
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=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 08:18:57.057
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_book_image (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/actions/udfs.cfm @ 08:18:57.057
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	left join editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
	left join editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1
                    
    where 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4731

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

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 08:18:57.057
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 08:18:57.057
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=7ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 08:18:57.057
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 08:18:57.057
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

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

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

get_quotes (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 08:18:57.057
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 08:18:57.057
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 08:18:57.057
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

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

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


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D4092475%26CFTOKEN%23%3D1974b1e526f1e12a%2D16A5044B%2DE76A%2D7E41%2DCFF7ECEDCF6469EE%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2008%3A18%3A56%27%7D%23hitcount%3D3%23timecreated%3D%7Bts%20%272026%2D06%2D01%2008%3A18%3A55%27%7D%23cftoken%3D1974b1e526f1e12a%2D16A5044B%2DE76A%2D7E41%2DCFF7ECEDCF6469EE%23cfid%3D4092475%23; CFTOKEN=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE; CFID=4092475; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/3873/lindsay-hunter
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=4092475
cftoken=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
hitcount=5
lastvisit={ts '2026-06-01 08:18:57'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 08:18:55'}
urltoken=CFID=4092475&CFTOKEN=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
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#=4092475&CFTOKEN#=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE#lastvisit={ts '2026-06-01 08:18:56'}#hitcount=3#timecreated={ts '2026-06-01 08:18:55'}#cftoken=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE#cfid=4092475#
CFID=4092475
CFTOKEN=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
Session Variables:
cfid=4092475
cftoken=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
sessionid=BOOKBROWSE_4092475_1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
urltoken=CFID=4092475&CFTOKEN=1974b1e526f1e12a-16A5044B-E76A-7E41-CFF7ECEDCF6469EE
URL Parameters:
author_number=3873
lindsay-hunter=
Debug Rendering Time: 15 ms