Anchee Min Interview, plus links to author biography, book summaries, excerpts and reviews

Anchee Min
Photo: Naishi Min

Anchee Min

How to pronounce Anchee Min: an-key min

An interview with Anchee Min

In two separate interviews, Anchee Min discusses Empress Orchid, the first of two planned novels about the last Empress of China, a country girl who seized power through seduction, murder, and endless intrigue; and her more recent novel, Pearl of China, about the life of Pearl Buck.

Pearl of China is the story of Pearl S. Buck. Why did you decide to tell Pearl's story?

Pearl Buck and I have a long history together, and in some sense that story is at the heart of my novel. As a teen back in China in 1972 during the Cultural Revolution, I was asked to denounce Pearl Buck as an "American cultural imperialist." Though I wasn't given a chance to read The Good Earth, I dutifully went ahead and made the denunciation. Years later, when I was living in America and on a book tour for my memoir Red Azalea, a fan thrust a copy of Buck's most famous novel into my hands as a gift. I read the book on a plane and burst into tears. I cried because I realized how beautifully Buck had told the story of the Chinese peasant, in a way that few others, even Chinese, had ever done. And I cried because I was only then realizing this, and that I was only one of a generation that had been indoctrinated to think poorly of Buck.

I wrote the novel to show where Pearl's great sensitivity and insight into the Chinese and Chinese culture came from. And also to show how the relationship between Pearl Buck and China changed over time, just as mine had changed. Right now, Pearl Buck is finally being celebrated in China, for the first time. That is a good sign for international relations between the U.S. and China.


How did you conduct your research on Pearl's personal life?

First, I continued reading Pearl's own writing and continued to be amazed at her perspective, how well she knew the Chinese. Pearl not only grew up in China, but grew up with the people, who she loved and didn't feel separate from. One of the most important things I did was to spend time in the town where Pearl Buck grew up. It was the town Pearl called "Chin-kiang," which we call "Zheng Jiang" today.

I wanted to know who her childhood friends and neighbors were and how those folks thought of her. Some she stayed in contact with for over forty years - some of the same people that refused to denounce Pearl during the Cultural Revolution. But people were afraid to talk to me at first. The memories of the brutal persecution during the Cultural Revolution were still fresh. I kept returning until one day I was referred to a dying pastor. The local man who introduced me said that "the pastor is ready to open up because he was told by the doctor that he has only few days left to live," which meant that he, the pastor, could afford to tell the truth and escape punishment. I felt terrible to steal the dying man's last moments, but the pastor insisted that he see me.

When I went looking for confirmation about who had denied Pearl Buck a visa to China in 1972, I also got lucky. I suspected Madame Mao was behind the rejection but had no proof. So I was thrilled when I met Pearl Buck's daughter Janice at the Pearl Buck House in Pennsylvania in 2007. Janice told me that her mother believed that it was Madame Mao, and she listed the reasons, all of which made sense to me. Janice also shared with me some wonderful details about her mother, for example, about the Chinese pond Pearl created in her backyard and Pearl's passion for Chinese camellias.


The Christian community that Pearl's father belongs to is an important part of the novel. The Christian presence in China was always controversial and was the center of the Boxer Rebellion. How did you feel about it as you wrote the novel?

The Christian community in China has had a long history, some chapters have been very positive, some not so. Christian ideas were foreign ideas, and China has been a very tradition-bound culture. Some of what you feel about the Christian influence in China is how you feel about traditional Chinese culture. The period I wrote about, from just before the Boxer Rebellion through the Cultural Revolution, was a period of great chaos and violence in Chinese history. Some might say that Christian influence played a part in bringing this on - I don't think so. It was just China coming into the modern age, violently. What I do know is that I came to see the large and growing Baptist community of which Pearl's father was at the center as something that provided a caring, human, and relatively sane refuge in the midst of the craziness of the Cultural Revolution. True believers were not as susceptible to the kind of brainwashing that occurred on a massive scale then.

Another reason I had positive feelings toward the community was my mother's own faith. I regret that I had never bothered to learn about my mother's Christian background until it was too late. I wish that I had asked my mother some questions, which bothers me now. For example, who converted her as a child? And how was her value system, by which I was raised, built? I only witnessed how my mother struggled to stand tall and alone during the Cultural Revolution, holding on to her faith.

She kept it a secret from her children fearing she would be denounced. Again, it is part of Chinese history that hasn't been recorded yet, and it's the material that I am familiar with.


You seem to be a stickler for historical accuracy. Did you embellish or make up parts of Pearl's life?

In all of my historical novels (from Becoming Madame Mao to Empress Orchid and The Last Empress to Pearl of China) I have tried to be as accurate as possible because accuracy gives my historical themes weight. But some have been more literally true than others. The advantage of being a novelist is having the freedom to go directly after the truth of the human heart. With Pearl, I thought it important to tell her story from a Chinese perspective, but I could find no figure in the historical record that knew Pearl throughout her life. I combined a number of Pearl's actual friends at different times throughout her forty years in China to create the character Willow. Looking back, I think it was the best choice I made.


How did you find out about Pearl's relationship with the Chinese poet Hsu Chih-mo?

Pearl grew up with Chinese classic novels and Chinese operas. She admitted that the "Chinese way" had a powerful impact and influence on her life. The possibility of a romantic relationship between the two has been rumored for years within certain circles. From the way Pearl Buck described Hsu Chih-mo in her own writing and in a letter to her girlfriend, I was convinced that her relationship with Hsu Chihmo was extraordinary. The affection and love was in the details of Pearl's observation of the man, the beauty she saw in him. These were two great individuals who possessed both the Eastern and Western cultures and worlds - they were bound to admire and love each other. Once having imagined it, how it might have happened, the beauty and passion of it, I can no longer think that it happened any other way.


What challenges did you face writing about a real person, especially one so beloved?

The challenge was to not only tell a unique story, but also to have a unique perspective. Many books and biographies have been published on Pearl Buck from a Western point of view. I offer a Chinese perspective, or rather a perspective that emphasizes her relationship with China from a Chinese perspective. Readers will get to see how Pearl Buck became who she was because of China; and, for the first time, how Chinese people saw Pearl Buck, this brave American woman who was beloved by people close to her but denounced by the authorities.

I could have written this story only now and only in America. Here, I can write without worry of being persecuted for what I write. And I wrote about Pearl at the right time in my own life - I was born and lived in China for twenty-seven years, and I have lived in America for twenty-six years. I truly can comprehend Pearl Buck as a "person of two worlds." I have begun to understand how an author's background decides, if not dictates, what she writes. In some sense, I could not have written this book until now, because it has taken me this long to truly understand the American side of Pearl Buck's character.


Your longtime editor said that one of the things that makes you such a unique writer is that, unlike so many American writers, your literary model isn't the nineteenth-century realistic novel. Rather, it is Chinese opera. Can you explain how your writing is like the Chinese operas you love to write about?

I didn't think that was anything unique until my editor, Anton Mueller, pointed it out to me. It was the way traditional Chinese people learned how to write. I learned writing by copying ancient Chinese opera scripts, which were composed with dynasty-old poems and verses. It's the only way I knew how to compose writing in Chinese, and I apply the instincts I learned from the old forms when I write in English. I grew up with operas; I love their poetry, their compressed structures, and their emotional intensity. I have tried to give my novels some of these qualities. But another thing that I do is combine this with the Western conventions of the historical novel. So, what my editor really says is that I write historical operas in novel form. It's a truly bicultural concoction.


Your collected works offer a wonderful and historically accurate story of China from the mid-nineteenth century to today. What period will you be writing about next?

I think I am ready to embrace the idea that it's time to review my life as an American. My next book will tell the story of my life in my adopted country. When I arrived in America over twenty years ago, I didn't speak English and had no money and knew practically no one. I learned English by watching TV shows like Sesame Street and Mr. Rogers' Neighborhood and The Oprah Winfrey Show. And I did whatever work I could find. Survival was tough, but, ironically, my previous experience at the labor camp prepared me well. The unexpected makes interesting stories.




Anchee Min discusses Empress Orchid

You did extensive research for Becoming Madame Mao and lived through the Cultural Revolution in China, which added a special intensity to your descriptions. Did similar experiences inform Empress Orchid?

Details are extremely important to me. The most challenging thing has been to get the facts and get them right. There are sometimes several contrasting versions of a single incident involving Empress Orchid, and many sources are false or inaccurate. I went through documents not only in the Forbidden City, but also medical, accounting, and police records. My reading on the lives of eunuchs, maids, palace tutors, imperial warlords, and generals helped me gain crucial perspective. The Empress's food and herb manuals and her opera manuals also revealed a lot about her character.


Remarkably, you and your father were able to gain access to documents in government-guarded storerooms in Beijing. Would you describe how it happened?

Well, I had to get my hands on the facts, but no official in Beijing would risk his career to open the door for me. So I tried the "back door." I can't say more than this, because I don't want to get the person who helped me in trouble. Anyway, I got in. The place where all the ancient documents are stored is treated with strong chemicals, so I was told not to stay inside for more than half an hour. But I didn't want to leave. I read the Empress's original decrees (or copies of decrees, I can't be sure). I was choking on the fumes, but I was glad I stayed. The evidence was compelling that she was a fitter ruler than anyone else of that time. There was a reason her regime lasted for forty-six years.


Your seamlessly real depiction of the Forbidden City transports the reader inside its palaces and gardens. How was Orchid's life there defined — and confined — by its traditions?

What affected her most was that she knew she was a woman, a concubine. Any wrong move would cost her her life. The price of her survival was a lot of personal sacrifice and suffering. For example, she was a passionate woman, widowed at the age of twenty-six. From then on, she was forbidden to have a relationship with a man. She had to fight her need for intimacy, denying her own humanity. As with everything else in her life, such as her effort to revive China, she failed, but her struggle was heroic. She kept China in one piece until she died.


What are Chinese schoolchildren taught about Empress Orchid? And how do history books around the world remember her?

She was considered "the enemy of the human race." In China, children learn that the collapse of every dynasty was the fault of the concubine. The execution of the concubine justified whatever was wrong. That's the tradition. The most recent example was Madame Mao. She was sentenced to death, while her husband was seen as the George Washington of China. Children are taught that the Empress was responsible for destroying China's two-thousand-year imperial culture. Chinese and Western history books remember her negatively too, but the books provide very few facts.


Empress Orchid and Madame Mao are both powerful personalities with a great deal in common. What characteristics drew you to them, and do you share those characteristics yourself?

I do. I am female and Chinese, and at a very young age I learned that my culture disfavors females. Books hold up women as negative examples, such as Madame Mao and Empress Orchid. I was drawn to them because I like to find out the truth. It started with Red Azalea, my first book, about growing up during the Cultural Revolution. The Chinese government's official version of the Cultural Revolution contrasted with the life I had lived. I could not let the lies be the only record. It scared me to think that my daughter would be studying false history, and I felt obligated to do something about it.


Some of your writing is critical of China — past and present. Has the Chinese government taken an "official position" on you? What has your experience been when visiting your family in China each year?

China's policy toward me is "We don't want to make an enemy of Anchee Min, but we don't have to promote her, either." My family in China has concerns. But as long as there are no Chinese versions of my books, they feel safe.


The conclusion of Empress Orchid is "the end of the beginning" and leaves your audience begging for a sequel. Can you give us an idea of what happens next?

After she was widowed, Tsu Hsi ruled for forty-six years. The material about this time is absolutely fascinating. She was forced to learn many things, including diplomacy. Keep in mind that China in the late 1800s had been closed to outsiders for more than two thousand years. Westerners were trying to force their way into the opium trade. Meanwhile, domestic rebels, the Boxers, wanted to overthrow the dynasty. The Empress performed a delicate balancing act, and as a result she single-handedly held the dynasty together. My next book will reveal more of her private character. She was a great politician, a clever strategist, and a caring mother and lover.

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 Anchee Min at BookBrowse
The Cooked Seed jacket Pearl of China jacket The Last Empress jacket Red Azalea 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 Anchee Min 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

  • Anita Amirrezvani

    Anita Amirrezvani

    Anita Amirrezvani was born in Tehran, Iran, and raised in San Francisco. For ten years, she was a dance critic for newspapers in the Bay Area. She has received fellowships from the National Arts Journalism Program, the NEA's ... (more)

    If you enjoyed:
    Empress Orchid

    Try:
    The Blood of Flowers
    by Anita Amirrezvani

  • Jasper Becker

    Jasper Becker

    Jasper Becker is a British author, commentator and journalist who has spent two decades as a foreign correspondent mostly in China. Becker has contributed features to Vanity Fair, National Geographic, Marie Claire, Travel & ... (more)

    If you enjoyed:
    The Last Empress

    Try:
    The Chinese
    by Jasper Becker

We recommend 23 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:35 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
1780284925722 ms 1.78028492572E+012 ms 1 /root/website/app_server.cfm
527 ms 527 ms 1 /root/website/author_interviews/full/index.cfm
213 ms 213 ms 1 /root/website/author_interviews/full/dsp_main.cfm
156 ms 156 ms 1 /root/website/app_globals.cfm
114 ms 57 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
68 ms 68 ms 1 /root/website/app_layout.cfm
65 ms 22 ms 3 /root/website/adsystem/adsystem_mod.cfm
48 ms 48 ms 1 /root/website/queries/qry_get_active_obc.cfm
44 ms 44 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
39 ms 39 ms 1 /root/website/adzones/AdZone2.cfm
37 ms 12 ms 3 /root/website/site/blocks/membership_advantages.cfm
35 ms 12 ms 3 /root/website/queries/qry_get_member_account_types.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_current_competition.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
21 ms 21 ms 1 /root/website/act_check_login.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_member_info.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
18 ms 5 ms 4 /root/website/actions/act_spider_tracker.cfm
17 ms 17 ms 1 /root/website/adzones/AdZone6.cfm
16 ms 16 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
13 ms 13 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
12 ms 12 ms 1 /root/website/adzones/showcase_track.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
10 ms 10 ms 1 /root/website/actions/adstatus.cfm
7 ms 7 ms 1 /root/website/act_libraryIPLogin.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
7 ms 7 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_wordplay.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
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/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_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/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
528 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 03:35:25.025
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=19ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:35:25.025
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:35:25.025
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:35:25.025
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=6ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:35:25.025
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=12ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:35:25.025
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=11ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:35:25.025
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:35:25.025
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=9ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:35:25.025
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=8ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:35:25.025
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=27ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:35:25.025
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=12ms, Records=3) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:35:25.025
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) = 1454

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:35:25.025
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) = 1454

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=22ms, Records=5) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 03:35:25.025
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) = 1454
Parameter #2(CF_SQL_INTEGER) = 1454

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=19ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:35:25.025
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) = 1454

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=6ms, Records=23) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:35:25.025
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) = 1454

get_ads (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:25.025
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=20ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
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:35:26.026
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_book_image (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/udfs.cfm @ 03:35:26.026
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) = 2552

get_book_image (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 03:35:26.026
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) = 1986

get_member_account_types (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:35:26.026
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=77ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:35:26.026
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) = 1467
Parameter #2(CF_SQL_INTEGER) = 1467
Parameter #3(CF_SQL_INTEGER) = 1467

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:35:26.026
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) = 1467

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:35:26.026
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:35:26.026
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=9ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:35:26.026
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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
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=6ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:35:26.026
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:35:26.026
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:35:26.026
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=FREEACCESSCOUNT=1; CFGLOBALS=urltoken%3DCFID%23%3D4084401%26CFTOKEN%23%3Dd76ae236bd480eae%2D0C809BF8%2DA949%2D03D4%2DA922F610BD62CDE7%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A35%3A25%27%7D%23hitcount%3D29%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A35%3A19%27%7D%23cftoken%3Dd76ae236bd480eae%2D0C809BF8%2DA949%2D03D4%2DA922F610BD62CDE7%23cfid%3D4084401%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4084401; CFTOKEN=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
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/1454/author/anchee-min
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=4084401
cftoken=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
hitcount=32
lastvisit={ts '2026-06-01 03:35:26'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:35:19'}
urltoken=CFID=4084401&CFTOKEN=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
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#=4084401&CFTOKEN#=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7#lastvisit={ts '2026-06-01 03:35:25'}#hitcount=29#timecreated={ts '2026-06-01 03:35:19'}#cftoken=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7#cfid=4084401#
CFID=4084401
CFTOKEN=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
FREEACCESSCOUNT=1
Session Variables:
cfid=4084401
cftoken=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
sessionid=BOOKBROWSE_4084401_d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
urltoken=CFID=4084401&CFTOKEN=d76ae236bd480eae-0C809BF8-A949-03D4-A922F610BD62CDE7
URL Parameters:
author=anchee-min
author_number=1454
Debug Rendering Time: 24 ms