Lily King Interview, plus links to author biography, book summaries, excerpts and reviews

Lily King

Lily King

An interview with Lily King

Two interviews with Lily King about her life and works, and in particular her 2014 novel Euphoria, and Father of the Rain (2010)

Two interviews with Lily King about her life and works, and in particular her 2014 novel Euphoria, and Father of the Rain (2010)

A Conversation with Lily King about Euphoria, loosely inspired by the life of anthropologist Margaret Mead

Euphoria is loosely inspired by events in the life of Margaret Mead—what first struck you about this revolutionary anthropologist?
I loved that her personal life was even more radical than her anthropology, and that the two were completely entwined. She had many lovers, men and women, often at the same time, whether she was married or not. And she believed that our culture's lack of sexual freedom was the root of some of our most serious problems. She was always working out theories of anthropology through her relationships and theories about her relationships through anthropology. "The world is my field," she said. "It's all anthropology."

Why did you decide for the first time to deal with a historical premise for Euphoria?
I didn't mean to. In fact, I tried not to write it for a long time, because it was so far out of the realm of what I'd written before—or even what I like to read. But I started reading this biography of Margaret Mead, and I got to this part where she's working in Papua New Guinea with her second husband, and they meet another anthropologist, Gregory Bateson, and she falls madly in love with him. And for four months the three of them are way up the Sepik River, studying these headhunting tribes in the jungle, spiking malarial fevers, and struggling to cope with this wild, intense love triangle. It was impossible not to imagine writing a novel with some of those elements in it. But it took a great deal of research to work up the courage to try it.

Tell us about that research. Was there anything you intentionally chose not to research?
I read anything I could find about Mead, her husband Reo Fortune, and her next husband Gregory Bateson; about field work, Papua New Guinea, World War I in England, and World War II in the Pacific; about tropical animals, plants, and diseases; about anthropology, the 1920s and '30s, and British and Australian and American culture and language use of that era. But if you flip through my notebooks, you will see, beside all the facts, long starred notes about what could happen in a novel. Those were the notes that were most important in the end, the fictional ideas that the factual details triggered. I hate books that feel heavily researched, that rely on the reader finding the facts—and not the plot and characters and sentences—as fascinating as the writer obviously did. I throw those books across the room in a rage. So in the end, if I had to make a statistical analysis, I probably used .037 percent of my research. For a long time, for as long as my curiosity could bear it, I tried not to read much about what happened to them after they left the Sepik in the late spring of 1933.

Where was the line between fact and fiction for you? Was there a certain point when your imagination took over and these characters began to act and speak for themselves?
Yes. Page one. I really did believe, the whole time I was researching the book, that I would stay within the boundaries of what I knew happened between these three anthropologists during that four-month period. But the moment I had to enter their thoughts, create their dialogue, describe the boat they were on, they individuated themselves from their historical inspirations, and we were off on a very different journey. The one scene in the book that came specifically from Mead's memoir was cut by my editor. In her margin note she said they never would have behaved that way.

What did you learn as a writer from working on this book? Was there anything in your process that was especially surprising or enlightening for you?
I came across a quote by Jennifer Egan early in this process in which she says she needs to write what she thinks she cannot write, that she needs that challenge. That made me feel less alone. This was really the first book I've written that I didn't believe I was capable of writing. I mean, you always worry that you're not capable of finishing it or making it readable or interesting, but there was nothing in this book—1933, the jungle of Papua New Guinea, anthropology, male British narrator—that was familiar ground. I felt it had to be written—the story was so interesting to me—but I feared I did not have the right arrows in my quiver for it.

Euphoria is set in 1930s New Guinea, but the themes you deal with and the emotional struggles your characters face still deeply resonate today. What aspects of this story do you feel make it so universal?
I think humans will always struggle with the enormous question of how to be in the world. Anthropologists at the beginning of the twentieth century introduced the idea of scientifically comparing our culture—our social organization, our behavior, our most basic assumptions about right and wrong and masculinity and femininity—to those of other cultures. Margaret Mead was the first to write up a study like that for the general public, not other scientists, and those sorts of comparisons still make the headlines daily: THE HAPPIEST PEOPLE IN THE WORLD. TEN COUNTRIES WHERE PEOPLE LIVE THE LONGEST. THE MOST SEXUALLY SATISFIED COUNTRIES. Mead and my character Nell Stone, for example, studied the question of raising children, another issue that seems a perpetually hot topic in the media now, particularly in comparison to other cultures: Should you be a Tiger Mother or French maman?

Euphoria also deals with the age-old question of possession in all its forms. The book is set when Western corporations were just beginning their modern, full-scale depredation of the land and resources from undeveloped places like the island of New Guinea, which is obviously still going on today. The anthropologists of the time were aware of this and were frantically trying to observe and record the details of these societies before they were wiped out by Western need and greed. But they also mimicked a sort of colonization of their own, as they became highly possessive of their regions of study. An even smaller microcosm of this need for ownership is played out between the three anthropologists in my novel. And possession in love is a theme I don't believe will ever die.

* * *

A Conversation with Lily King about Father of the Rain Interviewed by Joshua Bodwell

What was the first book you remember reading as an adolescent that made a lasting impression on you?
In ninth or tenth grade I was assigned Winesburg, Ohio in English class and I fell deeply in love with the language and just the utter bizarreness of the characters' behaviors, all their secrets and thwarted passions. I remember having to write a paper on the "grotesque" in Winesburg, Ohio. And at the heart was George Willard, a writer struggling to break free from all these people in pain. I wouldn't have been able to identify with him at the time, but now I understand why I was so drawn to it. I read it over and over in high school.

When did you first start writing and what do you remember of that time?

One of my best friends in fifth grade, Amy Mix, told me one day that she was writing a novel. We had never had one creative writing assignment, ever, so the idea was a shock to me. I started my own novel that night. I only wrote twenty pages, and it had perhaps too many parallels to the Partridge Family (five kids, a painted bus), but it definitely lit the fuse for me. The funny thing is, years later, after college, I talked to Amy Mix on the phone, the first time I'd talked to her since eighth grade, and the first thing I asked her was if she was still writing. "Writing?" she asked, completely bewildered. I'd always assumed she'd become a writer, too.

When you began your new novel, Father of the Rain, what was the initial idea or image that got the story rolling?
I think it started with the puppy, a father buying his daughter a puppy that she wouldn't be able to keep because she knew, though he didn't, that she would be moving out of the house with her mother in a week. And her choice of the ugliest puppy, so that it wouldn't be even harder to leave. Once I got the puppy in the car, the rest of the first chapter came quickly: the mother with the group of city kids in the pool, the father scheming to sabotage the moment in some way, and the daughter trying to please them both at the same time, all the while carrying around this tremendous secret that her mother was about to leave the marriage.

Are you an extensive plotter or did this novel evolve organically as you wrote? 

I plot a little ahead. I write with a pencil in a lined notebook and in the back of every notebook I leave twenty blank pages for notes. So while I'm writing chapter one, I'll get ideas for chapter three and I'll take a few notes. And then when I have too many notes to see at once, I'll make a little time line. And sometimes I'll follow the timeline, and sometimes I'll toss it out and go in a different direction. I don't like to be too confined to and restricted by an outline. It can deaden the writing. But I do like a little hint of direction, something to be moving toward.

This makes me think of great E.L. Doctorow line: "Writing is like driving at night in the fog. You can only see as far as your headlights, but you can make the whole trip that way."
I can't believe you quoted that of all quotes. It has been my mantra for years and years. Actually, I misquoted it for years and years. Until recently I thought it was "driving cross-country at night." Not sure where I got that, but writing a novel to me does feel like driving from Boston to L.A. in the pitch black.

It's so common for readers to believe that novelists pull material from their own lives. You've published three novels that feature three complex female characters (two of them written in the first-person). Can you talk about how much material you harvested from personal experience for Father of the Rain and how much is pure fiction?
My mother recently quoted Padgett Powell as saying: "I take everything I know, then lie about it." I have searched the Internet and can't find this line anywhere, but I think it sums up the process pretty well. For me writing is like dreaming, elements from life come in but they are jumbled and distorted. It's the fictional possibilities that light everything on fire for me. When I try to write straight memoir, it feels dead. The only thing that's still alive is the emotion. So all my novels have a lot of emotional truth, emotions, but not necessarily situations, I have experienced, and in entirely different contexts. Though Father of the Rain begins in autobiographical territory for me—summer of 1974, small town Massachusetts, parents divorcing—it departs from my actual experiences pretty quickly, and by the end of the novel the trajectory that the narrator Daley's life has taken is very different from mine.

If one were forced to name a common thread between your three very different novels, they might point out your exploration of family. Why do you think that is?
I have a hard time staying away from the family drama. Whenever I write anything, even a short story that is not intended to be about family, a sibling or a parent always walks through the door.

Daley, the narrator of Father of the Rain, is not an only child even though at times it seems she is, and is usually much more emotionally mature than her older brother, Garvey. Why did you decide to not make Daley an only child?
It wasn't a decision, exactly. Garvey came in during the first chapter, but very faintly, very much in the background, but his presence became increasingly important to Daley and the book. I was really surprised myself by how vital he becomes by the end.

As you follow Daley's life, you make three significant time leaps in this novel in order to move her from adolescence to middle age. Can you talk about the way you crafted those sections, and also how you maintained Daley's voice and personality.
I love big leaps in time in novels. But I also know they can be disastrous to its cohesion.  I really tried hard not think of how badly it could go wrong and just tried to write from instinct without any sort of intellectualization of it. I didn't think about trying to maintain anything. I just wrote it the way I felt—not thought—Daley would be thinking in those different circumstances and stages of her life.   

The father in Father of the Rain, Gardiner, does many despicable things in the course of this novel—be it reading letters aloud from Penthouse magazine to his children, or the mix of mental and physical violence he commits on those around him—yet he never devolves into a caricature. How did you go about forming this character? Did you have to find a way to empathize with him in order to write him?
He was just there for me. I wasn't at all aware that I had empathized with him until my husband, my first reader, read it and found him endearing. It really shocked me. Endearing? I knew I was trying to depict as thoroughly as possible Daley's complicated feelings for her father, but I didn't realize that the reader would end up with those complicated feelings for him, too.

Do you think this reaction has anything to do with the complexity of alcoholism as an illness, not a choice?
Well, one of the things I've learned about alcoholism is that an active drinker who wants to keep his life as together as he can needs to be awfully charming and lovable in order for the people around him to tolerate the drinking. 

In The English Teacher you explored a complex mother/son relationship. With Father of the Rain, you have turned your attention to a father/daughter relationship. What caused you to turn your attention to father/daughter?
I guess I wasn't quite done with all the bad parenting possibilities! I am very interested in father/daughter relationships, and I don't think they get equal play in fiction. There are certainly a great many mother/daughter and father/son novels out there, and a good many mother/son ones, too. But not many father/daughter ones come to mind. Several years ago, I read a parenting book that claimed, with all sorts of studies to back up this claim, that women get their self-esteem almost solely through their relationship with their father. Given that our society, and our world, is still quite patriarchal, it makes sense that a man's opinion of you is what is going to matter more. Just a few days ago I found one of the first notes to myself that I ever wrote about this novel. There were possible scene ideas, and then at the bottom it said: "The way we were treated by our father is the way we expect the world to treat us." Father of the Rain is one woman's efforts to escape that fate.

You once told me that this novel came in fits and starts, but when it came, "it came in a torrent." Can you talk about that?
My first two novels came out at a fairly steady trickle, but this one was really erratic. I remember one month in particular, January of 2008. I wrote between 3 and 6 pages every day, which is a lot for me. It felt like it was pouring out of me. Then I woke up on the first of February and nothing. I had a sudden visceral aversion to my own novel. I couldn't go near it. I wrote short stories instead. I didn't write another word until May. There were a number of times like that. I think I got very sad writing parts of the book, and I'd have to stop so that I wouldn't be swallowed up by that sadness. 

Your novels have involved no shortage of difficult subject matters: giving up the child of an unplanned teenage pregnancy, rape, and alcoholism. When asked about the difficult subject matter of his writing, the short story writer Andre Dubus once said, "I think honest writers write about what bothers them." Do you agree?
What a great quote. I think it's very true. And so often what bothers you is stuff you really don't want to write about. But it comes in. It walks into your novel and you scream No! and tell those ideas to get out, but they don't listen.

Father of the Rain is set in a seaside New England town. Your previous novels have been set in France and on an island off the East Coast. How important is place in your fiction?
I love writing about a place, small towns in particular, and I had a really good time in this novel creating a town in Massachusetts quite similar to the one I grew up in, with the three-aisled grocery store and the carnival that came every summer, and then creating the characters' relationships to it. I think of the setting as another character. Some novels don't need that character, but I love reading books that do it well.

Who are some of the writers who have influenced you?
It begins with Judy Blume, then Anderson and Updike and Bellow, then Faulkner and Carver, then Virginia Woolf and Toni Morrison, then Marilyn Robinson, Alice Munro, Shirley Hazzard, Alice McDermott, and Rachel Cusk.

Can you take one of those writers and talk specifically about how their work has impacted you, and therefore your work?
I suppose Virginia Woolf has had the greatest impact on me. I discovered her late, in graduate school, and because of her and because of the work of my best friends there at school, Laura McNeal, who is a stunning writer, my writing took a dramatic turn. I had come to grad school writing sort of pithy, dialogue-driven short stories with very little attention to imagery or the beauty of sentences, but by the end of my two years there, I found I was much more interested in creating mood and texture, a sort of sensual experience. My first novel very much reflects that shift. While I was writing Father of the Rain I was aware of moving away from the lyrical sentence and found my writing was much more driven by dialogue again. I felt like I was leaving Woolf's influence and it made me feel sort of panicky, like where was I going if not in her direction anymore? I'd like to believe I am coming more into my own voice, though I am at a loss for how to describe it or exactly who has influenced it.  I think the truth is that it's the material itself that has the most influence on how I tell a story, not whom I have read or what I admire.  The voice is organic to the story itself.

How does your reading life affect your writing life?

Reading is essential to my writing.  It feeds it. I often take notes while I read, not notes on what I'm reading but on what the reading has sparked in my imagination, which is often entirely unrelated to the words on the page. I got the idea for my second novel while reading an essay by James Wood on Virginia Woolf. I think the note I took was: "novel set during hostage crisis '79-‘81?" When I am completely depleted, I often take a day or week off of writing and just read to replenish.

Some authors have claimed that they only read nonfiction—or don't read at all— while they are in the thick of writing a novel because they fear that another writer's voice will creep into theirs. Do you ever worry about that?
I hear that a lot. But I have to read fiction for inspiration, for a reason to go on. Nonfiction rarely gives me the thrill of fiction. And I don't feel like my voice is so fixed that it wouldn't be aided by a dose of great writing every day.

You once told me that given the option between writing and your daughters, you will "choose my children over my writing every time." Can you talk a little bit about navigating motherhood and authorhood?
Before my children were in school full-time it was a chronic struggle and confused me to no end. I had part-time childcare and was constantly reconfiguring the hours. I never felt like I had enough time to write, and yet I missed my children terribly in the hours that I did have. Then they went to school and the balance was righted.

Do you think stories are created or discovered?

I just read my eleven-year-old daughter this one, and she said, "That's an amazing question." I think they are created, but the good ones feel discovered.

Finally, if you could be any fictional character, who would you be?
Elizabeth Bennett. I admire her to no end.


Joshua Bodwell is a journalist and writer in Maine. His newspaper journalism has garnered awards from the Maine and New England press associations. He is a regular contributor to Poets & Writers Magazine, as well as the online journal Fiction Writers Review.  Joshua is a recipient of the Maine Community Foundation's Martin Dibner Fellowship for fiction. His short stories have appeared in many journals, including: The Threepenny Review, Ambit (London, England), Northern New England Review, Frank (Paris, France), and Tears in the Fence (Dorset, England).

Reproduced by permission of the publisher, Grove Atlantic

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 Lily King at BookBrowse
Five Tuesdays in Winter jacket Writers & Lovers jacket Euphoria jacket Father of the Rain 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 Lily King 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

  • Chris Bohjalian

    Chris Bohjalian

    Chris Bohjalian is the #1 New York Times bestselling author of twenty-five books, including The Jackal's Mistress, Midwives, Hour of the Witch, and The Flight Attendant, which was an Emmy-winning MAX series starring Kaley ... (more)

    If you enjoyed:
    Father of the Rain

    Try:
    Midwives
    by Chris Bohjalian

  • Claire Cameron

    Claire Cameron

    Claire Cameron's novel, The Bear, became a #1 national bestseller in Canada and was long-listed for the 2014 Baileys Women's Prize for Fiction. Cameron's writing has appeared in the New York Times, the Globe & Mail, the ... (more)

    If you enjoyed:
    Euphoria

    Try:
    The Last Neanderthal
    by Claire Cameron

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

Poetry is like fish: if it's fresh, it's good; if it's stale, it's bad; and if you're not certain, try it on the ...

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 02:53 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
1780282393338 ms 1.78028239334E+012 ms 1 /root/website/app_server.cfm
653 ms 653 ms 1 /root/website/author_interviews/full/index.cfm
219 ms 219 ms 1 /root/website/author_interviews/full/dsp_main.cfm
201 ms 201 ms 1 /root/website/app_layout.cfm
157 ms 157 ms 1 /root/website/app_globals.cfm
99 ms 99 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
88 ms 29 ms 3 /root/website/adsystem/adsystem_mod.cfm
60 ms 60 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
54 ms 27 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
48 ms 48 ms 1 /root/website/adzones/showcase_track.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_active_obc.cfm
39 ms 13 ms 3 /root/website/site/blocks/membership_advantages.cfm
38 ms 38 ms 1 /root/website/adzones/AdZone6.cfm
38 ms 13 ms 3 /root/website/queries/qry_get_member_account_types.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_current_competition.cfm
31 ms 31 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
21 ms 21 ms 1 /root/website/site/blocks/layout/head.cfm
20 ms 20 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
18 ms 5 ms 4 /root/website/actions/act_spider_tracker.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
16 ms 16 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/act_check_login.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_member_info.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_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_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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
655 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 02:53:13.013
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=10ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:53:13.013
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=15ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:53:13.013
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 @ 02:53:13.013
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=22ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:53:13.013
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=19ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:53:13.013
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=15ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:53:13.013
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 @ 02:53:13.013
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=12ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:53:13.013
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=12ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:53:13.013
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=16ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:53:13.013
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=4) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:53:13.013
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) = 1201

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:53:13.013
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) = 1201

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=5) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 02:53:13.013
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) = 1201
Parameter #2(CF_SQL_INTEGER) = 1201

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 02:53:13.013
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) = 1201

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=4ms, Records=22) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 02:53:13.013
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) = 1201

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:13.013
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=12ms, Records=1) in /root/website/actions/udfs.cfm @ 02:53:13.013
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) = 4367

get_book_image (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/actions/udfs.cfm @ 02:53:13.013
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) = 3080

get_book_image (Datasource=bookbrowse_com_new, Time=61ms, Records=1) in /root/website/actions/udfs.cfm @ 02:53:13.013
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) = 2449

get_member_account_types (Datasource=bookbrowse_com_new, Time=19ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:13.013
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=19ms, Records=6) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:13.013
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) = 183
Parameter #2(CF_SQL_INTEGER) = 183
Parameter #3(CF_SQL_INTEGER) = 183

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:13.013
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) = 183

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:13.013
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) = 2954
Parameter #2(CF_SQL_INTEGER) = 2954
Parameter #3(CF_SQL_INTEGER) = 2954

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:13.013
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) = 2954

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:13.013
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:53:13.013
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=16ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:53:13.013
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=22ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:53:13.013
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 @ 02:53:13.013
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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 @ 02:53:13.013
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:13.013
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%3D4083040%26CFTOKEN%23%3D5c7ab8809ad80942%2D0AFDC8BD%2DA7AB%2D91C8%2DA45DE6BE4747E9A1%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2002%3A53%3A13%27%7D%23hitcount%3D44%23timecreated%3D%7Bts%20%272026%2D06%2D01%2002%3A53%3A04%27%7D%23cftoken%3D9aa61cc6332995c1%2D0AFDB632%2DD4D4%2D3B42%2D632BF6CA9BC2C822%23cfid%3D4083035%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1; CFID=4083040
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/1201/lily-king
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=4083035
cftoken=9aa61cc6332995c1-0AFDB632-D4D4-3B42-632BF6CA9BC2C822
hitcount=48
lastvisit={ts '2026-06-01 02:53:13'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 02:53:04'}
urltoken=CFID=4083040&CFTOKEN=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1
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#=4083040&CFTOKEN#=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1#lastvisit={ts '2026-06-01 02:53:13'}#hitcount=44#timecreated={ts '2026-06-01 02:53:04'}#cftoken=9aa61cc6332995c1-0AFDB632-D4D4-3B42-632BF6CA9BC2C822#cfid=4083035#
CFID=4083040
CFTOKEN=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1
Session Variables:
cfid=4083040
cftoken=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1
sessionid=BOOKBROWSE_4083040_5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1
urltoken=CFID=4083040&CFTOKEN=5c7ab8809ad80942-0AFDC8BD-A7AB-91C8-A45DE6BE4747E9A1
URL Parameters:
author_number=1201
lily-king=
Debug Rendering Time: 64 ms