Monique Truong Interview, plus links to author biography, book summaries, excerpts and reviews

Monique Truong

Monique Truong

How to pronounce Monique Truong: Trun

An interview with Monique Truong

Monique Truong talks about her novel The Book of Salt and how her own history as a child of wartime Vietnam has flavored her writing.

The main character of The Book of Salt is a cook. What's your relationship to the preparation of food?
I cook for pleasure. I cook to experience something new. I cook, like the characters in my novel, to remind me of where I have been. I always cook or rather I always "taste" the food first in my mind. I approach a recipe like a story. I imagine it, sometimes I have a dream about it, then I go about crafting it.

Tell us about the novel's structure.
The Book of Salt opens in Paris in October of 1934. Bình, the cook, has accompanied his employers Gertrude Stein and Alice B. Toklas to the train station. He seems to be faced with a decision. Will he go to the United States with his Mesdames? Will he return to his family in Vietnam, or, will he continue his life in France or will he travel to some other place of his choosing? Before Bình's "choice" is revealed, the reader is brought back in time and made privy to the stories of the Vietnamese cook and of his American employers. What led each of them to live far from the land of their birth? What, if anything, could bring them back home again? The answers to these questions are found in Bình's memories, musings, observations, and possibly lies--all of which are continuously asserting and interrupting one another. Bình's stories are told via his internal voice, one which is far richer, far more agile--in fact, it is a stark contrast to the voice that comes out of his mouth. Bình is a man living in a land, working for employers whose languages are foreign to him. He struggles with their words, and they win the confrontation every time. Limited and silenced, Bình has only his memory and his imagination to keep him company. In the last chapter of the novel, the story returns to the train station where the reader is in essence asked to make the same decision as Bình. Whether they would emerge from Bình's life triumphant or in despair; whether they would be pulled together or asunder by the competing stories of Bình's past, present and future?

How did you get the idea for your book?
When I was in college, I bought a copy of the Alice B. Toklas Cook Book because I was curious about Toklas' hash brownie recipe. It turned out that the famous recipe was not a Toklas recipe at all, but one submitted by the artist Brion Gysin in a chapter called "Recipes from Friends." Gysin's recipe was actually for a "haschich fudge" and was for a sort of dried fruit bar concoction "dusted" with a bunch of pulverized "canibus sativa." It didn't sound tasty to me, but I read the rest of the book anyway and found that it was less of a cookbook and more of a memoir. In a chapter called "Servants in France," Toklas wrote about two "Indochinese" men who cooked for Toklas and Stein at 27 rue de Fleurus and at their summer house in Bilignin. One of these cooks responded to an ad placed by Toklas in the newspaper that began "Two Americans ladies wish- " By this point in the cook book, I had already fallen for these two women and for their ability to create an idiosyncratic, idyllic life for one another. When I got to the pages about these cooks, I was to say the least surprised and touched to see a Vietnamese presence and such an intimate one at that in the lives of these two women. These cooks must have seen everything, I thought. But in the official history of the Lost Generation, the Paris of Gertrude Stein and Alice B. Toklas, these "Indo-Chinese" cooks were just a minor footnote. There could be a personal epic embedded inside that footnote, I thought. The Book of Salt is that story, as told from the perspective of Bình, a twenty-six-year old Vietnamese man living in Paris in the late 1920's. I have imagined him as one of the candidates who answered Stein and Toklas' classified ad.

When did you begin writing the novel?
The novel began as a short story called Seeds, which I wrote in 1997. I had graduated from college, worked for two years as a paralegal, gone to law school, and was practicing intellectual property law in New York City by then. I was still calling myself a writer, even though I had not written any fiction since graduating from college in 1990. I began to write again because I was co-editing Watermark, an anthology of Vietnamese American poetry and prose, and I had submitted a piece that I had written early on in college to my co-editors for consideration. They rejected it. I was mortified. I took four days off from work in order to prove to myself and to my fellow editors that I was a writer. When I sat myself down to write, I knew the story that I wanted to tell. I had never forgotten about the Vietnamese cooks who worked in the Toklas and Stein household. "Seeds" was the beginning of The Book of Salt.

Are you still practicing law?
Thankfully, no.

Why did you go to law school and practice if you considered yourself a "writer"?
I was a coward. My grandfather was a writer back in Vietnam, but besides him I didn't know of any other writers. I didn't know how to go about creating a writing life for myself. I had no roadmaps, and I had a bad sense of direction to begin with. I thought that if I went down that path I would end up at the welfare office.

How did you make the transition from being a lawyer to a full-time writer?
I quit my job at the law firm. Actually, I wasn't so immediately bold. After I wrote "Seeds," I knew that there was more that I could write about Bình, the cook, but I found it impossible to work as a lawyer and to write at the same time. I didn't have the physical or emotional energy to do it. One of my Watermark co-editors suggested that I apply for a Van Lier fellowship for writers under the age of thirty. Luckily, they gave me the fellowship because I was twenty-nine when I applied. The fellowship came with a cash grant that allowed me to pay my rent and school loans for about two months. I asked for and received a leave of absence from the law firm that I was with at the time, and my career as a lawyer has never been the same.

Why did you choose the title The Book of Salt?
Salt--in food, sweat, tears and the sea--is found throughout the novel. The word "salary" comes from the word salt, so salt is another way of saying labor, worth, value. For me, the title is also a nod toward the Biblical connotation of salt, in particular to the turning of Lot's wife into a pillar of salt for "looking back" at her home, to the city of Sodom. That story says to me that the Catholic God, whom the cook is so wary of, not only disapproves of the activities of the Sodomites but also of nostalgia. Bình is a practitioner of both. In the novel, there is an unpublished manuscript by Gertrude Stein with the same name, which plays a significant role in Bình's relationship with his American lover, Sweet Sunday Man.

Is there really a manuscript by Stein entitled The Book of Salt?
No, I made that manuscript up. In the novel, Bình claims that Stein's The Book of Salt is about him. Stein has certainly written about cooks and servants. In Portraits and Prayers, for instance, there is a piece called "B. B. or the Birthplace of Bonnes" about all the women from Brittany who had worked in the Stein and Toklas' household. Also, two of the "lives" in Stein's Three Lives were servants. So, it does not seem improbable to me that Stein could have devoted a few words to a cook like Bình.

There is a character in the novel that Bình refers to as "the man on the bridge" until he finds out that his name is Nguyen Ai Quoc. Isn't that one of Ho Chi Minh's pseudonym?
Yes, when Ho Chi Minh was living in Paris he called himself Nguyen Ai Quoc. A fictionalized Nguyen Ai Quoc appears in the novel as a man whom Bình meets on a bridge over the Seine. They share a meal, their longing for a home, their thoughts about the French, among a number of other significant things all in the course of a few short hours. But a question that "the man on the bridge" asks of Bình stays with him for much longer: "What keeps you here?"

You have Bình meeting "the man on the bridge" in 1927. Wasn't the real Ho Chi Minh living elsewhere by then?
Yes, Nguyen Ai Quoc was living and organizing in southern China by then, but he was forced to flee the region for a time in 1927. He went to Moscow and from there he traveled around Europe as a tourist visiting castles and cathedrals. According to the historian Stanley Karnow, a French communist friend of his actually recalled meeting Nguyen Ai Quoc on a bridge in Paris in 1927 during the course of that pleasure trip.

What inspired you to include a fictionalized Ho Chi Minh in the novel?
Actually, I think of the character in The Book of Salt as a fictionalized Nguyen Ai Quoc as opposed to a fictionalized Ho Chi Minh. From what I have read about him, his name changes often signaled or accompanied a significant change in the man as well. When he was in Paris, he was literally "a man on the bridge" between democracy and socialism. He eventually felt rejected by both and turned towards communism to reach his goal of independence and self-determination for Vietnam. By that time, he was well on his way to becoming Ho Chi Minh. The man that interested me was Nguyen Ai Quoc, the young man living in Paris who read Shakespeare and Dickens in the original English, who wrote plays and newspaper articles, who earned money as a painter of fake Chinese souvenirs, a photographer's assistant.

In the novel, "the man on the bridge" tells Bình that he also worked as a cook. Is this based on fact?
Yes, I had done some research on Nguyen Ai Quoc because someone told me that he had been a cook in France. It turned out that he was an assistant cook at the pie bakery of the Carlton Hotel in London, whose kitchen at that time was under the supervision of the legendary French chef Auguste Escoffier. As a young man, he had left Vietnam by working as a "mess boy" on a French ocean liner going from Saigon to Marseilles. I decided that my cook, Bình, would take a similar route. Many of Bình's experiences on the fictional freighter Niobe were based on or inspired by the more well-documented experiences of Ba, as he called himself then, on the Latouche Treville. Nguyen Ai Quoc's travels out of Vietnam began in 1911, and they took him to Dakar, Brooklyn, London, Paris and many other port cities around the world. From 1917 to 1923 he lived in Paris. Some time in the summer of 1923, he left Paris for Moscow to begin his full-time education and activity as a "revolutionary."

You were born in Vietnam and came to the United States in 1975 as a refugee. Did that experience play a role in shaping this novel?
I was six years old when my mother and I left Vietnam in April of 1975. It was suppose to be just a precautionary measure, a temporary solution to keep us safe from the nightly bombings. My father, who was a high level executive for an international oil company, stayed behind at their bequest. Later that month, when Saigon fell to the communist forces my father left on a boat for the South China Sea, the same sea that my mother and I were lucky enough to have flown over in an airplane just weeks before. The departure, the loss of home, that act of refuge seeking have everything to do with the themes playing themselves out in The Book of Salt. There are no military conflicts in my novel, there are no soldiers, there are no weapons. I suppose it is no coincidence that the first long distance flight of my imagination as a writer would take me to a time in history when Vietnam was more or less at peace. When you are a child of wartime, peace is the all consuming fantasy. Also I think as a child of wartime, one of the questions that stays with me and that I've tried to answer for myself by writing this novel is what if there was not a war, what then would make a person leave the land of their birth behind?

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 Monique Truong at BookBrowse
The Sweetest Fruits jacket Bitter in the Mouth jacket The Book of Salt 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 Monique Truong 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

  • Monica Ali

    Monica Ali

    Monica Ali is the daughter of English and Bangladeshi parents.

    She came to England at the age of three, and her first home was Bolton in Greater Manchester. Ali later studied at Oxford University.

    Her first novel, Brick ... (more)

    If you enjoyed:
    The Book of Salt

    Try:
    Brick Lane
    by Monica Ali

  • Glen David Gold

    Glen David Gold

    Glen David Gold is the author of Sunnyside and Carter Beats the Devil, which has been translated into fourteen languages. His short stories and essays have appeared in McSweeney's, Playboy, and The New York Times ... (more)

    If you enjoyed:
    The Book of Salt

    Try:
    Sunnyside
    by Glen David Gold

We recommend 9 similar authors

View all 9 Read-Alikes

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

BookBrowse Book Club

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

Members Recommend

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

Silent gratitude isn't much use to anyone

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:10 PM
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
1780326654511 ms 1.78032665451E+012 ms 1 /root/website/app_server.cfm
1059 ms 1059 ms 1 /root/website/author_interviews/full/index.cfm
449 ms 449 ms 1 /root/website/app_globals.cfm
235 ms 235 ms 1 /root/website/author_interviews/full/dsp_main.cfm
202 ms 202 ms 1 /root/website/app_layout.cfm
170 ms 170 ms 1 /root/website/actions/adstatus.cfm
153 ms 153 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
137 ms 46 ms 3 /root/website/adsystem/adsystem_mod.cfm
136 ms 68 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
122 ms 122 ms 1 /root/website/queries/qry_get_active_obc.cfm
62 ms 62 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
58 ms 58 ms 1 /root/website/adzones/AdZone6.cfm
54 ms 54 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
50 ms 50 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
49 ms 12 ms 4 /root/website/actions/act_spider_tracker.cfm
49 ms 49 ms 1 /root/website/queries/qry_get_current_competition.cfm
42 ms 42 ms 1 /root/website/adzones/AdZone2.cfm
41 ms 41 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
40 ms 40 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
38 ms 38 ms 1 /root/website/adzones/showcase_track.cfm
29 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
27 ms 9 ms 3 /root/website/queries/qry_get_member_account_types.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
22 ms 22 ms 1 /root/website/act_check_login.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_member_info.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_current_ezine.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1060 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=48ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 15:10:54.054
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=20ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:10:54.054
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=169ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:10:54.054
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 @ 15:10:54.054
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=15ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:10:54.054
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=23ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:10:54.054
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=23ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:10:54.054
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 @ 15:10:54.054
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=25ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 15:10:54.054
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=27ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 15:10:54.054
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=68ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 15:10:54.054
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=29ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:10:54.054
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) = 881

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=32ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:10:55.055
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) = 881

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=53ms, Records=3) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 15:10:55.055
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) = 881
Parameter #2(CF_SQL_INTEGER) = 881

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=26ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 15:10:55.055
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) = 881

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=27ms, Records=9) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 15:10:55.055
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) = 881

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

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

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:10:55.055
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=20ms, Records=1) in /root/website/actions/udfs.cfm @ 15:10:55.055
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) = 1204

get_member_account_types (Datasource=bookbrowse_com_new, Time=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:10:55.055
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=22ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:10:55.055
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) = 935
Parameter #2(CF_SQL_INTEGER) = 935
Parameter #3(CF_SQL_INTEGER) = 935

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=61ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:10:55.055
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) = 1698
Parameter #2(CF_SQL_INTEGER) = 1698
Parameter #3(CF_SQL_INTEGER) = 1698

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=49ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:10:55.055
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) = 1698

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

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=23ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:10:55.055
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=29ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=40ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:10:55.055
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 @ 15:10:55.055
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:10:55.055
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4105095%26CFTOKEN%23%3Da4a6135e1921a21b%2D255AC499%2DC2FD%2DF2CB%2D255AE2DF5F412D04%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A10%3A54%27%7D%23hitcount%3D231%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A10%3A14%27%7D%23cftoken%3Da4a6135e1921a21b%2D255AC499%2DC2FD%2DF2CB%2D255AE2DF5F412D04%23cfid%3D4105095%23; CFID=4105095; FREEACCESSCOUNT=0; CFTOKEN=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
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/881/author/monique-truong
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=4105095
cftoken=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
hitcount=234
lastvisit={ts '2026-06-01 15:10:55'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:10:14'}
urltoken=CFID=4105095&CFTOKEN=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
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#=4105095&CFTOKEN#=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04#lastvisit={ts '2026-06-01 15:10:54'}#hitcount=231#timecreated={ts '2026-06-01 15:10:14'}#cftoken=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04#cfid=4105095#
CFID=4105095
CFTOKEN=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
FREEACCESSCOUNT=0
Session Variables:
cfid=4105095
cftoken=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
sessionid=BOOKBROWSE_4105095_a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
urltoken=CFID=4105095&CFTOKEN=a4a6135e1921a21b-255AC499-C2FD-F2CB-255AE2DF5F412D04
URL Parameters:
author=monique-truong
author_number=881
Debug Rendering Time: 14 ms