Excerpt from The Invisible People by Greg Behrman, plus links to reviews, author biography & more

Summary |  Excerpt |  Reviews |  Readalikes |  Genres & Themes |  Author Bio

The Invisible People by Greg Behrman

The Invisible People

How the U. S. Has Slept through the Global AIDS Pandemic, the Greatest Humanitarian Catastrophe of Our Time

by Greg Behrman
  • BookBrowse Review:
  • Critics' Consensus (8):
  • First Published:
  • Jun 1, 2004, 304 pages
  • Rate this book

About this Book

Print Excerpt

With Foege's blessings, and McCormick's drive and gumption, leadership at the CDC persevered, intent on continuing the international effort that had been started. They were professionals. They were, perhaps, too professional.

With budget slashing the order of the day, all areas of the federal health effort were under siege, and the CDC was no exception. Foege calculated that he would be better off moving things around and making do with existing resources, rather than taking on a controversial and still largely unknown disease, and perhaps risking further cuts and wrath from the executive branch.

As public health officials went, Foege was a deft political operative. But he was able to measure himself against a very low bar in that regard. America's leading scientific and health officials were trained in science, medicine, and public health and were among the foremost technical experts in those fields in the world. Those who rose to positions of stature and power in public health and science, though, were generally ill schooled at the sort of political advocacy necessary to secure the resources and political capital they needed to effectively do their job.

The episode in the fall of 1983 was a classic instance. Foege and his entire team did the best they could within the system, but no one sought to jolt the system. No one cultivated relationships with the media or used it to scream about the team's findings or the significance of the disease's stronghold in Africa, the disturbing global dimension that had just been discovered. They did not forcefully lobby the administration or seek to galvanize domestic political constituencies to the issue.

Of course they were facing a panoply of problems and constraints: their budget was under siege, they did not have their own administration's support or leadership, they were struggling to amass resources for the wide range of prevalent U.S. domestic health problems, including the domestic AIDS epidemic brewing in the United States, and relatively little was known about the international dimension at the time.

McCormick would later assert that "by steadfastly refusing to acknowledge the true dimensions of the AIDS crisis, the Reagan administration made itself an ally of the virus." Brandt's negligence struck an ominous note at a seminal juncture.

It was a cause, in 1983, in search of a political champion.


On the memorably inauspicious morning of April 23, 1984, HHS Secretary Margaret Heckler stood at the podium at the department's headquarters in Washington, D.C., with Dr. Robert Gallo in tow, wearing a wide and sprightly smile. Gallo, the director of the eminent National Cancer Institute and one of the world's foremost experts on retroviruses, had earned his spot in the limelight next to Heckler, she announced, because he had officially "discovered" the virus that causes AIDS. It would be dubbed, shortly thereafter, the human immunodeficiency virus, or HIV.

Heckler's unbridled enthusiasm seemed to give the announcement great occasion, as did her buoyant pronouncements. "Today's discovery," she proclaimed, "represents the triumph of science over a dreadful disease." She suggested that the discovery would pave the way for a vaccine that would be ready for testing within two years.

Wild miscalculations would continue to abound through the year that followed.

In the summer of 1984, the McCormick/Piot article would be released in The Lancet. In addition, a handful of prominent epidemiologists had been drawn to the global dimension of the disease. One of them was Dr. Robert Biggar, who published a set of very bold estimates in The Lancet in that same year. Many more would follow, including Gallo himself.

The World Health Organization, or WHO, on the other hand, had extricated itself from global AIDS. An internal 1983 WHO memorandum stated that AIDS "is being well taken care of by some of the richest countries in the world where there is the manpower and the know-how and where most of the patients are to be found." It was of course, a grossly mistaken presumption on all accounts. WHO would have been a logical clearinghouse for the science -- estimates of incidence and features of the disease, for example. Without WHO's participation, disparate sets of teams set out, intent on capturing data on the global dimension. The results would be divergent, leading to contention and chaos.

In April 1985, the CDC organized what would become the first International AIDS Conference, to be held in Atlanta, Georgia. It would attract approximately two thousand scientists, public health officials, and journalists, brought together with the aim of sharing knowledge, and reaching common ground and consensus.

Peter Piot had been working on a CDC-sponsored AIDS longitudinal study that McCormick had helped to set up in Kinshasa. Studying the disease in Africa, Piot had developed a keen sense for the urgency of the problem brewing. He was ecstatic about the opportunity in Atlanta. Piot had even encouraged several of his African colleagues to make the long journey. He believed that the experience would be of value in their work, and that their perspective would enrich the proceedings.

As the scientists took to the stage to present their findings, Piot watched, befuddled. Some of the world's most prominent scientists were presenting estimates of incidence of HIV in Africa that were absolutely stratospheric, off the charts. Some estimates purported that in certain regions of Uganda, children tested 66 percent positive for the virus; others suggested that 88 percent of the female prostitutes in Rwanda carried the virus. Robert Biggar of the U.S. National Cancer Institute estimated that between 1982 and 1984, roughly half of the Kenyan population had been infected with the disease.

Piot had hoped that the international scientific community would acknowledge the severity and magnitude of the epidemic. He had been living in Africa for a year and he knew from firsthand experience, however, that the numbers presented here were gross overestimations. Confounded and despondent, Piot kept a close eye on his African colleagues. Their goodwill and support was the bedrock upon which his presence was made possible in Zaire.

When Harvard scientist Max Essex averred that the origins of the disease could be traced back to monkeys in central Africa, Piot's trepidation grew. Sure enough, a group of journalists found their way to Piot's African colleagues and asked them, "Is it true? Do Africans have sex with monkeys?" The African scientists were aghast.

Hours later, sitting alone in a stairwell, Piot was utterly dejected. "This is a disaster," he said to himself.

Shortly after the conference it would be verified that almost all of the estimates proffered were wildly erroneous. The blood tests used -- still terribly unrefined and clearly inadequate -- yielded positive results for traces of malaria and other unrelated pathogens. All of these cases were captured in the results, inflating the AIDS estimates. Almost all of the African populations tested had, at some time, been exposed to malaria in varying capacities. It was a wonder, then, journalist Laurie Garrett wrote, that the estimates did not report even higher levels of incidence.

The immediate reaction was panic -- it seemed all of a sudden that the continent was about to erupt in a terrible conflagration. While the inaccuracy of the estimates would be redressed in short order, the social and political fallout of the conference would generate debilitating consequences that would reverberate for years to come. The inflated estimates would breed skepticism among U.S. policy makers, the public health establishment, the media, and the public.

On the African side, political leaders, ever sensitive, particularly in light of the imperial legacy and the stereotypes they knew to abound in the West, grew incensed at the false estimates. "African AIDS reports are a new form of hate campaign," Kenyan President Daniel arap Moi fumed. Already grappling with crises like drought, famine, civil war, poverty, and a panoply of existing health issues, African leaders were furious about western scientists grandstanding and painting a near apocalyptic depiction of Africa. The inflated estimates would plant seeds of skepticism that would help breed denial among the continent's leaders for the next decade and a half. African denial would, in turn, serve as a crutch for U.S. inaction.

When the estimates were later brought down to single-digit incidence rates, the immediate reaction was one of relief -- "It's not as bad as we thought." With that sentiment as an undercurrent, what little attention Africa had garnered was seamlessly redirected within America's borders, where incidence was escalating precipitously.

 

While no one could claim a commanding grip on the magnitude of the pandemic, by 1986 certain progress had been made. The misestimates proffered in Atlanta had been debunked and more reasonable and accurate ones offered in their place. The research effort that McCormick had worked to establish in Kinshasa, Zaire, had been up and running since the middle of 1984. Called Project SIDA (the French acronym for AIDS), it was yielding a great deal of useful data. Finally, WHO had taken up the issue and established the Special Program on AIDS, or SPA. Its leader, Dr. Jonathan Mann, would in time become a pioneer and a legend. Already by 1986, he was a credible and forceful advocate for the world's response to the pandemic.

Despite the Reagan administration's continued refusal to address the disease, Congress was able to ensure that funds for the domestic epidemic were scaled up. Priority number one was vaccine development. A vaccine would, of course, have positive ramifications for the global dimension of the disease, but the politics and constituencies driving the effort were almost entirely domestic-centric. The global dimension was not considered at all, and had received entirely no funding or political leadership.

That would change in 1986. A small handful of figures in the Congress were starting to take notice. Primarily through the efforts of Pat Leahy, the towering, gray-haired senator from Vermont and a staunch internationalist whose politics leant to the left, Congress was able to appropriate an inaugural sum for global AIDS.

By the end of that year a quarter of a million people had died of AIDS worldwide. Almost 4 million had been infected with HIV. The total U.S. appropriation for global AIDS in 1986: $2 million.

Leahy and other early champions, including Representative David Obey from Wisconsin, knew that it was a woefully inadequate amount. But the White House was entirely disinterested, if not averse, to the effort, and it was notoriously difficult to create any new line item on the budget, particularly in the foreign assistance bucket. It did not help that this was taking place against the backdrop of the gaping deficits being generated under Reagan's aggressive supply-side economic plan. It was, they hoped, a start. And a most needed one at that.

But where would it go?

Now that Congress had appropriated the money, what branch of the government, what department or agency, would tackle global AIDS? There was no one obvious candidate.

In time, AIDS would begin to eviscerate national economies. At the outset, however, the Treasury Department, the area of the U.S. government empowered to oversee matters of international finance and economic development, was not interested. Treasury had its hands full managing what were becoming unprecedented budget deficits. In the Reagan era, framed by the Cold War, "globalization" had yet to catch on. The world was still divided into two camps, and the idea that the world's economic well-being was interwoven among all the world's nations was weak in currency. Officials weren't accustomed to thinking in terms of "nontraditional" economic issues like health or the environment.

At the Department of Defense, Reagan's hawks had their hands full defeating the "evil empire." Managing the U.S.-Soviet great power rivalry and the NATO alliance, building up the U.S. missile arsenal, developing Star Wars and deploying U.S. intermediate range ballistic missiles in the European theater kept Defense busy through the mid-1980s. In a prescient 1980 article in Foreign Affairs, entitled "Redefining Security," Richard Ullman argued that the strictly politico-military conception of "security" ignored other pressing "nontraditional" security issues. In time, forward thinkers would emerge willing to push Defense to revisit Ullman's call for a "redefinition" to include threats such as global AIDS. In the 1980s, though, the idea was ahead of its time.

As the diplomatic arm of the U.S. government, the State Department was able to highlight and prioritize emergent international crises and champion resource allocation for them. It was able to press foreign leaders to engage matters of import to the U.S. foreign policy agenda. Yet few at State, even through the late 1980s, demonstrated serious interest in upgrading U.S. policy to tackle the burgeoning pandemic. A handful of ambassadors voiced concern through the State hierarchy on several occasions. But they were more the exception than the rule. At a critical point in the Cold War and on the eve of a "New World Order," U.S. diplomatic capacity was stretched and focused elsewhere.

In the late 1980s, the Soviet Union, East Germany, and their satellite "minions" launched a propaganda campaign in Africa, claiming that the CIA had created the disease to kill black Africans. Leaders at State's Africa Bureau were shaken by cables that seemed to forewarn of "apocalypse," but they spent more time and energy digesting the reports and debunking the Soviet-led propaganda campaign than pressing for U.S. involvement or spurring African leaders to lead. State wasn't opposed to U.S. engagement, one bureaucratic operative explained, "it was more benign neglect."

The Department of Health and Human Services, or HHS, seemed to many the logical place to house the U.S. response. HHS, though, would join the leading U.S. departments in passing the proverbial buck on global AIDS.

Among the most stung, HHS found itself waylaid by the Reagan budget cuts. Assuming office, Reagan proclaimed, "Government doesn't solve problems, it subsidizes them." Adhering to his mantra, Reagan eviscerated the funds available to the department responsible for the health of the American people. From 1981 to 1983 Reagan slashed the HHS budget by approximately 25 percent. Amid the siege, HHS was doing all it could to fight America's biggest killers, heart disease and cancer. The domestic AIDS epidemic was thrown into the mix at a time that was less than propitious. The Department was overwhelmed.

Importantly, HHS's official mandate extends only so far as matters of "domestic" health. Paul DeLay, a longtime U.S. health official, later to become a leader in the U.S. response, remarked: "HHS was seen as not only not having the mandate, but not really understanding what was involved....They didn't have the experience [necessary to tackle the problem]. How many people," DeLay asked, "at HHS have passports? How many had been to Africa?"

There was an arm of HHS, though, that was brimming with rough and tumble "virus hunters" who had spent more than their fair share of time in Africa and other international locales. The CDC is the United States's center of technical excellence for disease surveillance. "Bug busters" like Joe McCormick had been all over the earth, searching for and combating emerging and reemerging infectious viruses. They knew how to identify them, how to conduct surveillance, and, when possible, how to control the outbreaks.

But CDC, like HHS and all the other aforementioned departments, had no international mandate per se. Dr. Kenneth Shine, former president of the Institute of Medicine, explained, "CDC has no international surveillance responsibility. The CDC operates under the assumption that if an outbreak of something occurs they will be called in to investigate." But international surveillance, let alone intervention, strictly speaking, was not a mandatory responsibility.

The calculus to fly McCormick and his colleagues halfway around the world and sponsor their investigations was generally driven by U.S. national interests. If there was an outbreak, even in a faraway locale, it behooved the U.S. scientific community to know about it so that they would be well schooled in the threat and thus able to protect the U.S. population at home and abroad. Funds were tight and humanitarian efforts were a luxury, not the norm. Congressional oversight generally saw to that. American taxpayers, after all, were funding CDC's activities.

"In the beginning," Dr. Helene Gayle, an African-American woman who would later oversee the CDC's global HIV/AIDS effort, explained, "because CDC primarily has a domestic mandate, a lot of what drove the ability to work in international settings was the fact that there were lessons to be learned from the international setting that could be used for domestic populations." The CDC would launch surveillance efforts in Zaire, and later Côte d'Ivoire and Azerbaijan. The CDC's surveillance work would yield insights that would benefit developing nations as they fought the pandemic in their own backyards. But the impetus driving the CDC's engagement had its origins in a domestic mandate and U.S. concerns.

There was a sense, anyhow, that the CDC was equipped to conduct surveillance and do research, but that was where their competency ended. What was needed abroad, global AIDS advocates argued, was intervention.

The CDC may not have been "set up" to lead interventions, but they had done it in the past, and they had done it with astounding success. Counters Dr. Jeffrey Harris, a CDC official at the time, they "did it on smallpox, did it on diarrhea and immunization. They had done a good job."

AIDS demanded a more ambitious intervention, though, and resources were scant. Initiating an intervention effort would have been, or at least was perceived as being, extramandatory. CDC figures like Helene Gayle would expend a good deal of energy through the late 1980s and 1990s trying to expand CDC's efforts. But until the late 1990s, global AIDS was viewed as only one emergent health issue among a vast panoply of diseases and sicknesses already claiming millions of lives a year.

Early on, CDC's leadership could muster neither the foresight nor the political will or ingenuity to marshal the resources and political support to broaden its range of involvement. A decade and a half later, the CDC, like its parent department, HHS, would join the State Department in a loud chorus pleading for resources to expand its efforts in fighting the pandemic. At the moment, though, when their engagement might have done the most to preempt the pandemic's global explosion, all of these centers of government were willing simply to pass the buck. And the buck -- all 2 million of them -- would stop, it turned out, at the United States Agency for International Development, or USAID.

USAID was created by the Kennedy administration in November 1961 to provide developmental assistance to countries in need. Like the Peace Corps, it was an outgrowth of the "New Frontier" ethos of international service. The agency was quickly consumed, though, by the geopolitical context into which it was born. All major U.S. international initiatives during the Cold War were to a great extent either a function of, or greatly influenced by, the overarching U.S. foreign policy imperative of the epoch: containment of the Soviet Union.

USAID, though perhaps born of a noble impulse, would prove pervious to that phenomenon. USAID's grant making and developmental assistance functions became yet another weapon in the U.S. arsenal to fight the Soviet Union. Grants and assistance were doled out not on the basis of need, but to countries friendly to the United States. Assistance was used as leverage both to keep countries in the U.S. camp as well as to woo countries away from the Soviet bloc.

Confusing the agency's mission further, it would come to award hundreds of millions of dollars in contracts to U.S. companies or nongovernmental organizations (NGOs). As such, a veritable cottage industry grew around the agency, competing for money and becoming a political lobby in the beltway.

Financed with billions of dollars a year, and with missions and deeply dedicated foreign officers, the agency was able to do significant good all over the developing world. By the mid-1980s, however, the agency's clarity of mandate, its operational efficiency, its credibility, and its sense of purpose were all foundering.

A decade earlier, in the 1970s, health was added to its long and extremely diverse list of priorities including, but not limited to, agriculture, famine, democracy promotion, family planning, and education. By the mid-1980s, USAID's leadership began attempting to upgrade the agency's health effort. Dr. Kenneth Bart, a prominent CDC official, was brought on to head the agency's Health Office. Funds were scant though, and were disbursed based primarily on geopolitical considerations. What little remained was meted out to the multitudinous array of offices and divisions at the agency. The funds available to Bart and his Office of Health were mostly earmarked for child-related programs. The agency's polio immunization effort and its support of the development for a malaria vaccine were among their most prominent efforts for a long time. Child-centric health issues, which circumvented issues of sex or dubious behavior, were viewed by most at the agency as a safe sell, a particularly important consideration in the conservative Reagan years.

As a consequence of all these factors, in tackling the world's major health problems and crises, Bart and his Office of Health were able to pack only a very meek punch. And though HIV/AIDS had been an emerging global crisis for several years, "we weren't rehearsed on infectious disease," let alone HIV/AIDS, Paul DeLay said of USAID's health effort.


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

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 /excerpts/index.cfm
Time Stamp 01-Jun-26 03:43 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
1780328609101 ms 1.7803286091E+012 ms 1 /root/website/app_server.cfm
1539 ms 1539 ms 1 /root/website/excerpts/index.cfm
364 ms 364 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
259 ms 259 ms 1 /root/website/app_globals.cfm
236 ms 236 ms 1 /root/website/queries/qry_get_book_by_id.cfm
193 ms 193 ms 1 /root/website/app_layout.cfm
131 ms 131 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
115 ms 115 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
95 ms 95 ms 1 /root/website/queries/qry_get_active_obc.cfm
90 ms 90 ms 1 /root/website/excerpts/dsp_main.cfm
86 ms 43 ms 2 /root/website/adsystem/adsystem_mod.cfm
77 ms 77 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
60 ms 60 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
59 ms 59 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
58 ms 58 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
48 ms 48 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
47 ms 47 ms 1 /root/website/adzones/showcase_track.cfm
43 ms 43 ms 1 /root/website/act_check_login.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_member_info.cfm
41 ms 41 ms 1 /root/website/adzones/AdZone6.cfm
31 ms 31 ms 1 /root/website/actions/adstatus.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_current_competition.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
22 ms 22 ms 1 /root/website/site/blocks/membership_advantages.cfm
20 ms 7 ms 3 /root/website/actions/act_spider_tracker.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_member_account_types.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
13 ms 13 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
11 ms 11 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
4 ms 4 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_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_closed_reviews.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/site/blocks/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_awards.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_btb.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_readalikes.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1540 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

15:43:30.030 - 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=20ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 15:43:29.029
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=42ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:43:29.029
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

adactive (Datasource=bookbrowse_com_new, Time=31ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:43:29.029
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 15:43:29.029
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=29ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:43:29.029
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:43:29.029
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:43:29.029
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

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

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

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

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

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

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

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=23ms, Records=0) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 15:43:29.029
select 		a.reader_review_number, a.book_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.book_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    from 		reader_reviews a
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number,
    			books b
    where 		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
    and 		a.book_number = ?
    and 		a.reader_review_approved_flag = 1
    and 		a.book_number = b.book_number
    

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

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

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

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=49ms, Records=5) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 15:43:29.029
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) = 1451

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=17ms, Records=4) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 15:43:29.029
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) = 1451

bb_review (Datasource=, Time=0ms, Records=1) in /root/website/excerpts/index.cfm @ 15:43:29.029
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=19ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:43:29.029
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) = 1451

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

obc_discussions (Datasource=booktalk_new, Time=237ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:43:30.030
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=84ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 15:43:30.030
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) = 1451

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

check_permalink (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:43:30.030
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=20ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 15:43:30.030
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) = 1451

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

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

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

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

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

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

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

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

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

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=14ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:43:30.030
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=39ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:43:30.030
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=20ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:43:30.030
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=22ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:43:30.030
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:43:30.030
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 @ 15:43:30.030
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=10ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:43:30.030
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:43:30.030
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:43:30.030
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:43:30.030
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:43:30.030
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; CFTOKEN=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1; CFGLOBALS=urltoken%3DCFID%23%3D4106119%26CFTOKEN%23%3Dfa89f57d6d9aa23a%2D268AACEA%2DE257%2D191B%2DC029049D0DAD98A1%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A43%3A28%27%7D%23hitcount%3D7%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A43%3A26%27%7D%23cftoken%3Dd50ca91021f8b38d%2D268A9D3F%2DFECF%2DABD5%2DDEFBD95DE5209737%23cfid%3D4106115%23; CFID=4106119
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/1451/page_number/5/the-invisible-people
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=4106115
cftoken=d50ca91021f8b38d-268A9D3F-FECF-ABD5-DEFBD95DE5209737
hitcount=14
lastvisit={ts '2026-06-01 15:43:30'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:43:26'}
urltoken=CFID=4106119&CFTOKEN=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1
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#=4106119&CFTOKEN#=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1#lastvisit={ts '2026-06-01 15:43:28'}#hitcount=7#timecreated={ts '2026-06-01 15:43:26'}#cftoken=d50ca91021f8b38d-268A9D3F-FECF-ABD5-DEFBD95DE5209737#cfid=4106115#
CFID=4106119
CFTOKEN=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1
Session Variables:
cfid=4106119
cftoken=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1
sessionid=BOOKBROWSE_4106119_fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1
urltoken=CFID=4106119&CFTOKEN=fa89f57d6d9aa23a-268AACEA-E257-191B-C029049D0DAD98A1
URL Parameters:
book_number=1451
page_number=5
the-invisible-people=
Debug Rendering Time: 92 ms