What readers think of The Kite Runner, plus links to write your own review.

Summary |  Excerpt |  Reading Guide |  Reviews |  Read-Alikes |  Genres & Themes |  Author Bio

The Kite Runner by Khaled Hosseini

The Kite Runner

by Khaled Hosseini
  • Critics' Consensus (6):
  • Readers' Rating (139):
  • First Published:
  • Jun 1, 2003, 368 pages
  • Paperback:
  • Apr 2004, 384 pages
  • Rate this book

About This Book

Reviews

Page 4 of 10
There are currently 77 reader reviews for The Kite Runner
Order Reviews by:

Write your own review!

Caitlin

the kite runner
My mum recommended this book to me, and honestly just from the caption on the back cover, I wasn't very interested. But from page one, it drew me in. This story is so emotionally charged, I felt like I knew the characters. I was rooting for them, and cried for them. I felt everything they went through, and even felt like I better understood that part of the world after finishing. Everyone should read this book. It is an amazing piece of literature.
Jessica-Mae B.

Can high school students appreciate the literary merit of
I am a high school student that has read this book in my AP Literature Class. I believe that any high school student can appreciate this book, but are they willing? Are they mature enough? These are the factors that can affect the way the high school student can view this book. All together, I enjoyed this book. It was literally love/hate relationship with the main character. This book has taught me about human behavior and how decisions made at a young childhood age can still affect us when we become adults. Following the main character throughout the book was not a bore like most novels. His life growing up was written in such an intoxicating way, that I couldn't put the book down and wanted to read more. This book was one of the most heart-twisting readings I've had. The ending of the book, to me, was not a "happily ever after". It was more like *sigh*, "This is the end of the book." I wanted more, but I think that is just what the author wanted us to feel. This method, to me, is very effective. It keeps me wanting more of the book, it keeps me thinking about what will happen to their lives, if there is a happily ever after. This way, the relationship with the book does not end with he last word. I find myself contiuously thinking about the book and if there will be a Book 2. Also, this book is culturally invigorating. I have a lot more appreciation for the Afghans than I have ever had. Overall, I think any highs school student can read this book, but of course it's up to them on whether they enjoy it or not.
lila E

my kite runner
This book was glorious. I would recommend it to any one who loves epic, deep and powerful stories. The book really touches my heart I was just like Amir as a child. The fact that Amir grew up to the adult that he did made gave me some satisfaction. I do find the ending a little crude. I want to now so much more. The fact that I was never really exposed to Afghani culture before made it all the more interesting, it showed how beautiful the country was before war times. The vivid details made me feel like I was standing right there.
Sierra

A Reason 2 Read
If you are suffering from a lack of interest in novels, or looking for a unique plot to capture your attention, then I would strongly suggest that you read “The Kite Runner.” An accurate description of this book is that it is similar to an unfinished puzzle that is carefully pieced together because it skillfully creates a stunning masterpiece. I believe my reading experience with this book was pleasurable because its turning points made the novel more relatable. “The Kite Runner” also possesses a versatility that also makes it more adaptable for readers. It is shown through the novels use of different themes that cater to lovers of different genres of reading, such as, romance, adventure and comedy.
VW

Khaled's Kite Runner not for kids
What does a successful doctor of internal medicine living in the Bay Area have in common with a kid flying a kite in Kabul, Afghanistan? Dr. Khaled Hosseini WAS the kid in Kabul, for one.
I had the privilege of interviewing Hosseini in April, 2004 before he embarked on a demanding book tour of the U.S. and several other countries, where his novel is making quite an impression. Who knew? The popularity of kite flying around the world may have helped Hosseini with the warm reception of his very poignant story of Amir and his Hazara servant, Hassan. The two Afghan boys struggle with their caste roles in Kabul society and find themselves bound together over years and oceans, even beyond death.
Khaled, whose family was given political asylum in America in 1980, created his young protagonist Amir to reflect his own experiences to a fair extent, he admits. And the colorful, vibrant kite-flying images held in his mind and heart since childhood definitely inspired him to write this book.
Khaled compared the scars of Afghan-style kite-flying (where strings are coated with crushed glass to “cut” down other kites) to young American scrapes from skateboarding or other outdoor activities. He explained that “every boy was outside flying kites in winter, as common as playing catch here. In winter, we had no school, so we were always out in the cold wind with our kites.”
Coining the term “kite runner,” Khaled refers to Amir’s young servant and companion Hassan, who runs to catch the other boys’ kites as Amir cuts them down. A winning duo, these boys grow to test each others’ integrity in heart-stirring and surprising ways.
Early in the book, Amir is often challenged by Hassan’s unruffled loyalty. Amir later remembers Hassan’s haunting rebuke, “…that’s the thing about people who mean everything they say. They think everyone else does too.”
Khaled’s story traces the harsh realities of the Afghan people through these two young men. One comes to America, but the other stays behind to create a startling legacy for his friend to find decades later. The journey back to one’s native country after devastation by warring factions is not a pleasant one. Khaled Hosseini has personally discovered this reality, as well.
In 2003, he returned to Afghanistan and was powerfully affected. He plans to return again to gather material for another book. He has no family in his native land; they’ve all emigrated to California. Though happy to be in America, he feels for Afghanistan. Turmoil wrought by the former Soviet Union’s invasion and eight-year occupation, plus the subsequent Taliban rule gravely damaged his native country.
Khaled admitted a small faction of Afghan expatriates has reacted negatively to his book. But he felt he must show truth in his writing, unlike the “glorified” version some would prefer. Khaled believes he wrote “what every Afghan knows is true, but is taboo to speak openly about.” He refused to write what he calls propaganda. What nerve, he remonstrated to me, that some fellow Afghans consider “all the pillaging, raping and ethnic cleansing done by Afghans themselves between 1992-1996 as nothing – but [my book] The Kite Runner is so bad?!”
Obviously hitting home, striking nerves and flying in the face of adversity, Khaled Hosseini’s book is already published in ten nations now, with nine more to be added in the near future. Academy Award-winning Director Sam Mendes (American Beauty, Road to Perdition) has purchased film rights to Khaled’s novel for a proposed Dreamworks Pictures film. A bit wary, perhaps, but certainly excited by the prospect, Khaled will be busy as a technical consultant when production begins.
Interestingly, Khaled Hosseini grew up enjoying American western movies in Kabul, like The Magnificent Seven. He does not write using traditional outlines; instead he “sees each scene as in a movie,” then writes and watches it come to life.
In the book’s opening chapter, Khaled’s protagonist, now an adult in America, receives a phone call from an old family friend living (and dying) in Pakistan. His last request takes Amir back to Afghanistan, carries him through disturbing nostalgiac scenes and catapults him through danger he has only heard about from more recent refugees. By the novel’s end, Amir returns wounded and wiser to his American way of life.
Khaled’s powerful writing provokes a stark comparative reality when the old man comments to the visiting Amir, “I see America has infused you with the optimism that has made her so great…We’re a melancholic people, we Afghans…we wallow too much…we give in to loss, to suffering, accept it as a fact of life, even see it as necessary.”
But, the kite can only fly when the adverse wind is blowing. A symbol emerges triumphant for Amir, for Khaled Hosseini, for all of us.
Matt Lintz

Hope as a kite
It was a crisp clear January morning, where the deeper you inhaled, the more bitter the sting from the chilled winter air. The streets and countrysides were teeming with children, most battling kites far above the ground, into a remarkable silvery gray canopy of clouds. Those children who were not controlling the air campaigns above, chased down and attempted to capture the paper gladiators which had not been triumphant. The Place was Kabul, Afghanistan. The time was 1975, and the best Kite Flyer/Runner tandem to be found was Amir and Hassan. It is the relationship surrounding these two that spurred The Kite Runner to be hailed as a masterpiece of contemporary literature. Published in 1992, The Kite Runner was Dr. Khaled Hosseini’s inaugural attempt at authoring a novel. Issues such as violence, family, loyalty and displacement all come to bare as this tale unravels, all told through the eyes, ears and above all, heart, of Amir. All of the themes unearthed within the pages have been carefully crafted, as to resonate a mirror like parallel of Afghanistan’s own battle worn history. That history, scarred with ethnic cleavages, religious rifts and a tidal wave of political instability, has all but extinguished what has become a heavily diluted sense of pride and hope for the people of Afghanistan. Has that tumultuous history raised the price of peace so high that redemption has become as much a work of fiction as the novel itself?

The parallels begin by breathing life into the characters of Amir and Hassan. Amir, the son of Baba, a well to do merchant, was a Pashtun, while Hassan, his servant and later revealed half brother, was a Hazara. The relationship between these two was, at it’s core, duplicitous. They were, while in only each others company, the best of friends. They would play together, dream together and cause mischief together. Aside from Amir’s teasing and childish cruelty, they were, by most accounts, friends. In public however, they were Pashtun master and Hazara servant. Both knew their respective roles and neither ever attempted to deviate from them because, even at such a young age, both knew and respected the Afghan mores. Ironically, Hassan was the epitome of everything the Afghan culture admired; Honor, pride, loyalty, integrity and courage. Amir though, would not come to represent these qualities until much later in life. Baba too, shows a sense of duplicity. While acknowledging Hassan’s status of servant, he is treated much like a son (and fittingly so). His surgery is paid for by Baba and his care is never neglected. Because of the society, he is forced into living two lives, the inner and the outer. The parallel is an awkward one, displaying the impact culture can play in the lives of individuals within a society. Because the facet of religious and cultural status is capriciously held above that of merit, a natural attrition is created, lying feverishly dormant until finally compounded into combustion. The continual deprivation of a class of people by another leads to senseless bloodshed and avoidable war. This is illustrated not just by those in Afghanistan, but by most all of the nation states comprising the entirety of the globe. Look no further back than WWII to see how the world can be savaged by the disgustingly numbing truth.

Another parallel, mentioned quite fittingly after the first, is that of hypocrisy. One is hard pressed to find a character within the novel, aside from Ali, Hassan and Sorhab, that is not, to some level, plagued with this affliction. Much a fruit of the duality noted earlier, hypocrisy serves as a devil in waiting, kept below the surface in almost all of the characters. Baba’s culpability regarding his often quoted “one sin“, that of theft, being perhaps the most poignant literary example. Also, the General, who’s national pride and façade of Afghan perfection, is exposed through his collection of welfare, his refusal to take up gainful employment and his treatment of others. The reign of the various governments throughout the novel, too, is a seething hotbed of double standards. The Mujahedeen and the successor government of the Taliban were given control of the country, after the soviet withdrawal, under the pretext of equality, righteousness and Afghan propriety but soon began imposing self serving laws and butchering arbitrarily to genocidal proportions.

The value placed on family within the novel is paramount. Although there are elements of self righteousness and hypocrisy, there is also a tender sincerity and a bond between blood that is perhaps matched, but never surpassed in any other known culture. It is mentioned more than once in the book, how important family is to the Afghan community. It is even said that if you put two Afghani strangers in a room, within fifteen minutes they could find out how they were related. It was this reason, above all others, that Baba kept Hassan’s identity one of secrecy. If those in the Afghan community were to find out that a family’s bloodline had been “tainted” by Hazara blood, it would have meant shame and a veritable loss of everything he had worked to achieve. During Amir’s conversation with his In-Laws about adoption, the General went on a diatribe about the importance of blood and his point was never refuted. Amir and Soraya, although more Americanized than most Afghans, actually agreed with him. The bond of family is expressed quite bluntly and serves as one of the Afghan’s most endearing qualities but ironically, at the same time, shows all that is troubled within the culture.

Another word often used disparagingly and when extremism is displayed with regards to the focus on family, is tribalism. When the attribute of loyalty to a faction, group or family supercedes all other agents, including the ethics and thoughts of the individual, the term tribalism is given shape. It is the very waylaying of personal ethics and thought, and the promotion of a centralized, if not skewed, idealism that widens the cleavage of chaos within a society. This sense of tribalism, though not fully expressed within Baba’s or the General’s families, is seen in full when describing the reign of the Taliban. Dr. Hosseini illustrates quite effectively how fervently death and mutilation was cheered on within the football (soccer) stadium by Afghani spectators. Although we later learn about Baba’s sense of guilt and self hatred over his outward treatment of his son Hassan, he too displayed a sense of tribalism in accepting and complying with the cultural standards within his community. The parallel to reality here is self evident. Dr. Hosseini, while being interviewed, said he had gotten the depictions of the Taliban circling the arena in Pick Up trucks from actual footage of the events as they were broadcasted around the world. The destruction that the wars had so brutally generated, from the Soviets to the Taliban, was noted first hand from his visit to the crumbling rock, twisted steel and broken lives that had stolen the memory of his once beautiful homeland.

The reason Amir’s reaction to returning home was so honestly tragic, was because the words on the page were filled with the passion of Dr. Hosseini himself, having made the trip home and seeing the utter devastation firsthand. Before Afghanistan was totally raped by the dreadfulness of hate, both the author and main character had been displaced into America, much to the character, Amir’s, appreciation. He had carried such a weight of guilt for so long that he whole heartedly embraced his journey into America, a place that “had no ghosts, no memories, and no sins.” Before long he realized that no matter the geographical distance, his shame would continue to wage its own war within him. That was the reality of many of the displaced Afghans within the story. The General, Baba, and probably many of the other notables that they conversed with inside the Flea Market carried and tended to their own struggles with lives left behind. This is not to say that the displacement was an all bad thing. Much like the Bazaars back home, the Flea Market served as an makeshift Afghani marketplace. They had their mosques and their homes and most of Fremont, as mentioned by the author, was populated with Afghans. America, in a way, served as a place where the great aspects of Afghan culture could be remembered and practiced, but the negative aspects, unless harbored individually, could be forever left behind and lost. America also placed a large responsibility onto the character of Afghanis. Because Americans, the author noted, places much less, or at least different, value on family, there was no longer an outwardly social inclination towards tribalism. This meant that the Afghan experience, at least in America, ideally, could evolve.

The price of peace would appear to be quite high to those who remain in the war riddled country of Afghanistan. Throughout the novel, Dr. Hosseini makes mention of the escalation in violence and the even greater separation of ideas within the troubled country. These elements serve as fuel, continually poured over an already blazing environment. He writes at one point within the story that “Maybe….It was a hopeless place”, however the title of the book carries a symbolism that might suggest otherwise. Kite running was and is a great national past time within Afghanistan. It is a symbol of their heritage, history and pride. The soviet occupation prevented the running of kites due to obvious safety concerns, and under the Mujahedeen and Taliban it was outlawed. Only recently has the practice been re-instituted. Perhaps that is what hope is represented by within the novel. The kite represents hope. The novel begins with kites soaring high into the sky. Throughout the novel, kites are referred to less and less, except in memory. The last kite to be seen until the last page of the book had been the one clipped by Amir to win the festival and run by Hassan. Seemingly, as a harrowing foresight, the running of that kite signaled the ending of an era and the slow destruction of hope for what would turn out to be a very long time. As if to parallel Amir’s experience at the end of the novel with Afghanistan’s equally questionable future, Hosseini closes the novel with a particularly optimistic insight. “Because when Spring comes, it melts one snowflake at a time, and maybe I just witnessed the first flake melting.” By writing this, Dr. Hosseini illustrates that he is not yet certain of his homeland’s future. He admits that the price of peace has risen greatly, but where a kite can be flown, maybe hope can still be risen. Perhaps, in Afghanistan, hope can still soar among that same silvery gray canopy of clouds that watched over them all so long ago.
Sabah

The Kite Runners.
This is the kind of novel which you would not like to stop reading and once you finish reading it , it is going to stay with you for a very long time. Khalid Hosseini's debut novel has opened up issues that were people were scared to think about but what people needed to know. In the bonds of friendship of Amir and Hassan Khalid has let us know about a lot more that goes wrong in the deeps of Afghanistan.

Within this novel you will find an Afghanistan which is not the same anymore, an Afghanistan no soul gets to see anymore.This book is more then a novel about a mere friendship, its a journey that takes you to the time when Kabul was beautiful and the word "war" was still undiscovered. When Taliban had not yet entered the realm of beauty. While reading the book one can actually picture the beautiful country, walk through the mansions with thick hedges , admire the oriental furniture and almost taste the wonderful cherries and pomegranate on the trees.

This book is about Amir and Hassan.Amir who is born rich and a Sunni.Hassan who is a Shia, and Hazara, his only mistake. Amir who has a father who is the most influential and powerful man and Hassan who has a father who is crippled by nature and is nicknamed as "Babulu" . Amir is the literate one and Hassan is the smart clever yet the illiterate one.

Their friendship is a journey on its own.Amir reads and Hassan listens quitely. Amir commands and Hassan obeys not uttering a word.Amir is flies the Kite and Hassan is the kite runner.And it is here where the story turns a drastic point.Where no reader i presume would want to stop and keep the book down because it is at this point that everything changes.

This book touches a delicate issue of child abuse which is seldom discussed in our world so openly as Khalid Hussaini did. It does not shy away from talking about uneasy and usually not talked about subjects.It is only right that the author chose to describe the Horrors to us as we need to know about it.

But mostly Kite runners is a book about a love. Love that is not bonded in the shackles of "romance" only.

Its about Amir's guilt and how he redeems it getting what he deserved really.

And for all those who read it I ask you to ponder these few words which are one of the most beautiful words every written.

"For you a thousand times over"

The most outstanding work I have read about something which I can sort of relate to being a sunni muslim myself.

Thank you for bestowing us with this wonderful treasure.
Janet

A touching story...
This is a GREAT book...go get it right now! I was a bit reluctant to read it as I didn't want another depressing stories about the Middle East. However, this was a very touching story about a young boy who happened to live in Afghanistan. It's a tear jerker that you will never forget...

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

Finishing second in the Olympics gets you silver. Finishing second in politics gets you oblivion.

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 03:15 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780326908901 ms 1.7803269089E+012 ms 1 /root/website/app_server.cfm
1789 ms 1789 ms 1 /root/website/reader_reviews/index.cfm
519 ms 519 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
351 ms 351 ms 1 /root/website/app_layout.cfm
327 ms 327 ms 1 /root/website/reader_reviews/dsp_bookshell.cfm
268 ms 268 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
262 ms 131 ms 2 /root/website/adsystem/adsystem_mod.cfm
224 ms 224 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
215 ms 215 ms 1 /root/website/app_globals.cfm
151 ms 151 ms 1 /root/website/adzones/AdZone6.cfm
128 ms 128 ms 1 /root/website/queries/qry_get_book_by_id.cfm
116 ms 116 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
111 ms 111 ms 1 /root/website/adzones/showcase_track.cfm
87 ms 87 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
58 ms 58 ms 1 /root/website/queries/qry_get_active_obc.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_current_competition.cfm
41 ms 41 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
31 ms 31 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
29 ms 10 ms 3 /root/website/actions/act_spider_tracker.cfm
29 ms 29 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
27 ms 27 ms 1 /root/website/act_check_login.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_member_info.cfm
26 ms 26 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
22 ms 22 ms 1 /root/website/actions/adstatus.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_closed_btb.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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_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/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1790 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

15:15:10.010 - 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=28ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 15:15:08.008
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=25ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:15:08.008
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=21ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:15:08.008
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 15:15:08.008
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=28ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:15:09.009
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=19ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:09.009
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=21ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:09.009
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 15:15:09.009
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=14ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:09.009
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=23ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:09.009
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=20ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:09.009
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=18ms, Records=0) in /root/website/reader_reviews/index.cfm @ 15:15:09.009
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 @ 15:15:09.009
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=90ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 15:15:09.009
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) = 1232

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=36ms, Records=6) in /root/website/queries/qry_get_book_by_id.cfm @ 15:15:09.009
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) = 1232
Parameter #2(CF_SQL_INTEGER) = 1232
Parameter #3(CF_SQL_INTEGER) = 1232
Parameter #4(CF_SQL_INTEGER) = 1232

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=34ms, Records=77) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 15:15:09.009
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) = 1232
Parameter #2(CF_SQL_INTEGER) = 1232

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=16ms, Records=22) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=16ms, Records=10) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 15:15:09.009
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) = 1232

bb_review (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/index.cfm @ 15:15:09.009
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=12ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:15:09.009
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) = 1232

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:15:09.009
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) = 1232

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

searchResults (Datasource=bookbrowse_com_new, Time=69ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:15:09.009
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) = 1232

get_ezine_type (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 15:15:09.009
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 15:15:09.009
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) = 1232

check_permalink (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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=3ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

check_free_ezine (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

check_cat_73 (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_ezine_status (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

check_old_ezine (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_ezine_status (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:15:09.009
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) = 1232

get_author_bookcount (Datasource=bookbrowse_com_new, Time=13ms, Records=4) in /root/website/queries/qry_get_author_bookcount.cfm @ 15:15:10.010
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) = 900
Parameter #2(CF_SQL_INTEGER) = 900

get_coauthor (Datasource=bookbrowse_com_new, Time=38ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:10.010
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) = 1232

get_book_image (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:10.010
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) = 1232

get_book_image (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:10.010
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) = 1232

get_coauthor (Datasource=bookbrowse_com_new, Time=181ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:10.010
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) = 1232

IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'caitlintolland@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'jessicamae_89@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'fobcandie@yahoo.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'bear_nose@hotmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'valerie@pacific.net'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'lintzm@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'Sabahz@gmail.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 15:15:10.010
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'libre@dslextreme.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:10.010
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=27ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:10.010
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=66ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
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=68ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
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=28ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:15:10.010
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 15:15:10.010
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=65ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
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=20ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:10.010
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=4105290; CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4105290%26CFTOKEN%23%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A15%3A08%27%7D%23hitcount%3D55%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A14%3A56%27%7D%23cftoken%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23cfid%3D4105290%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/book_number/1232/page/4/the-kite-runner
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=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
hitcount=64
lastvisit={ts '2026-06-01 15:15:10'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:14:56'}
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
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#=4105290&CFTOKEN#=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#lastvisit={ts '2026-06-01 15:15:08'}#hitcount=55#timecreated={ts '2026-06-01 15:14:56'}#cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#cfid=4105290#
CFID=4105290
CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
Session Variables:
cfid=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
sessionid=BOOKBROWSE_4105290_a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
URL Parameters:
book_number=1232
page=4
the-kite-runner=
Debug Rendering Time: 43 ms