Erica Bauermeister Interview, plus links to author biography, book summaries, excerpts and reviews

Erica Bauermeister
Photo courtesy of Author

Erica Bauermeister

An interview with Erica Bauermeister

Erica Bauermeister talks about her first novel, The School of Essential Ingredients, romantic meals on cold nights, the satisfaction of buying locally grown foods and much more.

When did you decide to be a writer? Was it your dream since you were a child, or did it happen 'by accident'? What made you feel you were ready to write?

I have always loved books and reading, and I wanted to be a writer from the time I was small.  I read constantly and studied literature in college, and then graduate school.  I taught literature, I wrote reader's guides to books (which meant I read thousands of books to select a far smaller number).  All of that taught me a great deal about the beautiful machines that are books – their parts, the connections between them, the stroke of magic or imagination that brings them alive.

I think the reason I waited until I was 43 to start writing fiction, however, was that I knew from the time I was in college the kind of book I wanted to write – and that I wasn't mature enough to write it yet.  I wanted to write books about the small, "unimportant" things in life – the ways we interact with each other as parents and friends and lovers and spouses, those subtle moments of miscommunication and grace – and I knew it took a lot of life experience to see those things with a perspective that could take those small moments and make them universal.  I was beginning to think I would never be grown up enough to write what I wanted to write – but finally, I was.

How did you end up in Italy?

Moving to Italy was one of those "growing up" experiences that helped me to be a writer – honestly, I don't know if I would have written fiction if we hadn't lived there.  We relocated for two years because of my husband's job, and I simply fell in love with the country and culture. Still to this day, when I return to Italy I am happy in a way I am nowhere else.  It was not just the food or the sensuality of the language or the kindness I saw among family members – although certainly all those things were eye-opening for me.

What major cultural differences struck you when you were there?

 I think the thing that struck me most was the feeling that the people around me were taking on only as much as they could truly take care of  – the farms we saw, the houses, the families.  People took care of what they had and they didn't overextend just to prove they were important.  As a result, there was a peacefulness and beauty there that I find missing in the United States.

Tell us a bit about your agent: when did you find her and how?

Finding my agent was a very serendipitous experience.  I just happened to be invited to dinner with an author who is very well-connected in New York (although I didn't know that at the time). She heard about the idea for The School of Essential Ingredients and said she knew exactly whom I should send it to.  With her help, the manuscript got in front of the eyes of a wonderful agent.  I know so many incredible authors who have tried for years to get representation, and I know how lucky I was. So when aspiring writers ask me what they should do, I tell them "say yes to everything" - every conference where you will meet authors and agents, every opportunity to meet other people in your field. You never know who will end up opening a door for you.

What do you think of self-publishing and the ebook revolution.

I am a complete addict of the real thing - I love the textures of a book in my hands; I need to feel when the end of a book is coming by the shifting weight of the pages in my hands. So for me, an ebook will never replace a real book. That said, I think anything that gets people reading is wonderful. I talk with people who say "my mother is reading for the first time in years because with an ebook she can make the type large enough to see" or "my son finally loves books." I think that is great. I also think it's wonderful that authors who can't or don't want to go through the traditional publishing route can see their work in print.  

But we need to be very, very careful not to lose the independent bookstores in the process. They are the curators of interesting books that will change your life, and the lifeblood of the books that aren't blockbusters - without those stores we would be reduced to reading the same ten books that you see on the tables at the big box stores and on-line. Especially with the overwhelming influx of books that will occur with self-publishing, small bookstores are more important than ever and we have to make a concerted effort to support them.

Nowadays most writers need to self-promote themselves online, even those who have signed with a reputable publisher. How much of your time do you dedicate to social media and blogging?

When someone tells me they want to be a writer, my first question always is "do you want to write, or do you want to be a writer?" because those are two different things. Both are wonderful, but in today's book world, they require different qualities.  To be a writer these days means to spend roughly half your professional time NOT writing books.  You are blogging, traveling, meeting readers, tweeting, doing Facebook posts and interviews, talking with book clubs.  You have to like talking to people, in groups and individually.  And if you're going to be successful, you have to be good at it – you can't just get up at a podium and mumble your way through 3 chapters of your book.  It's a very tough climate out there and publishers will expect you to have a marketing platform.

Do you feel like it slows your writing down, would you prefer to concentrate on the writing alone, or do you really enjoy keeping in touch with your readers?

I'm lucky because I have two parts to my personality – the quiet, reclusive part that loves nothing better than to spend a week in total silence with my characters, and a more public part that enjoys interacting with readers.  For me, the two balance each other out and keep me sane. Too much writing alone and I go a little stir-crazy. Too much promotion and I lose track of the intricate beauty of the written word.  So, it really helps to have a healthy sense of perspective and balance - something I am learning over time.

This interview was first published in lostfiction.co.uk by Lucy Hannau in November 2011, and is reproduced with permission of Lost in Fiction UK. all rights reserved.

A Conversation with Erica Bauermeister about her first novel, The School of Essential Ingredients

What led you to write this book?

In 1999, my family had just returned to Seattle after spending two years in northern Italy. I found that I missed the food and being around people who celebrated even the most simple meals. So, I took a cooking class. The first night, we killed crabs. I'm the kind of person who takes spiders outside when I find them in my house and it was a deeply unsettling experience. I had an image of a young mother, Claire, and I began wondering what effect it might have on her to kill something. In the end, her story wasn't at all what I expected. And then I started thinking about all the different characters you could have in a class, and started wondering which foods would affect each one – revive a memory, create an epiphany, change the direction of a life – and that's where the book came from.


How are food and cooking connected to the way we live our whole lives, not just the time we spend in the kitchen or at the table?

The act of cooking provides us with an opportunity to slow down, to focus on our senses rather than the speed of our world. I think we all want that, miss that, in our everyday lives. The people I know who pay attention to those things simply seem to be happier and more fulfilled, in the kitchen and out of it.

My children were incredibly lucky, in that they were 7 and 10 when we moved to Italy and they learned that lesson early. They are both dedicated foodies and truly creative cooks. My son just went to college and he inherited my college blender. The funny thing is, he took it because he wanted to be able to make pesto – a far cry from the margaritas and protein shakes it made in the early 1980s.


What are some of your favorite dishes to make and to eat?

I have been a cookie-maker since I was seven years old, and I love what the smell of baking cookies does to a household. I am also a big fan of any dish that requires chopping or stirring or simmering, particularly if my day has been frantic and I want it all to slow down. Making risotto is one of the most comforting activities I can imagine, just standing at the stove, adding chicken broth a bit at a time, while people sit around the kitchen table and talk.


If you were to make a romantic meal for a cold winter night, what would it be?

My favorite dish is a ragu sauce with Italian sausage and hamburger, crushed tomatoes, onions, carrots, red pepper flakes and white wine. Simple – and the white wine is a surprise every time. If you are cooking it for someone before they arrive, the smell that greets him or her when you open the door is amazing, so full of love. And if you are making it with someone, it can be all about trading tasks and doing the whole kitchen ballet, which can be utterly sensual.

But actually, the most romantic dinner I ever had was in college, when my not-yet-husband took me to Griffith Park in Los Angeles and made fondue over a pot of sterno (and yes, that part of the book is a wink in his direction).


Do you believe in recipes, or is it enough just to know food and fundamental techniques?

I think cooking is a language, and like all languages, it's easiest to learn early, although I am proof that that it is possible to learn later in life. The women I met in Italy all had learned cooking as children from their mothers. They approached ingredients as parts of a conversation; they knew how each ingredient talked to the others and they didn't want a recipe to tell them how much of one thing or another to add. They simply listened to the food. And while I think that recipes can be very helpful – particularly in baking, where amounts need to be fairly specific – I think that if we pay too much attention to recipes we can lose track of our relationship with the ingredients.

If I am making a dish I have no experience with, I love to go on the internet and find six different recipes for it. I particularly like Epicurious.com, where people comment on how they have altered the recipes. I take note of the ingredients, think about which ones sound intriguing, what I might add or subtract, and then I play.


There's been a movement in recent years toward using local and organic food. Where do you shop for this kind of food near your home in Seattle? Where should people look for the best and least expensive local and organic produce in their own areas?

I think there is nothing more inspiring for a cook than a farmer's market, and we're lucky in Seattle to have many of them. I love walking along the stalls at the end of summer and stopping to eat a sample slice of peach that just stops you with its sweetness, makes you wonder why all life can't be that astonishingly full. I am also an advocate of the organic-food companies and the local farms that will deliver a box of produce to you on a weekly basis. You never quite know what you are going to get, only that it is going to be fresh and organic – which I think brings out a lot of creativity in cooks.


You had two good friends who died of cancer as you wrote this book. Also, your father died of a neurological disease. How did these experiences influence your story?

In 2006, two dear friends of mine were dying, and my father was failing from a disease related to Parkinson's. There is a circle that surrounds people who are dying, and to be inside that circle is a beautiful and horrible honor – as the saying goes, there is no time for superficiality. My friend Karin asked to read something I had written and I gave her a manuscript for another project I was working on. One day we went out to lunch after her treatment and she looked at me, all beautiful and turbaned and said, "I think you should write something more from your heart."


After years of illness, within the space of four months, Karin, Heidi, and my father all died.

I turned to the cooking stories, which I had worked on for years but had never finished a single one, and I wrote. I finished Tom's story first. Neither Karin nor Heidi are Charlie, Tom's wife in the book who dies of cancer. I had written most of Tom's story years before either Heidi or Karin were diagnosed, an irony that doesn't escape me. But the end of Tom's story became a place to put the pain of losing them. And being able to finish that story was a gift – because after I knew I could finish one story, the rest fell into place. So in many ways, this is Karin and Heidi's book.

It is also my father's book. I grew up with a brilliant man, an engineer and musician who loved me but rarely knew how to show it. The irony of my father's illness was that it included a dementia that made him, little by little, less able to use his astonishing mind and he began to live more from his heart. I learned a lot about dignity and empathy and forgiveness being with my father as he slid into death, and in the process it profoundly changed the book I was writing.


This is your first novel, although you've written other books about literature. How was the process of writing fiction different for you?

I remember once speaking with an author who had made a comment about her characters in her presentation – how they talked to her and told her what to do, etc. I was skeptical, and said so. I declared that no characters had ever talked to me. She just looked at me and smiled this small smile and said "maybe you aren't listening."

So I decided to listen. Carl was the first character who appeared in my imagination, a man whose wife has had an affair, but who doesn't want to end his marriage. He was such a wonderful man and I wanted to do him justice; I wanted people to realize that his decision to stay in his marriage was something complicated and loving, rather than a lack of will. It wasn't until six months later that I had a dream about his wife, and I realized that she had actually been planning on leaving him when she sat down at that kitchen table, but had changed her mind at  the last moment – and that that decision, too, was complicated and loving, and gave their story a complexity I didn't know it had until then.

Writing Helen's story made me realize how powerful the concept of interconnected stories can be, allowing the reader to delve deeply into each character, and to be, in the end, the only person who truly knows all the connections between them.


Are you surprised that your first novel has become a major title for a big publisher? How did you go about getting it published?

Absolutely. Stunned. But one of the things I have learned is that as a writer you need to say "yes" to every experience you can. In my case, I was very lucky to say yes to a spur-of-the-moment dinner invitation, where I met MJ Rose, an amazingly generous author, who introduced me to Writer's House and my agent, Amy Berkower, who I swear can fly.


When did you know you wanted to be a writer? What experiences moved you in that direction?

I have always wanted to write, but I realized what I wanted to write when I read Tillie Olsen's "I Stand Here Ironing" in college (and I doubt very much I am alone in that experience). I wanted to write books that took what many considered to be unimportant bits of life and reminded people of their beauty – but the only other thing I knew for certain back in college was that I wasn't grown up enough yet to do that.

So I got a PhD in literature and wrote 500 Great Books by Women and Let's Hear it for the Girls. In the process I read, literally, thousands of books, good and bad, which is probably one of the best educations a writer can have. I still wrote, but thankfully, that material wasn't published. I taught. I had children.

It's been thirty years since I first read Tillie Olsen. I still believe, even more so now, that paying attention to the small, unimportant bits of life is one of the most important things human beings can do. And I believe that literature that takes those things and looks at them with compassion has the ability to feed people's souls – and that that is a goal worth having.


How did being a mother affect your development as a writer?

Having children probably had the most dramatic effect upon how I write of anything in my life. As the care-taker of children, my life was one of constant interruption – not the optimal environment for writing novels with traditional, sequential story-lines. So I worked on other projects and learned to multi-task, and when the children's demands were too many, we created something called the "mental hopper." This is where all the suggestions went – "can we have ice cream tonight?" "can we go to Canada this summer?" "can I have sex when I am 13?" The mental hopper was where things got sorted out, when I had time to think about them. What's interesting about the mental hopper is that when something goes in there, I can usually figure out a way to make it happen (except sex at 13).

The mental hopper became a way of thinking and deeply affected how I write now. All the characters, all those first details and amorphous ideas for a story, the voices of the characters, the fact that one of them loves garlic and another one flips through the pages of used books looking for clues to the past owner's life, all those ideas go in the mental hopper and slowly but surely they form connections with each other. Stories start to take shape. It's a very organic process, and it suits me. So when people say being a mother is death for writers, I disagree. Yes, in a logistical sense, children can make writing difficult, because of the time they demand. In fact, I don't think it is at all coincidental that my first fiction book will be published after both my children are in college. But I think differently, I create the way I do, because I have had children.


What do you hope readers take away from The School of Essential Ingredients?

I always love it when a reader says "Now I'm going to go home and cook my wife a real dinner" and you just know what that dinner will turn into. But perhaps my favorite response was from an American reader living in a small town in Mexico. She volunteers in a shelter for street kids, cooking them lunch once a week. She said that even though the kids were obviously hungry, they wouldn't always eat what she prepared for them, especially if it wasn't what they knew. She wrote that after she read Isabelle's story in the novel, she cooked a real Mexican pork stew and that the kids ate every bite and she got 83 hugs.

In the end, what I hope people take away from my book is that cooking can be a sensual experience that slows down time, but that cooking is also about thinking about other people. When we really cook for other people, we are seeing them – who they are, what will make them happy, excite or comfort them. And when we eat something that has been prepared, beautifully and especially for us, we feel loved, taken care of, seen.

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 Erica Bauermeister at BookBrowse
No Two Persons jacket Joy For Beginners jacket The School of Essential Ingredients jacket 500 Great Books by Women 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 Erica Bauermeister 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 8 similar authors

View all 8 Read-Alikes

Non-members can see 2 results. Become a member
Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

BookBrowse Book Club

Book Jacket
The Cover Girl
by Amy Rossi
Find them early enough, and they will always be her girls.

Members Recommend

  • Book Jacket
    The Sister's Curse
    by Nicola Solvinic
  • Book Jacket
    The Lost Story of Eva Fuentes
    by Chanel Cleeton
    A mysterious book links three women across generations in this novel by New York Times bestselling author Chanel Cleeton.
  • Book Jacket
    The Vanishing Place
    by Zoë Rankin
Who Said...

Dictators ride to and fro on tigers from which they dare not dismount. And the tigers are getting hungry.

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 03:38 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
1780285114079 ms 1.78028511408E+012 ms 1 /root/website/app_server.cfm
568 ms 568 ms 1 /root/website/author_interviews/full/index.cfm
234 ms 234 ms 1 /root/website/app_layout.cfm
170 ms 57 ms 3 /root/website/adsystem/adsystem_mod.cfm
157 ms 157 ms 1 /root/website/author_interviews/full/dsp_main.cfm
146 ms 146 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
139 ms 139 ms 1 /root/website/app_globals.cfm
125 ms 125 ms 1 /root/website/adzones/showcase_track.cfm
74 ms 74 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
41 ms 14 ms 3 /root/website/site/blocks/membership_advantages.cfm
39 ms 13 ms 3 /root/website/queries/qry_get_member_account_types.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_active_obc.cfm
31 ms 31 ms 1 /root/website/actions/adstatus.cfm
29 ms 15 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_current_competition.cfm
24 ms 24 ms 1 /root/website/adzones/AdZone6.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone2.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
12 ms 12 ms 1 /root/website/act_check_login.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_member_info.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
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_current_wordplay.cfm
4 ms 4 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
2 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
1 ms 1 ms 1 /root/website/Application.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/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.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/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.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/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
570 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 03:38:34.034
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=11ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:38:34.034
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=31ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:38:34.034
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 @ 03:38:34.034
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=5ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:38:34.034
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:38:34.034
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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:38:34.034
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 @ 03:38:34.034
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:38:34.034
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 @ 03:38:34.034
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=12ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:38:34.034
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=10ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:38:34.034
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) = 633

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:38:34.034
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) = 633

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=4) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 03:38:34.034
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) = 633
Parameter #2(CF_SQL_INTEGER) = 633

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=5ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:38:34.034
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) = 633

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=3ms, Records=8) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:38:34.034
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) = 633

get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:38:34.034
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=14ms, Records=1) in /root/website/actions/udfs.cfm @ 03:38:34.034
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) = 2223

get_book_image (Datasource=bookbrowse_com_new, Time=25ms, Records=1) in /root/website/actions/udfs.cfm @ 03:38:34.034
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) = 816

get_member_account_types (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:38:34.034
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=8ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:38:34.034
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) = 797
Parameter #2(CF_SQL_INTEGER) = 797
Parameter #3(CF_SQL_INTEGER) = 797

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:38:34.034
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) = 797

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:38:34.034
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) = 632
Parameter #2(CF_SQL_INTEGER) = 632
Parameter #3(CF_SQL_INTEGER) = 632

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:38:34.034
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) = 632

get_member_account_types (Datasource=bookbrowse_com_new, Time=29ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:38:34.034
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:38:34.034
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=11ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:38:34.034
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=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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 @ 03:38:34.034
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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=12ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:38:34.034
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 @ 03:38:34.034
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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 @ 03:38:34.034
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:38:34.034
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=0; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4084497; CFGLOBALS=urltoken%3DCFID%23%3D4084497%26CFTOKEN%23%3Db507f6483b807367%2D0C9C333D%2D9B80%2DAB27%2D2BF770CD7AB78CEE%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A38%3A34%27%7D%23hitcount%3D95%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A38%3A20%27%7D%23cftoken%3Db507f6483b807367%2D0C9C333D%2D9B80%2DAB27%2D2BF770CD7AB78CEE%23cfid%3D4084497%23; CFTOKEN=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
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/633/erica-bauermeister
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=4084497
cftoken=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
hitcount=98
lastvisit={ts '2026-06-01 03:38:34'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:38:20'}
urltoken=CFID=4084497&CFTOKEN=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
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#=4084497&CFTOKEN#=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE#lastvisit={ts '2026-06-01 03:38:34'}#hitcount=95#timecreated={ts '2026-06-01 03:38:20'}#cftoken=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE#cfid=4084497#
CFID=4084497
CFTOKEN=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
FREEACCESSCOUNT=0
Session Variables:
cfid=4084497
cftoken=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
sessionid=BOOKBROWSE_4084497_b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
urltoken=CFID=4084497&CFTOKEN=b507f6483b807367-0C9C333D-9B80-AB27-2BF770CD7AB78CEE
URL Parameters:
author_number=633
erica-bauermeister=
Debug Rendering Time: 85 ms