Anna Quindlen Interview, plus links to author biography, book summaries, excerpts and reviews

Anna Quindlen

Anna Quindlen

How to pronounce Anna Quindlen: kwind-len

An interview with Anna Quindlen

In three separate interviews Anna Quindlen discusses her 2007 novel, Rise and Shine, her inspirational nonfiction book, A Short Guide To A Happy Life and her 2012 memoir, Lots of Candles, Plenty of Cake

In three separate interviews Anna Quindlen discusses her 2007 novel, Rise and Shine, her inspirational nonfiction book, A Short Guide To A Happy Life and her 2012 memoir, Lots of Candles, Plenty of Cake

Best-selling author Anna Quindlen takes us on a video walk through her New York City town house as she discusses Lots of Candles, Plenty of Cake (2012)



A Conversation with Anna Quindlen about Rise and Shine

Scroll past this first interview to read a separate interview with Quindlen about "A Short Guide to a Happy Life".

Q: We love the premise of Rise and Shine - two sisters, New York City, and two very different career trajectories. In dreaming up this novel, what came to you first: the sisters, the setting, or Megan's on-air slip? And how did your storyline evolve from there?

Anna Quindlen: I always begin a novel with a theme.  Black and Blue, for instance, began with the theme of identity, Blessings with the theme of redemption.  Rise and Shine grew out of constant thoughts about the disconnect in modern American life between appearance and reality.  The more I thought about that disconnect, about how we've all come to believe that what looks good is good, the more I thought I should write about someone famous.  That's where the dissonance is greatest, it seems to me, and the public interest weirdest.  And then I thought that the story would be best told by someone on the outside looking in.  (Yes, I have read "Gatsby."  Many many times.)   That's where the idea of the sisters eventually came into play: one the doer, the other the watcher.  And over time I realized that in doing that I had given the story, which is essentially a comedy of manners, greater resonance than it might have had otherwise.  I find that I almost always make the right decisions for purely accidental reasons.

Q: Bridget and Meghan's relationship seems to strike a realistic chord with readers - they are each other's number one fan and critic. Do you have a sister of your own, or any siblings? Did your experiences with them help shape Bridget and Meghan’s relationship? How?

AQ: I have a sister and three brothers, who fall between us on the birth order ladder.  My sister and I agree that our relationship bears little resemblance to that of Bridget and Meghan.  I am not that controlling, and she is not that compliant.  Perhaps the one aspect of their relationship that is taken from our lives has to do with our jobs.  My sister is a public school teacher.  She makes far far less money than I do, and gets almost no public attention for her work.  Yet I believe what she does is infinitely more important and more difficult than what I do.  And certainly that mirrors Meghan's feelings about Bridget's job as a social worker. 

Q: Do you believe in the birth-order convention, that the eldest child is a natural leader, who strives to please others and can be controlling, while the younger child is charming, but irresponsible, and looks to others for guidance and discipline? Did the study of birth order influence you in writing about the Fitzmaurice sisters? Does birth-order ring true in your own experience, or, do you think it's a bogus label?

AQ: Well, I recently got an email from a very irate reader complaining that I was perpetuating birth order stereotypes in a way I would never dare do about gender, sexual orientation, and the like.  So I'm more equivocal about answering these questions now!  But my experience, as both the eldest in a large family and the mother of three, is that certain birth order conventions frequently apply.  But maybe it's more useful, and illuminating, to put it the way Aunt Maureen puts it in the novel: that successive children fill the spaces not already occupied.  So if extrovert, or leader, or wild child, or whatever is already taken by one of your siblings, you may feel compelled--or free--to shape your identity otherwise.  That's certainly what happened with the Fitzmaurice sisters.  

Q: Do you share any qualities and/or characteristics with Meghan? Bridget?

AQ: I am like both Meghan and Bridget.  For years I had the sort of laser focus that Meghan had, and I have some of her rather cynical attitudes about the affluent around her.  But, like Bridget, I have always been interested in trying to do something about the situation of the poor and disenfranchised in New York and the rest of America, in my case through the columns I've written. 

Q: There are several interesting male characters in the book: Irving, the gritty cop, Edward, the smooth operator, Evan, the seemingly reliable yet duplicitous husband, and Leo, the upbeat, loveable young man. Who is your favorite among them, if you can pick one? And what qualities do you find most (or least) attractive in men in general?

AQ: Most female readers of a certain age seem to fall hard for Irving Lefkowitz. I can totally understand that; we've had it up to here with the sensitive man, and Irving is pure retro.  He also really really likes women, and he really likes Bridget.  I assume the reader shares that sentiment; I certainly do.  But if I had to pick just one male character in the book as my personal favorite, it would be Leo.  Some critics have suggested that he's too good to be true, but I've met a fair number of teenage boys like him: smart, self-deprecating, truly inclined to do the right thing.  Obviously one of the reasons I love him so is that he's based, in part, on both my sons. 

Q: Your portrait of New York is loving, yet you see the city–and its residents–for what they are. What do you love about the city? What do you hate? Can you ever imagine leaving New York, or is it home to you?

AQ: I made New York City a major character in this book because I thought it would make my task as a novelist easier.  I've covered New York for more than 35 years as a reporter and columnist, and I know from long experience that it's a story teller's dream.  It's so polyglot, so vivid, so sharply drawn, that writing about it is as easy as finding a cab outside the Carlyle (or finding crack on certain corners in certain parts of the Bronx).  But like any great character, part of its greatness, part of its power, is in its manifest flaws.  New York is a city where it's particularly hard to be poor, not only because everything costs twice as much as it does elsewhere but because over-the-top affluence is part of its identity.  Yet it's a city, as the novel makes clear, where affluence and want exist almost side by side.   I hate the ways in which the rich are too often blind to their own conspicuous consumption.  With what some East Side women spend on Botox and fillers a year, they could put a kid through parochial school, which could change a life completely.   What I love is the flip side of that: that there is such enormous generosity.  And I love other things, too, of course.  I love that you can always get a decent Ethiopian meal.  I like the places in Central Park in which you can feel as if you're on top of a mountain, not in the middle of town.  I like the way the subway can take you to the beach in a half hour, then back to the roar and glare of Times Square.  New York is just more alive than any place else I've ever been.  People never really leave.  I can't tell you how often in promoting this book, in Atlanta or Orlando or Minneapolis, someone has said to me, "I'm a New Yorker."  They may have lived elsewhere for most of their life.  But they're still New Yorkers. 

Q: Meghan goes off the radar in Jamaica. What do you do to “go dark” and have time for yourself to get away and regroup?

AQ: We have a house that's in the middle of nowhere in Pennsylvania.  I spend the entire summer there.  It's a good place to write because there's really nothing else to do.  After the third time rowing across the pond in the canoe, I think, well, hell, and I go inside and work.  Occasionally there will be a bear or eagle sighting to break up my day.  But it's pretty easy for me to be off the grid in Manhattan, too.  I'm not visually identifiable as Meghan is, so I don't get much attention in the city.  New Yorkers are so accustomed to the truly famous that they are very cool about it.  Usually they just smile.  It's interesting for me to go to cities that have a small clutch of well-known writers.  In those places they are a BIG DEAL.  Here no one cares. 

Q: Have you ever had a career-defining moment, either positive (like Meghan's first big scoop), or negative, like Meghan’s on-air gaff? How did you grow from it?

AQ: I had one fairly substantial setback as a reporter when I was much younger.  There was the perception that I had blown a major major story, although the truth was much more complicated than that.  But, like Meghan, I came to understand rather quickly that the truth was less important than the spin. The perception was that I had certain glaring deficits as a reporter, chief being that I could write a pretty feature but was a washout with hard news.  Over the space of several days I tried to scope out assignments that could exorcise that perception if I filled them in a satisfactory fashion.  In this way I became a member of the New York Times City Hall bureau for two years.  It wasn't my dream job, but after two years of Council hearings, budget reports, and the like, many of which ended up on page one, there was no longer the sense that I couldn't do hard news. 

Q: CNN anchor Kyra Phillips’ left her microphone on as she chatted in the ladies room. What did you think of this story, which broke the same week Rise and Shine went on sale? Did you imagine such a thing could happen as you wrote the book?

AQ: I always say that if you can imagine it, it can happen.  While several interviewers were skeptical about Meghan blurting out an obscenity into a "hot mike," I was certain such a thing was possible.  Of course, after the CNN blooper, interviewers kept asking me whether I'd had it in mind when I wrote the book.  Illustrating the simple fact that even well-connected reporters don't understand the nine-month lag time between finishing a novel, and publishing one.


Anna Quindlen discusses A Short Guide To A Happy Life

This book was inspired by a commencement speech you gave to a graduating high school class. Why did you choose the topic of happiness, as opposed to more familiar topics, like civic achievement and academic excellence? Is the advice given in the book something you think you needed to hear at the same age in your life?
I know lots of people of great accomplishment who seem to take precious little pleasure in that accomplishment. And I know people of achievement who seem to have let friendship and family fall by the wayside. So I believed that young people were growing up in a culture in which they heard over and over again that they would want to accomplish great things but were not hearing enough that they would want to appreciate the small ones. It's a lesson I learned early in life, but which I've kept on learning. In fact one of the things I said to the graduate was that they might not appreciate what I was saying as they sat there, but that perhaps my sentiments would come back to them at some time when they really needed them. Their parents, however, came up to me afterwards and said they wished they'd heard this message many many years before.

Throughout A Short Guide to a Happy Life, you mention many people, but in particular your mother. Why do you think it was the loss of you mother that taught you about true happiness, and how do you think you pursued happiness before her death? What role does family and close friends play in a happy life?
I have attended several memorial services in recent years at which family and friends noted that the deceased has understood what really mattered in the face of terminal illness. That's so sad. That's a knowledge we would have long before we get a bad biopsy results. But of course I know that that's how I understood the importance of living life to the fullest, from watching my mother lose it by inches. She wasn't clinging to life so that she could write a bestseller, or make a million bucks. She just wanted to watch the sun come up one more time, or to hug my little sister, or to listen to "South Pacific" on the stereo. And that teaches you something. It teaches you that so much of what you take for granted is the bedrock of happiness. You know, one of the most affecting scenes in any play for me is when Emily is watching the mourners at her own funeral in "Our Town." And she asks the other dead around her whether living people ever understand how wonderful life is. And one of them replies, "That's what it was to be alive. To move about in a cloud of ignorance; to go up and down trampling on the feelings of those about you. To spend and waste time as though you had a million years." I refused to live with that inevitability.

Who are the people in your life who have informed your thinking on what's important in life most?
Well, certainly my mother, who was a humble woman with a great capacity for unconditional love. And now my kids. Because you can reexperience the world through the eyes of your kids, whether it's the first time they catch a fish or dive off the board, or read "To Kill a Mockingbird." I feel infinitely more alive and aware of the world since I had children to show me the way. I could never do enough to repay them for that. (And, no, honey, you can't have a motorcycle!)

Several times in the book you quote writers, like Gwendolyn Brooks, and you incorporate their wisdom about life into your own. Which writers and books have influenced you the most and helped you to form your own philosophy about living?
Reading is another thing that has made me more human by exposing me to worlds I might never have entered and people I might never meet. Actually it's poetry that more than any other form makes me feel the quiet overwhelming joy that points the way to emotional satisfaction. Yeats, for example, whose poem I used for the dedication to "Thinking Out Loud." Elizabeth Bishop. William Carlos Williams. John Ashbery. Robert Lowell. Sometimes you read a novel and it's like a symphony playing in your head, Anna and Vronsky and all the rest, the rich Tapestry of Faulkner's language. And it takes the one of two perfectly placed words in a short poem to pick out the truth on the strings of your violin-heart. How's that for an overwrought metaphor?

How has your own writing contributed to your happiness and satisfaction with your life, both in a day to day way and in general?
There's no greater happiness than doing something every day that you love, that you feel you do in a satisfactory fashion, and which both supports and gives you time to support your family. I felt so lucky to have all that. But I am also happy that it provides me a measure of immortality with the people I love most. When I am gone my children will be able to sit down and read "A Short Guide to a Happy Life" and remember me, and remember what I cared about and held most dear. That's enormously soothing.

Beautiful, happy, and uplifting photos appear throughout A Short Guide to a Happy Life, and they capture what you are saying perfectly. When choosing these photos, what were you looking for? What role has art played in your own life, and how do you think it contributes to the pursuit of happiness?
Louis Armstrong once said when someone asked him to define jazz, if you have to ask, you'll never know. I just knew that these pictures belonged. Call it a chemical reaction. Their emotional content just seemed consonant with that of the book.

Many of these photographs are of beautiful landscapes or people surrounded by nature. What role has nature played in your understanding of happiness? Why do you think it is such an apt metaphor for rediscovering the wonder of life?
There's an Emily Dickinson poem - now that I'm on the subject of poetry - that ends with the words, "How much can come/and much can go/ and yet abide the world!". That has something to do with it, that sense of clinging to what will remain after we are gone.

In the book, you stress the importance of women realizing and being thankful for being alive during such a healthy, prosperous and peaceful time. Women now seem to have more opportunity than ever to pursue their dreams. Of what importance are issues of womens' rights to you? Has your involvement in women's issues in the community contributed to your own happiness?
I've been a feminist since I was a teenager, but originally it was because I wanted to make the world a better place for me. Now I just rejoice in the opportunities for so many. What could make you happier than to make a better world, a world that is fairer, more egalitarian, that works better for all.
2002

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 Anna Quindlen at BookBrowse
After Annie jacket Miller's Valley jacket Still Life with Bread Crumbs jacket Lots of Candles, Plenty of Cake 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 Anna Quindlen 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

  • A Manette Ansay

    A Manette Ansay

    A. Manette Ansay grew up in Wisconsin among 67 cousins and over 200 second cousins.  She is the author of six novels, including Good Things I Wish You, Vinegar Hill, an Oprah Book Club Selection, and Midnight Champagne, ... (more)

    If you enjoyed:
    Black and Blue

    Try:
    Vinegar Hill
    by A Manette Ansay

  • Diana Athill

    Diana Athill

    Diana Athill was born in 1917. She helped Andre Deutsch establish the publishing company that bore his name and worked as an editor for Deutsch for four decades. Athill's distinguished career as an editor is the subject of ... (more)

    If you enjoyed:
    Lots of Candles, Plenty of Cake

    Try:
    Somewhere Towards the End
    by Diana Athill

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

The thing that cowardice fears most is decision

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:52 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
1780318368211 ms 1.78031836821E+012 ms 1 /root/website/app_server.cfm
917 ms 917 ms 1 /root/website/author_interviews/full/index.cfm
369 ms 369 ms 1 /root/website/app_layout.cfm
317 ms 317 ms 1 /root/website/author_interviews/full/dsp_main.cfm
315 ms 105 ms 3 /root/website/adsystem/adsystem_mod.cfm
308 ms 308 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
224 ms 224 ms 1 /root/website/adzones/AdZone6.cfm
207 ms 104 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
139 ms 139 ms 1 /root/website/app_globals.cfm
63 ms 63 ms 1 /root/website/queries/qry_get_current_competition.cfm
60 ms 60 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
59 ms 59 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
53 ms 53 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
53 ms 18 ms 3 /root/website/site/blocks/membership_advantages.cfm
52 ms 52 ms 1 /root/website/adzones/showcase_track.cfm
51 ms 17 ms 3 /root/website/queries/qry_get_member_account_types.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_active_obc.cfm
41 ms 41 ms 1 /root/website/adzones/AdZone2.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
17 ms 17 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
13 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
6 ms 6 ms 1 /root/website/act_check_login.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
4 ms 4 ms 1 /root/website/actions/adstatus.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/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/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
920 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 12:52: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=5ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 12:52: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=4ms, Records=2) in /root/website/actions/adstatus.cfm @ 12:52: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:52: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=1ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 12:52: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:52: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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 12:52: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:52: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=13ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 12:52: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=5ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 12:52: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=23ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 12:52: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=12ms, Records=6) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 12:52: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) = 293

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

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=27ms, Records=6) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 12:52: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) = 293

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=38ms, Records=26) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 12:52: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) = 293

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 12:52: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=58ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 12:52: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) = 322
Parameter #2(CF_SQL_INTEGER) = 322
Parameter #3(CF_SQL_INTEGER) = 322

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=73ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 12:52: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) = 1792
Parameter #2(CF_SQL_INTEGER) = 1792
Parameter #3(CF_SQL_INTEGER) = 1792

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=21ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 12:52: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=34ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 12:52: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=23ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 12:52: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=70ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:52: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=145ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:52:49.049
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:52:49.049
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 12:52:49.049
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:52:49.049
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:52:49.049
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=18ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:52:49.049
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:52:49.049
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=CFID=4100904; CFTOKEN=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465; 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%3D4100904%26CFTOKEN%23%3Dfa89dfb9342d0c9f%2D206C0C65%2DFB28%2D32C6%2DFD5651C9DF27E465%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2012%3A52%3A48%27%7D%23hitcount%3D141%23timecreated%3D%7Bts%20%272026%2D06%2D01%2012%3A52%3A19%27%7D%23cftoken%3Dfa89dfb9342d0c9f%2D206C0C65%2DFB28%2D32C6%2DFD5651C9DF27E465%23cfid%3D4100904%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/293/anna-quindlen
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=4100904
cftoken=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
hitcount=145
lastvisit={ts '2026-06-01 12:52: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:52:19'}
urltoken=CFID=4100904&CFTOKEN=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
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#=4100904&CFTOKEN#=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465#lastvisit={ts '2026-06-01 12:52:48'}#hitcount=141#timecreated={ts '2026-06-01 12:52:19'}#cftoken=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465#cfid=4100904#
CFID=4100904
CFTOKEN=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
Session Variables:
cfid=4100904
cftoken=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
sessionid=BOOKBROWSE_4100904_fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
urltoken=CFID=4100904&CFTOKEN=fa89dfb9342d0c9f-206C0C65-FB28-32C6-FD5651C9DF27E465
URL Parameters:
anna-quindlen=
author_number=293
Debug Rendering Time: 14 ms