Amanda Eyre Ward Interview, plus links to author biography, book summaries, excerpts and reviews

Amanda Eyre Ward
Photo: Cory Ryan

Amanda Eyre Ward

An interview with Amanda Eyre Ward

Amanda Eyre Ward talks about the genesis of her short stories, including those collected in Love Stories in This Town, and how her writing style has evolved over the years.

Reproduced with the permission of Random House Reader's Circle.

Most of your readers know you as a novelist, but you have actually been a short-story writer for longer than you have been a novelist. Can you talk a little about how and when you first started writing stories?

I went to Williams College, where I signed up for Jim Shepard's Introductory Fiction Workshop. I showed up the first day to find the room packed. Jim (Professor Shepard to me then) told us we could submit one story, and he would choose the members of the small class and post a list on his office door. Many of the other students had folders of stories, neatly stapled, but although I was an avid reader, I had never written a story before. I was reading Denis Johnson and Raymond Carver at that time. I typed all night on my Brother word processor, creating a story about a speed-addled trucker on an all-night run. I think the trucker ended up in a "wall of flames." I wasn't hopeful, so I didn't even check the list on Jim's door. When a friend congratulated me, I had already missed the first class. I showed up the next week, and Jim said, "Now where were you for the first meeting, Amanda?" 

"I was at the mall buying sneakers." 

"At the mall buying sneakers," Jim said. "Class," he said, "this is what we call off to a flying start.

After this "flying start," I never looked back. Jim taught us what a short story was. He also showed his students, by example, that one could write fiction, that it was possible to study and work hard and become an author, the same way others might become a banker or a hockey coach. This was a revelation to me. My father remembers a moment in his car when I opened the envelope with my final grade in Jim's class–a B-minus–and burst into tears. It was the only grade I cared about, and by the end of college, writing a beautiful short story was the only thing I wanted to do. I wanted to be Raymond Carver, Rick Bass, and Richard Ford, so after a year abroad, I moved to Montana. 


How do you think your writing has changed since then? 

In Missoula, I was imitating writers I loved. My professor at the University of Montana, William Kittredge, taught me to expand my repertoire, to rely on honesty–on my story, what I had to say–instead of shock value. I expanded my reading list, devouring Paul Bowles, Mona Simpson, James Salter, Katherine Anne Porter, Michael Cun ningham, and Jennifer Egan. I began to slow my sentences down, working to trust character development, to choose sincerity over sarcasm. He also told me that if I wanted to be a novelist, I needed to move to where my best friend was and write my damn book. 


One of the stories in this collection grew out of a story you wrote as a graduate student. Can you tell us about that? 

"Miss Montana's Wedding Day" was my first published short story. It won third prize in the Austin Chronicle Short Story Contest, and when they called to tell me, I was busy at my latest job, answering phones at a software company. I told my colleagues the exciting news, and one called out, "Hey everyone! Amanda's going to have one of her stories published in the Pennysaver!" 

It was strange to revisit the story. I was a heartbroken graduate student when I wrote it, so it was interesting to peek back in time, to see how I viewed love. I now understand some things about the character Lola that I didn't understand then. Sometimes that happens – I don't know why a story or book isn't working, and I give up, but when I revisit the work later, some event or knowledge enables me to understand the piece. 

On a technical level, I liked to rely on pointing out local color a bit too much, I think. I wanted the setting to tell the reader things that could be conveyed only by allowing readers into Lola's thoughts. (I was trying to be like Paul Bowles ... his use of setting is unsettling and amazing.) My editor, Anika Streitfeld, has worked on all four books of mine, and she's really encouraged me to let readers into a character's thoughts. Almost every first draft comes back with pages of Anika's red-penned notes saying, "What is she thinking here?" and "A bit about what he's feeling." 

The end of "Miss Montana's Wedding Day," when Abe says, "There are no love stories in this town," seemed very bleak and revelatory to me when I wrote the story. Instead of a sad statement about Lola's future, I now see it as a harbinger of things to come: Lola will leave that town, and she will have a love story of her own. 


What do you usually start with when you're setting out to write a short story? How do you know that the material is better suited to a story than to a novel? 

Generally, I think in "scenes." I'll see an image–a woman sitting at an airport bar, or a man in a canoe. So for "The Stars Are Bright in Texas," for example, I saw a couple house hunting, an unhappy woman in the back of a minivan. I'm interested in places like The Woodlands, outside Houston, so I set the story there. As Kimberly and Greg moved through their house hunt, however, I wasn't sure if the "scene" would be a story, a piece of a novel ... I didn't know. And when it ended, with Kimberly walking toward Greg at the airport, I just knew the story was over. I didn't need to follow them back to Bloomington, or see how they ended up. I realized that the story was an exploration of loss counterbalanced with hope. And whether or not that hope was fulfilled wasn't what I wanted to write about. 

On the other hand, I am now working on a novel, and as I'm following the characters through the scenes, I just keep thinking more of their past and future, and how their stories will dovetail. I don't know how to explain it–I know there's a novel (or maybe ten) there. I wish I knew how it would all work out, but as long as the images keep coming, I feel lucky. 


"Should I Be Scared" and "The Way the Sky Changed" take place in the wake of 9/11. Did you write them soon after the events in the story occurred? Were these difficult stories to write? 

I am from Rye, New York, a town that was deeply affected by 9/11. There are so many heartbreaking stories from my town–families who lost fathers, families who lost sons. And I hadn't lived in Rye for a long time, so it always seemed somewhat idyllic in my memory, a childhood place full of walks to school with my best friend, white picket fences, and lemonade stands. After the collapse of the towers, I was devastated–it seemed impossible that not even Rye was safe. I remember I went to a reading that week, it was Jonathan Franzen reading from The Corrections at Book People in Austin. I raised my hand and asked him if he'd ever be able to write about normal, calm life again. He thought my question was strange, and said, "Of course I will." (Everyone reacted in a different way–in several interviews since, I've read Franzen's take on the 9/11 aftermath, and how it has, in some ways, affected his work.) I drove home that night wondering if I was crazy for feeling so frightened. I wrote "Should I Be Scared?" soon after 9/11, and I have to admit that I did, indeed, get a prescription for ciprofloxacin. I hid the pills in a baggie in my utensil drawer. I didn't write "The Way the Sky Changed" for a while. I actually wrote a short play first about a policeman coming to a 9/11 widow's apartment with her husband's remains. As time passed, the aftermath of 9/11 became so awful it was surreal–the hairbrushes, the bones. I know that many people have been hurt around the world by acts of terrorism, but I don't think I'll ever get over September 11. 


"Shakespeare.com" also captures a particular time and place–the Internet boom in San Francisco. Can you tell us about the evolution of this story? 

I worked at many different jobs during the Internet boom–I was just out of graduate school, and though newspapers were calling the time a boom, I had never known anything different. At one point, I got a job as a "Curriculum Developer" for a company in Austin. We had a great time, and most of the details about margarita machines and puppies are true. But there was always a gnawing sense that we might not all strike it rich with this venture. I guess I like the idea that Mimi is knocking at the door of the real world–parenthood, responsibility–but not quite walking through it yet. 

The first draft of the story ended with Mimi realizing that she is not pregnant, and the company getting more money and Girl Scout cookies. I sent the story out and was contacted by M.M.M. Hayes, the editor of Story Quarterly. We had a great conversation about the story, and she said that she felt I had dropped the ball at the end. She told me she wanted stories that "opened out," or gave a reader some wider sense of the world. 

I took her comments to heart, and I'm really proud of the final story. Like the dinosaurs, Mimi and Leo are about to get hit: by parenthood, by adulthood, by world events like 9/11. 


As the title suggests, place plays an important role in this collection. How did you come up with the settings for the various stories? How is writing about places you have lived in different from writing about places you haven't? 
Luckily, in my search for a home, I've lived in many places. And place is very important to me. I can hardly write about a place I don't really know, though it's often
years after I leave a place that I want to write about it. Some time needs to pass before I can figure out what a place has meant to me, what I've learned there. But for the stories to work together, they couldn't all be set in the same towns. "Shakespeare .com," for example, was moved from Austin to San Francisco. My editor's husband, Jared Luskin, had worked in an Internet start-up, so he was able to help me relocate the story without too much trouble. I kept some of the Austin bars, however. Jovita's is here in Austin–you won't find it south of Market. 

In general, I don't like to write about places I don't know well. There's no substitute for walking the streets of a city, sitting at a local diner, driving the same streets every day to get to work. 

Now that I've settled in Austin, Texas, for a while if not forever, I'm interested in neighbors, in the way proximity leads to friendship and dependence. I'm also able, once in a while, to turn off the fiction writer's radar, to not always be noting the local customs, as if I'm in a foreign country and not in my yard. But that's another story. 


Can you talk about how Lola developed? 

Well, originally, she was named Vera, for one thing. When I realized I had enough stories for a collection, I wasn't sure which stories were about the same character. Many of the women were the same age, and many were married (as I am) to a geologist. 

It took some time to trust myself and figure out which characters were connected and how . . . putting all the stories together was very difficult. Each story was written to be its own world, to stand alone. I had to think about how the book would flow thematically. I feel as if I have a sense about how to structure a novel at this point, but putting this collection together was challenging. I am still changing the order of the stories–even as the book is about to be typeset. 


Do you think you will continue to write about Lola? 

I'm sure I will. I love her, and I can't wait to see how her life turns out. I hope she goes back to vet school. I had also written a scene in which she and Emmett are much older and get matching tattoos–I'd like to use that scene someday. 


Some of these stories went through a number of rounds of editing. How does that process work? How do you know when a story is finished? 

I always feel scared to say that a story is finished, I think. Honestly, I could keep working on all of these stories. But at some point, you do feel that a subtle balance has been achieved–the characters' actions feel true. But Anika and I worked on some of these stories through a dozen or more drafts. I would generally send her a story, and she would send detailed notes, or give me a call. Then I'd let her comments sit with me, and go back at the story. I always get very upset at this stage–hacking away at a story's foundations makes me feel that the whole thing will come crashing down. But Anika has edited all three of my novels, so I take solace when she tells me, "You were just as nervous with How to Be Lost." Each time, it feels like a new terror. Anyway, sometimes a day, sometimes a week, later I would send Anika a new draft. One thing I've learned through editing these stories is that sometimes Anika will say, "This ending isn't working," but I don't have to fix the ending. I have to fix, perhaps, the character's morning, or her job, or her husband ... the scenes leading up to the last scene. Sometimes the problem is where I least expect it. Anika might feel that the character's actions are not working, but sometimes it may not be the actions but the way I set them up. And there's never a simple answer. For example, in one draft of "Mother hood and Terrorism," the husband was named Anthony, and he was an investment banker. We went through numerous drafts before I realized that the female character was, in fact, Lola, and the husband was Emmett. So Anthony got sent to the graveyard. There's a big pile of discarded characters for this book. I think of them all in a serene graveyard, waiting to be exhumed. 


What was it like to have your first book in the world, to become a published author? 

When my first novel, Sleep Toward Heaven, was published, I had listened to a hundred readings, and had always thought about what it might feel like to be the one behind the podium ... I never thought I'd be wearing a maternity dress. The publication process was different from what I had expected, actually. I had thought so much about what the cover would look like, what it would be like to see the book on the shelf, but some steps surprised me. I had long phone calls with my agent, Michelle Tessler, and Anika–after having the characters live in my imagination for so long, it was an honor to have thoughtful talks about them, to have Anika and Michelle's perspective on who they were, and how they developed. I didn't realize how much I'd enjoy that. And then seeing my words typeset–that was really exciting. But even as I loved having my book in the world and giving readings, I ached to get back to writing. I can dress up and speak to a crowd–I love it, in fact–but I am most comfortable alone in my bathrobe, reading or writing. It's really strange to answer questions about the solitary process of writing. I don't really know how it all works–I'm still learning–and I feel I might jinx something. 


You mentioned Bill Kittredge's advice to "Move to where your best friend is and write your damn book." What advice do you give to aspiring writers? Is there anything you wish you had known, or done differently? 

I think you have to love the writing, and have faith that someday there will be an agent and an editor who get what you're trying to do, and who want to work with you. But it always comes back to the blank page, to a new morning in front of the computer screen. After a series of jobs that were somewhat related to publishing, I finally started working at jobs that didn't use the same part of my brain as my writing. I knew it might take years to get published (and it did take years ... ten years), so I wanted to enjoy myself in the meantime. I set up an office in my house, splurged on beautiful journals and a big bulletin board for mapping out story lines and tacking up stories from the New York Times that captured my interest. I tell students to take themselves, and their writing, seriously. I also read for hours every day. After years of trying to write for my professors or for my fellow students, I now aim to write a book that I want to read. 


How does your reading life affect your writing life? 

The other morning I woke up at about three a.m. I lay awake in the dark and wondered what the point of all my reading was. In the time I've spent lying around with books, I could have become a pediatrician–or a rocket scientist. And it's not that I like to talk about what I've read: For the most part, my reading is completely selfish. I leave books half unread, and I was kicked out of my book club for never getting around to that month's pick. I don't keep up my virtual bookshelf, and I lost the little leather notebook that I bought to jot down what I'd read. 

It's solitary, it's compulsive, it's expensive, and I tend to read a short story or novel and imagine that the fictional problems are my own, living half in Andre Dubus's character's sadness and half in my own life. But I can't stop. There are times that I think my reading and writing life are truer than my real life, the one I have to brush my teeth for. Sometimes it's hard to look closely at the fragile beauty that surrounds me. I'm scared that looking too closely will mess everything up. So I read, to re-wire my brain, to expand my sense of what is possible. So that morning, at three a.m., I picked up a short-story collection and began to read. I was hoping to find solace, to find inspiration, to find my way back to sleep. 


How do you think writing – and reading – short stories is different from writing or reading a novel? 

I guess if novels are like a long car ride, one in which you might see many glorious sights but might also run out of gas and be stuck in some strange town, short stories are like one perfect evening. There doesn't have to be a moment wasted: The moon is out, the wine is chilling, and the steaks are on the grill. A story can do anything–a gunshot can pop, a memory from long ago can alter a kiss, a cow can have a point of view. Of course, any of these events can occur in a novel, but they happen with baggage. If your main character gets shot, you have to write her through her ambulance ride and convalescence. Writing a short story, I feel freer. As a reader, a story's joys are manifold. I can read one before bed and still have time to mull it over before morning. When I begin reading a story, I never know if it will contain a lifetime (as many of Alice Munro's and Jhumpa Lahiri's stories do) or one defining moment. 

I think there is a kind of magic in the books that come to a reader. A few years ago, when I was experimenting with what a short story could do, I happened to open the New Yorker and find "A Primer for the Punctuation of Heart Disease" by Jonathan Safran Foer. When I was learning to be sincere, I was humbled by Lorrie Moore's "People Like That Are the Only People Here: Canonical Babbling in Peed Onk" and Jhumpa Lahiri's "A Temporary Matter." Helen Simpson inspired me to write about parenthood. And last week, a friend handed me Ben Fountain's Brief Encounters with Che Guevara, which is, in a word, stunning, and has inspired me to try to write about my time in Africa. 


What are you working on now? 

I'm working on a new novel. I'm still getting to know all the characters. There are two sisters with secrets from each other, there's a new mother drinking whiskey with an elderly woman. There's a murder, and a neighborhood trying to make sense of tragedy. I've been inspired by the recent work of Francine Prose, Ann Patchett, Jonathan Franzen, Roxanna Robinson, Wally Lamb, Stewart O'Nan, and Kate Atkinson. 


Would you share some of your favorite short story collections with us? 

I would love to. Here are some of my favorites, in the order that I happened to read them. 

  • The Short Stories of F. Scott Fitzgerald (I especially love "The Ice Palace.") 
  • The Watch by Rick Bass 
  • Where I'm Calling From by Raymond Carver 
  • The Collected Stories of Grace Paley 
  • The Collected Stories of Amy Hempel (I never stop thinking about the friendship in "The Cemetery Where Al Jolson Is Buried.") 
  • Rock Springs by Richard Ford 
  • Our Story Begins by Tobias Wolff (My favorite stories are "Say Yes" and "Deep Kiss.") 
  • Mary and O'Neill by Justin Cronin 
  • Selected Stories by Nadine Gordimer 
  • A Distant Episode: The Selected Stories by Paul Bowles 
  • CivilWarLand in Bad Decline by George Saunders (especially "Offloading for Mrs. Schwartz") 
  • Interesting Women by Andrea Lee (especially "The Birthday Present") 
  • Dusk and Other Stories by James Salter Emerald City by Jennifer Egan 
  • Interpreter of Maladies by Jhumpa Lahiri 
  • A Stranger in this World by Kevin Canty 
  • Birds of America by Lorrie Moore 
  • Drown by Junot Díaz 
  • Jesus' Son by Denis Johnson 
  • How It Was for Me by Andrew Sean Greer (also "The Islanders," which was published in the New Yorker and is so lovely I have to reread it every few months) 
  • Remote Feed by David Gilbert 
  • Sam the Cat and Other Stories by Matthew Klam 
  • Carried Away: A Selection of Stories by Alice Munro (and later, "Deep Holes") 
  • We Don't Live Here Anymore by Andre Dubus (I can't stop thinking about "Finding a Girl in America," the last novella.) 
  • The Bridegroom by Ha Jin (especially "After Cowboy Chicken Came to Town") 
  • The Collected Stories of Richard Yates (especially "Oh Joseph, I'm So Tired") 
  • Among the Missing by Dan Chaon 
  • Lucky Girls by Nell Freudenberger 
  • A Relative Stranger by Charles Baxter 
  • Getting a Life by Helen Simpson 
  • Female Trouble by Antonya Nelson (and later, "Shaun - trelle," published in the New Yorker
  • Say You're One of Them by Uwem Akpan 
  • Brief Encounters with Che Guevara by Ben Fountain (especially "Rêve Haitien") 

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 Amanda Eyre Ward at BookBrowse
The Same Sky jacket Love Stories in This Town 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 Amanda Eyre Ward but some maybe more relevant to you than others depending on which books by the author you have read and enjoyed. So look for the suggested read-alikes by title linked on the right.
How we choose readalikes

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

Believe those who are seeking the truth. Doubt those who find it.

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 01:42 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780321334996 ms 1.780321335E+012 ms 1 /root/website/app_server.cfm
672 ms 672 ms 1 /root/website/author_interviews/full/index.cfm
331 ms 331 ms 1 /root/website/app_layout.cfm
198 ms 198 ms 1 /root/website/author_interviews/full/dsp_main.cfm
150 ms 50 ms 3 /root/website/adsystem/adsystem_mod.cfm
142 ms 142 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
120 ms 120 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
109 ms 109 ms 1 /root/website/adzones/showcase_track.cfm
96 ms 96 ms 1 /root/website/app_globals.cfm
83 ms 42 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
72 ms 72 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
70 ms 23 ms 3 /root/website/site/blocks/membership_advantages.cfm
69 ms 23 ms 3 /root/website/queries/qry_get_member_account_types.cfm
68 ms 68 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
41 ms 41 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
34 ms 34 ms 1 /root/website/adzones/AdZone6.cfm
32 ms 32 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_active_obc.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/adzones/AdZone2.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_current_ezine.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
11 ms 11 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_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/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
674 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:42:14.014
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=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 13:42:15.015
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=7ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:42:15.015
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 13:42:15.015
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=10ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:42:15.015
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=14ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:42:15.015
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:42:15.015
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 13:42:15.015
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:42:15.015
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=5ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:42:15.015
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=10ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:42:15.015
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=15ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:42:15.015
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) = 1691

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

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=9ms, Records=2) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 13:42:15.015
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) = 1691
Parameter #2(CF_SQL_INTEGER) = 1691

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 13:42:15.015
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) = 1691

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=5ms, Records=15) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 13:42:15.015
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) = 1691

get_ads (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=31ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:42:15.015
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=7ms, Records=1) in /root/website/actions/udfs.cfm @ 13:42:15.015
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) = 3168

get_book_image (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/udfs.cfm @ 13:42:15.015
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) = 2250

get_member_account_types (Datasource=bookbrowse_com_new, Time=22ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:42:15.015
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=26ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:42:15.015
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) = 1881
Parameter #2(CF_SQL_INTEGER) = 1881
Parameter #3(CF_SQL_INTEGER) = 1881

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:42:15.015
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) = 1881

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=27ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:42:15.015
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) = 633
Parameter #2(CF_SQL_INTEGER) = 633
Parameter #3(CF_SQL_INTEGER) = 633

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:42:15.015
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) = 633

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

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

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

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

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

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

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=31ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:42:15.015
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 13:42:15.015
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=26ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:42:15.015
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=CFTOKEN=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61; CFID=4102302; 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%3D4102302%26CFTOKEN%23%3D83409aa70fe6693c%2D222EA4C4%2D08C5%2DE523%2D5B67C859391DFE61%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A42%3A14%27%7D%23hitcount%3D296%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A41%3A32%27%7D%23cftoken%3D83409aa70fe6693c%2D222EA4C4%2D08C5%2DE523%2D5B67C859391DFE61%23cfid%3D4102302%23; FREEACCESSCOUNT=0
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/1691/author/amanda-eyre-ward
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=4102302
cftoken=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
hitcount=303
lastvisit={ts '2026-06-01 13:42:15'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:41:32'}
urltoken=CFID=4102302&CFTOKEN=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
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#=4102302&CFTOKEN#=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61#lastvisit={ts '2026-06-01 13:42:14'}#hitcount=296#timecreated={ts '2026-06-01 13:41:32'}#cftoken=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61#cfid=4102302#
CFID=4102302
CFTOKEN=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
FREEACCESSCOUNT=0
Session Variables:
cfid=4102302
cftoken=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
sessionid=BOOKBROWSE_4102302_83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
urltoken=CFID=4102302&CFTOKEN=83409aa70fe6693c-222EA4C4-08C5-E523-5B67C859391DFE61
URL Parameters:
author=amanda-eyre-ward
author_number=1691
Debug Rendering Time: 115 ms