What readers think of Only the Beautiful, plus links to write your own review.

Summary |  Excerpt |  Reading Guide |  Discuss |  Reviews |  Beyond the book |  Read-Alikes |  Genres & Themes |  Author Bio

Only the Beautiful by Susan Meissner

Only the Beautiful

by Susan Meissner
  • BookBrowse Review:
  • Critics' Consensus (5):
  • Readers' Rating (29):
  • First Published:
  • Apr 18, 2023, 400 pages
  • Paperback:
  • Mar 2024, 400 pages
  • Reviewed by BookBrowse Book Reviewed by:
    Jordan Lynch
  • Genres & Themes
  • Publication Information
  • Rate this book

Reviews

Page 1 of 2
There are currently 10 reader reviews for Only the Beautiful
Order Reviews by:

Write your own review!

Power Reviewer
Anthony_Conty

The Holocaust Has So Many Stories
My favorite critic, Roger Ebert, always made astute points but had seen so many movies that he had less tolerance for cliches. "Only the Beautiful" by Susan Meissner covers the often-discussed mistreatment of pregnant single women in the 1930s, a time when societal norms and attitudes towards unwed mothers were particularly harsh. Despite this familiar theme, the novel still feels fresh and new. Our hero, Rosie, can see colors when she hears sounds. This peculiarity, along with the pregnancy, places her in an asylum.

As a reader, I need help mixing realism with fantasy. You must hang onto the theme of seeing colors to see the point. The drama associated with our unwed mothers is heart-wrenching on its own. We also glimpse the future about how paternal responsibility can take a back seat as we only blame the mother for indiscretions.

I once recommended a book to a friend with three kids, and she told me not to make her read about child endangerment. Consider this mantra applicable here. When Rosie realizes that the staff assumes she will give up Baby Amaryllis, she enters a panicked flight mode. Her unique ability to see colors when she hears sounds, a condition known as synesthesia, is misunderstood and feared, leading to her mistreatment. This connection between her condition and the mistreatment she faces is a powerful exploration of societal attitudes towards difference and mental health in the 1930s.

Since many categorize the book as "mental health," I had to research a bit to see that Roseanne's condition, synesthesia, actually exists and synesthetes have turned their state into a positive. Since she was different, they sterilized her, and we see how the new narrator experienced similar thoughts while caring for a differently-abled child abroad.

This important book was heavy but worth the read.
Power Reviewer
Cheryl_Winter

Tragic Humanity
This book is heart wrenching, Rosie cannot catch a break, losing her parents, brother, taken in by someone who despises her and uses her as a maid. She becomes pregnant and taking to a home for the mentally handicapped. This book address so many areas including sterilization, eugenics plus what happens when you are different.
Carmel B

America's Secluded Shame
Meissner’s searing chronicle of the lives of Rosie and Helen is the most enlightening I have read since reading “Uncle Tom’s Cabin” when I was fifteen years old. I am now seventy-five. I learned three new words within the first few chapters: Eugenics, Salpingectomy and Synesthesia. It is also the first time I have ever read the “Acknowledgements” section at the end of any book and was astonished at its revelations. Fellow readers, this one is hard to put down and the kernels of truth informing its plot and characters harder to dismiss when you finally turn the reading lamp off at bedtime. As Meissner reminds us, "Let us not forget our past, lest we repeat it."
Power Reviewer
Elizabeth

Elizabeth@Silver's Reviews - WOW!! READ IT!!
WOW - another beautiful read by Susan Meissner!!

After Rosanne's parents were killed in an accident, she moved into the house of the vineyard owners where her parents worked.

Celine and Truman Calvert were always good to Rosanne and her family, but Celine said Roseanne couldn’t be treated like family but could be their domestic help.

Rosanne enjoyed her time as the family’s domestic until she was betrayed by their son when he told the Calverts she sees colors and which during this time society didn’t accept people who were different.

Seeing colors was considered different and a defect.

Another misfortune fell on her when she became pregnant by a member of the household.

Rosanne was sent to a home, but not one for unwed mothers. This home sterilized young women who had defects.

Meanwhile the Calvert’s daughter, Helen, was working in Europe as a nanny and kept in touch with Rosanne even though the contact lessened over the years.

When Helen came home after WWII and found out what happened to Rosanne nine years ago, she was saddened and shocked thinking of her young charge in Austria who was not perfect and was killed because of her defects.

Beautifully written with the main character, Rosanne, who you will love and who will pull at your heartstrings.

You will also become fond of Helen and praise all the good she did to help during WWII and when she came back to America.

ONLY THE BEAUTIFUL is another marvelous, marvelous read by Susan Meissner that fans will not want to miss and one I didn’t want to put down.

Enjoy, and have some tissues ready!! 5/5

This book was given to me by the publisher via NetGalley for an honest review.
Power Reviewer
Becky_Haase

a Must Read
This two-pronged story tells of the young vinedresser’s daughter, Roseanne, who is orphaned and then turned into a maid/servant by her supposed guardians. The inter twining story tells of Roseanne’s “aunt” who has shown her great kindness and love, but is far away in Europe facing her own devils when Roseanne’s parents die.
These two stories are dependent on each other as they tell of man’s inhumanity to man and also great love and resilience. Meissner is able to show both good and characters in all their faults, but also their humanity. She has done her research on vine dressing, wine making and on Europe in the years preceding and during Hitler’s rise. Meissners’ great ability to empathize with her characters and cause them to grow and change in the course of the story makes the novel radiant with life.
Book groups will have many topics to discuss – meaning of family, child abuse, discrimination, grief, adoption, exploitation of minors, mental health, abusive laws, sterilizations, love, empathy and more.
Janie-Hickok-Siess

Fiction Based on History That Must Never Be Forgotten
Author Susan Meissner says Only the Beautiful focuses on "a movement in history that has been all but forgotten." The eugenics movement led to state laws authorizing the sterilization of institutionalized citizens who had conditions deemed to result from genetic flaws for the purpose of "race betterment." Not only were persons with disabilities discouraged from having children in the name of "making better, healthier babies." Those adjudicated unable to make their own medical decisions were forcibly sterilized. Many of them were labeled "feeble minded" or "imbeciles," but even persons with epilepsy and alcoholism were subjected to the irreversible medical procedure against their will.

When Meissner began her research for the book, she had only passing knowledge of the eugenics movement. While conducting research to pen The Nature of Fragile Things, she happened upon photographs from the 1915 World’s Fair in San Francisco, one of which depicted an exhibit touting eugenics. She continued researching and when she learned about the tragic case of Carrie Buck, she "toyed with" the idea of fictionalizing her story but abandoned the notion because she realized Buck's story "was just too sad." Although Buck earned average grades in school, she lived in poverty and was targeted as an "imbecile," largely because her mother was institutionalized. While a foster child, she was assaulted and impregnated by the foster family's nephew. At just eighteen years of age, she was the first person involuntarily sterilized in Virginia pursuant to a statute which was, unbelievably, upheld by the U.S. Supreme Court’s 1927 decision in Buck v. Bell. The Court found that sterilization of institutionalized persons who were deemed to suffer from a hereditary form of insanity or imbecility was within the power accorded states under the Fourteenth Amendment.

Sadly, Virginia was not the only state seeking “race betterment.” The Buck case permitted laws to be enacted in all fifty states that remained in effect for decades and resulted in the forced sterilization of more than sixty thousand men and women. California, which has for many years provided the broadest civil rights protections of any state, was actually the worst offender. Between 1909 and 1964, the highest number – more than twenty thousand -- of involuntary sterilizations were performed in the state and the law permitting the procedure was not repealed until 1979. It wasn’t until 2003 that the State issued a formal apology and $7.5 million was earmarked for reparation payments to victims in 2021.

Meissner determined to tell a story built around fictional characters, but based on actual historical events that would encompass "powerful, hopeful moments." She succeeded.

Only the Beautiful opens in 1938. Meissner tells the tragic story of Rosie, who grew up in a loving family on a beautiful vineyard in Sonoma County. But school was always difficult for her because she was born with a hereditary condition – synesthesia. For synesthetes, stimulation of one of the senses produces an involuntary reaction in another sense. In her first-person narrative, Rosie explains that sounds cause her to see colors and shapes, and numbers, names, and places all correlate with specific colors. At that time, synesthesia was not yet understood by the scientific and medical communities. Her parents warned her that she perceived the world differently than other people and must keep her experiences secret. She convinced her parents to let her quit school when she turned sixteen because the “colors in my mind were always fighting for my attention, and there were so many sounds at school. Too many. It had been so hard to concentrate.” Math was particularly difficult. Indeed, Meissner notes that, in those days, synesthesia was considered a "flaw to be removed and definitely not to be passed on,” even though her research revealed that many synesthetes find their condition is "beautiful. It adds depth and dimension to their lives. They see colors in the periphery of their mind,” despite the fact that, like fictional Rosie, many of them struggle in school.

As the story opens, Rosie loses her entire family – her parents and younger brother – in a tragic motor vehicle accident and, with no other relatives to care for her, the owners of the vineyard on which she has spent her entire life, Truman and Celine Calvert, take her in. Truman, a World War I veteran, is quiet, reserved, and deferential to his domineering wife who requires Rosie to serve as the family’s maid to prepare her for life beyond the vineyard when she becomes an adult. The arrangement works well for a time, until the Calverts’ son, Wilson, returns for a visit. He brings up a long-ago conversation with Rosie during which he thought she said she could see ghosts. She, of course, denies that, but later confesses the truth to Truman.

At age seventeen, Rosie becomes pregnant, and when she can no longer hide her condition, Celine is incensed. She demands not only that Rosie leave their home immediately but uses her knowledge of Rosie’s synesthesia to see to it that Rosie suffers a fate she never knew was imaginable. She believes that she will be sent to a home for unwed mothers until her baby is born and has no intention of relinquishing her child for adoption. Instead, the county social worker transports her to the Sonoma State Home for the Infirm (modeled after the real Sonoma State Home). Naturally, Rosie protests but quickly learns that objections result in punishment.

Rosie’s story is harrowing, particularly when read with an understanding that it is based upon the experiences of actual victims of prejudice against and misunderstanding of not just synesthesia, but myriad other conditions, as well. Meissner heightens the power of the tale by relating it in Rosie’s own words and from her perspective. She credibly describes her shock about her circumstances, regret about having failed to keep her condition a secret, the horrific living conditions and abuse to which she is subjected in the institution, and her determination to be released and build a meaningful life for herself.

Part Two of Only the Beautiful is told in the first-person by Helen Calvert, Truman’s sister. It opens in 1947 in Lucerne, Switzerland as Helen, at sixty-two, is returning to California after decades spent working for various families as a nanny in Europe. Helen became acquainted with Rosie when she was a young girl growing up at the vineyard, and the Calverts made it a point to share her letters with Rosie over the years. For Rosie’s first Christmas without her family, Helen sent her an amaryllis plant to cheer her, and Rosie treasured it and all it represented.

Helen is understandably weary. She opted to remain in Europe when war broke out, rather than return to the United States. She relates her experiences with the Maier family in Austria, the last family for whom she served as a nanny. She was particularly fond of their youngest child, seven-year-old Brigitta, who was born prematurely and struggled to reach developmental milestones. The Germans invaded and annexed Austria in 1938, and Johannes Maier was forced to serve as an officer in a panzer division while his wife, Martine, remained at home with the children and Helen. But even the family of a Nazi officer was not immune from the atrocities of the Adolf Hitler regime.

When Hitler came to power in Germany, he did not immediately begin constructing concentration camps in which to imprison and murder Jews. His quest to create a “master race” began with measures designed to alter the genetic makeup of the German population through "racial hygiene" or eugenics, relying on ideas that had already been adopted by the mainstream medical community. The Nazis started by involuntarily sterilizing persons they believed should not procreate. The sought to eradicate persons with disabilities, referring to them as “useless eaters.” They did not just target adults. Children were forcibly removed from their parents’ care and transported to special “hospitals” like Am Steinhof and Hartheim Castle where they were subjected to experimentation and murdered.

Helen describes her wartime experiences, and the heartbreakingly unthinkable events Meissner includes are difficult to read about, based upon actual events. Helen never had children of her own, but in her role as a nanny, cared for her charges as though they were her own. But she was, like most people, naïve and could never have envisioned the evils the Nazis were capable of. Wracked with guilt, regret, and remorse, she resolves to save as many children as she can.

And when she returns to California and has a visit with Celine, she is appalled and outraged to learn what transpired in her absence and the fate that befell Rosie. She is determined to find Rosie’s child and enlists her good friends, one of whom is a lawyer, to assist her. Of course, in the late 1940’s and early 1950’s, the internet did not exist, and it was much more difficult to find people . . . and adoption records were sealed.

The actions of the Nazi regime “shown a light on eugenic legislation,” illustrating how such laws led to catastrophic abuse. "It was kind of a defining moment in our history, and it's being forgotten," Meissner laments. Only the Beautiful is a compelling and credible story, set against the backdrop of the monstrous agenda of the Nazis and the abhorrent eugenic movement that gained traction in the United States in the early part of the twentieth century. Through the tragedies that befall her characters and the challenges they face, Meissner illustrates the intersection and similarities of the two, emphasizing their far-reaching and tragic consequences.

Meissner’s characters are fully developed, multi-layered, and empathetic. Rosie, in particular, easily slips into readers’ hearts. A minor, powerless to make decisions about her own life and health, she is ensnared in the custody of the county, victimized by a vengeful, angry, and bitter woman and her weak, despicable husband who claim to care about Rosie, and confined to an institution by medical personnel who fail to listen to her or understand that she is not “inform” or afflicted in any way that makes her incapable of competently parenting. Rosie discovers in the most painful ways that her “parents were right to fear the colors. They are dangerous. People will always distrust what they don’t understand. And what they distrust, they cannot love.”

Helen is also intriguing and sympathetic. She refuses to acquiesce when evil forces come to power, intent on doing whatever she can to help as many children as possible and, perhaps, atone for one innocent, but horrible mistake.

The pace of Only the Beautiful never slows as Meissner’s poignant narratives alternate between past and present before melding seamlessly. Although some plot details are gut wrenching and deeply upsetting, their inclusion is critical to the characters’ motivations and development, as well as the message Meissner seeks to convey. There are times “in our history that we ought not to forget. If we forget our history, we are more apt to repeat it, aren’t we?” Meissner provides an emotionally satisfying conclusion to her riveting story, demonstrating that despite all the cruelty and misguided quests for power and dominance that people are capable of, there are also “people who will stand up for those who can't stand and speak for those who cannot speak and it's their bravery that encourages the rest of us to do the same.” In other words, there is always cause for hope.

Moreover, given that reproductive rights are again at issue in the United States, with increasingly restrictive laws being passed in many states and critical political races poised to hinge on candidates’ positions on the subject, Only the Beautiful is a decidedly timely and contemporary work of historical fiction. The book lends itself to discussion and debate about who has the right and should be empowered to make decisions about bearing and raising children, government overreach into decision-making, and how best to ensure that the dark and shameful historical events Meissner depicts are never permitted to recur.

Thanks to NetGalley for an Advance Reader's Copy of the book.
Power Reviewer
Elizabeth

Elizabeth @Silver's ReviewsFantastic...don't miss this one!!
WOW - another beautiful read by Susan Meissner!!

After Rosanne's parents were killed in an accident, she moved into the house of the vineyard owners where her parents worked.

Celine and Truman Calvert were always good to Rosanne and her family, but Celine said Roseanne couldn’t be treated like family but could be their domestic help.

Rosanne enjoyed her time as the family’s domestic until she was betrayed by their son when he told the Calverts she sees colors and which during this time society didn’t accept people who were different.

Seeing colors was considered different and a defect.

Another misfortune fell on her when she became pregnant by a member of the household.

Rosanne was sent to a home, but not one for unwed mothers. This home sterilized young women who had defects.

Meanwhile the Calvert’s daughter, Helen, was working in Europe as a nanny and kept in touch with Rosanne even though the contact lessened over the years.

When Helen came home after WWII and found out what happened to Rosanne nine years ago, she was saddened and shocked thinking of her young charge in Austria who was not perfect and was killed because of her defects.

Beautifully written with the main character, Rosanne, who you will love and who will pull at your heartstrings.

You will also become fond of Helen and praise all the good she did to help during WWII and when she came back to America.

ONLY THE BEAUTIFUL is another marvelous, marvelous read by Susan Meissner that fans will not want to miss and one I didn’t want to put down.

Enjoy, and have some tissues ready!! 5/5

This book was given to me by the publisher via NetGalley for an honest review.
Maureen_Connolly

Interesting Historical Fiction
Another wonderful novel from Susan Meissner. This book is about a topic I knew little about, Eugenics. It was shocking to discover during WWII what Hitler was doing to the young children and to realize that this was happening in the U.S.
This novel was written in two story lines.

Rosie California, 1930’s . Rosie was a young girl who lived in a home on a vineyard with her parents until their sudden death. Celine and Truman owned the vineyard and took her in giving a job as a maid. Rosie had a special gift as did her mother of seeing colors in her mind when words were spoken. Her mother told Rosie never to tell anyone about her gift. All went well until Rosie at the age of seventeen became pregnant. Rosie is forced to leave the vineyard and becomes institutionalized because of her gift. She fights to keep her baby and to leave this horrid place.

Helen sister of Truman has lived in Europe all through WWII. She was living in Vienna and saw first hand what Hitler was doing. When she returns to the U. S. She discovers what happened to Rosie and tries to find her and what happened to the baby.

A captivating story.
  • Page
  • 1
  • 2

Beyond the Book:
  Sad Music is Blue, Literally

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

They say that in the end truth will triumph, but it's a lie.

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 01-Jun-26 09:44 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
1780307069697 ms 1.7803070697E+012 ms 1 /root/website/app_server.cfm
1752 ms 1752 ms 1 /root/website/reader_reviews/index.cfm
1128 ms 1128 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
178 ms 178 ms 1 /root/website/queries/qry_get_book_by_id.cfm
120 ms 120 ms 1 /root/website/app_layout.cfm
94 ms 94 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
66 ms 66 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
65 ms 65 ms 1 /root/website/reader_reviews/dsp_bookshell.cfm
48 ms 48 ms 1 /root/website/app_globals.cfm
48 ms 48 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
48 ms 48 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
39 ms 20 ms 2 /root/website/adsystem/adsystem_mod.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
35 ms 35 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
31 ms 31 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone6.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
20 ms 20 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
18 ms 18 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
17 ms 17 ms 1 /root/website/adzones/showcase_track.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_active_obc.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_current_competition.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
5 ms 5 ms 1 /root/website/act_check_login.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 1 ms 3 /root/website/actions/act_spider_tracker.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_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/site/blocks/layout/dsp_bottom_block.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_reader_reviews_power_reviewers.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_closed_about.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_awards.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_btb.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_readalikes.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/head.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
17 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1769 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

09:44:31.031 - Expression Exception - in /root/website/site/blocks/dsp_top_book_block.cfm : line 237
	    Variable BOOK_NUMBER is undefined.
	    


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 09:44:29.029
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=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 09:44:29.029
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=5ms, Records=2) in /root/website/actions/adstatus.cfm @ 09:44:29.029
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=1ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 09:44:29.029
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 09:44:29.029
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:44:29.029
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:44:29.029
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 @ 09:44:29.029
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=4ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 09:44:29.029
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=3ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 09:44:29.029
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=4ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 09:44:29.029
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=3ms, Records=0) in /root/website/reader_reviews/index.cfm @ 09:44:29.029
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

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 @ 09:44:29.029
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_book_by_id (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 09:44:29.029
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) = 4622

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=155ms, Records=5) in /root/website/queries/qry_get_book_by_id.cfm @ 09:44:29.029
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) = 4622
Parameter #2(CF_SQL_INTEGER) = 4622
Parameter #3(CF_SQL_INTEGER) = 4622
Parameter #4(CF_SQL_INTEGER) = 4622

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=37ms, Records=10) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 09:44:29.029
select 		a.reader_review_number, a.book_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.book_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    from 		reader_reviews a
    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,
    			books 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.reader_review_approved_flag = 1
    and 		a.book_number = b.book_number
    

	order by a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 09:44:29.029
select 		c.book_awards_category_number, c.book_awards_category_name, c.book_awards_category_sort_order,
				m.book_awards_mapping_number, m.book_award_dt,
                a.book_award_number, a.book_award_image, a.book_award_name
                
                
	from 		book_awards_mapping m
	inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    inner join	book_awards a on a.book_award_number = c.book_award_number
    
	where 		m.book_number = ?
    
    order by	c.book_awards_category_sort_order ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 09:44:29.029
select	book_number
    
    from	category_book_mapping a, categories b, top_categories t
    
    where	t.top_category_number = b.top_category_number
    and		b.category_number = a.category_number
    and		t.top_category_number = 9
    and		a.book_number = ?
    and		b.category_visible_flag = 1
	and		a.book_number not in (	select book_number 
    									from 		book_awards_mapping m
													inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    												inner join	book_awards a on a.book_award_number = c.book_award_number
                                    	where m.book_number = ? 
                                    	and a.book_award_number = 7)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622
Parameter #2(CF_SQL_INTEGER) = 4622

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=31ms, Records=4) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 09:44:30.030
SELECT 		b.book_title, b.book_number,
    			c.book_title "referenced_book_title", c.book_number AS "liked_book_number", c.book_short_summary as "liked_short_summary",
            	e.*,
                CASE WHEN datalength(e.author_middle_initial) > 0 
                	 THEN e.author_first_name + ' ' + e.author_middle_initial + '. ' + e.author_last_name
					 ELSE e.author_first_name + ' ' + e.author_last_name
					 END AS "author_name",
				(select top 1 edition_publish_dt from editions where editions.book_number = c.book_number order by edition_publish_dt DESC) as 'sortdate',
				(select count(*) from book_author_mapping m where m.author_number = d.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = d.author_number and ezine_preview_bb_link =0)
				 as 'liked_author_bookcount'
                
	FROM 		liked a
	INNER JOIN	books b ON b.book_number = a.book_number
	INNER JOIN	books c ON c.book_number = a.liked_book_number
	INNER JOIN	book_author_mapping d ON c.book_number = d.book_number
	INNER JOIN	authors e ON d.author_number = e.author_number
    
    WHERE 		a.book_number = ?
    
	ORDER BY 	sortdate desc, c.book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=8ms, Records=12) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 09:44:30.030
select 		distinct a.category_number, a.top_category_number, a.category_name, a.category_description, a.category_meta_keywords, a.category_active_flag, a.category_visible_flag, a.category_member_only_flag, a.category_qry_template, a.category_sort_order, a.category_tag_size,
    			b.*
	
    from 		categories a
	left join	top_categories b on a.top_category_number = b.top_category_number
	left join	category_book_mapping c on c.category_number = a.category_number
	
    where 		a.category_active_flag = 1
    and 		a.category_visible_flag = 1
	and 		c.book_number = ?
	

    order by 	b.top_category_sort_order, b.top_category_name, a.category_sort_order, a.category_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

bb_review (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/index.cfm @ 09:44:30.030
SELECT media_review, reviewer_number from get_media_reviews_by_book_id where media_review_type_number = 9
get_arc_idfk (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:44:30.030
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_bb_link = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 4622

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:44:30.030
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_bb_link = ? 
    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) = 4622

obc_discussions (Datasource=booktalk_new, Time=1047ms, Records=22) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:44:31.031
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) = 3DA17A90-B34E-03F0-D99BED8BE667044C

searchResults (Datasource=bookbrowse_com_new, Time=64ms, Records=5) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:44:31.031
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) = 4622

get_ezine_type (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 09:44:31.031
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=38ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 09:44:31.031
SELECT TOP 1  
                a.ezine_short_title, a. ezine_boxed_content_title, a.ezine_boxed_content, a.ezine_review, a.ezine_review_2,
                b.edition_paperback_flag, b.edition_publish_dt, b.edition_isbn,
                c.book_title, c.book_sub_title, c.book_reading_guide, c.book_excerpt, c.book_number,
                e.author_first_name, e.author_middle_initial, e.author_last_name, e.author_number, 
                f.author_info_biography, 
                g.ezine_number, g.ezine_dt, g.ezine_bbsays_flag,
				i.article_category_number, i.article_category_name
		
	FROM    	ezine_edition_mapping AS a 
		
	INNER JOIN 	editions AS b ON (a.edition_number = b.edition_number)
	INNER JOIN 	books AS c ON (b.book_number = c.book_number )
	INNER JOIN 	book_author_mapping AS d ON (c.book_number = d.book_number )
	INNER JOIN 	authors AS e ON (d.author_number = e.author_number )
	INNER JOIN 	author_info AS f ON (e.author_number = f.author_number)
	INNER JOIN 	ezines AS g ON (a.ezine_number = g.ezine_number)
	LEFT JOIN	article_ezine_edition_mapping h ON h.ezine_edition_mapping_number = a.ezine_edition_mapping_number
	LEFT JOIN	article_categories i ON i.article_category_number = h.article_category_number

	WHERE		c.book_number = ?
	AND			g.ezine_bbsays_flag = 1
	AND			g.ezine_active_flag = 1
	
	
	ORDER BY 		g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

check_permalink (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

check_editors_choice (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
    AND		book_number IN (SELECT		top 4 a.book_number
                            FROM		editors_choice a 
                            WHERE		editors_choice_dt < getdate()
                            ORDER BY	editors_choice_dt DESC)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

check_free_ezine (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			ezine_edition_free_review_flag = 1
	AND			dateadd(ww,4,b.ezine_dt) > getdate()
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

check_cat_73 (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 		count(*) as "count"
    FROM    	books AS b
    INNER JOIN 	category_book_mapping AS c ON c.book_number = b.book_number
    WHERE 		b.book_number = ?
	AND			c.category_number = 73
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_ezine_status (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

check_old_ezine (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			datediff(mm,b.ezine_dt,getdate()) > 12
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_ezine_status (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:44:31.031
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4622

get_author_bookcount (Datasource=bookbrowse_com_new, Time=5ms, Records=5) in /root/website/queries/qry_get_author_bookcount.cfm @ 09:44:31.031
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) = 3125
Parameter #2(CF_SQL_INTEGER) = 3125

get_coauthor (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/udfs.cfm @ 09:44:31.031
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) = 4622

get_book_image (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 09:44:31.031
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) = 4622

get_book_image (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/actions/udfs.cfm @ 09:44:31.031
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) = 4622

get_coauthor (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/actions/udfs.cfm @ 09:44:31.031
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) = 4622

IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'aconty@bcps.org'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'wincheryl1@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'carmelbaker48@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'silversolara@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'beckyann555@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'jhsreads@comcast.net'
IsPowerReviewer (Datasource=, Time=8ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'silversolara@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 09:44:31.031
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'maurconn49@gmail.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=30ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:44:31.031
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=17ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:44:31.031
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
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=20ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 09:44:31.031
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 @ 09:44:31.031
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
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=0ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:44:31.031
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=4094176; CFTOKEN=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2; CFGLOBALS=urltoken%3DCFID%23%3D4094176%26CFTOKEN%23%3D2deedccd72672f75%2D19B15EEB%2D9D24%2DFD3D%2D088D37FDEE65B5C2%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2009%3A44%3A29%27%7D%23hitcount%3D144%23timecreated%3D%7Bts%20%272026%2D06%2D01%2009%3A44%3A09%27%7D%23cftoken%3Dcfb23027d064a56f%2D19B1599E%2DABA9%2D9C84%2DC3085ADCC68058CE%23cfid%3D4094174%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0
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=/book_number/4622/order/bw/only-the-beautiful
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=4094174
cftoken=cfb23027d064a56f-19B1599E-ABA9-9C84-C3085ADCC68058CE
hitcount=157
lastvisit={ts '2026-06-01 09:44:31'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 09:44:09'}
urltoken=CFID=4094176&CFTOKEN=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2
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#=4094176&CFTOKEN#=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2#lastvisit={ts '2026-06-01 09:44:29'}#hitcount=144#timecreated={ts '2026-06-01 09:44:09'}#cftoken=cfb23027d064a56f-19B1599E-ABA9-9C84-C3085ADCC68058CE#cfid=4094174#
CFID=4094176
CFTOKEN=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2
FREEACCESSCOUNT=0
Session Variables:
cfid=4094176
cftoken=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2
sessionid=BOOKBROWSE_4094176_2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2
urltoken=CFID=4094176&CFTOKEN=2deedccd72672f75-19B15EEB-9D24-FD3D-088D37FDEE65B5C2
URL Parameters:
book_number=4622
only-the-beautiful=
order=bw
Debug Rendering Time: 39 ms