Haven Kimmel Interview, plus links to author biography, book summaries, excerpts and reviews

Haven Kimmel

Haven Kimmel

An interview with Haven Kimmel

Haven Kimmel discusses life, poetry, Jane Austen - and her family and friends as portrayed in A Girl Named Zippy.

[A hand reaches out and depresses a knob on a little blue tape recorder. Someone says "glamorous park bench." Tapping sound. Throat clearing.]

Hello, and welcome to Interview. Let's just go straight to our guest, author Haven Kimmel, and have her answer a few questions about her book, A Girl Named Zippy.

You had some unusual experiences in the beginning of your life--a near fatal staph infection, baldness until almost three, and, most memorably, your first words at three years old: "I'll make a deal with you." How did this unusual start affect your life?


I'm of the opinion (I share this with some contemporary literary theorists, I think) that the word "text" is both broad and deep metaphorically, and thus we can, without much shame or sense of personal responsibility, litter our conversation with it. So let's say an individual life is a text; in A Girl Named Zippy I simply read my life backwards. The person I am now is essentially that weird little mute bald girl, only taller. And with hair, obviously. James Hillman, in his book The Soul's Code, proposes the "acorn theory" of psychological development. Everything in my book is revelatory of my acorn. If I may say such a thing.

You describe the career aspirations of your friends--Rose the artist and Maggie the "Solid Gold" disc jockey--and your own fluctuations between the Mafia and co-owning a farm with your best friend Julie. At what point did you realize you wanted to write?

Oh, I never wanted to be a writer. My only real dream was to be a rodeo star. Wait, that's not true. There was a time I thought I'd make a good prison guard, and my sister agreed with me. I remember that the first time I heard the phrase "legislate morality" I thought that was probably for me, and so I announced to the world at large that I was going to be a Supreme Court justice. I had some ideas about what was moral, and they didn't seem to be in keeping with the rest of the world. Finding a way to inflict my values on the innocent greatly appealed to me. However, I was never able to fulfill any of my career goals because I am essentially free of talent.

I started writing at age nine--automatically and without intention--like a savant; much the same way, I imagine, Rain Man couldn't help himself from counting jelly beans and match sticks. When I say I started "writing," what I mean is that I copied Ray Bradbury's stories out of Twice-22 onto my own paper and then showed them to my mom, declaring them my own. It is, perhaps, rare for a person to be both a savant and a plagiarist, I don't know. My mom was very supportive (some might even say enabling) of those efforts, and of other examples of my creativity, such as the way I liked to recite whole episodes of The Beverly Hillbillies, lying, each time, about the ending. Sometimes the Hillbillies all died in a plane crash, sometimes they were mauled by rabid possums. That sort of thing.

The turning point for me, the place I parted from Mr. Bradbury, was the moment I looked at a story of his--let's say it contained a little girl doing little girl things--and as I was copying it I decided that the story could greatly benefit from an explosion out of the girl's nose. Perhaps it was a special gift of hers. I'd veer away from the plot I was copying in order to accommodate the nose eruptions, and soon I wouldn't be looking at Twice-22 at all. Eventually I stopped copying and just began inventing and then things really got ugly.

One of my favorite sections in the book described your agitation over the power of poetry, particularly the famous repeating line of Frost's "Stopping by Woods on a Snowy Evening," which everyone has wrestled with at some point. Did you ever reconcile with poetry? Or even perhaps become inspired by it? Who are some of your literary inspirations?

I would say, with only a slight measure of hysteria and hyperbole, that by the time I was twenty-one I had given my life over to Poetry. (This prose thing I'm doing is really an act of infidelity and I'm terrified Poetry will find out.) I wrote poems exclusively and with great seriousness for at least fifteen years, but as with all those other vocations, I wasn't good enough. The level of my talent was egregiously distant from my aspirations. I wanted to write as well as John Donne, Emily Dickinson, Rilke, Elizabeth Bishop. (Elizabeth Bishop once said to Robert Lowell, "When you write my epitaph, you must say I was the loneliest person who ever lived." That's a perfect epitaph for a poet, as opposed to mine, which would be: "She was ridiculous.") There are some contemporary poets who are so good I don't think I would be able to sit in the same room with them without hyperventilating. I'm thinking specifically of Geoffrey Hill, Louise Glück, Kay Ryan, Denis Johnson, and most especially, the brilliant Gjertrude Schnackenberg, who is not only maybe the best poet alive, but has a first name that begins "Gj."

I know you studied creative writing in college. Did you draw upon your wealth of childhood experiences? How did this book get its start?

I didn't write much about my childhood when I was in college because I was a poet and too cool for that.

The first essay I attempted to write was about Edythe Koontz, the old woman who lived across the street from my house and who hated me for inexplicable reasons. I started the essay in the autumn, twelve or thirteen years ago, and did it secretly. I didn't even really let myself catch on that I was doing work that wasn't poetry. Something about that particular season caused me to remember Edythe, and I found that there was something about her I very much wanted to say. She had recently died and had left no family, so I began by writing down everything I knew about her. What I discovered was that what remained the most vivid about Edythe for me were the things my parents repeated to me, the details about her behavior and personal habits that my mother and father had sorted out from the infinite details that make up a real life. I had heard my mom say countless times in conversations with people not from Mooreland, "Edythe walked to the post office every morning at seven, where she would salute the flag while whistling 'The Star-Spangled Banner.'" It's a small detail (just one of Edythe's eccentricities) but brilliantly precise. Added to the other things my parents had recorded--the way Edythe bathed only twice or so a year; the way she played hymns on her discordant piano late in the night; her bathtub full of old newspapers--the little picture of Edythe whistling at the flag became more resonant. I began the essay and it went disastrously wrong; there was, in fact, nothing right about it, it stunk to high heaven, and I put it aside.

Over the next few years I worked on the essay sporadically. Sometimes at night I told stories about Mooreland into a small tape recorder, just so I wouldn't forget them. As I was telling them I tried to remember the facets my parents considered the most cogent, and built from there.

Years after first writing about Edythe, I took a writing class while in seminary at the Earlham School of Religion. The professor, Tom Mullen, made as the course requirement that we all begin a book-length project. I began the manuscript for what I would later call Qualities of Light (and which is now titled A Girl Named Zippy) in that course, completing about fifty pages. When I left seminary and moved to North Carolina I put it aside for three years, during which time I became pregnant, had my son, Obadiah, and spent a year exclusively with him. After his first birthday, when it became clear that mothering would not, strictly speaking, be enough of an occupation for me, I started writing in the evenings, after Obadiah went to bed. I decided to look over those essays I had written for Tom at Earlham. None of them made it into the finished book (because they were lousy), but some events were recycled.

Jane Austen famously said that "3 or 4 Families in a Country village is the very thing to work on." You grew up in Mooreland, a small town in Indiana; in fact, the book begins with a description of the strange mathematic principle that maintains the town's population of 300. Why do you think that small towns are particularly rich in material?

Just for a moment I'd like to savor the fact that a question posed to me contains the words "Jane Austen." Also I'd like to consider the Austen-village in relation to Mooreland. Oh, dear.

The simple answer, I think, is that in a small town more can be known about people and events. I lived in Mooreland for sixteen years, in the same house on the same corner, so I enjoyed a certain continuity (in terms of information), as did my friends and neighbors. In some ways my own continuity was multiplied by that of other townspeople, so that when I talk to the woman who is still my best friend (I call her "Rose" in the book) her history is as available to me as my own. Rose's story is not in any way the subject of the book, but informs it. I once heard Vanessa Redgrave say in an interview that she prepares for a part by deciding what her character carries in her purse. The contents of the purse are never revealed to the audience, but they are integral to the way Redgrave understands herself in the role. There's a famous story (maybe anecdotal) about a stage production for which an entire kitchen was built off-stage in order that the audience would hear a tea-kettle whistle. There are limits, obviously, to the depths to which realism can be provocative, but I know what a lot of people in Mooreland were carrying in their pockets, their wallets, their purses when I was growing up. In writing Zippy I didn't need to make an itemized list; I just needed to stand, in memory, where I really stood and say what I saw and heard.

Why do you think the memoir has become such a popular genre for both writers and readers?

It seems to me that, ultimately, the study of history is our attempt to find out how we are to live. Things are going very badly for a lot of people--economically, spiritually, phenomenologically (by which I mean that as a species we seem to suffer from the grief of temporality without evolving from that suffering)--and others seem to have inherited more than their fare share of grace. Memoir is flat out interesting, on the one hand, and at another level it can be a tangible, artistic reckoning with this most basic question, the question of how we are to live, a reckoning and a sort of comfort. I'm thinking specifically of a memoir published in the last year, Barbara Robinette Moss's Change Me Into Zeus's Daughter. There was so much in that book I treasured (courage, beauty, delicacy), but the most amazing thing to me was the way Moss revealed events in her life that were so odd and so idiosyncratic--in some cases so extreme--that few people, I'm guessing, would recognize or understand their content. But again and again I thought of my own sister, Melinda, and the way Melinda and Barbara Moss seem to share a certain posture in relation to life, and I knew immediately that the book would be a comfort to Melinda. I sent her a copy and by the time she finished it she was a little speechless (very unusual for her, I must say). When she called me to talk about it, I said, "Who knew?" Memoir is the voice of our common humanity, even in the most uncommon lives.

I also have the impulse to say, as many people are currently saying, that memoir is so popular among readers because as a culture we are unrepentant and unreconstructed voyeurs, and that as writers we love it because we're lazy and narcissistic. It does seem that as the genre du jour, memoir reveals the best and the worst in our nature as consumers of literature.

Something that distinguishes your book from other memoirs is the narrative voice. Whereas many authors look back at their childhoods from an adult point of view, you maintain the viewpoint of your younger self, giving weight to situations that many adults would otherwise bypass and vice versa. Did you make a conscious choice to stick with this voice?

There is no single element in Zippy I worked on harder, longer, or with more conscious deliberation than the voice. And, as you've noticed, the voice dictated the content. I once heard Robert Morgan say that the voice of a child is the hardest to get right, because one must be accurate and convincing, which demands a kind of ignorance, but the adult intelligence has to be the guiding principle. It's a tough mix to produce consistently.

Have your family and friends from Mooreland read the book? What do they think?

I think that most of the people who appear as characters in the book couldn't love it more. My sister owns a diner called The Blue Moon just outside of Mooreland, and she has the book cover framed and hanging on the wall there. I feel certain that as the book produces more artifacts Melinda will eventually put together a little shrine. My mom is the same: just unabashedly supportive and delighted. My favorite reaction, though, came from my old friend Andy Hicks, who is featured in the essay, "Favors For Friends." I gave him the book in manuscript, and he and most of his family read it. He sent me a letter and said they all wept when they finished it, because they realized that someone had actually seen them; their family had meant something to someone else. That feeling of having been seen is so important to us all, I think, but consistently a surprise.

I agree. The way that you "see" each character shows that you clearly have a deep bond with all of them; even evil Edythe and Petey Scroggs get no less a loving treatment than, say, Andy and Julie and their families. Related to that, I loved the inclusion of photographs. It made the memoir more of a family album experience than just a regular book reading.

The photographs in the book were the idea of my fabulous editor, Amy Scheibe, and I owe their inclusion to Doubleday's generosity. I love how they look, and the way they complement the stories. I also had a great time locating them. My sister and mom and I spent hours going through the defunct ammunition box in which family photographs are stored. I am too limited a writer to describe our reaction upon finding the photograph of Edythe, for instance (none of us knew any pictures of her existed), but suffice it to say our response was some combination of glee, pity, and terror.

Are you working on anything now?

I'm always working. I write like a fiend. My work ethic as a writer is a direct outgrowth of the knowledge I'm virtually unemployable in every other field.

In addition to Zippy, Doubleday has purchased my first novel, which is titled (so far) The Solace of Leaving Early, the first book in a projected trilogy. Solace is scheduled to be released in February, 2002. My impression is that having two books released within a year of one another qualifies, within the classical definition, as an "invasion." I'm working on the second book in the series now. And Houghton Mifflin has picked up a children's book, which should be out in two years or so.

And, finally, does anyone still call you "Zippy"?

I have the feeling that over the next few months, everyone will call me Zippy.

Well, I guess we'll sign off. That's all for Interview. Good night, folks.

[Static, a giggle, some crunching sounds, and then tape is shut off. They weren't really sitting on a park bench. But that doesn't make it any less glamorous.]

Interview by Kelley Kawano, 2001.  First published in Bold Type.  Reproduced by permission of Random House publishing.

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 Haven Kimmel at BookBrowse
Iodine jacket The Used World jacket She Got up off the Couch jacket A Girl Named Zippy 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 Haven Kimmel 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 11 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...

Life is the garment we continually alter, but which never seems to fit.

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 12:53 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
1780318428452 ms 1.78031842845E+012 ms 1 /root/website/app_server.cfm
236 ms 236 ms 1 top level /root/website/author_interviews/full/index.cfm
84 ms 84 ms 1 /root/website/app_layout.cfm
81 ms 81 ms 1 /root/website/author_interviews/full/dsp_main.cfm
58 ms 29 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
58 ms 58 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
41 ms 14 ms 3 /root/website/adsystem/adsystem_mod.cfm
36 ms 36 ms 1 /root/website/app_globals.cfm
33 ms 33 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
32 ms 32 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
20 ms 20 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
19 ms 19 ms 1 /root/website/adzones/showcase_track.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
14 ms 14 ms 1 /root/website/adzones/AdZone6.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_active_obc.cfm
10 ms 3 ms 3 /root/website/site/blocks/membership_advantages.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
8 ms 8 ms 1 /root/website/adzones/AdZone2.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
7 ms 2 ms 3 /root/website/queries/qry_get_member_account_types.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
5 ms 5 ms 1 /root/website/actions/adstatus.cfm
4 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/act_check_login.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_competition.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_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/dsp_bottom_block.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
237 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

adactive (Datasource=bookbrowse_com_new, Time=5ms, Records=2) in /root/website/actions/adstatus.cfm @ 12:53:48.048
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 @ 12:53:48.048
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=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 12:53:48.048
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 12:53:48.048
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=0ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 12:53:48.048
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 @ 12:53:48.048
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=2ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 12:53:48.048
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=3ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 12:53:48.048
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=4ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 12:53:48.048
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=1ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 12:53:48.048
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) = 586

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 12:53:48.048
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) = 586

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=1ms, Records=4) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 12:53:48.048
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) = 586
Parameter #2(CF_SQL_INTEGER) = 586

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=5ms, Records=3) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 12:53:48.048
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) = 586

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=7ms, Records=11) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 12:53:48.048
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) = 586

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 12:53:48.048
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=13ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 12:53:48.048
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) = 924
Parameter #2(CF_SQL_INTEGER) = 924
Parameter #3(CF_SQL_INTEGER) = 924

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=5) in /root/website/queries/qry_get_books_by_author_id.cfm @ 12:53:48.048
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) = 84
Parameter #2(CF_SQL_INTEGER) = 84
Parameter #3(CF_SQL_INTEGER) = 84

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 12:53:48.048
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=10ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 12:53:48.048
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 @ 12:53:48.048
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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:53:48.048
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:53:48.048
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 @ 12:53:48.048
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=7ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 12:53:48.048
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 @ 12:53:48.048
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:53:48.048
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:53:48.048
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 @ 12:53:48.048
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=FREEACCESSCOUNT=1; CFTOKEN=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714; CFID=4100927; 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%3D4100927%26CFTOKEN%23%3Ddd3463667dba0136%2D20786A90%2DD8D8%2D892C%2DB60AA63F5938C714%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2012%3A53%3A48%27%7D%23hitcount%3D57%23timecreated%3D%7Bts%20%272026%2D06%2D01%2012%3A53%3A40%27%7D%23cftoken%3Ddd3463667dba0136%2D20786A90%2DD8D8%2D892C%2DB60AA63F5938C714%23cfid%3D4100927%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/586/haven-kimmel
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=4100927
cftoken=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
hitcount=59
lastvisit={ts '2026-06-01 12:53:48'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 12:53:40'}
urltoken=CFID=4100927&CFTOKEN=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
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#=4100927&CFTOKEN#=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714#lastvisit={ts '2026-06-01 12:53:48'}#hitcount=57#timecreated={ts '2026-06-01 12:53:40'}#cftoken=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714#cfid=4100927#
CFID=4100927
CFTOKEN=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
FREEACCESSCOUNT=1
Session Variables:
cfid=4100927
cftoken=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
sessionid=BOOKBROWSE_4100927_dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
urltoken=CFID=4100927&CFTOKEN=dd3463667dba0136-20786A90-D8D8-892C-B60AA63F5938C714
URL Parameters:
author_number=586
haven-kimmel=
Debug Rendering Time: 19 ms