Bryn Turnbull Interview, plus links to author biography, book summaries, excerpts and reviews

Bryn Turnbull
Photo: Louise Claire Johnson

Bryn Turnbull

An interview with Bryn Turnbull

Two Interviews with Bryn Turnbull: The Last Grand Duchess, which chronicles the fall of the Romanovs, and The Woman Before Wallis, the story of Thelma Furness, the woman who lost Edward Prince of Wales to Wallis Simpson.

The Last Grand Duchess

Why write about Olga, rather than her better-known sister Anastasia?

As a frequently impersonated historical figure (the subject of an animated Fox movie) Anastasia holds a lot of interest to modern audiences—but as the protagonist of a book which focuses on the political dynamics surrounding the fall of the Romanovs, she's less compelling. Anastasia was a sixteen-year-old girl when she died, and an incredibly immature sixteen-year-old at that. Unlike her eldest sister Olga, who wrote frequently in her diaries about the political climate in Russia, Anastasia had teenage preoccupations: crushes, gossip, and lessons. By contrast, Olga was ideally situated not only as an intellectually engaged spectator to the last days of the Empire, but also as an active participant: of her siblings, she had the closest relationship with her father, giving her in-the-room access to the abdication and its aftermath, and her war-work as a Red Cross nurse gave her a unique perspective on how the war impacted not only the nobility, but the Russian population at large.

And of course, as a more mature young woman, Olga's personal life provided a real fascination as well. A grand duchess who falls in love with an officer? What author could resist?

Why was Alexandra so enthralled with Rasputin?

Given her popular reputation as a morose and withdrawn woman, it is perhaps surprising to learn that Alexandra's childhood nickname was "Sunny" – but by the time we meet Alexandra- also known as Alix - in The Last Grand Duchess, the weight of the world has fallen on her shoulders. Though her marriage to Nicholas II was absolutely a love match, by 1903 she'd failed in her one task as empress: to produce a son and heir for the Russian throne. She'd given birth to four daughters, of course, but Russian law barred them from the line of succession.

Alix was an insecure woman at the best of times, and the fact that high society had begun to mutter about whether Nicholas had chosen the wrong wife surely weighed on her mind. She loathed public events, never made much of an effort to ingratiate herself with the St. Petersburg elite (preferring to see herself, in a romantic and patronizing way, as the mother of the low-born Russian peasantry), and was awkward in a crowd: moreover, she'd never managed to get much of a handle on the Russian language, which further alienated her from the high society women who would otherwise have been her friends and confidantes.

Given the pressures of her public role and her private insecurities, it's not surprising that a man like Rasputin – who was pious, low-born, willing to say what Alix wanted to hear, and able to help her vulnerable son – was able to become such an invaluable support.

Did the scene with the seer actually happen?

Yes. Alexandra's visit to the seer at Nizhny Novgorod is well documented, and absolutely eerie – in her diaries, Olga writes of the patchwork curtain that covered the seer's cot, and describes the seer as wearing iron fetters, claiming that she looks "107 years old."

The seer's warning to Alexandra – "Behold the martyred Empress" – comes to us from a couple of different sources. Olga herself notes in her diary that the seer told Alexandra that it would "all be over soon" and that "everything would be all right"; Anna Vyrubova and Ida Buxhoeveden, who both accompanied the Imperial family on the trip, recount the moment more dramatically: both of them state that the seer cried out "Behold the martyred Empress," though Buxhoeveden claims that Alexandra didn't hear the warning. In my retelling of the scene, I wanted to strike a chord between Olga's recollection and the retainers' more melodramatic descriptions – especially given the fact that both Vyrubova and Buxhoeveden wrote about the visit after the fact, and most certainly with an eye to posterity.

You wrote The Last Grand Duchess in 2019/2020. How did the pandemic affect your research process?

I began working on The Last Grand Duchess at the end of 2019, and as with The Woman Before Wallis, I'd planned on visiting the locations where the book takes place. To that end, I was in the process of arranging a research trip to St. Petersburg when the first lockdown threw my plans into disarray.

As much as I would have liked the opportunity to visit Russia, research can always be done from the comfort of home – thank you, internet! Given the amount of documentation on the Romanovs – memoirs, documentaries, newsreels, diaries, historical accounts, and more – there was more than enough to go by to come to an understanding of the characters. In terms of location-scouting, I was lucky enough to have Youtube – so many people have posted their videos of Alexander Palace and the Winter Palace online, so there was plenty for me to work with in the absence of physically going there myself.

Strangely enough, the pandemic also led to new insights about my characters. In Ontario, we went through an extended at-home lockdown, and while the lockdown in no way resembled the house arrest that the Romanovs endured for the last months of their lives, it did give me an appreciation for the monotony and uncertainty of what their days must have been like.

Do you think Nicholas II understood how he'd failed Russia as an emperor?

Historically, Nicholas II was an ineffectual ruler, one who believed that his birthright gave him carte blanche to do and say what he liked. According to him, as emperor he was God's chosen representative on earth – therefore, he believed that any conclusion he made on Russian government policy was, by definition, God-given.

Of course, this meant that Nicholas was incredibly susceptible to manipulation by his advisors. It was said that the last person who spoke to Nicholas on a given topic tended to get their way; paradoxically, he was also known for being incredibly polite and accommodating to his advisors, then turning around and doing whatever he'd planned to do in the first place. He also insisted on having final say on pretty much everything that went on in Russia, whether or not he had any real understanding of the issue at hand, which meant that government moved agonizingly slowly: how could it not, when Nicholas was bogged down in the minutiae of so many different portfolios? As a result, it was very difficult to get anything done in the court of Nicholas II, which absolutely contributed to the destabilization of the country in the early days of the First World War.

The real tragedy about Nicholas was that, as ill-equipped as he was to be Emperor, he never truly wanted to the job in the first place: he would have been content as a gentleman farmer, or as a minor Russian nobleman. To Nicholas, the only thing that mattered, both before the Revolution and after, was his family. Had he been able to live a quiet life as a family man, he would have been quite content.

What did you enjoy most about writing this book?

As a student of history, I'd been familiar with the story of the Romanovs for a long time, but the thing I enjoyed most about writing this book was coming to a deeper understanding of who the family was, not as symbols but as individuals. Olga's passion, Anastasia's impishness, Maria's good nature and Tatiana's practicality… so often, the Romanovs are seen as tragic figures, and of course they were, but they were also living, breathing people: a devoted, loving, family that shared jokes, played games, had disagreements, and enjoyed each others' company. The circumstances of their deaths notwithstanding, this was a deeply committed family with their virtues and flaws, just like any other. I hope that I managed to reflect who they were as people.

The Woman Before Wallis

Everyone knows the story of Edward and Wallis. What drew you to Thelma's story instead?

Thelma's affair with Edward is only aspect of her story because she was not only on the periphery of the abdication crisis, but also the biggest custody battle in U.S. history to date. She can easily be dismissed as a socialite—famous for being famous—but she was also strongly principled, and willing to stand up for those she loved. Other people have written beautifully about Wallis and Edward, but Thelma's story deserved to be told on its own merits.

This novel contains the real-life stories of real life people—some of whom have living descendants. How did you balance the drive to tell a good story against the historical record in terms of character development?

It's a tricky balance to strike, but at the end of the day my job is to tell a good story, taking as much historical fact into consideration as I can without sacrificing the plot. I spent a lot of time researching the people who make up my book: luckily, Thelma and Gloria wrote a memoir, and we have plenty of letters, biographies, and recordings of Edward VIII and Wallis Simpson, so by the time I started actually writing, I had a very good sense of who they were. Wallis in particular leapt out of the pen, and I think that's because she's left such a legacy behind. I certainly hope that they would see themselves in the characters I've created, but at the end of the day these are fictional representations.

How did you find Thelma's story?

I'd long been interested in the abdication crisis and had read biographies of Wallis Simpson before, but I'd never really picked up on Thelma's story until I watched W.E., a movie directed by Madonna about Wallis and Edward's relationship. In the film, we see Wallis and Thelma have the conversation where Thelma asks Wallis to "take care" of Edward for her while she's travelling, and I remember thinking it was such a strange request to make of a friend—even one as close as Wallis was to Thelma. After watching the movie I found myself down a bit of a Wikipedia rabbit hole, where I discovered her connection to the Gloria Vanderbilt trial and recognized that this was a story that ought to be told.

One of the major relationships in this novel is between Gloria and Nada. Why was it important to you to show a relationship between two women in the 1930s?

I truly believe that Gloria loved Nada, and had they lived in a different time period their story would have ended quite differently. What's more interesting to me is the fact that their relationship was permitted because of social privilege—and when Gloria lost that privilege, their relationship fell apart.

How does Gloria's experience as a queer woman shape Thelma's actions?

To me, The Woman Before Wallis is a love story—but it's not a royal romance. While the abdication crisis looms large over Thelma's life, this is a book about the love between sisters: Thelma supported her sister in a day and age when being gay was seen as unacceptable—except, as Gloria points out, in the highest echelons of society. In the history books, Thelma has often been dismissed as a lesser socialite, but when it comes down to it, she was a deeply principled woman, and her experience as an ally spoke to me.

After spending so long with his character, how do you feel about Edward VIII and his decision to abdicate?

I think Edward VIII would have found an excuse to abdicate, regardless of whether Wallis Simpson had come into his life or not. He was a fundamentally weak man, and would have made a fundamentally weak king—and while in my novel I have him discuss the sort of king he wants to be with Thelma, I don't think he ever honestly intended to take up his crown. If it hadn't been Wallis, he would have found another excuse to abdicate.

That said, Thelma was genuinely in love with him. It was important for me to find a way into that love, and to be able to portray him with some compassion.

Edward VIII and Wallis Simpson are known to have been Nazi sympathizers. Why don't you address this in your book?

I don't address it for three reasons. First, Thelma and Edward's relationship ended in 1934. Hitler only became chancellor in 1933, so while he would have been a topic of conversation around the dinner table, he wouldn't have been the main topic of conversation. Second, Thelma was not a political person. One of the biggest complaints the government levied against Wallis Simpson was her political activism—in fact, when it became clear Edward wouldn't give Wallis up, the government floated the idea of inviting Thelma back to England to catch Edward's eye again because she wasn't seen as someone who would interfere in politics the way Wallis did. Finally, the sad fact is that many members of Britain's upper crust had extreme right-wing leanings in the 1930s, and many were generally supportive of Hitler's policies. At the time, socialism was seen as a far greater threat than fascism, particularly because the General Strike of 1926 had been so successful in disrupting industrial production. Oswald Mosley's British Union of Fascists had 50,000 members at the height of its popularity in the 1930s.

In the end, I find it incredibly interesting that history shook out in such a way that Britain had the king it needed during the war. Could you imagine what would have happened if George VI hadn't been on the throne during the Blitz?.

Do you think Wallis intended to replace Thelma?

I don't think she did. Whatever else has been written about her—and there has been a lot written about her—Wallis was extremely ambitious. I believe that Wallis was genuinely trying to keep Edward's eye from straying, for Thelma's sake, but when it became clear that his affection had transferred to her, she didn't feel too much guilt in taking advantage of the situation.

She certainly didn't intend to marry Edward—that much is clear. In 2011, Anne Sebba published a biography of Wallis Simpson which contains previously unpublished letters between Wallis and Ernest Simpson—she wrote to him until the end of his life, and expressed regret at having ended their marriage. I believe that Wallis had hoped to take advantage of Edward's attraction to make new friends and move in the highest social circle in Britain. She genuinely believed that Edward would tire of her before too long—when he didn't, I think she was as surprised as anyone else.

What did you enjoy most about researching this book?

I wasn't on any fixed timeline to complete this book, so I was able to spend two full years researching—just researching!—the time period. I particularly enjoyed researching the fashion of the 1930s– the attention to detail is incredible, especially for someone who had Thelma's budget. I was able to access a lot of newspaper articles about the Vanderbilt trial at the New York Public Library, which really helped me understand the frenzy that the trial had created. A photographer actually did try to rappel down the side of the courthouse to get a picture of the proceedings! The trial reached newspapers in Pakistan! I went to London and walked Thelma's neighbourhood—while Duke's Arlington townhouse is no longer there, I visited her home in Mayfair and had drinks in the Ritz.

My favourite research moment, though, was finding Edward's plane, and while I wish I'd had the right place to put it in the manuscript, it did help me come to an understanding of who he was as a person. One of his planes is at the Vintage Wings museum in Gatineau, Quebec, and I was able to visit it: it's a beautiful little biplane with an open cockpit and a closed cabin for passengers. The plane itself looks like a Rolls Royce, with beautiful a chrome and indigo body and burgundy leather interior: but the best part of it is that Edward had a small generator installed on one of the wings so that he could power a wireless radio. While that sounds like a good idea, Vintage Wings was kind enough to take me up in a plane of a similar age, and I was struck by how unbelievably loud it was up in the air. Even with headphones on, it would have been extremely difficult to hear anything on a wireless.

I think this really sums up who Edward was. He was so concerned with his image—with looking and feeling like a modern royal—that he forgot to take into account the practicalities of the situation.

Also, see the Book Club Kit for a "Behind the Book" essay, discussion guide. recipes and a timeline.


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 Bryn Turnbull at BookBrowse
The Last Grand Duchess jacket The Woman Before Wallis 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 Bryn Turnbull 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 Last Grand Duchess

    Try:
    Lady Clementine
    by Marie Benedict

  • Melanie Benjamin

    Melanie Benjamin

    Melanie Benjamin is the New York Times bestselling author of The Children's Blizzard, Mistress of the Ritz, The Girls in the Picture, The Swans of Fifth Avenue, The Aviator's Wife, The Autobiography of Mrs. Tom Thumb, and ... (more)

    If you enjoyed:
    The Last Grand Duchess

    Try:
    The Aviator's Wife
    by Melanie Benjamin

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

Harvard is the storehouse of knowledge because the freshmen bring so much in and the graduates take so little out.

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
1780285855910 ms 1.78028585591E+012 ms 1 /root/website/app_server.cfm
612 ms 612 ms 1 /root/website/author_interviews/full/index.cfm
239 ms 239 ms 1 /root/website/author_interviews/full/dsp_main.cfm
190 ms 190 ms 1 /root/website/app_layout.cfm
177 ms 89 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
106 ms 106 ms 1 /root/website/app_globals.cfm
106 ms 106 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
90 ms 30 ms 3 /root/website/adsystem/adsystem_mod.cfm
45 ms 45 ms 1 /root/website/adzones/AdZone6.cfm
44 ms 44 ms 1 /root/website/queries/qry_get_active_obc.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
34 ms 34 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
32 ms 32 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
31 ms 31 ms 1 /root/website/adzones/showcase_track.cfm
23 ms 23 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
23 ms 23 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
21 ms 21 ms 1 /root/website/site/blocks/layout/main_menu.cfm
20 ms 20 ms 1 /root/website/adzones/AdZone2.cfm
20 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
20 ms 7 ms 3 /root/website/site/blocks/membership_advantages.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_competition.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_member_info.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
4 ms 1 ms 4 /root/website/actions/act_spider_tracker.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
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/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_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
614 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:55.055
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:50:55.055
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=6ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:50:55.055
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:55.055
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=5ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:50:55.055
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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:50:55.055
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:50:55.055
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:55.055
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=16ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:55.055
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=21ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:56.056
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=6ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:50:56.056
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=15ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:50:56.056
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) = 3388

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

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:50:56.056
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) = 3388

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=20ms, Records=10) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:50:56.056
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) = 3388

get_ads (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
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=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
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:56.056
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=9ms, Records=1) in /root/website/actions/udfs.cfm @ 03:50:56.056
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) = 4403

get_member_account_types (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:50:56.056
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=153ms, Records=4) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:50:56.056
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=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:50:56.056
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=5ms, Records=5) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:50:56.056
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) = 1801
Parameter #2(CF_SQL_INTEGER) = 1801
Parameter #3(CF_SQL_INTEGER) = 1801

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:50:56.056
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=8ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:50:56.056
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1
and getdate() <= dateadd(day,1,a.arc_off_ad_dt)

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=23ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:50:56.056
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=21ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
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:56.056
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=22ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:50:56.056
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:56.056
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:50:56.056
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=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4084757; CFGLOBALS=urltoken%3DCFID%23%3D4084757%26CFTOKEN%23%3D121be115a344f179%2D0D0DD080%2DA25E%2D8323%2D3EABB768E898E0B9%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A50%3A55%27%7D%23hitcount%3D75%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A50%3A45%27%7D%23cftoken%3D121be115a344f179%2D0D0DD080%2DA25E%2D8323%2D3EABB768E898E0B9%23cfid%3D4084757%23; CFTOKEN=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9; FREEACCESSCOUNT=0
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/3388/author/bryn-turnbull
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=4084757
cftoken=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
hitcount=82
lastvisit={ts '2026-06-01 03:50:56'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:50:45'}
urltoken=CFID=4084757&CFTOKEN=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
view=books
Cookie Variables:
CFCLIENT_BOOKBROWSE=order=p#member_number=0#member_active_flag=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4084757&CFTOKEN#=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9#lastvisit={ts '2026-06-01 03:50:55'}#hitcount=75#timecreated={ts '2026-06-01 03:50:45'}#cftoken=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9#cfid=4084757#
CFID=4084757
CFTOKEN=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
FREEACCESSCOUNT=0
Session Variables:
cfid=4084757
cftoken=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
sessionid=BOOKBROWSE_4084757_121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
urltoken=CFID=4084757&CFTOKEN=121be115a344f179-0D0DD080-A25E-8323-3EABB768E898E0B9
URL Parameters:
author=bryn-turnbull
author_number=3388
Debug Rendering Time: 36 ms