Sarah Bird Interview, plus links to author biography, book summaries, excerpts and reviews

Sarah Bird

Sarah Bird

An interview with Sarah Bird

Two interviews with Sarah Bird. In the first, she describes why she wrote The Flamenco Academy and why she chose to portray the experience of obsessive love through the lens of Flamenco dancing. In the second, she discusses what it was like growing up as a 'military brat' in the 1950s and 60s, like the characters in her novel, The Yakota Officer's Club.

How did you decide to take on the subject of Flamenco for a novel?
The one subject that I always knew I wanted to write about was an obsessive love affair I had that began when I was 16 and fell in love at first sight with a deliriously handsome young man and remained so until I was 23. For years I tried to capture this experience on paper, but it always came out as a suburban melodrama.

When I was 20 and living with Beloved, I walked in on him in bed with a friend. Realizing that I had to put at least an ocean between us or I would never break free, I went to Europe. So, dazed and heartbroken, I hitchhiked and Eurailed for a year and a half. During that time I found a job as a tour guide in a botanical garden owned by White Russian émigrés on Spain’s Costa Brava. One very late night, very early morning, in a tiny club outside of Barcelona, I saw an astonishing performance of what I would learn later was flamenco.

Flamenco was the first materialization I’d witnessed that mirrored my tumultuous inner landscape. Decades later, as I was struggling to make a novel convey the experience of obsessive love, I recalled that night. The passion and intensity of flamenco, its insistence upon revealing the unrevealable, fit the emotional truth of the story I wanted to tell. I began a fumbling, stumbling study of flamenco and quickly discovered how dauntingly vast and impenetrably arcane the subject is. I live in Austin, Texas, not a hotbed of flamenco activity. I was despairing of ever cracking the flamenco code when I learned that my alma mater, the University of New Mexico, was becoming the academic center of flamenco! That each summer the UNM flamenco program hosted a festival that drew every flamenco star in the world. Submerging myself in classes and performances, I began to understand a bit about this art that only truly reveals itself in the moment of performance.

The University of New Mexico’s vibrant flamenco scene was a gift from the universe not only in terms of research but also in providing a setting for my young protagonists. Exactly the same one where, thirty years earlier, I’d enacted my drama. Flamenco’s other great gift to me is that, as one of my character puts it, “Flamenco is OCD with a beat.” Flamenco dancers, guitarists, singers are obsessed and do become compulsive about their art.

Possibly best of all is that flamenco demands the same sort of transformation that my obsessive love affair did. My heroine, Rae, goes through the flamenco dance program in order to transform herself into someone that Tomás, the object of her adoration, will fall in love with.


Was it exhilarating to write about a dance that is so symbolic of passion? And what is it you were drawn to about this dance in particular?
Writing about flamenco was extremely intimidating. I chose flamenco thinking it was the embodiment of wild, anarchic abandonment built on unstructured improvisational outpourings and learned that el arte is as strictly regimented as haiku. Every stomp of a foot, every strum of the guitar, must fall precisely within a certain rhythmic pattern called el compás and that there are probably fifty different styles or palos. The other daunting fact I learned about flamenco is that it is an insider’s art. Experts, aficionados, and buffs abound and they all have very strict ideas about what is and is not flamenco puro.

At the times when I could manage to stop worrying about those battalions of experts and sort of channel the years of research, it was exhilarating to feel that, perhaps, I was putting on the page a distillation of both of flamenco and obsessive love.


The Flamenco Academy is a departure from your other novels, most recent of them the wonderful Yokota Officers Club, in that the others were more comic in tone. What made you decide to make this one different and was it hard to leave the humor behind?
There was never any choice about leaving humor behind. I love humor. I love writing it, I love reading it, but a novel about obsessive love is not the place for it. Humor is a distancing mechanism. Mostly a good one, it lets us detach enough that we can talk about tragedy and taboos, fears and failings. But I could not have distance or detachment in this novel. It was hard to leave humor behind. So hard, in fact, that two years ago, when I was utterly stuck and despairing, and too many other hard things were happening in my life, I took a break and wrote a novel that had only one purpose: to cheer me up. If an idea or a character or a line cheered me up, in it went. I’m rewriting it now.


How much research did you have to do and where?
Colossal, titanic, gargantuan amounts. I did all the live stuff in New Mexico, took classes, sat in on lectures, interviewed performers, watched the world’s best dancers, singers, and guitarists. Fortunately, back home in Austin, the library system is quite good and I had access to the University of Texas’s system as well. So I was able to do all the parts that involved holing up in carrels and filling out innumerable index cards in Austin.

I’ve been asked repeatedly if I went to Spain. No, modern-day Spain would not have helped unless I could have visited in a time machine. The parts of the novel that are set in Spain take place from, roughly, 1920 until the end of the Spanish Civil War. Though, if I did have that time machine, I would return to the Golden Age of Flamenco, around the turn of the last century when flamenco flowered in the cafes cantantes, the singing cafes, of Andalusia. That period entrances me. Maybe it’s the gaslight.


In your acknowledgments, you not only thank your teachers in flamenco, but also the astonishing guitarists who elucidated and inspired you. How?
Once I decided to attend the flamenco festival and take classes, I knew I would need something to keep my then-13 year-old son, Gabriel, occupied. He’d been studying guitar, so I signed him up for a beginning flamenco class. In the most amazing and necessary of coincidences, his teacher turned out to be an old friend of mine from high school, John Truitt, who generously allowed me to audit his class. I already knew that John is a lovely human but quickly discovered that he is a brilliant musician and, possibly, the best teacher I’ve ever witnessed. He electrified and elucidated me and the entire class.

In long conversations, John shared the history of flamenco in New Mexico and helped me understand how a guitarist and dancer work together. Best of all, he taught Gabriel the rhythm structures so that later, back in Austin, he could break them down for his old ma.

Some of the other guitarists I mentioned shared both technical information and stories from their own lives about romances with fiery Gypsy dancers and the intricate hierarchy of the flamenco world.


As there was with The Yokota Officers Club, are there always autobiographical elements in your fiction?
Yes, though I would say that The Flamenco Academy is both my most autobiographical book and the least. The most in the sense that I reveal the utter irrationality and humiliating self-annihilation of my obsessive love affair. The least in that none of the particulars of the story correspond to my own other than that they both took place in New Mexico and, like Rae, my protagonist, I ate a lot of chile cheeseburgers at the Frontier Restaurant!

Actually, answering this reminds me of another autobiographical link. Like most people, I have a semi-mythological relationship to the place where I came of age. In my case, it was along a fairly funky strip of Route 66. So, it was great fun for me to mythologize some of the landmarks of my teen years, the Aztec Motel, De Anza coffee shop, Pup and Taco drive-through, my high school just a few blocks off the main drag, Frontier Restaurant, the divey motels that were the sites of many a teen bacchanal.


In the opening of the book, you mention that Flamenco has 10 Commandments. The first being to give the truth and the second to do it en compás, or in time. Can you reveal any of the others?
Hah! I am and always will be an outsider in that world. In flamenco, you have to do the thing to truly understand the thing. So, ultimately, each artist discovers different commandments. Some applying only to him or her.


Do you recommend that mere mortals try it? Or just go and observe? And what happens at the big Festival in Albuquerue each year?
Yes, yes, yes! I wrote an article for Oprah’s magazine about being a fumble-footed, middle-aged matron trying to get my flamenco groove on. The “beginners” class was filled with professional dancers, owners of dance studios, teachers, so it was hardly the beginning I needed.

Because of the interest the article generated, the festival has added a true beginner’s class which, I hear, is an uproarious amount of fun. One thing I can testify to, however, ten days of flamenco hand twirls and my Carpal Tunnel was cured! Praise Jesus!


After this, do you know what you might write about next or is it too soon?
I’m working on my cheer-up novel, Weightless, right now. It grew out of knowing so many women—highly-educated, ambitious, bright—who had either just lost their jobs or had jobs with health insurance that was so bad, they couldn’t afford to get a Pap smear. It sounds facetious, but an entire political philosophy is revealed here.

So, I created a character who’d been brought low by divorce, (from a husband who bears an uncanny resemblance to W.), by the pop of the Internet bubble, and by losing her moral compass. And then I make her move back into her college co-op boarding house. It’s a riches to rice cakes story.


A Conversation with Sarah Bird, author of the novel The Yokota Officers Club

Q. What is your novel about?

A. The Yokota Officers Club is about how hard military life is on families. My protagonist, Bernie Root, sees this for herself after her first year of college. She visits her Air Force family stationed on Okinawa and notices how much they’ve disintegrated in the year they’ve been away. She starts to search for reasons why. While on the island, Bernie wins a dance contest. The prize is a trip to Tokyo where Bernie’s family was stationed for the only happy years of her childhood. The catch is that Bernie is the intermission act for a third-rate comedian, Bobby Moses, who believes she is going to be Joey Heatherton to his Bob Hope. While in Japan, Bernie learns the terrible cost paid when secrets that nations hide end up buried within families.

Q. You’re a military brat yourself. What was that like?

A. This novel is my big, gushy Valentine to military families, but especially to dependents, the children and wives in those families. My particular experience of growing up brat was defined by being the shyest in a family of eight fairly introverted human beings. Like the family in my novel, we were stationed on Yokota and Kadena and too many others to mention, and, my father did fly Cold War reconnaissance missions, but after we were transferred out of Japan, he ended up doing fairly non-military things like getting a doctorate and running Department of Defense Schools. My mother was always the antithesis of the white gloves and girdle sort of officer wife. All of this made us something of our own little tribe of nomadic recluses, outsiders within this greater tribe of outsiders permanently passing through America.

Q. You mentioned the secrets that nations hide. Did any actually end up getting buried in your family?

A. Not specifically, but this book did grow out of an exceptionally vivid memory I have from my family’s years in Japan. I was six at the time and we were living off-base "on the economy." It was a hot day, the hydrangeas were drooping in the sun and our small yard was saturated with the sweet smell of honeysuckle that hung from the high barbed wire fence around our house. My brothers and sisters and I were playing in the swimming pool my mother had rigged up from a large packing crate and some plastic sheeting. Though I didn’t know it at the time, she was pregnant with my third brother.

This was 1956 which was, essentially, the tail end of the American occupation, and my father had been gone for several weeks on "TDY," temporary duty assignment about which no questions were ever asked. He simply left on these assignments then, one day, with no warning, he would return. Sometimes with ginger jars from China. Sometimes with ivory carvings from Alaska. Details were never supplied. But on this day something unusual happened. Not only did an official staff car appear in our neighborhood, where giant American vehicles were rarely sighted, but this car carried my father’s commanding officer in full uniform. When the car stopped and the major got out, I felt all the sleepy summer air molecules around my head reverse polarity. I looked at my mother and though nothing showed on her face, I knew in that instant that the appearance of a uniformed officer at our house in the middle of the day meant tragedy beyond what I could imagine. Because no explanations were ever given for why my mother ended up sobbing in this officer’s arms, I went on to create my own stories about what might have happened.

It took many years before I understood that "reconnaissance" meant spying and it wasn’t until I was researching this novel I learned that of the ten crews that originally made up my father’s reconnaissance squadron, his was the only one that survived. Or that the Distinguished Flying Cross he had been awarded wasn’t for perfect attendance. Or that the major had come to our house that long ago day simply to tell my mother that my father’s crew had had engine trouble and would be coming home later.

Q. How has your family reacted to the novel?

A. In my dedication, I thank my family for their great gift of understanding and accepting my capricious weaving of fiction through our shared past. And they really have been colossally generous because there are many similarities between my family and the one I created. We are both families of eight, we lived on Japan, on Okinawa, we didn’t transplant easily. Then I take all that shared experience and mash it through, what the pulp writer Earle Stanley Gardner called, "The Plot Genie." So that some family members are removed, others are added, the mother ends up with a prescription pill problem and the father is silent and removed neither of which was true of my abstemious mother and garrulous father. But the larger truth is that, in fact, many, many wives were "over-served" by doctors at base dispensaries eager to keep wives slim and tractable, and most fathers of that time were silent and removed. My great blessing then is that no one in my family has fixated on these points where fact and fiction intersect and have accepted the book as the tribute I intended it to be.

Q. Since your main character is a girl growing up as the daughter of an Air Force Officer, do you see this at all as a sort of female version of Pat Conroy’s novel The Great Santini?

A. Only in my wildest, most self-deluded fantasies. The Great Santini is the dependent’s Rosetta Stone. It was the first and remains the most definitive portrait of the military family. I was in such awe of Conroy’s achievement in decoding the vast hieroglyphic of our world that I didn’t consider writing about my own brat experience for decades. Then I began getting little prickles that suggested something might remain to be said about all the women whose lives rotate around military men. And I mean all the women: wives, mothers, daughters, teachers, nurses, maids, sew girls, bar girls, pan pan girls, yes, even, go-go girls.

Q. You manage to bring a lot of great, vivid detail to the description of life overseas and on bases in the ‘50s and ‘60s. Did you rely on anyone else’s recollections beyond your own for the specifics?

A. My brothers and sisters helped me tremendously, especially with the parts about Okinawa, since they were there year-round for three years and I only visited during the summers. Their memories of the Kadena Karnival were especially vivid and borderline traumatic: the habu-mongoose fight, the Okinawana "exotic" dancer sticking a snake’s head in her mouth, the novelty act guy catching ping pong balls in his mouth then pretending to excrete them. These are research topics that Encyclopedia Britannica just can’t help you with.

Q. Would you have any desire to go back to those places in Japan from your childhood?

A. Well, I did go back. Like my heroine, I won a dance contest and toured the military clubs in Tokyo area with a third-rate comedian. This was in 1968. In the eight years since we’d left Japan, the country had been transformed. When we left, it was a child’s fantasy land of shopkeepers who gave you handfuls of fish oil gum just for being a child, of paper houses that glowed like golden lanterns in the night, of days where giant cloth carp were flown just to honor boys and girls, and hovering above the whole dreamscape, always pink in my memory, was Mount Fuji. Of course, it is always jarring when childhood memory encounters reality, but to have those fairy tale memories collide with what I found when I returned, visions of people sucking up oxygen on street corners because the air was so polluted (it was impossible any longer to see Fuji from where we’d once lived), was a shock.

What I would dearly love would be to go back to the Japan of my childhood. And, I suppose, I made as good an attempt at that as I’m likely to by writing The Yokota Officers Club.

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 Sarah Bird at BookBrowse
Daughter of a Daughter of a Queen jacket Above the East China Sea jacket The Gap Year jacket How Perfect Is That 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 Sarah Bird 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

  • Peter Carey

    Peter Carey

    Peter Carey was born in 1943, in Bacchus Marsh, Victoria, Australia. His parents, who had a General Motors dealership, sent him to Geelong Grammar School, one of the leading private schools, "where the children of Australia's... (more)

    If you enjoyed:
    The Flamenco Academy

    Try:
    Theft
    by Peter Carey

  • Therese Anne Fowler

    Therese Anne Fowler

    Therese Anne Fowler is the third child and only daughter of a couple who raised their children in Milan, Illinois. An avowed tomboy as a child, Therese protested her grandmother's determined attempts to dress her in ... (more)

    If you enjoyed:
    Daughter of a Daughter of a Queen

    Try:
    A Well-Behaved Woman
    by Therese Anne Fowler

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

Read the best books first...

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 02:53 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
1780282384362 ms 1.78028238436E+012 ms 1 /root/website/app_server.cfm
649 ms 649 ms 1 /root/website/author_interviews/full/index.cfm
220 ms 220 ms 1 /root/website/app_globals.cfm
187 ms 187 ms 1 /root/website/author_interviews/full/dsp_main.cfm
109 ms 55 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
106 ms 106 ms 1 /root/website/app_layout.cfm
95 ms 32 ms 3 /root/website/adsystem/adsystem_mod.cfm
74 ms 74 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
59 ms 59 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
46 ms 46 ms 1 /root/website/queries/qry_get_active_obc.cfm
36 ms 36 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
35 ms 35 ms 1 /root/website/adzones/AdZone2.cfm
35 ms 35 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
34 ms 9 ms 4 /root/website/actions/act_spider_tracker.cfm
34 ms 34 ms 1 /root/website/adzones/showcase_track.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_current_competition.cfm
32 ms 32 ms 1 /root/website/actions/adstatus.cfm
30 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
29 ms 29 ms 1 /root/website/act_check_login.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_member_info.cfm
28 ms 28 ms 1 /root/website/adzones/AdZone6.cfm
28 ms 9 ms 3 /root/website/queries/qry_get_member_account_types.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
10 ms 10 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
6 ms 6 ms 1 /root/website/site/blocks/layout/dsp_header.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/site/blocks/dsp_border_booktalk.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
649 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

adactive (Datasource=bookbrowse_com_new, Time=31ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:53:04.004
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 @ 02:53:04.004
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=36ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:53:04.004
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=20ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:53:04.004
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:53:04.004
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 @ 02:53:04.004
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 @ 02:53:04.004
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=19ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:53:04.004
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=17ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:53:04.004
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=45ms, Records=3) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:53:04.004
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) = 841

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=29ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:53:04.004
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) = 841

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=22ms, Records=6) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 02:53:04.004
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) = 841
Parameter #2(CF_SQL_INTEGER) = 841

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=16ms, Records=3) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 02:53:04.004
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) = 841

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=21ms, Records=17) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 02:53:04.004
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) = 841

get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=22ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
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=18ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:04.004
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=8ms, Records=1) in /root/website/actions/udfs.cfm @ 02:53:04.004
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) = 3814

get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:04.004
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=70ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:04.004
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) = 556
Parameter #2(CF_SQL_INTEGER) = 556
Parameter #3(CF_SQL_INTEGER) = 556

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=23ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:53:04.004
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) = 2023
Parameter #2(CF_SQL_INTEGER) = 2023
Parameter #3(CF_SQL_INTEGER) = 2023

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:53:04.004
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=5ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:53:04.004
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=10ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:53:04.004
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=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
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=8ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:53:04.004
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 @ 02:53:04.004
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:04.004
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 @ 02:53:04.004
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:53:05.005
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=
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/841/sarah-bird
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=4083038
cftoken=f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
hitcount=1
lastvisit={ts '2026-06-01 02:53:04'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 02:53:04'}
urltoken=CFID=4083038&CFTOKEN=f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
view=books
Cookie Variables:
CFID=4083038
CFTOKEN=f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
Session Variables:
cfid=4083038
cftoken=f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
sessionid=BOOKBROWSE_4083038_f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
urltoken=CFID=4083038&CFTOKEN=f7cda9b5216c316c-0AFDC083-CD6F-507B-D9D621EFA9FE4AA4
URL Parameters:
author_number=841
sarah-bird=
Debug Rendering Time: 13 ms