Norah Vincent Interview, plus links to author biography, book summaries, excerpts and reviews

Norah Vincent
Photo: Michele Asselin

Norah Vincent

An interview with Norah Vincent

Norah Vincent discusses her first novel Adeline in which she explores the life of Virginia Woolf. Among the many topics discussed Vincent explains how in many ways this novel is a work of immersion journalism, like her two previous nonfiction works.

What was it about Virginia Woolf that compelled you to start writing Adeline?

I thought about writing this book about three years ago. At that time, I bought Hermione Lee's biography and read it. I bought and reread VW's major novels and her diaries. I had bought and read all five volumes of Leonard Woolf's autobiography ten years before, so I already had that in my mind and on the bookshelf.

But after doing all of this I found that the specter of VW was just too much for me. I thought what any normal person would think: Are you nuts? You can't write about VW, much less as her. Forget it.

So I did forget it, sort of, and I shelved the idea. But then, after going through a pretty awful depression in 2013, I came back to VW, for obvious reasons, I think. I really identified with her struggle with mental illness and creative self-confidence. Also, I had just gotten married, so I realized that I wanted to write a book about marriage.

I've always felt that Leonard Woolf has been poorly represented/poorly remembered by history, and that VW has in a sense been too revered. He was a much kinder person I think than most people know, and she could be quite nasty personally, and often was. In writing about them I wanted to present a clearer picture both of who people are—their wholeness, their complexity—as well as how that complexity is reflected in their relationship.   With VW I had to learn to hate my heroine, as well as to connect with her vulnerability. With Leonard, I got to delve into his lifelong misanthropy and its seeming contradiction of and conflict with his deep humanitarianism, as well as his deeply held belief in VW's genius and his commitment to seeing her through the roughest times of her life. I told myself that in writing this I could do it only if I put it in the proverbial drawer and assumed that it would never see the light of day. That helped me to overcome my trepidations.


Did your writing process for this book differ from that of your previous ones?

Yes. Quite a lot. Another reason why I was able to overcome my trepidations about writing a book about VW was that I simply didn't write it. It wrote itself. I have been practicing meditation on and off for the better part of a decade, using it to more easily access and fertilize my subconscious. This became central to the process of creating Adeline. When I say that I didn't write this book, I really mean it. I received it in meditation, and I simply wrote down what I received—the words I heard, the things I felt, even the trajectory of the book itself, how it proceeded from VW's conception of To The Lighthouse in 1925, through her relationships with other suicidal/mentally ill women like Dora Carrington and Vivien Eliot, and ended with her stepping into the river Ouse. I tell people that this book happened to me. I simply watched it spread and take shape, like a stain on a tablecloth.


Who is Adeline, and what is her relationship to Virginia Woolf in the novel?

Adeline is Virginia Woolf, or Virginia Stephen as she was then known, when she was 13 years old. VW was named after her maternal aunt Adeline Vaughn, who died just before VW was conceived. Because the name was so associated with death and grieving, it was never used, but Adeline was VW's first name. So Adeline Stephen is VW's alter-ego. She is her child self stopped in time in the year 1895 when her mother died. VW idolized her mother and loved her dearly.

VW also first came to her love of the sea when she was a child vacationing with her family in St. Ives in the years prior to her mother's death. They stopped going to the house in St. Ives when VW's mother died, and thereafter, the family began to disintegrate. Part of VW cracked open then, too, and it was the part of her that suffered repeated breakdowns throughout her life.

I conceived of Adeline as a creative source for VW. It's well known that VW heard voices when she was most ill, and had hallucinations, so I made Adeline into one of her hallucinations. They talk to each other often throughout the book, and Adeline serves as the source of a great deal of VW's inspiration. She is also there with VW right to the end, walking with her into death.


It was certainly a bold move to write about Virginia and her peers in the style of Virginia herself.  What freedoms did this approach allow you? Was it in any way restricting? In what way is a novelist like a ventriloquist?

As I mentioned above, the difficulty of the task of writing as VW—well, really, the downright hubris it entailed—didn't escape me. I was able to overcome it by setting my mind aside and becoming a conduit in meditation, or as you suggest, a ventriloquist, and by convincing myself that whatever resulted from these seances would never be published. This approach did allow me much more freedom creatively, because it enabled me to disappear. This book was not about me—it is in fact the first book I have written in the third person, and also the first that is not explicitly or implicitly a memoir. Oddly, whenever I used to get down in the mouth about the process, though this happened while I was writing ADELINE far less often than it had happened while writing other books, a supremely confident voice in my head would say: Don't worry. It's already written. All you have to do is uncover it.  This helped me to feel entirely free and not restricted in the least, and I simply let it all come through however it would.


How would you describe the Woolfs' marriage? On balance, was it a help or a hindrance to Virginia in her life and work?

I think the Woolfs had an incredible marriage, a model, in many ways, for what a relationship can be. Contrary to what some have maintained, I don't think Leonard in any way kept VW under wraps creatively or personally, or drove her mad. In fact I think that he's the reason she lived as long as she did without ending up (like so many other similarly afflicted women of her time) in the madhouse. He nurtured her genius and believed in it wholeheartedly. He helped her navigate the difficult terrain of her mind, and shared her intellectual life fully and fruitfully. He also allowed her to express her sexuality extramaritally (primarily with Vita Sackville West) and though he and VW did not have a sexual relationship for most of their married life, I get the sense that they were quite physically intimate and fond nonetheless.


There is an incredibly poignant scene in Adeline where Leonard and Virginia are discussing her latest literary effort, and Leonard realizes with shocking clarity that to encourage his wife as an artist is to endanger her as a person. What does this tell us about the relationship between creativity and madness? And also the scope of our obligations to our loved ones, and also the limitations thereof?

I think Leonard was always treading that precarious line between feeding VW's visionary genius and keeping her from falling into the abyss. Creativity and madness are closely linked. This was especially true for VW precisely because to write what she wrote, she had to indulge her psychedelic experience of the world, to flirt in a sense with her madness, but stay out of its clutches at the same time. She never fully succeeded, but Leonard knew that this process was necessary to her life—i.e. her life would not be worth living if she could not get inside it and describe what she knew—so he helped her to walk the tightrope, and he caught her when she fell.

It was a lot to ask. It is a lot to ask of any relative or partner. In the end, I think VW wanted to let Leonard go, to let him get on with his life without the burden of taking so much care of her. He could nurture her, and he did, allowing her to produce the beautiful and unforgettable novels that she gave us, but he could not save her life. No one can do that, nor should they be expected to.


There are cameo appearance in Adeline of many well-known artists, poets, and writers—James Joyce, WB Yeats, T.S. and Vivian Eliot, and of course the Bloomsbury crew. One of the most surprising and interesting figures you introduce is Woolf's physician, Dr. Octavia Wilberforce. What role does she play in Virginia's story?

Dr. Wilberforce was a fascinating person. She came from the Wilberforce clan who were so famous for abolishing slavery in England in the early 19th century. She was the youngest of eight children, and so named, and she became a physician at a time when women simply didn't pursue professions, and often couldn't. She was also a lesbian who lived with her longtime companion, the American actress, Elizabeth Robins. 

At Leonard's insistence, she had a long conversation and consultation with VW on the day before VW took her life in March, 1941. It is not known what they said to each other, which is where I got to exercise the novelist's privilege of invention. Years before, in 1932, VW had had a long conversation about suicide with Dora Carrington on the day before Carrington killed herself. Again, little is known of what was said, so these two scenes—the one with Carrington occurs midway through the book, and the one with Octavia occurs in the penultimate chapter—functioned like bookends for VW's ideas about suicide and the role that her alter-ego Adeline played in the way that she thought about it. Her conversation with Octavia, somewhat like her conversation with Carrington, though this time it happens from the opposite side of the question, is about wanting to die, about asking a friend and physician to let you die. It offers the argument for why VW took her life and why she wanted to, and presents the challenge again of what a loved one might be confronted with under such circumstances.


You've written two controversial and well-received non-fiction books—Self-Made Man, an account of the 18 months you spent living as a man, and Voluntary Madness, an expose of depression and mental illness in America; your life and work seem to inform each other in very intimate ways. Where does Adeline fit in this continuum?

Though I did not know it while I was writing it, Adeline was another strange foray into immersion journalism. I immersed myself in VW and wrote as her, just as I had immersed myself in the experiences of being treated as a man and of being treated as a patient in various mental hospitals. I was also struggling to express my own thoughts about mental illness and suicide as well as lesbianism and issues of gender identity as they appear in VW's work. I suppose in that sense my earlier work was the ideal preparation for writing as VW. The parallels are many and obvious.


What are you working on now?

Through writing Adeline I discovered a new genre for myself, which I'm calling bio-fic or bio-lit. It blends biography, literary criticism and fiction and attempts to present a portrait of the lives and work of writers I admire. The novel I'm working on now is another in this genre. It's called Shadowbox and it's about the life and work of Samuel Beckett.


Amongst many other topics, Nora Vincent discusses how her concept of being a woman has changed since living as 'Ned' for 18 months, an experience she describes in Self-Made Man

Can you describe the process of your readjustment to life as a woman? How long did it take? Were there any surprises involved? What, if anything, do you miss about living as a man?

Living as a man taught me a lot about the things I most enjoyed about being a woman in the world, things I consider to be the privileges of womanhood—the emotional freedom, the range of expression, the sexual and social power we can exercise over men. Returning to my life as a woman was about reclaiming those privileges and taking greater satisfaction in them. Here's one small example, which may sound hopelessly old-fashioned and silly, but it made me smile so warmly: The other day a clerk in a store turned to me and apologized for having to refer to pornography in front of me during a discussion he was having with a male customer. I found it very thoughtful and sweet. When a man does something like this now, I connect again with all the vulnerability that I felt as a man in front of women, and I remember all the conversations I had with the men in my men's group about their need to take care of and protect women. Not all men behave the way this clerk did, of course, but nonetheless I feel a deep sense of the respect that men like him have for women and I feel grateful for it. It's nice to feel that someone is looking out for you, or trying to, and worries about offending or debasing you even in speech, and this is something I never felt as a man.

It took me months. Probably a good six months to really get back into being a woman. And this is partly because I had some unpacking to do. It wasn't just a matter of returning to myself, because I am a different person now than I was before I embarked on this project. I feel more womanly now, more in touch with my femininity, than I ever did before I lived as Ned, and that has taken some getting used to, though it has been very pleasant.

I don't miss anything about being Ned. The few social advantages I discovered in manhood—the swagger, the self-confidence, the entitlement—I've learned to incorporate into my life as a woman. Everything else I was happy to discard.

How has your concept of being a woman changed since your experience as Ned, in both general and personal terms?

Being able to incorporate the lessons of manhood into womanhood is, I suppose, one of the best examples of how my concept of womanhood changed because of Ned. In my view, this is the greatest liberation of feminism, a liberation that men haven't yet experienced in their own roles. They haven't really been allowed to express traditionally feminine qualities, and they are limited as a result. Having lived as both a man and a woman, it seems to me now that the definition of womanhood, at least as I live it and as I believe our culture defines it, is so much larger, can happily encompass so much more, than the definition of manhood. I can borrow from the boys—wardrobe, mien, temperament—and still be all woman. The reverse is not really true, or at least it wasn't for Ned. He had to shed all my female qualities and, as a result, became much smaller. I like to say that in that respect Ned can fit in Norah's pocket.

What influence do you think the media have on sexual roles? Do you see any trends that alarm or encourage you?

I think that the media reflect more than they influence. They show us images of ourselves, often idealized images to be sure, but I don't think they invent out of whole cloth. They're not that creative. Sexual roles are a very intimate business, I think. They change at the microcosmic level first. Individuals, often obscure individuals, are the creative ones, and they're the ones who end up changing the way we think and behave, and the media in turn digest those changes and spit them back at us as trends. If there's a trend that disturbs me it's probably that tendency on the media's part to homogenize originality, to dumb it down and sell it back to us as the norm.

Are there any public figures whom you admire for expanding social definitions of gender? Do you have any heroes—personal, political, or literary?

Though I disagreed with her often, I admire my friend the late Andrea Dworkin. Some heroes/heroines, in no particular order, are: Hamlet, George Orwell, Joan Didion, Graham Greene, W. H. Auden, Elizabeth Bishop, and Elizabeth I.

In Self-Made Man, you discuss the relationship between childhood experience and understanding gender roles—for example, fathers withholding affection in order to create tough young men. What advice would you give to a parent today to help him or her avoid imprinting gender expectations on children?

Having no children myself, I'm hardly in a position to judge, but if I had to say, I suppose I would suggest leniency when it comes to children's self-discovery. Too often parenting is a kind of narcissism. Parents see their children as little more than extensions of themselves, or potential re-enactors of their lost youths and missed chances. This is toxic to any child's self-actualization, especially when it comes to matters as intimate as sexuality and gender identity. If a child shows a proclivity for a particular style of dress or hobby or pursuit that the parent may not deem gender appropriate, or does not himself like, I think it is the parent's duty to resist showing disapproval, or, worse, distaste, and to encourage the child to be most authentically himself or herself in every way possible. God knows, the child will find enough disapproval in the outside world. Our parents are the first and foremost people whose job it is to love us entirely for who and what we are, and that means, when it comes to the expression of our individuality, letting us be.

Short of dressing up as a member of the opposite sex for a year and a half, how can a person begin to break free of gender clichés? Is there such a thing as a beneficial stereotype?

As has often been said, stereotypes are born of truth. I found this in my research. They are useful shorthands that help us to make sense of our world. The danger lies in being slavishly devoted to them, or allowing them to cloud our judgment when it comes to seeing and treating another human being as a person and not a set of categories. Similarly, gender roles are born at least in part—perhaps in large part—of natural inclination. Women may always be the primary nurturers on this planet, perhaps because something in our hormonal drives directs us toward intimate and interpersonal life or because we give birth. Maybe instinct conditions us far more than we know or may want to believe. The same is true, I think, for men. Perhaps their hormonal drives will always make them more physically competitive and better suited to high-pressure, teleological pursuits. This may mean that no matter how we jigger it, by virtue of who we are as creatures, women will always tend to predominate in the nursery and men the boardroom. This doesn't mean, however, that either sex should be mindlessly shackled to a prescribed or straitjacketed role, even if the vast majority of each sex tends to make a traditional choice. The key word here is choice, the cornerstone of feminism. Women should be able to choose whether to work or stay home, and so should men. Breaking free of stereotypes means being true to yourself and being flexible within your choices. You can, after all, be a stay-at-home mother and not be a shrinking violet, and you can be a type-A breadwinning dad and still join a knitting group if that's what turns your crank, or vice versa and a thousand other permutations as well.

Self-Made Man not only exposes the truth about contemporary manhood but is quite intimate in its discussion of your personal history, sexual identity, and emotions. How do you feel having so much of yourself in the book? How did you decide what to reveal and what to keep private?

I tried to write about everything that I thought was relevant, even if it didn't reflect particularly well on me. I had to overcome a lot of shame, for example, about mental illness in order to write honestly about my breakdown. A number of people who read the manuscript early on told me to take certain things out because they made me sound nuts. But it's precisely the things that embarrass or discomfort you the most that are most important for you to write about. That's the good stuff. I don't mean that endless navel gazing is desirable or makes for good writing. Tempering the urge to overwrite the especially mucky parts is important, but I didn't want to edit out the weird bits altogether simply because I didn't want people to know that I'd been in the bin, or that I'm not always the most attractive person on the planet. Of course, the downside of this is that if you're extremely sensitive, as I am, it means you need to protect yourself from people who take a malicious pleasure in sharpening their blades on your misfortunes and brandishing their cleverness at your expense.

The psychological toll of your experiences as Ned is both frightening and completely understandable. If you did the experiment again, knowing what you know today, what—if anything—would you do differently? Do you feel that the knowledge was worth the pain?

Ignorance is courage. If I'd known then what I know now, I could never have embarked on the project. Yet, all the same, I wouldn't trade the experience for anything. The knowledge was absolutely worth the pain; especially because part of what I learned was how to better take care of myself psychologically in my everyday life. I listen to my emotions much more carefully now. I take care of myself. I take responsibility for my own psychic health, and that's a daily practice. The lesson I can apply to my next project is that I can never again try to be someone else, someone that I'm not. I can and will immerse myself in situations and environments in order to write about them, but I will never again do so as another person.

Among the people you met as Ned, what range of reactions do you expect the book will receive? Do you think they will recognize themselves?

As a writer friend of mine told me when I embarked on this project, "When you write this intimately about real people, you are an assassin." And he's right. Almost invariably people object to something you've written about them. Either they say you got them wrong, or it didn't happen that way, or that's not how they remember it. I expect some of the Rashomon effect: The story of the same event will be told ten different ways by ten different observers. All the versions will be true and none of them will. The people in the book will recognize themselves. They'll agree with the compliments and they'll object to the disparagements, and that is to be expected.

This was a difficult, even dangerous experiment that consumed a year and a half of your life. What's next?

Ned is going to be an extremely hard act to follow. I've spent a lot of time thinking about what to do next, and I haven't hit on anything definitive yet. I'm trying very hard to resist the Hollywood temptation to find a formula that works and work it to death. I'd like to follow my imagination and have an adventure and that's all I know right now.

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 Norah Vincent at BookBrowse
Adeline jacket Voluntary Madness jacket Self-Made Man 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 Norah Vincent 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

  • Cris Beam

    Cris Beam

    Cris Beam is the author of Transparent and has written for public radio's This American Life, as well as for several national magazines. She has an MFA in writing from Columbia and teaches creative writing at Columbia, NYU, ... (more)

    If you enjoyed:
    Self-Made Man

    Try:
    I Am J
    by Cris Beam

  • Kate Bolick

    Kate Bolick

    Kate Bolick is a contributing editor for The Atlantic, freelance writer for ELLE, The New York Times, and The Wall Street Journal, and host of "Touchstones at The Mount," an annual literary interview series. Previously, she ... (more)

    If you enjoyed:
    Self-Made Man

    Try:
    Spinster
    by Kate Bolick

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...

Failure is the condiment that gives success its flavor

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 05:13 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
1780290830728 ms 1.78029083073E+012 ms 1 /root/website/app_server.cfm
368 ms 368 ms 1 /root/website/author_interviews/full/index.cfm
119 ms 119 ms 1 /root/website/app_layout.cfm
102 ms 102 ms 1 /root/website/app_globals.cfm
97 ms 97 ms 1 /root/website/author_interviews/full/dsp_main.cfm
96 ms 96 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
71 ms 24 ms 3 /root/website/adsystem/adsystem_mod.cfm
37 ms 37 ms 1 /root/website/adzones/AdZone6.cfm
36 ms 18 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
35 ms 35 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
32 ms 32 ms 1 /root/website/queries/qry_get_active_obc.cfm
26 ms 9 ms 3 /root/website/site/blocks/membership_advantages.cfm
25 ms 8 ms 3 /root/website/queries/qry_get_member_account_types.cfm
23 ms 23 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_competition.cfm
17 ms 17 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
15 ms 15 ms 1 /root/website/act_check_login.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_member_info.cfm
14 ms 14 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/adzones/showcase_track.cfm
10 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
7 ms 7 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/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/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
368 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 05:13:50.050
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=14ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 05:13:50.050
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=10ms, Records=2) in /root/website/actions/adstatus.cfm @ 05:13:50.050
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 @ 05:13:50.050
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=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 05:13:50.050
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 05:13:50.050
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 @ 05:13:50.050
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 @ 05:13:50.050
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=10ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 05:13:50.050
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=9ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 05:13:50.050
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=11ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 05:13:50.050
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=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:13:50.050
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) = 1250

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:13:50.050
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) = 1250

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=22ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 05:13:50.050
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) = 1250

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=3ms, Records=8) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 05:13:50.050
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) = 1250

get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:50.050
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=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:50.050
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=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:13:50.050
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=5ms, Records=1) in /root/website/actions/udfs.cfm @ 05:13:50.050
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) = 1723

get_member_account_types (Datasource=bookbrowse_com_new, Time=5ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:13:50.050
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=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:13:50.050
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) = 2017
Parameter #2(CF_SQL_INTEGER) = 2017
Parameter #3(CF_SQL_INTEGER) = 2017

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:13:50.050
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) = 2017

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:13:50.050
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=24ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:13:51.051
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=8ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:13:51.051
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=21ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
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=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
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 @ 05:13:51.051
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 @ 05:13:51.051
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
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=0ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:13:51.051
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFGLOBALS=urltoken%3DCFID%23%3D4089072%26CFTOKEN%23%3D9e483e748444868f%2D10006891%2D9C66%2D2EE0%2DC9052420B2E70227%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2005%3A13%3A50%27%7D%23hitcount%3D303%23timecreated%3D%7Bts%20%272026%2D06%2D01%2005%3A13%3A10%27%7D%23cftoken%3D9e483e748444868f%2D10006891%2D9C66%2D2EE0%2DC9052420B2E70227%23cfid%3D4089072%23; CFID=4089072; CFTOKEN=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227; 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
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/1250/author/norah-vincent
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=4089072
cftoken=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
hitcount=307
lastvisit={ts '2026-06-01 05:13:51'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 05:13:10'}
urltoken=CFID=4089072&CFTOKEN=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
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#=4089072&CFTOKEN#=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227#lastvisit={ts '2026-06-01 05:13:50'}#hitcount=303#timecreated={ts '2026-06-01 05:13:10'}#cftoken=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227#cfid=4089072#
CFID=4089072
CFTOKEN=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
FREEACCESSCOUNT=0
Session Variables:
cfid=4089072
cftoken=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
sessionid=BOOKBROWSE_4089072_9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
urltoken=CFID=4089072&CFTOKEN=9e483e748444868f-10006891-9C66-2EE0-C9052420B2E70227
URL Parameters:
author=norah-vincent
author_number=1250
Debug Rendering Time: 20 ms