Scott Stossel Interview, plus links to author biography, book summaries, excerpts and reviews

Scott Stossel
Photo: Michael Lionstar

Scott Stossel

An interview with Scott Stossel

A Q&A with Scott Stossel, author of My Age of Anxiety: Fear, Hope, Dread and the Search for Peace of Mind

Q: Was there a particular event or moment that made you decide to write this book or have you been thinking for some time about writing a book about anxiety?

A: Both. The idea had been gestating for years, since anxiety was a topic that had interested me for a long time. But the particular moment was when, during the months leading up to the publication of my first book in 2004, I became overwhelmed by anxiety about the book tour the publisher had planned for me, which included a few live TV shows and some public-speaking events in front of rather large numbers of people. I was terrified - convinced I was destined for terrible humiliation. I was already medicated and in psychotherapy, but in desperation I sought additional help from Boston University's Center for Anxiety and Related Disorders. As I recall, the Center's website advertised that it could cure some patients of public speaking anxiety in just a few sessions of Cognitive-Behavioral Therapy. Perfect! I thought. That's just what I need! But the site also warned that four to six weeks might elapse before a new patient could get evaluated and then set up with a therapist for treatment. I didn't have that kind of time! So I wrote an e-mail to Professor David Barlow, who was then the director of the Center, laying out my predicament and saying that I knew that because time was short the Center might not have any treatment slots available, but that I really needed help fast - and that, by the way, I was considering writing about my anxiety. I thought admitting this fact might draw attention and accelerate the process of my gett ing in for an appointment. Someone from the Center called the next day to set me up with an expedited evaluation and treatment. That was the moment I fully latched onto the book idea: I've always been interested in psychology and intellectual history - and, as my book tour began that spring, I clung tightly to the idea that if I did have a nervous breakdown in public, well, then at least that could be material for my next book, a rationalization that probably in some small way helped me to avoid such a meltdown.

Q: My Age of Anxiety is in part a memoir but is also an exploration of the history of anxiety and how it has been diagnosed, treated, understood, and misunderstood over time. Why did you decide to take this parallel approach to the subject?

A: I never had any intention of writing a straight memoir. My life isn't that interesting to me, so I couldn't imagine it would be terribly interesting to other people. But I realized that my personal experience with anxiety gave me a kind of writerly authority - not the authority of the academic expert or the clinician but of the anxiety sufferer. By writing a firsthand account of the phenomenology of anxiety, I thought I could provide something that might be interesting and/or useful to general readers, to anxiety sufferers - and perhaps even to those academic experts and clinicians. Also, what attracted me to writing about anxiety was the intellectual richness of the topic. It encompasses science, philosophy, culture, intellectual history - and it relates, in varying degrees, to religion, politics, sports, and myriad other things. But I worried that treating the subject as pure intellectual history could end up feeling dry and abstract. Putt ing myself into the book allowed me to provide a character that - I hope! - readers can relate to, and also to inject some levity into a dark subject. I ended up putt ing way more of myself into the book than I originally imagined - but that became necessary because my own struggles with anxiety ended up providing the main narrative engine of the book. My personal history became the glue for all the disparate material I wanted to cover - the history of psychiatric medication, performance anxiety, choking in sports, the genetics of anxiety, Freud, Kierkegaard, Hippocrates, Plato, the connection between anxiety and authoritarianism, the science of nervous stomachs, etc etc etc. My hope is that my subjective experience adds dimension and texture to the science and history - just as the science and history have provided depth and context to my experience.

Q: You are incredibly frank about your own experiences (and those of your family) and treatments, both in childhood and adulthood. As a journalist and editor who has written a lot about other people, how was it to open up about your own life?

A: Kind of excruciating - but my hope is that it will ultimately prove somewhat liberating. Actually, the writing about my own experience was not so bad - but that's because while I was writing the book I was able more or less to pretend that it would never come out. Which wasn't hard, actually, because I feared it would never come out. Now that it is coming out, I'm a litt le bit terrifi ed and a litt le bit mortified. The notion that certain specific individuals might read this - colleagues and former colleagues, long-ago acquaintances, my mother - makes me cringe. But the early responses have been reassuring. Several people who have read the proofs have told me they alternated between being able to relate to my experiences and feeling relieved that, as they put it, "Boy, I sure am glad I'm not as messed up as that guy!" I do hope that reading about my (sometimes prett y embarrassing) experiences will be useful to readers - both to those who suff er from severe anxiety, in allowing them to discover that they are part of a rather large tribe that extends back through history, and to those who don't, because in describing my anxious misadventures I'm also talking about ideas and scientific concepts that have relevance to all of our lives.

Q: You delve into so much science and pharmacology as well as philosophy, art and literature. How did you go about your research?

A: I spent a good part of last eight years trying to read everything I could get my hands on - not only the relevant historical material and works of philosophy and literature, but also a lot of the research that's published in scientific journals every month, and also the self-help books. I interviewed researchers and clinicians, and I att ended many academic conferences. At times, I worried I'd end up spending forty years researching anxiety and never get around to actually writing about it. Each summer when I'd see my uncle on vacation, he'd note the stack of books and articles I was toting around with me and then shake his head and ask me why I didn't just stop reading and start writing. But I was worried I'd fail to master all the material before I wrote the book. And of course I did fail. But I tried. And if anyone ever wants to visit a vast museum of anxiety-related material, just come up to my attic.

Q: You struggle to come up with a usable definition of anxiety (that say differentiates it from depression or other conditions), how would you defi ne it? Also, when did anxiety officially become a clinical category?

A: The "anxiety disorders" did not officially became a clinical category until 1980, with the publication of the third edition of the Diagnostic and Statistical Manual, which is the bible of the mental health field. Between, say, 1900 and 1980 - the heyday of Freudianism - what we would today call clinical "anxiety"was for the most part subsumed by categories like "neurosis" or "psychoneurosis." Before Freud, anxiety tended to be diagnosed clinically as "neurasthenia," or "melancholia," or "the vapors" - or as any number of a wide range of other diagnoses that tended to lump together both anxiety and depression. In my research, I came across hundreds, if not thousands of diff erent defi nitions of "anxiety," many of which contradicted one another. But the simple definition of anxiety I ended up using - borrowing from one of my therapists, Dr. W., who in turn was borrowing from Charles Darwin - is "apprehension about future suffering—the fearful anticipation of an unbearable catastrophe one is hopeless to prevent." Echoing Freud, Dr. W also makes a distinction between fear (which is produced by "real" threats from the world) and anxiety (which is produced by threats from within ourselves). In this view, anxiety is "a signal that the usual defenses against unbearably painful views of the self are failing." If you want a more official & technical definition, the current edition of the DSM defines anxiety as "The apprehensive anticipation of future danger of misfortune accompanied by a feeling of dysphoria or somatic feelings of tension. The focus of anticipated danger may be internal or external."

Q: The statistics are bracing. Rates of anxiety are rising along with the rates of those on medications to treat it. Some forty million Americans, or about eighteen percent of the population, now suff er from a clinical anxiety disorder. Are we gett ing more anxious? Or as you say might every age consider itself the most anxious?

A: Almost every age considers itself the most anxious. If you read back through history, you discover how almost every generation - going back to ancient times - laments how anxiety-wracked it is, claiming unprecedented levels of anxiety for itself. In some periods, claiming to be anxious - or "stressed," as we say today, or "neurasthenic" as we would have said in the 1890s—has been a self-flattering diagnosis, because it was thought to reflect a refined sensibility or good breeding or that you are hardworking and important. But some evidence suggests that certain eras truly are more anxious than others, and I think a pretty strong case can be made that the present era is one of them. Until the last few hundred years, your place in life - your job, your position in the economic system, your social role - as fixed from the moment of birth; you were born into the role you would inhabit. The unleashing of capitalism and individualism produced wondrous advances in standards of living and in freedom of opportunity - but this also produced a great deal of anxiety, by destabilizing old rules and social structures. The combination of abundant freedom to choose - not only about which of 387 breakfast cereals to buy but about what personal style to adopt, what career to pursue - with abiding economic uncertainty is powerfully "anxiogenic," as the experts say. Some argue that uncertainty is actually rewiring our brains to become more anxious. Plenty of statistics suggest high and rising levels of anxiety in the U.S and around the world. For instance, a majority of Americans say they are chronically stressed, many of them "highly" stressed. Far more people report being on the verge of nervous breakdown that a few decades ago. Some survey data suggests that the average high school student today has the same level of anxiety as the average psychiatric patient in the 1950s.

Q: You can't write a book about anxiety without talking about drugs. And your chronicle of this arena is at once fascinating and overwhelming. The debate seems endless on this front. Do they work? Are they dangerous? And as you have struggled with, from a real philosophical point, even if they help do they change the nature of you are (I think the way you put it is do they "diminish the soul")? After all the research and your own personal experiences, where do you stand on this issue?

A: Boiled down, here are five things I believe:
1. Psychiatric medication can be extremely effective for some anxiety-ridden people some of the time, and it is a necessary and valuable part of the therapeutic arsenal. For some people, it can be the difference between living in housebound misery and having a semblance of a normal life.
2. For some people, medication doesn't work at all - or works a little but with side effects that are too severe to be worthwhile. Some medications, in certain circumstances, can make patients worse - and it can prevent people from addressing underlying psychological or existential issues.
3. Medication can be dangerous, because of dependency and addiction issues; overdose potential; and impaired functioning.
4. Many more people than is necessary may be taking psychiatric medication, leading to a society thatis astonishingly drug-saturated. The drug companies - which I think on balance have done enormous good for the world, and for the clinically anxious - have succeeded, in cahoots with the psychiatric establishment, in vastly enlarging the disease categories for which drugs are prescribed. This is a real problem.
5. I do believe that psychiatric medication can "diminish the self," or alter it in ways that raise thorny philosophical questions. Yes, I realize some of these points seem to contradict one another. But this is a complicated set of issues, so I think that feeling a bit conflicted and confused is better than having a black-and-white ideological position about drugs. I wish I did not have to take these medications myself - but for now I sure am grateful they exist.

Q: You chronicle so many different schools of thought and every method of treatment. Is it our mother? Our environment? Our genes? Our mind v. our body? Is the most current research leaning in any one direction?

A: In some ways, current research is leading toward synthesis of these various schools of thought and methods. For instance, cognitive-behavioral therapists, who are more or less of behavior-and environment theory of anxiety, have begun experimenting with using drugs normally associated with the body-is-the-cause-of-anxiety school to augment the power of cognitive-behavioral therapy. To cite one specific example: research has shown that a drug called D-cyloserine can enhance the formation of new memories during exposure therapy for phobias. Another example: The academic research of one cognitive-behavioral therapist I worked with ("Dr M" in the book) focused on the respiration physiology of anxiety, looking at how breathing rates and CO2 levels relate to panic att acks. In other words, this was someone who used a "mind"-based approach to treatment, but whose understanding of anxiety clearly encompassed the body. Similarly, current research is finding out how meditation, another "mind"-based approach to anxiety reduction, has observable effects on the physical structure of the brain. Meditation has tangible effects on the body. But the areas where anxiety research seems to be advancing most rapidly are in neuroscience and molecular genetics - often in conjunction with one another. Scientists are learning which genes lead to which temperamental traits, and also which genes encode which brain functions, like serotonin or dopamine processing, and beginning to figure out how all this fi ts together. This holds the potential for transformative advances in our understanding of anxiety and in the development of better treatments for it.

Q: You actually underwent some of this genetic testing. Was it instructive? Do you think genetics could unlock some potential in terms of treatments?

A: I think the answer to the latter question is pretty clearly yes. Already, genetic research has shown some efficacy in predicting which genotypes will respond most favorably to which antidepressant andanti-anxiety medications. And some of the genetic research is helping scientists to grasp the underpinnings of "resilience," a trait that has been shown to be tied to resistance to and recovery from anxiety disorders and trauma. One danger lurking amidst all these new findings in behavioral genetics is the temptation to reduce everything to genes. While working on the book, I flirted with succumbing to this temptation myself, especially after I'd had myself tested for various gene variations. While it's clear that much of one's temperament and personality - and one's propensity to be anxious - derives from hereditary predispositions passed along via the genes, culture and nurture and life experience play a strong role in determining whether a genotype for, say, an inhibited temperament will turn into an anxiety disorder or depression. If one half of an identical-twin set has an anxiety disorder the other half is very likely also to have the disorder, which suggests anxiety is highly heritable - but this isn't true one hundred percent of the time, so factors other than genetics play roles in determining your levels of anxiety.

Q: Where are we now in terms of what's coming to the forefront of scientific thinking on anxiety?

You write about emerging research on resilience (and in fact that is title of the book's final chapter), what does resilience mean in this context?

A: Historically, in seeking the causes of and best treatments for psychopathology, researchers have tended to focus on what's wrong with the people who suff er from it: what abnormalities in thinking or behavior or brain systems or genes have produced a vulnerability to, say, anxiety or depression. But in recent years we've been looking also at what makes mentally healthy people resistant to anxiety and depression and asking what are the personal characteristics and thought processes and brain structures of people who are able to withstand stress and even severe trauma without breaking down? Modern researchers group many of these resistance-conferring traits under the umbrella of "resilience," which as a psychological term of art means roughly what it does colloquially: the ability to resist, or to rebound quickly from, the effects of stress or trauma, and to persist in the face of setbacks. Some recent neuroscience studies have been fi nding that having abundant quantities of a neurotransmitt er called Neuropeptide Y is highly predictive of resilience. For instance Navy SEALs and Army Rangers, who are selected in part based their psychological and physical resilience, tend to have exceptionally high levels of Neuropeptide Y. Emerging genetic research suggests that your baseline level of Neuropeptide Y is encoded by your genes - which suggests, in turn that how resilient you are is determined by your genes before birth. But other research is revealing that resilience can clearly be learned, and can be developed through training. The military is investing in research to determine how best to cultivate resilience. Dennis Charney, a professor of neuroscience at Mt. Sinai Medical School and one of the world's leading experts on the neurobiology of clinical anxiety, has done groundbreaking work in laying out the kinds of habits and traits - such as optimism, altruism, faith or spirituality, strong social support networks, a sense of purpose, a sense of humor etc - that bolster resilience. Crucially, resilience can be learned, and can be improved through practice - this was a hopeful fact that I, who sometimes tends not to feel terribly resilient, gleaned while writing this book. In the stressful, uncertain times we live in, cultivating resilience may be a valuable goal for all of us.

Q: You write, "It has occurred to me that writing this book might be a terrible idea." You even write about discussing the idea with your therapist. Yet early on in the process of writing this book you ask the question: "In all the insight into history and culture that a study of anxiety might produce, is there anything that can help the individual anxiety suff erer? Can we - can I - reduce anxiety, or come to terms with it by understanding the value and meaning of it." So, terrible idea or…?

A: The jury's still out. The process of writing it was stressful and anxiety-producing and often miserable but also, at times, rewarding. There were many moments when I felt like I'd be crushed under the weight of it. But I persisted - showing, I suppose, some modicum of resilience that I didn't know I had - and completed the book, which probably was good for my mental health. Now, of course, my greatest anxiety is about what actually publishing this book, and revealing my neurotic brain to the world, will be like. That may indeed be a bad idea. Is it too late for me to back out now? (NOTE FROM PUBLISHER: YES)

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 Scott Stossel at BookBrowse
My Age of Anxiety 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 Scott Stossel 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

  • Sasha Abramsky

    Sasha Abramsky

    Sasha Abramsky was born in England in 1972, grew up in London, and studied politics, philosophy, and economics at Balliol College, Oxford. He got his B.A. in 1993 and moved to New York to study journalism at the Columbia ... (more)

    If you enjoyed:
    My Age of Anxiety

    Try:
    Jumping at Shadows
    by Sasha Abramsky

  • Susan Cain

    Susan Cain

    Susan Cain is a writer whose work on introversion and shyness has appeared in the New York Times, Time, O Magazine, and PsychologyToday.com. She has taught negotiation skills at corporations, law firms, and universities and ... (more)

    If you enjoyed:
    My Age of Anxiety

    Try:
    Quiet
    by Susan Cain

We recommend 11 similar authors


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

BookBrowse Book Club

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

Members Recommend

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

Never doubt that a small group of thoughtful, committed people can change the world...

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 09:16 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
1780305398824 ms 1.78030539882E+012 ms 1 /root/website/app_server.cfm
464 ms 464 ms 1 /root/website/author_interviews/full/index.cfm
179 ms 179 ms 1 /root/website/app_layout.cfm
139 ms 139 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
126 ms 42 ms 3 /root/website/adsystem/adsystem_mod.cfm
114 ms 114 ms 1 /root/website/author_interviews/full/dsp_main.cfm
97 ms 97 ms 1 /root/website/app_globals.cfm
76 ms 76 ms 1 /root/website/adzones/AdZone6.cfm
60 ms 30 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
47 ms 47 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
46 ms 46 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_active_obc.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
31 ms 31 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
30 ms 30 ms 1 /root/website/adzones/showcase_track.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 7 ms 3 /root/website/site/blocks/membership_advantages.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
20 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_current_competition.cfm
13 ms 13 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
11 ms 11 ms 1 /root/website/act_check_login.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_member_info.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
6 ms 2 ms 4 /root/website/actions/act_spider_tracker.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_bb_briefs_by_author.cfm
4 ms 4 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/main_menu.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/main_search.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/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
465 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 09:16:38.038
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 09:16:38.038
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=8ms, Records=2) in /root/website/actions/adstatus.cfm @ 09:16:38.038
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 @ 09:16:38.038
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=8ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 09:16:38.038
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=5ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:16:38.038
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 @ 09:16:38.038
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 @ 09:16:38.038
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=7ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 09:16:38.038
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=23ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 09:16:38.038
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=7ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 09:16:38.038
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=21ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 09:16:38.038
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) = 2421

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 09:16:38.038
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) = 2421

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 09:16:38.038
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) = 2421
Parameter #2(CF_SQL_INTEGER) = 2421

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 09:16:38.038
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) = 2421

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=20ms, Records=11) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 09:16:38.038
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) = 2421

get_ads (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:16:39.039
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=4ms, Records=1) in /root/website/actions/udfs.cfm @ 09:16:39.039
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) = 3006

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:16:39.039
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=28ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:16:39.039
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) = 2985
Parameter #2(CF_SQL_INTEGER) = 2985
Parameter #3(CF_SQL_INTEGER) = 2985

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:16:39.039
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) = 2985

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:16:39.039
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) = 2121
Parameter #2(CF_SQL_INTEGER) = 2121
Parameter #3(CF_SQL_INTEGER) = 2121

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:16:39.039
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) = 2121

get_member_account_types (Datasource=bookbrowse_com_new, Time=5ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:16:39.039
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=17ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:16:39.039
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=28ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:16:39.039
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=49ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=10ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 09:16:39.039
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 @ 09:16:39.039
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:16:39.039
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=CFTOKEN=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245; 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%3D4093644%26CFTOKEN%23%3D34c4c3c68e319716%2D18B455CA%2DEC2A%2D139B%2DEA23573D27A01245%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2009%3A16%3A38%27%7D%23hitcount%3D47%23timecreated%3D%7Bts%20%272026%2D06%2D01%2009%3A16%3A31%27%7D%23cftoken%3D34c4c3c68e319716%2D18B455CA%2DEC2A%2D139B%2DEA23573D27A01245%23cfid%3D4093644%23; CFID=4093644
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/2421/author/scott-stossel
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=4093644
cftoken=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
hitcount=53
lastvisit={ts '2026-06-01 09:16:39'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 09:16:31'}
urltoken=CFID=4093644&CFTOKEN=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
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#=4093644&CFTOKEN#=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245#lastvisit={ts '2026-06-01 09:16:38'}#hitcount=47#timecreated={ts '2026-06-01 09:16:31'}#cftoken=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245#cfid=4093644#
CFID=4093644
CFTOKEN=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
Session Variables:
cfid=4093644
cftoken=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
sessionid=BOOKBROWSE_4093644_34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
urltoken=CFID=4093644&CFTOKEN=34c4c3c68e319716-18B455CA-EC2A-139B-EA23573D27A01245
URL Parameters:
author=scott-stossel
author_number=2421
Debug Rendering Time: 13 ms