Excerpt from Nine Lives by William Dalrymple, plus links to reviews, author biography & more

Summary |  Excerpt |  Reviews |  Beyond the Book |  Readalikes |  Genres & Themes |  Author Bio

Nine Lives by William Dalrymple

Nine Lives

In Search of the Sacred in Modern India

by William Dalrymple
  • BookBrowse Review:
  • Critics' Consensus (12):
  • First Published:
  • Jun 15, 2010, 304 pages
  • Paperback:
  • Jun 2011, 304 pages
  • Rate this book

About this Book

Print Excerpt

1

The Nun's Tale

Two hills of blackly gleaming granite, smooth as glass, rise from a thickly wooded landscape of banana plantations and jagged palmyra palms. It is dawn. Below lies the ancient pilgrimage town of Sravanabelagola, where the crumbling walls of monasteries, temples and dharamsalas cluster around a grid of dusty, red earth roads. The roads converge on a great rectangular tank. The tank is dotted with the spreading leaves and still-closed buds of floating lotus flowers. Already, despite the early hour, the first pilgrims are gathering.

For more than 2,000 years, this Karnatakan town has been sacred to the Jains. It was here, in the third century bc, that the first Emperor of India, Chandragupta Maurya, embraced the Jain religion and died through a self-imposed fast to the death, the emperor's chosen atonement for the killings for which he had been responsible in his life of conquest. Twelve hundred years later, in ad 981, a Jain general commissioned the largest monolithic statue in India, sixty feet high, on the top of the larger of the two hills, Vindhyagiri.

This was an image of another royal Jain hero, Prince Bahubali. The prince had fought a duel with his brother Bharata for control of his father's kingdom. But in the very hour of his victory, Bahubali realised the folly of greed and the transience of worldly glory. He renounced his kingdom and embraced instead the path of the ascetic. Retreating to the jungle, he stood in meditation for a year, so that the vines of the forest curled around his legs and tied him to the spot. In this state he conquered what he believed to be the real enemies—his passions, ambitions, pride and desires—and so became, according to the Jains, the first human being to achieve moksha, or spiritual liberation.

The sun has only just risen above the palm trees, and an early morning haze still cloaks the ground. Yet already the line of pilgrims—from a distance, tiny ant-like creatures against the dawn-glistening fused-mercury of the rock face—are climbing the steps that lead up to the monumental hilltop figure of the stone prince. For the past thousand years this massive broad-shouldered statue, enclosed in its lattice of stone vines, has been the focus of pilgrimage in this Vatican of the Digambara, or Sky Clad Jains.

Digambara monks are probably the most severe of all India's ascetics. They show their total renunciation of the world by travelling through it completely naked, as light as the air, as they conceive it, and as clear as the Indian sky. Sure enough, among the many ordinary lay people in lungis and saris slowly mounting the rock-cut steps are several completely naked men—Digambara monks on their way to do homage to Bahubali. There are also a number of white-clad Digambara nuns, or matajis, and it was in a temple just short of the summit that I first laid eyes on Prasannamati Mataji.

I had seen the tiny, slender, barefoot figure of the nun in her white sari bounding up the steps above me as I began my ascent. She climbed quickly, with a pot of water made from a coconut shell in one hand, and a peacock fan in the other. As she climbed, she gently wiped each step with the fan in order to make sure she didn't stand on, hurt or kill a single living creature on her ascent of the hill: one of the set rules of pilgrimage for a Jain muni, or ascetic.

It was only when I got to the Vadegall Basadi, the temple which lies just below the summit, that I caught up with her—and saw that despite her bald head Mataji was in fact a surprisingly young and striking woman. She had large, wide-apart eyes, olive skin and an air of self-contained confidence that expressed itself in a vigour and ease in the way she held her body. But there was also something sad and wistful about her expression as she went about her devotions; and this, combined with her unexpected youth and beauty, left one wanting to know more.

Mataji was busy with her prayers when I first entered the temple. After the glimmering half-light outside, the interior was almost completely black, and it took several minutes for my eyes fully to adjust to the gloom. At the cardinal points within the temple, at first almost invisible, were three smooth, black marble images of the Jain Tirthankaras, or Liberators. Each was sculpted sitting Buddha-like in the virasana samadhi, with shaved head and elongated earlobes. The hands of each Tirthankara was cupped, and they sat cross-legged in a lotus position, impassive and focused inwards, locked in the deepest introspection and meditation. Tirthankara means literally "ford-maker," and the Jains believe these heroic ascetic figures have shown the way to Nirvana, making a spiritual ford through the rivers of suffering, and across the wild oceans of existence and rebirth, so as to create a crossing place between samsara and liberation.

To each of these figures in turn, Mataji bowed. She then took some water from the attendant priest and poured it over the hands of the statues. This water she collected in a pot, and then used it to anoint the top of her own head. According to Jain belief, it is good and meritorious for pilgrims to express their devotion to the Tirthankaras, but they can expect no earthly rewards for such prayers: as perfected beings, the ford-makers have liberated themselves from the world of men, and so are not present in the statues in the way that, say, Hindus believe their deities are incarnate in temple images. The pilgrim can venerate, praise, adore and learn from the example of the Tirthankaras, and they can use them as a focus for their meditations. But as the ford-makers are removed from the world they are unable to answer prayers; the relationship between the devotee and the object of his devotion is entirely one way. At its purest, Jainism is almost an atheistic religion, and the much venerated images of the Tirthankaras in temples represent not so much a divine presence as a profound divine absence.

I was intrigued by Mataji's intense dedication to the images, but as she was deep in her prayers, it was clear that now was not the moment to interrupt her, still less to try to talk to her. From the temple, she headed up the hill to wash the feet of Bahubali. There she silently mouthed her morning prayers at the feet of the statue, her rosary circling in her hand. Then she made five rounds of the parikrama pilgrim circuit around the sanctuary, and as quickly as she had leapt up the steps, she headed down them again, peacock fan flicking and sweeping each step before her.

It was only the following day that I applied for, and was given, a formal audience—or as the monks called it, darshan—with Mataji at the monastery guest house; and it was only the day after that, as we continued our conversations, that I began to learn what had brought about her air of unmistakable melancholy.

"We believe that all attachments bring suffering," said Prasannamati Mataji, after we had been talking for some time. "This is why we are supposed to give them up. It is one of the main principles of Jainism—we call it aparigraha. This was why I left my family, and why I gave away my wealth."

We were talking in the annex of a monastery prayer hall, and Mataji was sitting cross-legged on a bamboo mat, raised slightly above me on a low dais. The top of her white sari was now modestly covering her plucked head. "For many years, I fasted, or ate at most only once a day," she continued. "Like other nuns, I often experienced hunger and thirst. I tried to show compassion to all living creatures, and to avoid all forms of violence, passion or delusion. I wandered the roads of India barefoot." As she said this, the nun ran a hand up the hard and callused sole of her unshod foot. "Every day I suffered the pain of thorns and blisters. All this was part of my effort to shed my last attachments in this illusory world.

"But," she said, "I still had one attachment—though of course I didn't think of it in that way."

"What was that?" I asked.

"My friend Prayogamati," she replied. "For twenty years we were inseparable companions, sharing everything. For our safety, we Jain nuns are meant to travel together, in groups or in pairs. It never occurred to me that I was breaking any of our rules. But because of my close friendship with her, I formed not just an attachment, but a strong attachment—and that left an opening for suffering. But I only realised this after she died."

There was a pause, and I had to encourage Mataji to continue. "In this stage of life we need company," she said. "You know, a companion with whom we can share ideas and feelings. After Prayogamati left her body, I felt this terrible loneliness. In truth, I feel it to this day. But her time was fixed. When she fell ill—first with TB and then malaria—her pain was so great she decided to take sallekhana, even though she was aged only thirty-six."

"Sallekhana?"

"It's the ritual fast to the death. We Jains regard it as the culmination of our life as ascetics. It is what we all aim for, and work towards as the best route to Nirvana. Not just nuns—even my grandmother, a lay person, took sallekhana."

"You are saying she committed suicide?"

"No, no: sallekhana is not suicide," she said emphatically. "It is quite different. Suicide is a great sin, the result of despair. But sallekhana is as a triumph over death, an expression of hope."

"I don't understand," I said. "If you starve yourself to death, then surely you are committing suicide?"

"Not at all. We believe that death is not the end, and that life and death are complementary. So when you embrace sallekhana you are embracing a whole new life—it's no more than going through from one room to another."

"But you are still choosing to end your life."

"With suicide, death is full of pain and suffering. But sallekhana is a beautiful thing. There is no distress or cruelty. As nuns our lives are peaceful, and giving up the body should also be peaceful. You have the Tirthankaras' names on your lips, and if you do it slowly and gradually, in the prescribed way, there is no pain; instead there is a gentle purity in all the privations.

"At all stages you are guided by an experienced mataji or guru. Everything is planned long in advance—when, and how, you give up your food. Someone is appointed to sit with you and look after you at all times, and a message is sent out to all members of the community that you have decided to take this path. First you fast one day a week, then you eat only on alternate days: one day you take food, the next you fast. One by one, you give up different types of food. You give up rice, then fruits, then vegetables, then juice, then buttermilk. Finally you take only water, and then you have that only on alternate days. Eventually, when you are ready, you give up that too. If you do it very gradually, there is no suffering at all. The body is cooled down, so that you can concentrate inside on the soul, and on erasing all your bad karma.

"At every stage you are asked: are you prepared to go on, are you sure you are ready for this, are you sure you don't want to turn back? It is very difficult to describe, but really it can be so beautiful: the ultimate rejection of all desires, the sacrificing of everything. You are surrounded, cradled, by your fellow monks. Your mind is fixed on the example of the Jinas."

She smiled. "You have to understand that for us death is full of excitement. You embrace sallekhana not out of despair with your old life, but to gain and attain something new. It's just as exciting as visiting a new landscape or a new country: we feel excited at a new life, full of possibilities."

I must have looked surprised, or unconvinced, because she stopped and explained what she meant using the simplest images. "When your clothes get old and torn," she said, "you get new ones. So it is with the body. After the age of thirty, every year it becomes weaker. When the body withers completely, the soul will take a new one, like a hermit crab finding a new shell. For the soul will not wither, and in rebirth you simply exchange your torn and damaged old clothes for a smart new suit."

"But you could hardly have felt excited when your friend left you like this."

"No," she said, her face falling. "It is hard for those who are left."

She stopped. For a moment Mataji lost her composure; but she checked herself.

"After Prayogamati died, I could not bear it. I wept, even though we are not supposed to. Any sort of emotion is considered a hindrance to the attainment of Enlightenment. We are meant to cultivate indifference—but still I remember her."

Again her voice faltered. She slowly shook her head. "The attachment is there even now," she said. "I can't help it. We lived together for twenty years. How can I forget?"



Jainism is one of the most ancient religions of the world, similar to Buddhism in many respects, and emerging from the same heterodox classical Indian world of the Ganges basin in the early centuries bc. Like Buddhism, it was a partly a reaction to Brahminical caste consciousness and the readiness of the Brahmins to slaughter huge quantities of animals for temple sacrifices—but the faith of the Jains is slightly more ancient, and much more demanding than Buddhist practice. Buddhist ascetics shave their heads; Jains pluck their hair out by the roots. Buddhist monks beg for food; Jains have to have their food given to them without asking. All they can do is to go out on gowkari—the word used to describe the grazing of a cow—and signal their hunger by curving their right arm over their shoulder. If no food comes before the onset of the night, they go to bed hungry. They are forbidden to accept or in any way handle money.

In ancient India, the Jain monks were also celebrated for their refusal to wash, and like the Coptic monks of Egypt, equated a lack of concern for outward appearance with inner purity. One early inscription at Sravanabelagola admiringly refers to a monk so begrimed with filth that "he looked as if he wore a closely fitting suit of black armour." Today the monks are allowed to wipe themselves with a wet towel and to wash their robes every few weeks; but bathing in ponds or running water or the sea is still strictly forbidden, as is the use of soap.

Unlike Buddhism, the Jain religion never spread beyond India, and while it was once a popular and powerful faith across the subcontinent, patronised by the princes of a succession of Deccani dynasties, today there are only four million Jains left, and these are largely limited to the states of Rajasthan, Gujarat, Madhya Pradesh and Karnataka. Outside India, the religion barely exists, and in contrast to Buddhism, is almost unknown in the West.

The word Jain derives from Jina, meaning liberator or spiritual conqueror. The Jinas or Tirthankaras—ford-makers—were a series of twenty-four human teachers who each discovered how to escape the eternal cycle of death and rebirth. Through their heroic tapasya—bodily austerities—they gained omniscient and transcendent knowledge which revealed to them the nature of the reality of the great theatre of the universe, in every dimension. The most recent of those, according to the Jains, was the historical figure of Mahavira (599–529 bc)—the Great Hero—a prince of Magadha, in modern Bihar, who renounced the world at the age of thirty to become a wandering thinker and ascetic.

Mahavira elaborated to his followers a complex cosmological system that the Jains still expound 2,600 years later. Like follower's of other Indian faiths they believe in an immortal and indestructible soul, or jivan, and that the sum of one's actions determines the nature of one's future rebirth. However, the Jains diverge from Hindus and Buddhists in many ways. They reject the Hindu idea that the world was created or destroyed by omnipotent gods, and they mock the pretensions of the Brahmins, who believe that ritual purity and temple sacrifices can bring salvation. As a Jain monk explains to a group of hostile Brahmins in one of the most ancient Jain scriptures, the most important sacrifice for Jains is not some puja, or ritual, but the sacrifice of one's own body: "Austerity is my sacrifical fire," says the monk, "and my life is the place where the fire is kindled. Mental and physical effort are my ladle for the oblation, and my body is the dung fuel for the fire, my actions my firewood. I offer up an oblation praised by the wise seers consisting of my restraint, effort and calm."

Crucially, the Jains differ from both Hindus and Buddhists in their understanding of karma, which for other faiths means simply the fruit of your actions. Jains, however, conceive of karma as a fine material substance that physically attaches itself to the soul, polluting and obscuring its potential for bliss by weighing it down with pride, anger, delusion and greed, and so preventing it from reaching its ultimate destination at the summit of the universe. To gain final liberation, you must live life in a way that stops you accumulating more karma, while wiping clean the karma you have accumulated in previous lives. The only way to do this is to embrace an ascetic life and to follow the path of meditation and rigorous self-denial taught by the Tirthankaras. You must embrace a life of world renunciation, non-attachment and an extreme form of non-violence.

The soul's journey takes place in a universe conceived in a way that is different from that of any other faith. For Jains, the universe is shaped like a gigantic cosmic human body. Above the body is a canopy containing the liberated and perfected souls—siddhas—who, like the Tirthankaras, have escaped the cycle of rebirths. At the top of the body, level with the chest, is the celestial upper world, the blissful home of the gods.

At waist level is the middle world, where human beings live in a series of concentric rings of land and ocean. The central landmass of this world—the continent of the Rose Apple Tree—is bounded by the mighty Himalayas, and set within ramparts of diamonds. At its very centre, the axis mundi, lies the divine sanctuary of the Jinas, Mount Meru, with its two suns and two moons, its parks and woods and its groves of wish-granting trees. Adjacent to this, but slightly to the south, lies the continent of Bharata or India. Here can be found the great princely capitals, surrounded by ornamental lakes blooming with lotus flowers.

Below this disc lies the hell world of the Jains. Here souls who have committed great sins live as hell beings in a state of terrible heat, unquenchable thirst and endless pain, under the watch of a group of malignant and semi-divine jailers, the asuras, who are strongly opposed to the dharma of the Tirthankaras.

In this world, there are no creator gods: depending on its actions and karma, a soul can be reincarnated as a god, but eventually, when its store of merit is used up, the god must undergo the agonies of death and fall from heaven, to be reborn as a mortal in the middle world. The same is true of hell beings. Once they have paid through suffering for their bad actions, they can rise to be reborn in the middle world and again begin the cycle of death and rebirth—depending on their karma, as human beings, animals, plants or tiny unseen creatures of the air. Like the fallen gods, former hell beings can also aspire to achieving moksha, the final liberation of the soul from earthly existence and suffering. Even the Tirthankara Mahavira, the Great Hero himself, spent time as a hell being, and then as a lion, before rising to be a human and so finding the path to Enlightenment. It is only human beings—not the hedonistic gods—who can gain liberation, and the way to do this is completely to renounce the world and its passions, its desires and attachments, and to become a Jain ascetic. As such, the monk or nun must embrace the Three Jewels, namely right knowledge, right faith and right conduct, and to take five vows: no violence, no untruth, no stealing, no sex, no attachments. They wander the roads of India, avoiding any acts of violence, however small, and meditating on the great questions, thinking about the order and purpose of the universe, and attempting to ford the crossing places that lead through suffering to salvation. For the Jains, then, to be an ascetic is a higher calling than to be a god.

It is a strange, austere and in some ways very harsh religion; but that, explained Prasannamati Mataji, is exactly the point.

  • 1

Excerpted from Nine Lives by William Dalrymple Copyright © 2010 by William Dalrymple. Excerpted by permission of Knopf, a division of Random House, Inc. All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.

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

BookBrowse Book Club

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

Members Recommend

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

Everywhere I go, I am asked if I think the university stifles writers...

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 /excerpts/index.cfm
Time Stamp 01-Jun-26 04:00 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
1780286424232 ms 1.78028642423E+012 ms 1 /root/website/app_server.cfm
1506 ms 1506 ms 1 /root/website/excerpts/index.cfm
363 ms 363 ms 1 /root/website/queries/qry_get_book_by_id.cfm
271 ms 271 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
196 ms 196 ms 1 /root/website/app_layout.cfm
175 ms 175 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
155 ms 155 ms 1 /root/website/app_globals.cfm
138 ms 138 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
136 ms 68 ms 2 /root/website/adsystem/adsystem_mod.cfm
109 ms 109 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
91 ms 91 ms 1 /root/website/adzones/AdZone6.cfm
59 ms 59 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_active_obc.cfm
47 ms 47 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
46 ms 46 ms 1 /root/website/adzones/showcase_track.cfm
42 ms 42 ms 1 /root/website/excerpts/dsp_main.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
33 ms 33 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
20 ms 20 ms 1 /root/website/actions/adstatus.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
20 ms 20 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
18 ms 6 ms 3 /root/website/actions/act_spider_tracker.cfm
17 ms 17 ms 1 /root/website/act_check_login.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_member_info.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
7 ms 7 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
5 ms 5 ms 1 /root/website/site/blocks/layout/main_menu.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_member_account_types.cfm
3 ms 3 ms 1 /root/website/site/blocks/membership_advantages.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/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.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
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/site/blocks/act_book_view_tracking.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_closed_reviews.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
16 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1522 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

04:00:25.025 - 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=13ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 04:00:24.024
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=14ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 04:00:24.024
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=19ms, Records=2) in /root/website/actions/adstatus.cfm @ 04:00:24.024
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 @ 04:00:24.024
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=11ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 04:00:24.024
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=16ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:00:24.024
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=11ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:00:24.024
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 @ 04:00:24.024
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=25ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 04:00:24.024
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=12ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 04:00:24.024
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=12ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 04:00:24.024
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_by_id (Datasource=bookbrowse_com_new, Time=65ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 04:00:24.024
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) = 2451

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=297ms, Records=14) in /root/website/queries/qry_get_book_by_id.cfm @ 04:00:24.024
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) = 2451
Parameter #2(CF_SQL_INTEGER) = 2451
Parameter #3(CF_SQL_INTEGER) = 2451
Parameter #4(CF_SQL_INTEGER) = 2451

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=30ms, Records=0) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 04:00:24.024
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_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2451

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=24ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 04:00:24.024
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) = 2451

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 04:00:24.024
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) = 2451
Parameter #2(CF_SQL_INTEGER) = 2451

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=58ms, Records=8) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 04:00:24.024
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) = 2451

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=11ms, Records=3) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 04:00:24.024
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) = 2451

bb_review (Datasource=, Time=0ms, Records=1) in /root/website/excerpts/index.cfm @ 04:00:24.024
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=47ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 04:00:24.024
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) = 2451

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 04:00:24.024
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) = 2451

obc_discussions (Datasource=booktalk_new, Time=106ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 04:00:25.025
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=103ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 04:00:25.025
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) = 2451

get_ezine_type (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 04:00:25.025
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=156ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 04:00:25.025
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) = 2451

check_permalink (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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=19ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

check_free_ezine (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

check_cat_73 (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

get_ezine_status (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

check_old_ezine (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

get_ezine_status (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 04:00:25.025
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) = 2451

get_coauthor (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_coauthor (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_coauthor (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_coauthor (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_book_image (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_book_image (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_coauthor (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/actions/udfs.cfm @ 04:00:25.025
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) = 2451

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 04:00:25.025
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:00:25.025
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=8ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:00:25.025
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=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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=58ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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=19ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 04:00:25.025
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 @ 04:00:25.025
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:00:25.025
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/excerpts/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4084943; CFGLOBALS=urltoken%3DCFID%23%3D4084943%26CFTOKEN%23%3D4cddb78da08c3623%2D0D5F80B8%2DF3C5%2D1EDD%2D73BD0B7B5BA17508%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2004%3A00%3A24%27%7D%23hitcount%3D280%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A59%3A40%27%7D%23cftoken%3D4cddb78da08c3623%2D0D5F80B8%2DF3C5%2D1EDD%2D73BD0B7B5BA17508%23cfid%3D4084943%23; CFTOKEN=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508; 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/2451/nine-lives
PATH_TRANSLATED=/root/website/excerpts/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/excerpts/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=4084943
cftoken=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
hitcount=287
lastvisit={ts '2026-06-01 04:00:25'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:59:40'}
urltoken=CFID=4084943&CFTOKEN=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
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#=4084943&CFTOKEN#=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508#lastvisit={ts '2026-06-01 04:00:24'}#hitcount=280#timecreated={ts '2026-06-01 03:59:40'}#cftoken=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508#cfid=4084943#
CFID=4084943
CFTOKEN=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
FREEACCESSCOUNT=0
Session Variables:
cfid=4084943
cftoken=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
sessionid=BOOKBROWSE_4084943_4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
urltoken=CFID=4084943&CFTOKEN=4cddb78da08c3623-0D5F80B8-F3C5-1EDD-73BD0B7B5BA17508
URL Parameters:
book_number=2451
nine-lives=
Debug Rendering Time: 27 ms