Victoria Christopher Murray Interview, plus links to author biography, book summaries, excerpts and reviews

Victoria Christopher Murray
Photo: Rochelle Scott Design and Photography

Victoria Christopher Murray

An interview with Victoria Christopher Murray

A Conversation with Marie Benedict and Victoria Christopher Murray about the extraordinary life of Bella da Costa Greene, which they bring to life in The Personal Librarian

What about Belle da Costa Greene's story made it necessary to write?

MB: In general, I am a writer on a mission—to excavate from the detritus of the past the most important women of history and bring into the light of present day their world-altering contributions and the insights from the very modern issues with which they struggled—and my ultimate goal is to change the lens through we view not only the past but the present. I first encountered the main character in The Personal Librarian when I was a lawyer in New York City, and I'd retreat to the Morgan Library as a place of refuge and sanctuary when I was frustrated with the career, which I knew wasn't my calling. While there one day, a docent mentioned The Personal Librarian to J. P. Morgan, Belle da Costa Greene, and I became fascinated with this woman who became one of the most powerful people in the art world, although there was very little information available about her at that time. When I decided to focus exclusively on historical fiction about women, Belle was always on my list of women I wanted to write about. But until I met Victoria, I didn't feel ready to delve into a book about her, because at the core of Belle's identity is her decision to pass as white even though she was a "colored" woman who'd been raised by a prominent advocate for racial equality in our country. And she rose up to prominence at a time of racism so rampant she likely would not even have been allowed entrance into the very institution she ran. I knew I needed a partner of color to tell the story with me, and Victoria has become more than a partner—she's a sister.

VCM: Honestly, I'd never heard of Belle da Costa Greene until my agent brought me the proposal from Marie. But the moment I heard about her, I wanted to tell her story. I wanted people to know her contributions. I wanted people to know that behind that incredible Morgan Library was a woman...a Black woman who I didn't want to be lost inside history.


Tell us about some of the research you did for the book. What was your most surprising discovery?

MB: The book required an enormous amount of research into the following topics: (1) the life and legacy of Belle da Costa Greene, (2) the life and legacy of J. P. Morgan and his son Jack, (3) the life and legacy of Richard Greener, (4) the life and legacy of Bernard Berenson, (5) the art and rare book world in the early twentieth century, (6) the history and creation of the Morgan Library, (7) the Gilded Age of New York high society, (8) the rise of suffragism and bohemian culture in the early twentieth century, (9) the general political realm in America in the early twentieth century, (10) the sociological and cultural context of the decision by African Americans to pass as white in the first half of the twentieth century, and most of all, (11) the racial landscape in the post–Civil War, post–Reconstruction America, focusing particularly on the rise of white supremacy and the Jim Crow laws as well as the movement toward equality. For me, the most surprising discovery was the insidious, rampant, and far-reaching tentacles of racism and segregation throughout the entire time period from the book—from the early 1900s through the 1940s. Each time I read about a lynching or a terrible piece of Jim Crow-esque legislation, I was horrified and devastated by the cruelty that proliferated during the whole of Belle da Costa Greene's life, leaving me even more in awe of Belle's accomplishments. And the danger inherent in the life she led.

VCM: Marie was the primary researcher for the book because historical fiction is her expertise. But I learned so much from her. I read An Illuminated Life, the biography of Belle da Costa Greene, and then I went searching deep into the Internet following one article after another. The most surprising thing that I found was that there were people who questioned Belle's ethnicity and some accused her of being Cuban. We put that reference in the book.


The Personal Librarian gives readers a deep look into Belle's career as well as her inner life. How did you bring together her inward thoughts and emotions for the book?

MB: Only by working together—discussing every scene, examining every character, studying the historical context—do I believe Victoria and I were able to delve into the inner life of Belle da Costa Greene. I could never have done it alone, and I would have never tried. How could I? Victoria's generosity and trust in sharing her personal experiences with race and her family's history with passing and racism gave me a very different lens through which to view the past and imagine Belle's existence. When we then came together to envision Belle and her private thoughts and feelings, Belle came to life.

VCM: That wasn't too much of a challenge for us. I think it was so important that her story was told from the eyes of a white woman and a Black woman. I knew what Belle was thinking; I knew what she was feeling because of the stories I'd been told by my grandmother and other people who had passed.


What was your favorite true story about Belle that you included in the book?

MB: Belle's life was rife with almost unbelievable encounters, friendships, and events, so much so that her daily existence is nearly unimaginable. Consequently, it's challenging to narrow it down to one favorite true story. That said, I found myself to be particularly proud of Belle's success in the spring of 1911 in purchasing the rare William Caxton edition of Thomas Malory's Le Morte Darthur at the Hoe auction. In securing this book, she achieved the seemingly unreachable goal that J. P. Morgan had set out for her, and she did so in the face of fierce competition in a much-anticipated and heavily watched auction. This prize forced her to face one of her greatest fears—the publicity she worried would reveal her deepest secret, her "colored" identity. Buying this particular Caxton at this particular auction meant that she'd have to face the press head-on, and while she was a celebrity in her own right, she'd successfully avoided intense journalistic scrutiny so far. But she rose up proudly and triumphantly to accept both her prize and her recognition—thereby securing at least one facet of her legacy.

VCM: I don't know if there is one particular part of the story that is all true. We weaved truth with fiction on every page. For example, my favorite storyline in the book is the sexual tension that was between J. P. Morgan and Belle. Now, we don't know that; we weren't there. But that storyline came from a statement Belle did make when someone asked her if she and Mr. Morgan had ever had an affair. Her response: "We tried." So we took the truth of those words and ran with it. That is one of my favorite storylines that runs throughout the book.


What were some of the best vignettes that you had to leave on the cutting room floor?

MB: Again, because Belle's day-to-day life was so extraordinary, there were countless vignettes and intriguing tidbits of information that we could not include in the book, for fear that readers would not find the story believable! Some of the best nuggets we left out include: (1) details about her friendships with well-know women of her day such as the actress Sarah Bernhardt, the dancer Isadora Duncan, and the writer Gertrude Stein, (2) information about her alleged affairs with several men as well as her supposed engagements, (3) the rumors about her purported romantic relationships with women, (4) the fact that she had her portrait done by many fine artists including Paul Helleu, William Rothenstein, and even the legendary Henri Matisse, (5) any specifics about the "nervous collapses" to which she was occasionally prone, although we certainly allude to her drinking issues, (6) her interest in Catholicism that sparked during the time period of the book but really developed in her latter decades as a corollary to her close friendship with Father Hyvernat with whom she collaborated on the Coptic manuscripts' restoration, and last but certainly not least, (7) her role as a surrogate parent to his sister Teddy's son, Robert Leveridge, which she took over when her sister remarried after her husband died in World War I.

Despite the fact that there are many flashy and often incredible tidbits we omitted from the book, one intriguing, not-quite-as-showy vignette is my particular favorite. In 1909, on a week away with friends, she encountered John D. Rockefeller at a resort in Hot Springs, Virginia. They'd met before, but they connected on this trip, talking for hours about business and their origins, although Belle undoubtedly altered hers quite a bit. As part of their gallivanting during that week, Rockefeller taught Belle how to drive a car, something she'd longed to learn how to do and a skill she relished using for the rest of her life. I particularly like this one specific tale because, while it is incredible to think of Belle being taught to drive by the famous Rockefeller himself, it isn't something she ever talked about as far as we know, except in a single letter to Bernard Berenson. For her, it was just another day in the life of Belle da Costa Greene, which only reveals how astonishing her life really was.

VCM: We took out something that was important in Belle's life, but we would have had to develop it so much more that it could have been its own story. Belle's younger sister Teddy had a child that Belle eventually raised. There is so much to that relationship and he passed away at a relatively young age. I would have loved for that to be part of this story.


Do you relate to Belle in any way?

MB: While I cannot fully imagine what it must have been like to walk in Belle's shoes, certain aspects of her life felt awfully familiar to me. That lonely, isolated sensation of being the only woman in the room—a feeling Belle experienced every day at the Morgan Library, at art auction houses, and in meetings with her colleagues as she was one of a handful of professional women in her field and the only one operating at her level—is one I am well acquainted with from my early days as a young lawyer at large law firms in New York City. In conference rooms, courtrooms, mediations, and meetings, I was often the only woman and treated as such; while this has changed today, when I first entered the legal field at that level, women were scarce, particularly in partnership and leadership roles. In addition, as someone who certainly pretended at several aspects of my existence—not the least of which was pretending at embracing a career as a lawyer—I identified with the weight of inauthenticity that Belle was forced to carry every day of her life, although, of course, my burden was far less than the one Belle shouldered.

VCM: Yes!!! I relate to Belle just as a Black woman. I've never passed, of course, but I imagine that when Belle walked out of her apartment every day, she had to put on an act. She had to live in a world that didn't fully accept her. More than one hundred years later, I feel the same way.


What do you think is Belle da Costa Greene's legacy?

MB: I believe that Belle left a vast indelible imprint upon the art world in the first half of the twentieth century in her taste, her erudition, and her expertise. But she did much, much more for the larger population by building up the phenomenal collection at the Morgan Library and ensuring that it—not only its unparalleled assemblage of rare books, manuscripts, drawings, prints, and ancient artifacts but also its status as a major cultural center for fine art, literature, and music—became a public institution, available not just to the wealthy and the scholarly but to individuals and organizations everywhere. The number of people who have been inspired, influenced, and educated by the legacy she left us with the Morgan Library is incalculable. Yet Belle's legacy could have been—and still could be—vaster still if her full background and identity had been known and accepted during her lifetime and in the decades beyond. Just imagine how much Belle herself could have galvanized people and changed perspectives, even racist ones, if it became known—then and now—that the collection of one of our country's greatest cultural benefactors had been assembled by a brilliant African American woman who instigated its status as a public institution.

VCM: I think Belle should be given credit for the hashtag #BlackGirlMagic. She survived and thrived in a white man's world. She did it with class and grace and built that library to a preeminent place that is still standing.


Victoria, what was it like to write a historical fiction novel after publishing so many contemporaries?

VCM: At first, I was a little intimidated by not only the language, but how were people supposed to communicate without a dang telephone? Ugh! Then, I embraced it and grew to love it. I had to research what a living room would look like, or what appliances were in a kitchen, or how in the world did you tell your girlfriend you wanted to meet up for beers on Friday. I love historical fiction now and I think my readers may be surprised at some of my future work.


Marie, what was it like finally writing a book that you've been thinking about for so long?

MB: It has been a gift beyond anything I could have anticipated, in part because of the wonder of Belle's life and legacy and in part because of the astonishing friendship and kinship I now share with Victoria, a relationship that truly altered how I see race in our country.


What was your cowriting process like for this book? Also what did you gain from writing The Personal Librarian together?

MB: When I think of us writing this book, I remember the two of us on Zoom for hours on the editing process, talking through the details and arc of Belle's life and deciding how we'd tackle the different editorial tasks necessary for each scene while racism and white supremacy unspooled throughout our country. From the confrontation unfolding in Central Park between Amy Cooper and Christian Cooper to the horrific death of George Floyd and spread of the Black Lives Matter movement, together we watched a critical, epiphanous moment unfurl in American society—and we talked about all of it. With candor and trust, we looked directly at this terrible moment together and I, at least, saw it all so differently through Victoria's eyes; I could no longer see the world we inhabit without wondering how Victoria sees it, how it affects her. For me, it was utterly transformative, and I realized how little I knew about the struggle and how removed I had been, how protected by own white privilege I really was. And how much I had to learn and how much I had to do. Then we would dip back into Belle's world only to see the same sort of racism and white supremacy as we were seeing in our own time—recognizing the parallels and concluding that, in both eras, racism surged when the promise of equality mounted. And we realized how change was imperative and how necessary it was that we use this book to help facilitate that change. The writing process and our relationship was life-altering and certainly transfigured our book and our Belle.

VCM: Cowriting this was one of the best experiences of my life, and I don't mean just my writing life. First, I learned so much from Marie about writing historical fiction (and sticking to deadlines, which are normally just suggestions for me!). I'd done collaborations before, so I kind of led Marie through that part. We had become fast friends, with a lot in common and that made it easier to write together, too—because we like each other and felt safe enough to say what worked and what didn't work. But then Marie and I were taken on some kind of...I don't even know what to call it...an emotional awakening. We were doing the edits during the early days of the pandemic and when the streets of America erupted with social unrest. Marie and I talked every day, not only about the book, but about what happened in the news that day. The world was moving fast and it was so amazing to talk to my "white sister" about this. And Marie was just as eager to hear my thoughts. Every single day, I had a safe place to talk about racial issues with someone who didn't look like me. Like I said, one of the best experiences of my life—and many of the things we discussed ended up on the pages of this book. And what did I gain? A sister for life!


What do you hope readers will take away from reading The Personal Librarian?

MB: We hope that Belle and her story have the capacity to make people think, discuss, and perhaps, change. Sometimes the distance of history can help people see things that are occurring in our own world—throwing them into bold relief, in a way—and it is a dream of ours that The Personal Librarian can help guide people toward a fresh, even revolutionary, way of thinking and acting about race. That said, we recognize, in part, that our metamorphosis occurred as a result of the special friendship Victoria and I share, and consequently, we hope that, somehow, we could gather people together—white, African American, and other people of color—to read and discuss The Personal Librarian, replicating even a little of our own experience. Perhaps if people were brought together in book clubs or otherwise to process Belle's story together and the inequality and racism of her world and then witness how Victoria and I were able to bridge the gap between us by honestly and plainly discussing the issues inherent in the book and in our society—issues so often shied away from—then we might be able to make a bridge toward change and get one step toward the equality about which Belle's father, Richard Greener, wrote and for which he fought.

VCM: I hope they will get to know Belle as well, but I'm really hoping that readers can have the experience reading that Marie and I had writing together. Belle lived in two worlds — Black and white. She brought those worlds together, which is why Marie and I came together to write this story. I'm so hoping some readers will seek out other readers and have that experience.

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 Victoria Christopher Murray at BookBrowse
Harlem Rhapsody jacket The First Ladies jacket The Personal Librarian 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 Victoria Christopher Murray 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

  • Marie Benedict

    Marie Benedict

    Marie Benedict is the New York Times and USA Today bestselling author of The Queens of Crime, The Mitford Affair, Her Hidden Genius, The Mystery of Mrs. Christie, The Only Woman in the Room, Lady Clementine, Carnegie's Maid, ... (more)

    If you enjoyed:
    The Personal Librarian

    Try:
    The Mystery of Mrs. Christie
    by Marie Benedict

  • Brit Bennett

    Brit Bennett

    Born and raised in Southern California, Brit Bennett graduated from Stanford University and later earned her MFA in fiction at the University of Michigan, where she won a Hopwood Award in Graduate Short Fiction as well as the... (more)

    If you enjoyed:
    The Personal Librarian

    Try:
    The Vanishing Half
    by Brit Bennett

We recommend 4 similar authors

View all 4 Read-Alikes

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

BookBrowse Book Club

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

Members Recommend

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

The dirtiest book of all is the expurgated book

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 03:50 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
1780285816772 ms 1.78028581677E+012 ms 1 /root/website/app_server.cfm
256 ms 256 ms 1 /root/website/author_interviews/full/index.cfm
82 ms 82 ms 1 /root/website/app_layout.cfm
76 ms 76 ms 1 /root/website/author_interviews/full/dsp_main.cfm
75 ms 75 ms 1 /root/website/app_globals.cfm
60 ms 20 ms 3 /root/website/adsystem/adsystem_mod.cfm
44 ms 44 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
26 ms 26 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
24 ms 24 ms 1 /root/website/adzones/showcase_track.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_active_obc.cfm
19 ms 19 ms 1 /root/website/actions/adstatus.cfm
18 ms 18 ms 1 /root/website/adzones/AdZone2.cfm
18 ms 18 ms 1 /root/website/adzones/AdZone6.cfm
17 ms 9 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
14 ms 14 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_current_competition.cfm
12 ms 4 ms 3 /root/website/site/blocks/membership_advantages.cfm
9 ms 3 ms 3 /root/website/queries/qry_get_member_account_types.cfm
6 ms 6 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
5 ms 5 ms 1 /root/website/act_check_login.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
3 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.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/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_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
257 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 03:50:16.016
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=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:50:16.016
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=18ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:50:16.016
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 03:50:16.016
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=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:50:16.016
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=6ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:50:16.016
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=5ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:50:16.016
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 03:50:16.016
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=4ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:16.016
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=3ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:16.016
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=15ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:16.016
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=8ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:50:16.016
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) = 3524

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

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=1ms, Records=3) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 03:50:16.016
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) = 3524
Parameter #2(CF_SQL_INTEGER) = 3524

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:50:16.016
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) = 3524

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=4) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:50:16.016
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) = 3524

get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:16.016
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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:16.016
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=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:50:16.016
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=6ms, Records=1) in /root/website/actions/udfs.cfm @ 03:50:16.016
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) = 4276

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:50:16.016
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=4) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:50:16.016
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) = 3310
Parameter #2(CF_SQL_INTEGER) = 3310
Parameter #3(CF_SQL_INTEGER) = 3310

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:50:16.016
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:50:16.016
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=7ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:50:16.016
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=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:16.016
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:16.016
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:16.016
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=5ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:50:16.016
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 03:50:16.016
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:17.017
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:17.017
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:17.017
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=FREEACCESSCOUNT=0; CFTOKEN=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23message%3DFull%20access%20to%20%3Ci%3EThe%20BookBrowse%20Review%3C%2Fi%3E%20is%20for%20members%20only%2E%3Cbr%3E%0A%09%09%09%09%09%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Fjoin%22%3E%3Cb%3EBecome%20a%20member%3C%2Fb%3E%3C%2Fa%3E%20%7C%20%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Flogin%3Fnext%5Furl%23%3D%2Fmag%22%3E%3Cb%3EMember%20login%3C%2Fb%3E%3C%2Fa%3E%20%7C%20%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Flibrary%22%3E%3Cb%3ELibrary%20patron%20login%3C%2Fb%3E%3C%2Fa%3E%23; CFID=4084722; CFGLOBALS=urltoken%3DCFID%23%3D4084722%26CFTOKEN%23%3De18c33460c854425%2D0D05E071%2DB590%2DEE21%2D2B58757AEE4B8199%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A50%3A16%27%7D%23hitcount%3D172%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A49%3A53%27%7D%23cftoken%3De18c33460c854425%2D0D05E071%2DB590%2DEE21%2D2B58757AEE4B8199%23cfid%3D4084722%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/3524/author/victoria-christopher-murray
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=4084722
cftoken=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
hitcount=175
lastvisit={ts '2026-06-01 03:50:16'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:49:53'}
urltoken=CFID=4084722&CFTOKEN=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
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#message=Full access to <i>The BookBrowse Review</i> is for members only.<br>
					<a href#="https://www.bookbrowse.com/join"><b>Become a member</b></a> | <a href#="https://www.bookbrowse.com/login?next_url#=/mag"><b>Member login</b></a> | <a href#="https://www.bookbrowse.com/library"><b>Library patron login</b></a>#
CFGLOBALS=urltoken=CFID#=4084722&CFTOKEN#=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199#lastvisit={ts '2026-06-01 03:50:16'}#hitcount=172#timecreated={ts '2026-06-01 03:49:53'}#cftoken=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199#cfid=4084722#
CFID=4084722
CFTOKEN=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
FREEACCESSCOUNT=0
Session Variables:
cfid=4084722
cftoken=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
sessionid=BOOKBROWSE_4084722_e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
urltoken=CFID=4084722&CFTOKEN=e18c33460c854425-0D05E071-B590-EE21-2B58757AEE4B8199
URL Parameters:
author=victoria-christopher-murray
author_number=3524
Debug Rendering Time: 11 ms