What do readers think of The Lost Story of Eva Fuentes by Chanel Cleeton? Write your own review.

Summary | Reviews | More Information | More Books

The Lost Story of Eva Fuentes by Chanel Cleeton

The Lost Story of Eva Fuentes

by Chanel Cleeton

  • Readers' Rating (56):
  • Published:
  • Jul 2025, 336 pages
  • Rate this book

About this book

Reviews

Page 3 of 4
There are currently 28 reader reviews for The Lost Story of Eva Fuentes
Order Reviews by:

Write your own review!

Sara_S

Cuba Libre Comes to Women's Fiction: History Made Accessible
Writer Chanel Cleeton does some of her best work here in this tale that incorporates the intertwined lives of three different women over three time periods. Cuba's political history serves as a backdrop to this contemporary murder mystery cum modern romance. The book has much to commend it for book clubs and individual book lovers. An accompanying reader's guide will enliven any group discussion.
Power Reviewer
Sandi

A bit of intrigue, a bit of romance and a murder
Thank you to Berkley and BookBrowse for giving me a copy for a unbiased review. Expected publication September 30, 2025.

Life in post revolutionary Cuba, with all the challenges that so many faced, was the basis for this story. It stung together the thread connecting three timelines in this book. A fictional book drove all three timelines. There was Eva in 1900 - who wrote the book. Then Pilar in 1966 who saved the book. And Margo in 2024 who tracked down the book.

This novel was well put together. A bit of intrigue, a bit of romance and a murder and all was wrapped up expertly.
Lee L. (Los Angeles, CA)

The Lost Story of Eva Fuentes
It's actually a little bit ironic that the first ARC I'm starting with this year doesn't publish until July, but that's how things ended up turning out. The Lost Story of Eva Fuentes is Chanel Cleeton's latest Cuban-themed historical fiction novel and it's definitely a good one! I've read most (but not all) of Cleeton's past novels and especially enjoyed her series about the Perez family, though her other novels (the ones not about the Perez family) have been a hit or miss for me overall. With this latest one, I'm guessing I enjoyed it so much because the storyline revolves around a lost book and its connection to three women from three different time periods.

In the present timeline (London in 2024), Margo Reynolds is hired to help her client find a rare book that was written 120 years ago, but there is a huge catch – only one copy of the book is currently in existence. Though Margo accepts the challenge, she quickly realizes that she may actually be in over her head as other parties interested in the book start to come out of the woodwork and her life is placed in danger. The timeline then moves to Havana in 1966, where librarian Pilar Castillo lives in grief and anger over the loss of her husband, who was arrested and imprisoned for going against Fidel Castro's regime. Pilar comes into possession of the mysterious book when it is turned over to her for safekeeping by a neighbor and eventually becomes more than a source of comfort for her as she endures the difficulties of living under Castro's repressive regime. Finally, the third timeline, in 1900, introduces us to the author of the book, Eva Fuentes, a Cuban teacher who is given the opportunity to travel to the United States as part of a summer cultural exchange program at Harvard University. During Eva's stay there, she experiences both joy and heartbreak that not only end up altering the course of her life, but also provide the inspiration for her novel.

I have to admit that I was a bit dubious at first how the story would unfold given how far apart the three timelines were. It turns out I didn't have to worry though, as Cleeton definitely knew what she was doing in making Eva's book the central thread that connected the seemingly disparate timelines together, but in a way that was seamless and made sense for the story's development. Given my affinity for historical fiction, no doubt that I enjoyed Eva's and Pilar's timelines more -- Margo's timeline was well done overall, but since the three timelines alternated with each chapter, it did feel a little jarring to jump from an early 20th century historical setting to a modern day murder mystery setting in 2024. Things turned out fine in the end though.

As an avid reader and also a writer myself, I love learning about the behind-the-scenes aspects of how a particular story came to be as well as the inspirations for certain characters and events, which is perhaps why Cleeton's latest work resonated with me more than her previous novels did. Speaking of behind-the-scenes, Cleeton writes in her Author's Note that The Lost Story of Eva Fuentes is a "love letter to the power of books and the impact they leave on our lives," which is one of the main reasons why she had Eva's fictional book be what links the three women in the three different timelines together. I couldn't agree more! Cleeton fans will definitely want to pick this one up, but those who enjoy "books about books" will likely enjoy this one as well.

Received ARC from Berkley via Book Browse First Impressions program.
Lynne_Brosch

Cleeton's Newest Historical Mystery Is a Ten
Having read and reviewed several of Chanel Cleeton's novels, I find The Lost Story of Eva Fuentes is the best yet. I was drawn in to the strong and defiant women characters immediately. With the history of Cuban life brought in with the setting it was also a chance to experience life in Cuba in 1900 and 1966.

The Cuban-American cultural exchange was also a very interesting historical element that I had never heard about. The mystery develops rather quickly as our present day heroine Margo is involved in trying to recover an important book which has only one existing copy in the world. It seems that it is worth more than anyone can imagine to certain people. The background of this book involves the woman who first wrote it, the woman who was given it to rescue and the generations after who desired it.

If you have ever found a book that personally resonated with you then you will surely empathize with this story. It is a story of women who have the courage to fight for what they want and about a book that changes all of their lives.
Dawn_Zuber

Engaging Across Eras—With One Historical Hiccup
Overall, I enjoyed reading this book. The story unfolds in three parts across three distinct time periods: Margo, an American living in London in 2024; Pilar, a woman navigating life in Havana under the Castro regime in 1966; and Eva, also a Havanan woman, working as a teacher in 1900.

Margo's and Pilar's stories felt realistic and engaging, but Eva's narrative didn't ring as true for me. In Chapter 3, she's described in a way that suggests she has considerable teaching experience, but the text later reveals that she was born at the end of the Ten Years' War, which would make her only twenty-two in 1900. I realize teacher training requirements were different in the late nineteenth century, but that discrepancy stood out. Additionally, part of Eva's story involves spending significant time alone with a man, including public displays of affection—behavior that seems unlikely for a young, unmarried woman of that time. Her lack of concern about her reputation or the social norms of the era made her character less convincing to me.

While I found Pilar's and Margo's stories compelling, the novel's central focus on a book Eva wrote—and my difficulty connecting with her character—made the overall reading experience less satisfying.
Katherine P. (Post Mills, VT)

Female Endurance, Rom-Com, Mystery, History and The Importance of Books ( and the Usefulness of Iron Frying Pans)
Chanel Cleeton provides them all in this book. She has chosen to reveal them all through the revolving chapters among three women, Eva a Cuban teacher living in Cuba at the turn of the 20th Century, Pilar, a librarian, also Cuban who leaves for Florida during Fidel's rule, and Margo, a Brit in modern London who is a finder for a fee of lost or stolen items for rich clients.

Needless to say the lives of Eva and Pilar and their friends and family describe the history of Cuba from its overthrow of Spanish dominian, through the short-lived influence of the United States, to the revolution that brought Fidel Castro into power and reduced the country to one of submission and fear.
It is during these chapters that we learn of Eva's experience as a member of a group of teachers who came to Harvard to learn about American educational practices and to show Cuban life and culture to their nearest neighbor now that they were free of Spanish rule and could establish themselves as an independent nation, Here, too, we are privy to the short romance between Eva and an American, James Webber. A romance that lead to heartbreak for her, not a real surprise. It also resulted in her penning of a novel she wrote about the experience called A Time for Forgetting. This book becomes the real star of Cleeton's book! And its writing is the first of Cleeton's demonstration of the importance of books--here to the writer-- allowing her to express her sorrow and grief and alleviate the pain somewhat.

Also Pilar's story takes place under Fidel's rule. Her husband has been taken by his troops. She has no idea where he is of if alive. But, in an effort to defy the regime in some small way, Pilar has taken to rescuing books of families who are fleeing Cuba and cannot take them. Some are very valuable and should be turned over to the soldiers but she hides them and as the time goes on this activity brings her into danger. Once she uses the frying pan she too must flee Cuba. But, one of the books in her care is Eva's novel and she searches for Eva and returns the book to her. Once she lells Eva of how important the book became to her in her loneliness and then grief at the loss of her husband, Cleeton's second belief that some books are meant for some people and give them the strength or hope needed to live.

And finally, we have Margo and her ex-husband Luke, in London looking for Eva's novel. No one seems to know what happened to it and they must learn its story and whereabouts without Cleeton giving them the information we, the readers, have. And this is the rom-com, mystery piece. Several people seem to be looking for the book. Margo has a client as does Luke both interested in finding it. Why? My first thought was the secret of a child in the book--an effort to keep it a secret. Then, still related to the child, I thought it was for money. Either blackmail or a claim to an inheritance. Well, money is involved--isn't it always? Along with the mystery, Margo and Luke analyze their failed marriage and look, they are getting together again--easy to see it coming. But, here is the last point of importance of books--can give someone a place in the world, a knowledge of one's heritage and its importance.

An easy read, that covers all these aspects surprisingly well with good integration. Some of it is obvious in its conclusions but the parts pursuing Eva's novel is complex enough to keep it interesting..
Micki_S

The Lost Story of Eva Fuentes
An interesting mix of historical fiction and adventure. The story braids the stories of three women over the last 125 years who have a connection with a book, The Story of Forgotten Time, written by the first woman, Eva, in 1900. Eva was a Cuban teacher who participated in an American program which brought over a thousand Cuban teachers to Harvard for a summer in a bid to Americanize Cuban education.

I very much enjoyed learning about the Harvard Cubans, something I had not known anything about. The second woman, Pilar, lived in Cuba at the time of the Cuban Revolution. She was a book-loving librarian who rebelled against the oppression of the Castro Regime by protecting books. The third woman, Margo, is an American living in London in the 2020s who is hired anonymously to find the only copy of Eva's book.

I appreciated being reminded of how rich Cuba's history and culture are, and how important books are in the lives of some. I personally had a harder time immersing myself in the action-adventure of the contemporary sections of the novel, but given how popular action thrillers are, that may not be a problem for many. I have read several of Chanel Cleeton's novels, and enjoy them.
Joanne W. (Ossining, NY)

A novel tells the story
Once you get sorted with the three time periods/voices the book moves quickly. I especially enjoyed the voice of Eva, a young, naive Cuban teacher having the adventure of a lifetime as a summer student at Harvard. Her story was well drawn and compelling. Margo our present day narrator had a complex story and interesting life.

The author meshed their story and created the center of the story. With Pilar, the third voice, we get the insight into Cuban life during a time of great strife and difficulty. And at the core of the book lies the heartfelt novel written by Eva as a way to deal with the trauma that played out after her summer in the US.

Definitely enjoyed and would recommend to lovers of novels with strong female characters and historical fiction.

Read-Alikes

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...

Only when we are no longer afraid do we begin to live

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 /reader_reviews/index.cfm
Time Stamp 31-May-26 09:41 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
1780263714939 ms 1.78026371494E+012 ms 1 /root/website/app_server.cfm
888 ms 888 ms 1 /root/website/reader_reviews/index.cfm
389 ms 389 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
173 ms 173 ms 1 /root/website/app_layout.cfm
125 ms 125 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
124 ms 62 ms 2 /root/website/adsystem/adsystem_mod.cfm
123 ms 123 ms 1 /root/website/app_globals.cfm
111 ms 111 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
83 ms 83 ms 1 /root/website/adzones/AdZone6.cfm
42 ms 42 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
41 ms 41 ms 1 /root/website/adzones/showcase_track.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_active_obc.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
16 ms 16 ms 1 /root/website/act_check_login.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_member_info.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
14 ms 14 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
13 ms 4 ms 3 /root/website/actions/act_spider_tracker.cfm
12 ms 12 ms 1 /root/website/actions/adstatus.cfm
12 ms 12 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_obc_number.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
2 ms 2 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_reader_reviews_power_reviewers.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.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/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/reader_reviews/dsp_views.cfm
0 ms 0 ms 1 /root/website/site/blocks/act_book_view_tracking.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/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
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
888 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 21:41: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=15ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 21:41: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=10ms, Records=2) in /root/website/actions/adstatus.cfm @ 21:41: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 @ 21:41: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=8ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 21:41: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=18ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 21:41:55.055
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 21:41:55.055
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 21:41:55.055
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 21:41:55.055
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 21:41:55.055
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=22ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 21:41:55.055
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_book_number (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/reader_reviews/index.cfm @ 21:41:55.055
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_reader_reviews_power_reviewers (Datasource=bookbrowse_com_new, Time=0ms, Records=50, Cached Query) in /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm @ 21:41:55.055
SELECT 		top 50 reader_review_reviewer_email_address, count(reader_review_reviewer_email_address) as "count"
	FROM 		reader_reviews
	WHERE 		reader_review_reviewer_email_address like '%@%'
	AND 		reader_review_reviewer_email_address <> 'reviews@bookbrowse.com'
	GROUP BY 	reader_review_reviewer_email_address
	
	
	ORDER BY 	count desc
get_preview_by_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 21:41:55.055
select 			a.ezine_preview_number,
				a.ezine_number, 
				a.ezine_preview_category_number, 
				a.ezine_preview_title, 
				a.ezine_preview_subtitle, 
				a.ezine_preview_author, 
				a.ezine_preview_publisher,
				a.ezine_preview_publish_dt,
				a.ezine_preview_number_of_pages, 
				a.ezine_preview_jacket_image,
				a.ezine_preview_reviews,
				a.ezine_preview_short_summary,
				a.ezine_preview_jacket_desc,
				a.ezine_preview_reading_guide,
				a.ezine_preview_bb_comments, 
				a.ezine_preview_isbn,
				a.ezine_preview_isbn13,
				a.ezine_preview_rating,
				a.ezine_preview_bb_link,
                a.ezine_preview_bb_author_link,
                a.ezine_preview_firsts_flag,
                a.ezine_preview_reading_level,
                a.ezine_preview_paperback_flag,
				b.*,
                c.ezine_dt, c.ezine_description
,(select publisher_holding_company from publishers where ezine_preview_publisher like publisher_imprint AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
 				
from ezine_previews a 
inner join ezine_preview_categories b ON b.ezine_preview_category_number = a.ezine_preview_category_number
left join ezines c ON c.ezine_number = a.ezine_number

where ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_author_name (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 21:41:55.055
SELECT author_number, 
        CASE WHEN datalength(author_middle_initial) > 0 then author_first_name + ' ' + author_middle_initial + '. ' + author_last_name
            ELSE author_first_name + ' ' + author_last_name
            END "author_name"
        FROM authors 
        WHERE author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3015

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 21:41:55.055
select a.book_award_number, a.book_award_name, a.book_award_image, c.book_award_dt
    from book_awards a 
    inner join book_awards_category b on b.book_award_number = a.book_award_number
    inner join book_awards_mapping c on c.book_awards_category_number = b.book_awards_category_number
    where ezine_preview_number =  ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=111ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 21:41:55.055
SELECT	(CAST(AVG(CAST(rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) >= 50 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
			ELSE 0
			END) AS "avrating",
            count(rating) as "ratcount"
            
	FROM (
		SELECT reader_review_rating AS rating
		FROM reader_reviews
		WHERE ezine_preview_number = ?
		
		AND reader_review_rating > 0
		
		UNION ALL
		
		SELECT reading_list_book_rating AS rating
		FROM reading_lists
		WHERE book_number LIKE 'p%'
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) = ?
		AND reading_list_book_rating > 0
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) IS NOT NULL
	) combined_ratings
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269
Parameter #2(CF_SQL_INTEGER) = 20269

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=14ms, Records=28) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 21:41:55.055
SELECT 		a.reader_review_number, a.book_number, a.ezine_preview_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.ezine_preview_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    FROM 		reader_reviews a
    INNER JOIN	ezine_previews b ON a.ezine_preview_number = b.ezine_preview_number
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number
	WHERE 		a.ezine_preview_number = ?
    AND			a.book_number = 0
    AND 		a.reader_review_approved_flag = 1
    

	ORDER BY a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_arc_idfk (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 21:41:55.055
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20269

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=28ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 21:41:55.055
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1 AND a.discourse_flag = 0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 20269

obc_discussions (Datasource=booktalk_new, Time=241ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 21:41:55.055
SELECT 		t.name,
                m.title, m.body,
                u.username, t.id,
				(SELECT COUNT(*) from booktalk_messages where threadidfk = t.id) AS	"responses"
                
    FROM 		booktalk_forums f
    INNER JOIN	booktalk_threads t on t.forumidfk = f.id
    INNER JOIN	booktalk_messages m on m.posted = t.lastpostcreated
    INNER JOIN	booktalk_users u on u.id = m.useridfk
    
    WHERE 	f.id = ?
    AND 	f.active = 1
	AND		t.active = 1
    
    ORDER BY t.name, t.messages DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

searchResults (Datasource=bookbrowse_com_new, Time=101ms, Records=3) in /root/website/queries/qry_get_discussion_by_id.cfm @ 21:41:55.055
SELECT book_number, post_id, topic_id, blurb, username, topic_title
					FROM DiscourseSearchResults
					
        WHERE 		book_number = ? 
                    AND topic_id IS NOT NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p20269

ya_check (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 21:41:55.055
select ezine_preview_reading_level 
from ezine_previews 
where ezine_preview_number = ?
and ezine_preview_reading_level = 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_books_by_brief (Datasource=bookbrowse_com_new, Time=8ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 21:41:55.055
select 			top 20
				a.ezine_preview_reading_level,
				b.category_name,
				c.category_number, 
				d.book_number, d.book_title,
				f.author_number, f.author_first_name, author_middle_initial, author_last_name
				
from 			ezine_previews a 
inner join		categories b on b.ezine_preview_category_number = a.ezine_preview_category_number
inner join		category_book_mapping c on c.category_number = b.category_number
inner join		books d on d.book_number = c.book_number
inner join		book_author_mapping e on e.book_number = d.book_number
inner join		authors f on f.author_number = e.author_number

where			a.ezine_preview_number = ? 

order by 		d.book_number DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 20269

get_author_bookcount (Datasource=bookbrowse_com_new, Time=4ms, Records=5) in /root/website/queries/qry_get_author_bookcount.cfm @ 21:41:55.055
select		b.book_title as "title", 1 as "bb_flag", b.book_number as "number"
        from		book_author_mapping a
		inner join	books b on b.book_number = a.book_number
        where		a.author_number = ?
union
    	select		c.ezine_preview_title as "title", 0 as "bb_flag", c.ezine_preview_number as "number"
        from		ezine_previews c
        where		c.ezine_preview_bb_author_link = ?
        and			c.ezine_preview_bb_link = 0
		
order by title DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3015
Parameter #2(CF_SQL_INTEGER) = 3015

get_obc_number (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_obc_number.cfm @ 21:41:55.055
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 20269.0

IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'sfl5sos@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'taking.mytime@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'louisa_lui@yahoo.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'lrugg1224@aol.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'dzuber@studiozarch.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'citygal65@myfairpoint.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'gomsmicki@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 21:41:55.055
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'Joannew0607@gmail.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 21:41: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=7ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 21:41: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=44ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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=27ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 21:41: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 @ 21:41:55.055
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:41: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/reader_reviews/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFID=4074892; CFTOKEN=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704; 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%3D4074892%26CFTOKEN%23%3D590379a282653914%2DFFDC2575%2DEE2E%2D23E5%2DDD9BC40E74D64704%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2021%3A41%3A54%27%7D%23hitcount%3D38%23timecreated%3D%7Bts%20%272026%2D05%2D31%2021%3A41%3A49%27%7D%23cftoken%3D590379a282653914%2DFFDC2575%2DEE2E%2D23E5%2DDD9BC40E74D64704%23cfid%3D4074892%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/ezine_preview_number/20269/page/3/the-lost-story-of-eva-fuentes
PATH_TRANSLATED=/root/website/reader_reviews/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/reader_reviews/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=4074892
cftoken=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
hitcount=46
lastvisit={ts '2026-05-31 21:41:55'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 21:41:49'}
urltoken=CFID=4074892&CFTOKEN=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
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#=4074892&CFTOKEN#=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704#lastvisit={ts '2026-05-31 21:41:54'}#hitcount=38#timecreated={ts '2026-05-31 21:41:49'}#cftoken=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704#cfid=4074892#
CFID=4074892
CFTOKEN=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
Session Variables:
cfid=4074892
cftoken=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
sessionid=BOOKBROWSE_4074892_590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
urltoken=CFID=4074892&CFTOKEN=590379a282653914-FFDC2575-EE2E-23E5-DD9BC40E74D64704
URL Parameters:
ezine_preview_number=20269
page=3
the-lost-story-of-eva-fuentes=
Debug Rendering Time: 22 ms