Michelle Moran Interview, plus links to author biography, book summaries, excerpts and reviews

Michelle Moran

Michelle Moran

How to pronounce Michelle Moran: mo-RAN

An interview with Michelle Moran

Read two interviews with author Michelle Moran - in the first, she discusses the real Madame Tussaud, and in the second she explains the inspiration for her first novel, Neferititi, and the historical details on which it's based.

This page includes two interviews with author Michelle Moran; in the first, she discusses the real Madame Tussaud, and in the second she explains the inspiration for her first novel, Neferititi, and the historical details on which it's based.

Michelle Moran on the Real Madame Tussaud

What drew you to the story of Marie Tussaud?

My interest in Marie Tussaud began on my very first trip to London. Like thousands of tourists before me, I had decided that I wanted to visit the famous wax museum, Madame Tussauds. At the time, I knew almost nothing about the woman behind the name, but as I passed through the exhibition, I began to piece together what would ultimately prove to be a fascinating story. In the first wax tableau I came across, Marie Tussaud had modeled Queen Marie Antoinette with her husband and children. They looked young and happy, dressed in lavish court gowns and silk culottes. In another tableau, the mistress of King Louis XV lay sprawled on a couch, her blonde hair tumbling down her shoulders. Clearly, Marie Tussaud had been interested in modeling the celebrities of her day. Some she would have sculpted from memory, while many she would have met and modeled in person. Marie's art had obviously gained her access to some of the highest circles in French society.

But in a third tableau, a different part of Marie Tussaud's life emerged. Dressed in a black gown and dirtied apron, a young Marie could be seen holding up a lantern in the Madeleine Cemetery. The Revolution had begun, and she was searching through a pile of severed heads - all victims of Madame Guillotine. Immediately, I wanted to know what was she doing in that cemetery. Whose heads were they, and did she know those people? When I learned what Marie Tussaud went through during the French Revolution - who she'd met, where she'd gone, and what she'd seen - I knew I would someday tell her story.

Why does history tend to remember the French Revolution as being successful?

Probably because it did exactly what its leaders intended, which was to deal a devastating blow to the aristocracy. But very soon after the overthrow of the monarchy, France's new government became obsessed with idea of rooting out Royalists. A fever like that of the Salem Witch Trials gripped France, and neighbor began turning on neighbor, accusing each other of being royalists. And it didn't take much to be sentenced to the guillotine. By 1793, all a person had to do was whistle the wrong tune or disrespect a liberty tree (saplings planted in the name of "liberty") to be accused of endangering the nation. By the end of the French Revolution, more than five hundred thousand French citizens had been killed, most of them commoners.

How did you go about researching Madame Tussaud?

I began with a trip to France, where nearly all of the novel takes place. Once there, I tried to visit the locations Madame Tussaud herself would have seen. Some - such as the Bastille - no longer exist, but there are others - Versailles being the sublime example - where a great deal of 18th century life has been preserved. After my trip, I did as much research as I could in libraries. Finally, anything I couldn't find in books I tried to discover through email conversations with some very generous French historians.

What is the most interesting fact you learned while researching Madame Tussaud?

That in 18th century France, most people went to street dentists when they had a toothache. These dentists would sit at a table laid out with various tools, and their unfortunate patients would have their teeth extracted right there, in the dirty street. After the extraction, the patient could sell his tooth (or teeth, if he was unlucky) to the dentist, who would then sell it to people like Marie Tussaud for her wax models. I know... creepy and disturbing!

In your research about Marie Antoinette, did you come away feeling sorry for Queen Marie Antoinette?

Yes. I think the queen was as much a victim of circumstance as she was her own naiveté. While it's true that she held lavish balls in Versailles and spent a fortune on gowns, this really wasn't anything new for the monarchy. The difference was that it was Marie Antoinette, and not the king, who was doing the spending. The resentment and jealousy which built up around the queen having access to her husband's money earned her some powerful enemies at court. Meanwhile, the commoners were growing resentful as well. Yet the entire royal family's expenditures were actually a small fraction of the nation's budget, and whenever Marie Antoinette tried to economize, the courtiers who counted on her favors would raise a hue and cry. Various nobles had grown accustomed to the extra money they could earn from selling the dresses she had already worn or the accessories which had been ordered for her (often far more than she actually needed or used). These privileges were jealously guarded in Versailles, and this meant that the queen was "damned if she did, and damned if she didn't."

Why are we still interested in Madame Tussaud 250 years after her birth?

I think the fascination with Madame Tussaud comes from the fact that the life she created was as intricate and mystifying as her artistry itself. Here was a woman who was asked to tutor the king's sister, yet she managed to keep her head during the Reign of Terror when women were being imprisoned for nothing more than wearing the wrong color. She navigated two very different worlds - the court of Versailles and the streets of Paris - and against all odds, lived to tell the tale. And through it all, it was her artistry that saved her. Today, with digital cameras available to capture everything around us, you would think it would be difficult to become enthusiastic about seeing a person's likeness reproduced in wax. But there is something compelling about waxworks, particularly those done at the various Madame Tussauds around the world. Perhaps it's the thrill of pretending to photograph yourself next to a celebrity, or getting to pose with Henry VIII "in the flesh," that keep customers coming back. Or maybe it's the eerie and arresting vision of a lifeless object that so closely mimics someone's humanity that people relate to. Whatever it is, I think Madame Tussauds will be a major draw even in another two hundred and fifty years.

If Madame Tussaud were alive today, would she be happy to see that her wax museums have expanded not only throughout Europe, but now the world?

I think Marie Tussaud would be ecstatic. Having grown up on the Boulevard du Temple surrounded by actresses and showmen, Marie was taught from a very young age that publicity was the difference between staying in business and having to sell your teeth in order to buy bread. Today, the Madame Tussauds wax museums do a wonderful job of finding new subjects to model, and the public unveilings of their new wax figures would have absolutely delighted Marie. A part of me wants to say, "If only Marie could see her museum now," but something tells me she wouldn't be surprised at all by how popular her exhibition has become.



Michelle Moran discusses her first novel, Nefertiti

What inspired you to write about a queen who's been dead for over three thousand years?

My love-affair with Egyptology began in the summer of 1998 on an archaeological dig in Israel. While our team was working to unearth an ancient trading post, we came across a scarab, proof that the Egyptians had traveled north, perhaps selling cloth, incense, or Nubian gold. Looking at the mysterious lapis stone in the dirt, untouched for who knew how many years, I was hooked. It wasn't long before I found myself wandering through Egyptian exhibits in Los Angeles, London and finally Berlin, where the stunning bust of Nefertiti rests behind a case of polished glass. Even three thousand years later it fills the viewer with the same awe that citizens of Amarna must have felt when they saw her. I wondered who she was, what her story must have been, and as I began researching into Nefertiti's life I was surprised to discover how many books and internet sites were devoted to her, yet there were no fictionalized accounts exclusively about her reign, one of the most enigmatic of any Egyptian Pharaoh-Queen. Spurred on by Nefertiti's untold story, I visited Egypt on an historical tour two years later, gathering books and writing down impressions of what had once been the most powerful kingdom in the East. When I returned to America, I began researching into Nefertiti's Egypt, scouring libraries and initiating dialogues with the contacts I made in the archaeology world.


Did Mutnodjmet really exist?

Yes, Mutnodjmet really existed, as did Nefertiti, Queen Tiye, Akhenaten, Vizier Ay, Lady Kiya, General Horemheb, General Nakhtmin... Suffice it to say that almost every character in the book was based on an historical personage.

So how much of the story is true?

While the main historical events are accurate, such as Ay's rise to power, Akhenaten's obsession with Aten, the dream of Amarna, and Nefertiti's unparalleled influence at court, liberties were taken with personalities, names and minor historical events. For instance, no one can be certain how Mutnodjmet felt about her sister's vision of an Egypt without the Amun Priests, but in an image of her found in Amarna she is standing off to one side, her arms down while everyone else is enthusiastically embracing Aten. In a period where art attempted to portray reality for the first time, I found this significant. And while Nefertiti did have six daughters with Akhenaten, she never, so far as we know, produced twins the way she did in the novel. Historical uncertainties revolve as well around the questions of whether Amunhotep the Younger ever had a co-regency with his father, or whether Nefertiti ever did rule on her own. These are questions that can only be answered by conjecture, and I went with what seemed most plausible given the historical evidence.

Today, some of these questions could be answered by a firm identification of the Amarna mummies. Although much of Kiya's funerary equipment was found in her son Tutankhamun's tomb, little to nothing remains that was Akhenaten's or Nefertiti's. How old was Nefertiti when she died? What killed Tiye? Dr. Joann Fletcher contends that a cache of mummies found in tomb KV55 are the bodies of Nefertiti and the Dowager Queen. If so, they were stunning beauties even in death.


Isn't there evidence that Nefertiti was banished to a Northern Palace towards the end of her husband's reign?


No. This belief was predicated upon an inscription on the Northern Palace which archaeologists believed read "Nefertiti." The name had been removed from the palace while Nefertiti was still alive and replaced with the name of Princess Meritaten. If Princess Meritaten had truly removed her mother's name from the palace, it would indeed seem to indicate a daughter taking the place of her mother. However, the inscription was later discovered to actually read "Kiya." After Kiya's death Nefertiti and her daughter set out to erase the existence of Nefertiti's only real rival. Unfortunately, many internet sites haven't bothered to update their information, so the erroneous theory of Nefertiti having been banished persists.


Is it true that Akhenaten had Marfan Syndrome?

There is absolutely no anthropological or DNA evidence to suggest this was the case. Those who believe that Akhenaten had Marfan Syndrome, a genetic disorder characterized by unusually long limbs and curvature of the spine, do so simply because some of his statues show a man with long arms and an elongated head. It is essential to remember, however, that Akhenaten purposefully changed the artistic style which all of his predecessors had used, creating a new style known today as Amarna Art. For as many images as there are of Akhenaten with a long, leonine face and feminine hips, there are just as many images from when he was a child displaying none of these startling features. During the Amarna period, all of Akhenaten's family begins to appear with long arms, elongated heads and large hips, even Nefertiti. It is highly unlikely that the entire royal family had this connective tissue disorder, particularly in light of Nefertiti's bust which resides in Berlin and shows none of the characteristics that those with Marfan Syndrome typically display.


What evidence is there to prove that Nefertiti ever ruled as Pharaoh on her own?

This depends on which Egyptologist you ask and what camp they fall into. Amunhotep IV changed his name to Akhenaten, and when Nefertiti became co-regent with her husband she changed her name to Ankhkheperura-Neferneferuaten. It is not beyond the limits of plausibility, then, to imagine that Nefertiti later became Pharaoh Ankhkheperura-Smenkhkara, who ruled briefly after Akhenaten's death. A beautiful gold figurine in Tutankhamun's tomb depicts a female Pharaoh (not a queen) walking atop an ebony leopard. Egyptologists have dated the figure back to Akhenaten's reign, which means there is only one possibility of who this feminine ruler of Egypt could be: Nefertiti. There is also evidence of foreign correspondence during Pharaoh Ankhkheperura-Smenkhkara's time that points to Egypt's Pharaoh being Nefertiti. If you want more information about this, I suggest checking out the work of Dr. Joann Fletcher, who wrote The Search for Nefertiti: The True Story of an Amazing Discovery and whose work was featured on the Discovery Channel. Dr. Fletcher stirred up quite the controversy with this book and her announcement that she discovered the body of Nefertiti.


In the novel you write about the ancient Egyptians using toilet seats and copper razors. Is this accurate?

Yes, it is accurate. Dating as far back as 1500 BCE, palaces were more comfortable than you or I might imagine given that it was 3,500 years ago. The wealthy shaved with copper razors and bathrooms were discovered in Amarna equipped with toilet seats that matched the limestone sink bowls. Royal women regularly applied face cream, eye shadow and lipstick. Women had elaborate containers for their makeup, and very wealthy women carried handheld mirrors made of polished brass the way women carry purses today.


If Nefertiti ruled on her own, then who would have been her queen?

Just as Hatshepsut made herself Pharaoh and her daughter queen, Nefertiti would have named her eldest daughter Meritaten as her consort. Surprising though this may seem, rulers of Egypt searched for balance, the feminine with the masculine, and in religious ceremonies it was necessary to have a female part which Pharaoh, as a "man," couldn't play.


How long did it take you to write Nefertiti: A Novel?

Over two years, then another year to edit it, and a fourth to publish. A common misconception amongst non-writers seems to be that as soon as an author signs a contract the book comes out just a few months later. Would that were so! Instead, the process seems to take forever. Up to a year and a half after the contract is signed the book might hit stores, or nine months if an author is really lucky.


How are the characters' names pronounced?

One of the most difficult aspects of translating hieroglyphics is the fact that the ancient Egyptians did not record vowels. So Amun might really be Amon or Amen, and Tutankhamun might equally be Tutankhamen. Some of the names in the book are quite hard to pronounce, and I think most readers can figure out why I chose to shorten Mutnodjmet to Mutny. Here's a few of the more difficult ones.

Mutnodjmet: Muht-know-gmet

Nefertiti: Ne-pher-tee-tee

Akhenaten: Ahh-khen-ahh-ten

Ankhesenamun: Ankh-es-sen-ah-moon

Tutankhamun: Toot-ankh-ah-moon

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 Michelle Moran at BookBrowse
Mata Hari's Last Dance jacket Rebel Queen jacket The Second Empress jacket Madame Tussaud 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 Michelle Moran 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

  • Martine Bailey

    Martine Bailey

    An amateur cook, Martine Bailey won the Merchant Gourmet Recipe Challenge and was a former UK Dessert Champion, cooking at Le Meurice in Paris. Her recipes have appeared in many publications including Good Housekeeping, Olive... (more)

    If you enjoyed:
    Madame Tussaud

    Try:
    An Appetite for Violets
    by Martine Bailey

  • Louis Bayard

    Louis Bayard

    Louis Bayard is the critically acclaimed bestselling author of nine historical novels, including Jackie & Me and The Pale Blue Eye, which was adapted into the global #1 Netflix release starring Christian Bale. His articles, ... (more)

    If you enjoyed:
    Madame Tussaud

    Try:
    The Black Tower
    by Louis Bayard

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

If we did all the things we are capable of, we would literally astound ourselves

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:59 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
1780286363867 ms 1.78028636387E+012 ms 1 /root/website/app_server.cfm
380 ms 380 ms 1 /root/website/author_interviews/full/index.cfm
163 ms 163 ms 1 /root/website/app_layout.cfm
99 ms 99 ms 1 /root/website/author_interviews/full/dsp_main.cfm
99 ms 99 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
69 ms 23 ms 3 /root/website/adsystem/adsystem_mod.cfm
59 ms 59 ms 1 /root/website/app_globals.cfm
45 ms 23 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
45 ms 45 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
41 ms 41 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
28 ms 28 ms 1 /root/website/adzones/AdZone6.cfm
28 ms 28 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
28 ms 28 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
26 ms 26 ms 1 /root/website/adzones/showcase_track.cfm
21 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
21 ms 7 ms 3 /root/website/site/blocks/membership_advantages.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_active_obc.cfm
17 ms 17 ms 1 /root/website/adzones/AdZone2.cfm
16 ms 16 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_competition.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
4 ms 4 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
3 ms 3 ms 1 /root/website/actions/adstatus.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_member_info.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/dsp_top_author_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
381 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:59:23.023
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=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:59:23.023
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=2ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:59:23.023
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:59:23.023
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=3ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:59:23.023
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:59:23.023
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=2ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:59:23.023
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:59:23.023
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=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:59:23.023
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=7ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:59:23.023
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=7ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:59:23.023
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=38ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:59:23.023
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) = 1468

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:59:23.023
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) = 1468

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

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

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=4ms, Records=24) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:59:23.023
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) = 1468

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:23.023
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=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:23.023
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=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:59:24.024
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=0ms, Records=1) in /root/website/actions/udfs.cfm @ 03:59:24.024
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) = 2555

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

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:59:24.024
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=20ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:59:24.024
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=18ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:59:24.024
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:59:24.024
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:24.024
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:24.024
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=15ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:59:24.024
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:59:24.024
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:24.024
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:24.024
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:59:24.024
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=CFID=4084933; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4084933%26CFTOKEN%23%3Dcaba144ee8dc9975%2D0D581F60%2DC6F8%2DA057%2DA8EA51EE7EA977B9%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A59%3A23%27%7D%23hitcount%3D216%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A58%3A52%27%7D%23cftoken%3Dcaba144ee8dc9975%2D0D581F60%2DC6F8%2DA057%2DA8EA51EE7EA977B9%23cfid%3D4084933%23; CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9; FREEACCESSCOUNT=1
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/1468/michelle-moran
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=4084933
cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
hitcount=219
lastvisit={ts '2026-06-01 03:59:24'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:58:52'}
urltoken=CFID=4084933&CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
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#=4084933&CFTOKEN#=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9#lastvisit={ts '2026-06-01 03:59:23'}#hitcount=216#timecreated={ts '2026-06-01 03:58:52'}#cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9#cfid=4084933#
CFID=4084933
CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
FREEACCESSCOUNT=1
Session Variables:
cfid=4084933
cftoken=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
sessionid=BOOKBROWSE_4084933_caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
urltoken=CFID=4084933&CFTOKEN=caba144ee8dc9975-0D581F60-C6F8-A057-A8EA51EE7EA977B9
URL Parameters:
author_number=1468
michelle-moran=
Debug Rendering Time: 29 ms