MW

Michele W

+ Follow

Reviews (14)

The Book of Speculation
by Erika Swyler
Easy Reader (3/28/2015)
This is the story of a family forever damned to watery death by -- a book?, a curse?, genetics? What becomes certain to the protagonist, Simon Watson, librarian, is that his family history is disturbing and there may be immediate repercussions for its living descendants. So far, so good. There is a story here, and some strong place and time opportunities, but in the end, everybody could have been living in the same time and place. For me, there wasn't adequate explanation of the occult side of things, though the characters were attractive and I could see this as a movie. It seemed to me the Easy Reader version of a real sic-fi thriller.
The Quick
by Lauren Owen
Not So Quick (4/9/2014)
This story of late Victorian London had little new or thrilling to offer- no romance, no suspense, no clever twists and turns. The ending was totally predictable. It was not badly written, but not well-written, either. All in all, very average.
The Cairo Affair
by Olen Steinhauer
Almost thrilling (12/4/2013)
The main character in The Cairo Station is Sophie. A Harvard graduate who married a fellow Harvard grad in 1991, Sophie agreed with husband Emmett that America wasn't where real life was happening. They went to Eastern Europe on their honeymoon, Sophie acquiescing despite her desire to see Paris, and then spent a few days in a small village in the Balkans just as the war was heating up. There they met Zora, a mysterious and compelling woman who showed them the sights. Two incidents from this time haunted Sophie in future years. First, her souvenir bust of Lenin was stolen by a child in the streets, and second, they became involved in a life and death situation whose details comprise the better part of the plot and take a while to emerge. Suffice to say that both incidents seemed to impact Sophie equally, though the latter would be the one to cause trouble 20 years later when they were stationed with the US government in Cairo and Zora turned up again.

In early 2011, the Arab Spring had begun. The Libyans were in revolt, and Cairo was abuzz. Agents from different countries vied for information. It was impossible to tell who was lying, who was just ignorant, and what the heck was going on. Were the Americans trying to hijack the revolution now that the Libyan masses had taken first steps to freedom themselves, or was Ghadafi using an old CIA plan to rid himself of opponents? Here begins the real plot, and suddenly the book becomes all about misdirection. Stories are told and retold from different perspectives. Characters speculate about the myriad possibilities. Is X lying? Does he even know what's going on? What if this is true? On the other hand, maybe that is true? What is truth? Who can know? Who are the heroes, which of the characters has altruistic motives and which are cynical? Which are devoted to their country and which to money? As the story unfolds, refolds and unfolds again, the extent of Sophie's involvement becomes clear, layer by layer.

The writing is average. The character development is average for a thriller. An attempt was made to explain the various motivations of the characters, but failed in my opinion. Sometimes I actually cringed at the sex scenes. I was put off by the cliches about Americans--there is a scene at Logan Airport near the end which was offensive and filled with trite observations. The plot was average. The misdirection was massive and tried my patience.

I would give it an average grade overall.
Lost Luggage
by Jordi Punti
Four of a Kind (8/12/2013)
I enjoyed reading Lost Luggage despite the fact that I skimmed large parts of the book. It reminded me of The Tiger's Wife in that traumatic issues were discussed, but without real feeling, making them more like fables or legends than realistic fiction. I also thought both books were engaging in plot and structure despite flaws in the development of the main character (Grandfather in The Tiger's Wife and Gabriel in Lost Luggage), and excessive development of secondary characters. The plot of Lost Luggage is basically simple, but the twists at the end made me glad I read it all the way through. I don't think it would be the very best book club read.
Golden Boy
by Abigail Tarttelin
Better than Defending Jacob (12/31/2012)
Golden Child is the story of a nearly perfect child whose caring and successful parents, confronted by a dilemma involving this child and which has implications far beyond their family circle, disagree on what should be done to the extent that the family fractures.

So far this sounds much like Defending Jacob, and it is very reminiscent, but Golden Child is better in that the parents are not totally blind and deaf, the science is not ridiculously exaggerated, the child's feelings are included along with those of the sibling, a friend, the doctor involved, as well as both parents, giving a much more balanced and complete picture, and finally, the resolution is not insane. I liked the writing style and the structure, which I thought opened up the characters and made them much more three-dimensional. The resolution of the problem is nuanced as well as complicated and has the advantage of being possible in the real world assuming the essential normality of the characters involved. If you like Defending Jacob, you'll like this better!
With or Without You: A Memoir
by Domenica Ruta
Too high up (11/25/2012)
Domenica Ruta is a courageous woman, and an admirable fighter for her own life. With or Without You is the story of her first 30 years and her struggle to recover from an abusive childhood. Nikki uses humor and her great intelligence to protect herself when her family, especially her mother, exposes her to harm. Even while she understands her mother's flaws, she is strongly connected to her. She frees herself by stages, and as Nikki's alcoholism grows worse and worse, she inches towards a decision in favor of survival. Nikki's story is sadly familiar. She is an insightful writer who has learned to hide her feelings so thoroughly that she tells her own story from 30,000 feet, as it were. I don't know if Nikki will ever come to terms with her feelings, and if she does, she might just choose to keep it to herself. I would love to hear from her again in this or any other format, but on the basis of her first book, I would especially like to see her try fiction.
Sharp: A Memoir
by David Fitzpatrick
Sharp (6/25/2012)
It's not that I'm unsympathetic to the suffering of the author; it's not that I don't admire his writing skill. I actually feel little guilty that I wasn't more moved by this tale of Fitzpatrrick's sad life as a victim, a non-suicidal cutter, and a manic-depressive professional mental patient. I always have trouble summoning up much empathy for people who accept victimhood as passively as David Fitzpatrick did. It's my nature to fight with all my strength, and I don't understand those who submit. Fitzpatrick tells us that self-punishers like him are competitive, and usually stop in their thirties when they begin to understand the essential futility of continuing on this path. David, on the other hand, didn't stop cutting and burning himself until he was over 40, a degree of stubborn hubris that he appears to think is his proudest life achievement. He leaves hints about sexual preoccupations, about family sadism, about religious confusions, and severe drug abuse, but he never puts it all together. His self-punishing, which was always non-suicidal, still seems to be his main source of self-esteem, judging by the attention he devotes to his episodes. Getting better is a process and this is where he is right now, but not where he may end up. I wish him all the luck in the world.
The Age of Miracles: A Novel
by Karen Thompson Walker
Almost good (5/13/2012)
I was immediately captured by this book and its main character, a sixth grader with a crush on the mysterious boy on the skate board, who while grappling with puberty, must also come to terms with the end of life on Earth. I loved the idea of the sudden and inexplicable lengthening of days and nights, and the way that small alterations in the way the Earth spun on its axis quite gradually changed everything about our complicated ecosystem. But in the end, neither the plot nor the science could live up to its early promise. I would not hesitate to recommend The Age of Miracles for YA readers, but not for adult fans of dystopian novels.
A Land More Kind Than Home: A Novel
by Wiley Cash
a land more kind than home (3/3/2012)
"A Land More Kind Than Home" is a thriller set in a small town in the mountains of rural North Carolina. It is the story of a local church whose practices are extreme and dangerous, and the impact of this unhealthy religion and its sociopathic pastor on one family. The novel starts slowly, but builds to a stunning conclusion. Using three narrators, the author takes an old story and multiplies its impact, effectively building suspense by means of both structure and language. I found myself racing through the book to the next revelation, and finished it in a single day.
Losing Clementine: A Novel
by Ashley Ream
Losing Clementine (2/3/2012)
Clementine Pritchard is a financially successful artist who has made a life decision. Her mental illness is unendurable, with her prescribed medications or without them. She decides she has no choice but to commit suicide, and gives herself thirty days to get everything ready so that those left behind will not be forced to clean up a big mess --literally and figuratively. In her disorderly way, she begins to set her affairs in order, one day at a time, revealing along the way what has brought her to this desperate decision. The book is funny and ultimately touching. I was enjoying it moderately until the middle, when it suddenly became a book I couldn't put down. Clementine, as the narrator, tells a story as mixed up as she is, but have patience. All will be revealed, and it's worth the effort.
Behind the Beautiful Forevers: Life, Death, and Hope in a Mumbai Undercity
by Katherine Boo
Ordinary Lives (1/7/2012)
This book requires reflection, and the writing is so densely packed with information and interpretation that I had to stop reading after every few pages to digest it all. Katharine Boo is a journalist who worked among the Hindu and Muslim people of the Mumbai slum called Annawadi, following them for years until they forgot she was filming; prodding them to express their thoughts aloud; hoping that her efforts would somehow illuminate universal concepts about global development, poverty and unfairness. She makes the lives she chronicles understandable to people who've never missed a meal or contracted jaundice or worms from a sewage lake that adjoins their neighborhood. And she makes slum dwellers precious to us by revealing their inner lives.

Her heroes and heroines are clawing their way up the economic ladder by stealing, swindling, and defrauding the government, charitable organizations, and each other. Hospital workers sell life-saving drugs in the streets while nurses refuse to touch patients in the wards. Policemen extort citizens who are beginning to make money, ruining their lives. Death comes early and often as neighbors refuse to help a man who needs an operation and step over a man lying injured on the sidewalk, leaving him to die. Suicide and accidental deaths are common occurrences. In this environment, Boo says, the need to beat out others in order to survive strangles empathy as well as organized resistance to corruption. Each family must be dedicated only to their own survival, and must put aside finer feelings in order to make progress into the middle class.

Despite all evidence to the contrary, Boo suggests that it is not foolish to hope in Annawadi. She maintains that life is improving for the impoverished, although very slowly and unevenly. The playing field is tilted against them, and they are prevented by their condition from joining together to reform the governments which ought to be helping them but are too often making things worse due to corruption.

This is a stunning and sometimes difficult book to read, but well worth a bit of discomfort. I think that Boo succeeded admirably in finding universal truth in the lives of ordinary people, and I think some lessons could be learned for our own lives and country.
The Orphan Master's Son: A Novel
by Adam Johnson
Trauma narrative (10/13/2011)
Adam Johnson describes his new book, The Orphan Master's Son as a trauma narrative, and it is. But it's also beautifully complex, densely plotted and peopled with memorable characters struggling to live in the twisted world of the Dear Leader, Kim Jong Il. It's horrifying, exciting, touching, funny, demanding, and impossible to describe adequately in 50 words. If you love David Mitchell's Cloud Atlas or The Thousand Autumns of Jacob de Zoet, I believe you will adore The Orphan Master's Son.
The Kitchen Daughter: A Novel
by Jael McHenry
Cooking with Spirits (4/3/2011)
Ginny Selvaggio is a 26-year-old woman who lives at home with her father, a doctor, and her overprotective mother. As the book opens, she is attending her parents' funeral. They have died years before their time, in a vacation cabin, of carbon monoxide poisoning. It becomes obvious immediately that Ginny has a problem. She cannot look people in the eyes or read social cues. She responds to touch by screaming or escaping into a dark closet for hours. She has a photographic memory and becomes engrossed in esoteric topics. The author has Ginny tell her own story, and does a fine job depicting her disability via her behavior and her thoughts. As a psychologist who worked with children, I was able to diagnose Ginny's problem long before she herself became aware of what made her a little different. She was preoccupied with the idea of normality, and cut up advice columns, pasted them in a book, and read them often to remind herself that nobody really knows what normal is. Ginny has a younger sister named Amanda who feels it necessary to take over where their mother left off in protecting Ginny from the world. Without consulting her, Amanda decides to sell the family home and make Ginny move in with her and her husband and children. Ginny is aghast and gathers her strength to resist Amanda's plan. Forced to take care of herself, Ginny improves her coping skills. Instead of hiding in the dark, she thinks about carmelized onions, or sesame oil, or a favorite recipe. Ginny's mother taught her to cook, and she cooks for comfort rather than to actually eat. After the funeral, Ginny makes the bread soup that her Italian grandmother made and wrote out for her on a recipe card. As she finishes, her grandmother's ghost suddenly appears on the kitchen stool, wearing a Shaker sweater and white Keds (she died in the '90's) She gives Ginny a cryptic warning, and the rest of the book involves Ginny sleuthing to find out what the warning means. She deduces that all she has to do to summon a person's ghost is to cook a recipe written in their hand. But it only works once, so she has to be sure she knows what she wants to ask. This is not so easy, and she summons several ghosts before she can understand the issues. She is supported in her fight to remain independent by her mother's cleaning lady, the Cuban-Jewish Gert, who not only gives her good advice, but also provides her with a way to get out of the house and make a life for herself. There were a couple of twists that caught me by surprise, which usually means I'm so busy enjoying the details that I don't stop to think about where the book is going. There is a lesson for us all in Ginny's growing understanding that appearances can't be trusted, that normal is indefinable, and that communication is difficult at the best of times.
Three Seconds
by Anders Roslund & Borge Hellstrom
Three Seconds (11/29/2010)
I wanted to review "Three Seconds" because I am a huge fan of Maj Sjowall and Per Wahloo, the pioneers and unchallenged masters of the Swedish police procedural, as well as Henning Mankell, who has followed in their footsteps with his charming and clever Wallender mysteries. "Three Seconds" is heir to the traditional formula in that it combines an intricate plot with pointed criticism of the Swedish state. Several crimes that are initially thought to be unrelated are shown to be part of the same larger picture. The lead detective is flawed, eccentric and interpersonally-challenged. The humor is missing, however, and therefore the book reads much more like a thriller a la James Patterson. I was distracted by the repetition of information, and by the occasional Britishisms in the translation (Can you really describe the indisposition of a cold-blooded criminal as a "dicky tummy?") At first, the rapid switches between stories and characters was difficult to follow. On the other hand, the plot was engrossing and the jumpy structure probably enhances the suspense as intended. There is a sort of a trick ending, but the impact is reduced by the fact that the reader has already figured it out, and is just hanging around to find out how it was done. In spite of its flaws, I enjoyed reading "Three Seconds", and I would rate it an above-average thriller that should appeal to those who like this genre.

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

There are two kinds of light - the glow that illuminates, and the glare that obscures.

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 /readers/index.cfm
Time Stamp 01-Jun-26 11:40 AM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780314051614 ms 1.78031405161E+012 ms 1 /root/website/app_server.cfm
2763 ms 2763 ms 1 /root/website/readers/index.cfm
2041 ms 2041 ms 1 /root/website/readers/dsp_profile.cfm
1317 ms 439 ms 3 /root/website/queries/qry_get_book_by_id.cfm
343 ms 343 ms 1 /root/website/app_layout.cfm
332 ms 30 ms 11 /root/website/queries/qry_get_preview_by_id_for_search.cfm
249 ms 249 ms 1 /root/website/app_globals.cfm
221 ms 221 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
219 ms 20 ms 11 /root/website/queries/qry_get_preview_awards_by_id.cfm
157 ms 79 ms 2 /root/website/adsystem/adsystem_mod.cfm
109 ms 109 ms 1 /root/website/queries/qry_get_active_obc.cfm
101 ms 101 ms 1 /root/website/adzones/AdZone6.cfm
94 ms 94 ms 1 /root/website/queries/qry_get_reviews_by_member.cfm
68 ms 68 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
67 ms 67 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
63 ms 63 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
61 ms 61 ms 1 /root/website/adzones/showcase_track.cfm
53 ms 53 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_current_competition.cfm
47 ms 47 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_member_profile.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
21 ms 21 ms 1 /root/website/act_check_login.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_member_info.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_follower_count.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_following_count.cfm
18 ms 18 ms 1 /root/website/actions/adstatus.cfm
15 ms 5 ms 3 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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/layout/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2765 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 11:40:51.051
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 11:40:51.051
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=17ms, Records=2) in /root/website/actions/adstatus.cfm @ 11:40:51.051
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 @ 11:40:51.051
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=24ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 11:40:51.051
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:40:51.051
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=36ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:40:51.051
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 @ 11:40:51.051
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=27ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 11:40:51.051
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=33ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 11:40:51.051
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=46ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 11:40:51.051
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_member_profile (Datasource=bookbrowse_com_new, Time=27ms, Records=1) in /root/website/queries/qry_get_member_profile.cfm @ 11:40:51.051
SELECT  m.member_number, m.discourse_username, m.member_first_name, m.member_last_name, m.profile_image_url, m.member_full_name, m.member_bio, m.external_link, m.member_classification_number, m.member_email
        FROM    members m
        WHERE   m.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4429

get_reviews_by_member (Datasource=bookbrowse_com_new, Time=93ms, Records=14) in /root/website/queries/qry_get_reviews_by_member.cfm @ 11:40:51.051
SELECT  a.book_number, a.ezine_preview_number, a.reader_review_number,
            COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
            a.reader_review_title, a.reader_review_rating, a.reader_review_description, a.reader_review_dt,
            (SELECT COUNT(*) FROM reader_review_likes rl WHERE rl.reader_review_number = a.reader_review_number) AS like_count
    FROM    reader_reviews a
    LEFT OUTER JOIN members m ON m.member_number = a.member_number
    WHERE   a.member_number = ?
    AND     a.reader_review_approved_flag = 1
    
        ORDER BY a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4429

get_follower_count (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/queries/qry_get_follower_count.cfm @ 11:40:52.052
SELECT COUNT(*) AS follower_count
    FROM member_follows
    WHERE followed_member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4429

get_following_count (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_following_count.cfm @ 11:40:52.052
SELECT COUNT(*) AS following_count
    FROM member_follows
    WHERE follower_member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4429

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 @ 11:40:52.052
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
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/readers/dsp_profile.cfm @ 11:40:52.052
SELECT * FROM get_reader_reviews_power_reviewers
                WHERE reader_review_reviewer_email_address = 'michelew@me.com'
get_preview_by_id (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 10445

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=25ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 10445

get_preview_by_id (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9403

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=21ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 9403

get_preview_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 9072

get_author_name (Datasource=bookbrowse_com_new, Time=26ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	a.author_number, datalength(b.author_info_interview) as "interview",
		        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 "author_name"
        FROM 		authors a
        INNER JOIN 	author_info b on b.author_number = a.author_number 
        
        WHERE 		a.author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1664

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 9072

get_preview_by_id (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8739

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 8739

get_preview_by_id (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7945

get_author_name (Datasource=bookbrowse_com_new, Time=33ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	a.author_number, datalength(b.author_info_interview) as "interview",
		        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 "author_name"
        FROM 		authors a
        INNER JOIN 	author_info b on b.author_number = a.author_number 
        
        WHERE 		a.author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2658

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=24ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 7945

get_preview_by_id (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7805

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 7805

get_preview_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7373

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 7373

get_preview_by_id (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 7155

get_author_name (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	a.author_number, datalength(b.author_info_interview) as "interview",
		        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 "author_name"
        FROM 		authors a
        INNER JOIN 	author_info b on b.author_number = a.author_number 
        
        WHERE 		a.author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3173

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=31ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 7155

get_book_by_id (Datasource=bookbrowse_com_new, Time=76ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:52.052
SELECT		a.book_number, a.book_title, a.book_sub_title, a.book_url, a.book_entry_dt, a.book_short_summary, a.book_excerpt, a.book_jacket_info, a.book_reading_guide, a.book_copyright_info, a.book_notes,
            	b.author_number, b.author_first_name, b.author_last_name, b.author_middle_initial,
            	f.edition_publish_dt AS "hardcover_publish_dt", f.edition_number_of_pages AS "hardcover_number_of_pages", f.edition_isbn AS "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13", f.edition_jacket_image as "hardcover_jacket_image", f.edition_publisher as "hardcover_publisher",
            	g.edition_publish_dt AS "paperback_publish_dt", g.edition_number_of_pages AS "paperback_number_of_pages", g.edition_isbn AS "paperback_isbn", g.edition_isbn13 "paperback_isbn13", g.edition_jacket_image as "paperback_jacket_image", g.edition_publisher as "paperback_publisher",
            	i.author_info_interview, i.author_info_biography,i.author_info_image,
            	CASE WHEN datalength(author_middle_initial) = 1 THEN author_first_name + ' ' + author_middle_initial + ' ' + author_last_name
            		 ELSE author_first_name + ' ' + author_last_name
            		 END "author_name",
            	CASE WHEN 
					(select count(*) from editions where book_number = 4364) = 1
					AND
					(select count(*) from editions where book_number = 4364 and edition_paperback_flag = 1) = 1
				THEN 1
				ELSE 0
				END AS "po_flag",
				(select count(*) from book_author_mapping m where m.author_number = b.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = b.author_number and ezine_preview_bb_link =0)
				 as 'author_bookcount',
            	(SELECT CAST(AVG(CAST(rating AS decimal(12,0))) AS decimal(12,1))
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) "savrating",
			(SELECT COUNT(rating)
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) as "savrating_count",
            	(select top 1 media_review_rating from media_reviews where book_number = a.book_number and media_review_type_number = 9) as "bbrating",
            	(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,1)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating",
				(SELECT COUNT(media_review_rating) FROM media_reviews WHERE book_number = a.book_number AND media_review_type_number <> 7 AND media_review_rating > 0) as "scritrating_count",
            	(select top 1 gg.ezine_number from ezine_edition_mapping aa, editions bb, books cc, ezines gg            	
            	where aa.edition_number = bb.edition_number and bb.book_number = cc.book_number and aa.ezine_number = gg.ezine_number 
            	and cc.book_number = a.book_number and gg.ezine_bbsays_flag = 1 and gg.ezine_active_flag = 1) as "ezine_number",
				cgm.category_number,
				cgya.category_number AS "ya_flag"
				
,(select top 1 publisher_holding_company from publishers where (publisher_imprint like f.edition_publisher OR publisher_imprint like g.edition_publisher) AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
        
    FROM		books a 
    INNER JOIN	book_author_mapping c ON c.book_number = a.book_number
    INNER JOIN	authors b ON b.author_number = c.author_number  
    INNER JOIN	author_info i ON i.author_number = b.author_number
    
    LEFT JOIN	editions f ON f.book_number = a.book_number AND f.edition_paperback_flag = 0
    LEFT JOIN	editions g ON g.book_number = a.book_number AND g.edition_paperback_flag = 1
    LEFT JOIN	category_book_mapping cgm on cgm.book_number = a.book_number AND cgm.category_number = 48
    LEFT JOIN	category_book_mapping cgya on cgya.book_number = a.book_number AND cgya.category_number = 40
          
    WHERE 		a.book_number = ?
         
    ORDER BY	c.book_author_mapping_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2693

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=336ms, Records=5) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:52.052
SELECT		a.media_review_number, 
				a.book_number, 
				a.media_review_type_number, 
				a.media_review_title, 
				a.media_review_rating, 
				a.media_review, 
				a.media_review_old,
	
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 (case when dbo.WordCount(c.ezine_review_2) > 0 then dbo.WordCount(c.ezine_review_2) + dbo.WordCount(c.ezine_extras) 
                                                                                    else dbo.WordCount(c.ezine_review) 
                                                                                    end)
                                                                from ezine_edition_mapping c
                                                                INNER JOIN editions d ON (d.edition_number = c.edition_number)
                                                                INNER JOIN ezines e ON e.ezine_number = c.ezine_number
                                                                WHERE d.book_number = ?
                                                                
                                                                ORDER BY e.ezine_number ASC)
	 			ELSE 0 
	 			END  "wordc",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_number
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			ELSE 1
				END "reviewer_number",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_first_name + ' ' + reviewer_last_name AS "reviewer_name"
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
																 INNER JOIN reviewers r on r.reviewer_number = c.reviewer_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			END "reviewer_name"
	
	FROM		media_reviews a, media_review_types b
	
	WHERE		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
	AND			a.book_number = ?
	AND			a.media_review_type_number = b.media_review_type_number
	
	ORDER BY	b.media_review_type_sort_order ASC, media_review_rating DESC, media_review_title ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2693
Parameter #2(CF_SQL_INTEGER) = 2693
Parameter #3(CF_SQL_INTEGER) = 2693
Parameter #4(CF_SQL_INTEGER) = 2693

get_book_image (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:52.052
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) = 2693

get_coauthor (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:52.052
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2693

get_preview_by_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6953

get_author_name (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:52.052
SELECT 	a.author_number, datalength(b.author_info_interview) as "interview",
		        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 "author_name"
        FROM 		authors a
        INNER JOIN 	author_info b on b.author_number = a.author_number 
        
        WHERE 		a.author_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2785

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:52.052
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) = 6953

get_book_by_id (Datasource=bookbrowse_com_new, Time=40ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:52.052
SELECT		a.book_number, a.book_title, a.book_sub_title, a.book_url, a.book_entry_dt, a.book_short_summary, a.book_excerpt, a.book_jacket_info, a.book_reading_guide, a.book_copyright_info, a.book_notes,
            	b.author_number, b.author_first_name, b.author_last_name, b.author_middle_initial,
            	f.edition_publish_dt AS "hardcover_publish_dt", f.edition_number_of_pages AS "hardcover_number_of_pages", f.edition_isbn AS "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13", f.edition_jacket_image as "hardcover_jacket_image", f.edition_publisher as "hardcover_publisher",
            	g.edition_publish_dt AS "paperback_publish_dt", g.edition_number_of_pages AS "paperback_number_of_pages", g.edition_isbn AS "paperback_isbn", g.edition_isbn13 "paperback_isbn13", g.edition_jacket_image as "paperback_jacket_image", g.edition_publisher as "paperback_publisher",
            	i.author_info_interview, i.author_info_biography,i.author_info_image,
            	CASE WHEN datalength(author_middle_initial) = 1 THEN author_first_name + ' ' + author_middle_initial + ' ' + author_last_name
            		 ELSE author_first_name + ' ' + author_last_name
            		 END "author_name",
            	CASE WHEN 
					(select count(*) from editions where book_number = 4364) = 1
					AND
					(select count(*) from editions where book_number = 4364 and edition_paperback_flag = 1) = 1
				THEN 1
				ELSE 0
				END AS "po_flag",
				(select count(*) from book_author_mapping m where m.author_number = b.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = b.author_number and ezine_preview_bb_link =0)
				 as 'author_bookcount',
            	(SELECT CAST(AVG(CAST(rating AS decimal(12,0))) AS decimal(12,1))
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) "savrating",
			(SELECT COUNT(rating)
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) as "savrating_count",
            	(select top 1 media_review_rating from media_reviews where book_number = a.book_number and media_review_type_number = 9) as "bbrating",
            	(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,1)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating",
				(SELECT COUNT(media_review_rating) FROM media_reviews WHERE book_number = a.book_number AND media_review_type_number <> 7 AND media_review_rating > 0) as "scritrating_count",
            	(select top 1 gg.ezine_number from ezine_edition_mapping aa, editions bb, books cc, ezines gg            	
            	where aa.edition_number = bb.edition_number and bb.book_number = cc.book_number and aa.ezine_number = gg.ezine_number 
            	and cc.book_number = a.book_number and gg.ezine_bbsays_flag = 1 and gg.ezine_active_flag = 1) as "ezine_number",
				cgm.category_number,
				cgya.category_number AS "ya_flag"
				
,(select top 1 publisher_holding_company from publishers where (publisher_imprint like f.edition_publisher OR publisher_imprint like g.edition_publisher) AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
        
    FROM		books a 
    INNER JOIN	book_author_mapping c ON c.book_number = a.book_number
    INNER JOIN	authors b ON b.author_number = c.author_number  
    INNER JOIN	author_info i ON i.author_number = b.author_number
    
    LEFT JOIN	editions f ON f.book_number = a.book_number AND f.edition_paperback_flag = 0
    LEFT JOIN	editions g ON g.book_number = a.book_number AND g.edition_paperback_flag = 1
    LEFT JOIN	category_book_mapping cgm on cgm.book_number = a.book_number AND cgm.category_number = 48
    LEFT JOIN	category_book_mapping cgya on cgya.book_number = a.book_number AND cgya.category_number = 40
          
    WHERE 		a.book_number = ?
         
    ORDER BY	c.book_author_mapping_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2667

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=455ms, Records=16) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:53.053
SELECT		a.media_review_number, 
				a.book_number, 
				a.media_review_type_number, 
				a.media_review_title, 
				a.media_review_rating, 
				a.media_review, 
				a.media_review_old,
	
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 (case when dbo.WordCount(c.ezine_review_2) > 0 then dbo.WordCount(c.ezine_review_2) + dbo.WordCount(c.ezine_extras) 
                                                                                    else dbo.WordCount(c.ezine_review) 
                                                                                    end)
                                                                from ezine_edition_mapping c
                                                                INNER JOIN editions d ON (d.edition_number = c.edition_number)
                                                                INNER JOIN ezines e ON e.ezine_number = c.ezine_number
                                                                WHERE d.book_number = ?
                                                                
                                                                ORDER BY e.ezine_number ASC)
	 			ELSE 0 
	 			END  "wordc",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_number
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			ELSE 1
				END "reviewer_number",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_first_name + ' ' + reviewer_last_name AS "reviewer_name"
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
																 INNER JOIN reviewers r on r.reviewer_number = c.reviewer_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			END "reviewer_name"
	
	FROM		media_reviews a, media_review_types b
	
	WHERE		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
	AND			a.book_number = ?
	AND			a.media_review_type_number = b.media_review_type_number
	
	ORDER BY	b.media_review_type_sort_order ASC, media_review_rating DESC, media_review_title ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2667
Parameter #2(CF_SQL_INTEGER) = 2667
Parameter #3(CF_SQL_INTEGER) = 2667
Parameter #4(CF_SQL_INTEGER) = 2667

get_book_image (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:53.053
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) = 2667

get_coauthor (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:53.053
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2667

get_book_by_id (Datasource=bookbrowse_com_new, Time=37ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:53.053
SELECT		a.book_number, a.book_title, a.book_sub_title, a.book_url, a.book_entry_dt, a.book_short_summary, a.book_excerpt, a.book_jacket_info, a.book_reading_guide, a.book_copyright_info, a.book_notes,
            	b.author_number, b.author_first_name, b.author_last_name, b.author_middle_initial,
            	f.edition_publish_dt AS "hardcover_publish_dt", f.edition_number_of_pages AS "hardcover_number_of_pages", f.edition_isbn AS "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13", f.edition_jacket_image as "hardcover_jacket_image", f.edition_publisher as "hardcover_publisher",
            	g.edition_publish_dt AS "paperback_publish_dt", g.edition_number_of_pages AS "paperback_number_of_pages", g.edition_isbn AS "paperback_isbn", g.edition_isbn13 "paperback_isbn13", g.edition_jacket_image as "paperback_jacket_image", g.edition_publisher as "paperback_publisher",
            	i.author_info_interview, i.author_info_biography,i.author_info_image,
            	CASE WHEN datalength(author_middle_initial) = 1 THEN author_first_name + ' ' + author_middle_initial + ' ' + author_last_name
            		 ELSE author_first_name + ' ' + author_last_name
            		 END "author_name",
            	CASE WHEN 
					(select count(*) from editions where book_number = 4364) = 1
					AND
					(select count(*) from editions where book_number = 4364 and edition_paperback_flag = 1) = 1
				THEN 1
				ELSE 0
				END AS "po_flag",
				(select count(*) from book_author_mapping m where m.author_number = b.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = b.author_number and ezine_preview_bb_link =0)
				 as 'author_bookcount',
            	(SELECT CAST(AVG(CAST(rating AS decimal(12,0))) AS decimal(12,1))
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) "savrating",
			(SELECT COUNT(rating)
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) as "savrating_count",
            	(select top 1 media_review_rating from media_reviews where book_number = a.book_number and media_review_type_number = 9) as "bbrating",
            	(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,1)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating",
				(SELECT COUNT(media_review_rating) FROM media_reviews WHERE book_number = a.book_number AND media_review_type_number <> 7 AND media_review_rating > 0) as "scritrating_count",
            	(select top 1 gg.ezine_number from ezine_edition_mapping aa, editions bb, books cc, ezines gg            	
            	where aa.edition_number = bb.edition_number and bb.book_number = cc.book_number and aa.ezine_number = gg.ezine_number 
            	and cc.book_number = a.book_number and gg.ezine_bbsays_flag = 1 and gg.ezine_active_flag = 1) as "ezine_number",
				cgm.category_number,
				cgya.category_number AS "ya_flag"
				
,(select top 1 publisher_holding_company from publishers where (publisher_imprint like f.edition_publisher OR publisher_imprint like g.edition_publisher) AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
        
    FROM		books a 
    INNER JOIN	book_author_mapping c ON c.book_number = a.book_number
    INNER JOIN	authors b ON b.author_number = c.author_number  
    INNER JOIN	author_info i ON i.author_number = b.author_number
    
    LEFT JOIN	editions f ON f.book_number = a.book_number AND f.edition_paperback_flag = 0
    LEFT JOIN	editions g ON g.book_number = a.book_number AND g.edition_paperback_flag = 1
    LEFT JOIN	category_book_mapping cgm on cgm.book_number = a.book_number AND cgm.category_number = 48
    LEFT JOIN	category_book_mapping cgya on cgya.book_number = a.book_number AND cgya.category_number = 40
          
    WHERE 		a.book_number = ?
         
    ORDER BY	c.book_author_mapping_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2642

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=368ms, Records=7) in /root/website/queries/qry_get_book_by_id.cfm @ 11:40:53.053
SELECT		a.media_review_number, 
				a.book_number, 
				a.media_review_type_number, 
				a.media_review_title, 
				a.media_review_rating, 
				a.media_review, 
				a.media_review_old,
	
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 (case when dbo.WordCount(c.ezine_review_2) > 0 then dbo.WordCount(c.ezine_review_2) + dbo.WordCount(c.ezine_extras) 
                                                                                    else dbo.WordCount(c.ezine_review) 
                                                                                    end)
                                                                from ezine_edition_mapping c
                                                                INNER JOIN editions d ON (d.edition_number = c.edition_number)
                                                                INNER JOIN ezines e ON e.ezine_number = c.ezine_number
                                                                WHERE d.book_number = ?
                                                                
                                                                ORDER BY e.ezine_number ASC)
	 			ELSE 0 
	 			END  "wordc",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_number
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			ELSE 1
				END "reviewer_number",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_first_name + ' ' + reviewer_last_name AS "reviewer_name"
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
																 INNER JOIN reviewers r on r.reviewer_number = c.reviewer_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			END "reviewer_name"
	
	FROM		media_reviews a, media_review_types b
	
	WHERE		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
	AND			a.book_number = ?
	AND			a.media_review_type_number = b.media_review_type_number
	
	ORDER BY	b.media_review_type_sort_order ASC, media_review_rating DESC, media_review_title ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2642
Parameter #2(CF_SQL_INTEGER) = 2642
Parameter #3(CF_SQL_INTEGER) = 2642
Parameter #4(CF_SQL_INTEGER) = 2642

get_book_image (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:53.053
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) = 2642

get_coauthor (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/actions/udfs.cfm @ 11:40:53.053
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2642

get_preview_by_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:53.053
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 6132

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=40ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:53.053
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) = 6132

get_preview_by_id (Datasource=bookbrowse_com_new, Time=62ms, Records=1) in /root/website/queries/qry_get_preview_by_id_for_search.cfm @ 11:40:54.054
SELECT 	ezine_preview_number,
            ezine_preview_title, 
            ezine_preview_subtitle, 
            ezine_preview_author, 
            ezine_preview_publisher,
            ezine_preview_publish_dt,
            ezine_preview_number_of_pages, 
            ezine_preview_short_summary,
            ezine_preview_jacket_image,
            ezine_preview_reviews,
            ezine_preview_jacket_desc,
			ezine_preview_reading_guide,
            ezine_preview_isbn,
            ezine_preview_isbn13,
            ezine_preview_rating,
            ezine_preview_bb_author_link
            				
    FROM 	ezine_previews
    WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 5800

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:40:54.054
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) = 5800

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=41ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:40:54.054
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=24ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:40:54.054
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=50ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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=23ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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=23ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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=46ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 11:40:54.054
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 @ 11:40:54.054
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=20ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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=19ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:40:54.054
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/readers/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=CFTOKEN=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1; CFGLOBALS=urltoken%3DCFID%23%3D4098009%26CFTOKEN%23%3D391b54903d42526e%2D1DD582E4%2DD9DD%2D3BC2%2DD7A733D634D6AFB1%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2011%3A40%3A51%27%7D%23hitcount%3D285%23timecreated%3D%7Bts%20%272026%2D06%2D01%2011%3A39%3A57%27%7D%23cftoken%3D391b54903d42526e%2D1DD582E4%2DD9DD%2D3BC2%2DD7A733D634D6AFB1%23cfid%3D4098009%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4098009
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=/4429
PATH_TRANSLATED=/root/website/readers/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/readers/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=4098009
cftoken=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
hitcount=299
lastvisit={ts '2026-06-01 11:40:54'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 11:39:57'}
urltoken=CFID=4098009&CFTOKEN=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
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#=4098009&CFTOKEN#=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1#lastvisit={ts '2026-06-01 11:40:51'}#hitcount=285#timecreated={ts '2026-06-01 11:39:57'}#cftoken=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1#cfid=4098009#
CFID=4098009
CFTOKEN=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
Session Variables:
cfid=4098009
cftoken=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
sessionid=BOOKBROWSE_4098009_391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
urltoken=CFID=4098009&CFTOKEN=391b54903d42526e-1DD582E4-D9DD-3BC2-D7A733D634D6AFB1
URL Parameters:
4429=
Debug Rendering Time: 57 ms