Aleksandar Hemon Interview, plus links to author biography, book summaries, excerpts and reviews

Aleksandar Hemon
Photo: Sa Schloff

Aleksandar Hemon

How to pronounce Aleksandar Hemon: HEH-mahn

An interview with Aleksandar Hemon

The Lazarus Project is Aleksandar Hemon's third work of fiction, but the first intended as a novel. In it he tackles some tough questions about the life of immigrants in the US. In this interview he discusses what led him to this story, and the resources he drew on to write it.

This is your third work of fiction, but the first one that was conceived and intended as a novel. Was this simply a natural progression in your work, or was it a challenge that you consciously set for yourself?
Well, Nowhere Man was elected a novel. On the cover of the Nowhere Man hardback there was no description of the book - I talked my editor into omitting it. The book was neither a novel nor a short story collection. But then everyone reviewed it as a novel and it came out in paperback as a novel and I guess it is a novel now.

As for The Lazarus Project, for the longest time I called it simply “the big book.” I could not, and would not, refer to it as “a novel” until I submitted it to my editor, so it became something I could describe as a novel very late in its production. It is pretty weird, I think, to set out to write a novel - unless it merely means a lot of pages - because that implies that one is simply writing down what has already been thought up and imagined, that the form precedes the work; I don’t know how to do that. I had no idea what would come out when I started writing The Lazarus Project, except that it would not be a short story. Then one day I just recognized it as a novel, it seems to fit the description and now the proposition is up for popular vote. Writing The Lazarus Project, I learned that you have to arrive at the form, you have to earn the right to call a book a novel.

What was it about the true story of Lazarus Averbuch that appealed to you? Why a Jewish immigrant like him and not a Bosnian or Eastern European gentile like yourself or your narrator?
What initially appealed to me was the tragedy of his immigration to America. He had survived a pogrom, spent some unpleasant time in refugee camps, and came to Chicago to be killed by Chief Shippy, after only 7-8 months of being here. The American Dream did not work out for him at all. His story was edited out of that grand narrative.

I could see no reason to turn Lazarus into someone “like myself.” First of all, I wanted to retain--to the extent that that is possible in a work of literary fiction--his historicity. The killing of Lazarus Averbuch did happen, even if a lot of stuff in my book did not “really” happen. The photos of the dead Lazarus--the heart of the book--are so haunting because they document that he did live and he did die.

Second, at the time of the Averbuch affair there was ubiquitous pseudoscientific discourse--the early 20th century is the high point of phrenology and eugenics--that identified many immigrants as racially inferior degenerates biologically inclined toward anarchism. The fact that Lazarus was a poor Eastern European Jew made him a perfect anarchist in the eyes of the law-abiding American public.

Third, I do believe in a sort of immigrant solidarity. I am not a Jew, but I was an alien resident--and often feel as one--as are many of my friends and family members. It has been easy to identify with his or his sister Olga’s loneliness and anger.

How did you research the life of Lazarus Averbuch, the Chicago of a hundred years ago, and real historical figures like Chief of Police George Shippy?
The main source was “An Accidental Anarchist” (Rudi Publishing, 1998) a book by Walter Roth and Joe Krauss, although I significantly diverged from--indeed distorted--the (true) story Roth and Krauss told. I also spent many hours in the archives of the Chicago Historical Society browsing through old newspapers. I looked at hundreds of photos from that era. Then at some point I stopped researching, started imagining and then let it all merge into a story.

This is your first book since you won a MacArthur Foundation “genius grant.” How has receiving the award affected your life and your work? Was it anything like what happens to Brik after he wins a “Susie” award?
Actually, a Guggenheim fellowship allowed me to go on a research trip to Eastern Europe. By the time I received a MacArthur, I was up to my neck in The Lazarus Project. The MacArthur made everything much easier, obviously, allowing me to remove myself from Chicago for a little while, which felt necessary for a number of reasons, and finish the book.

Brik makes a direct connection between the anti-immigrant fervor of the early twentieth century and today’s so-called war on terror. What is the link between them?
I recently read a quote from a supporter of Tom Tancredo--the maniac xenophobe presidential candidate. Here it is (from “Return of the Nativist,” The New Yorker, December 17, 2007): “Some of these people [immigrants] may be coming in here to get jobs washing dishes, but some of them are coming in here to hijack airplanes… But I can’t tell Jose Cuervo from the Al Qaeda operatives by looking at them, because they cut their beard off. It’s like trying to get fly manure out of pepper without your glasses, you know? I mean, not a racist thing, but they’re all brown with black hair and they don’t speak English and I don’t speak Arabic and Spanish, so if they don’t belong here and they don’t come here legally, I want to know who’s here.”

I love it that he felt compelled to establish he was not a racist.

This kind of patriotism--which is at the heart of the war on terror--is very much akin to what was expressed in a 1908 editorial cartoon I ran into: an enraged Statue of Liberty kicking a cage full of foreigners, whom you can recognize as such because they are dark-faced, curly-haired, hook-nosed and are clutching bombs and knives. The caption says “Enough.”

The notion of immigrants as foreign bodies contaminating America is as old as it is persistent, and it is closely related to the fantasy of American innocence and inherent goodness. The war on terror activates and exploits this idea.

American innocence — or rather, Americans’ conception of their own innocence — is a major theme here, especially as it plays out in the relationship between Brik and his American neurosurgeon wife, Mary. What is it about American innocence that is so disturbing to Brik? What is it that Americans don’t understand, in his view, about evil and the limits of good intentions?
Around the time of the Abu Ghraib revelations, I went to see my physician, who is the kindest, nicest American woman. I was devastated by the Abu Ghraib pictures. They recalled the camps in Bosnia in which Bosnian Muslims were tortured and killed much in the same manner as Iraqis were in Abu Ghraib, with plenty of sexual humiliation, as though both the Americans and the Serbs read the same torture manuals, the same studies on “the Muslim mind.” I talked about it all with my physician and she was, of course, appalled, but then she said: “To think that even Americans can do such things.” For her, it seemed, Abu Ghraib was possible only because Americans somehow descended to the level of the rest of the world. The Abu Ghraib torturers became all too human, as it were, they forgot they were saintly Americans. It is a fascinating, fantastic notion--that moral evolution is most advanced in this country, that Americans are incapable of crimes against humanity, because America is the high point of humanity.

The immigrant experience has long been one of the great preoccupations of American literature, and it has been reinvigorated in recent years by a number of writers from all over the world who have come of age in an era of globalization. In the case of you and your work, there is the added element of coming from a country torn apart by a war. Is it possible for an immigrant like Brik — who is not sure where he belongs, who is overwhelmed by sadness and rage and guilt — to ever integrate fully into American life?
What is American life? Is it devoid of sadness and rage and guilt? I bet that living through the depredations of the past eight years, for example, resulted in substantial deposits of American sadness, rage and guilt. Indeed, it seems to me that sadness, rage and guilt in various forms are essential ingredients of American life.

I cannot imagine a life--American or not--that does not exist in some sort of a conflicted, historically troubling and troubled space. (Perhaps that is the limit of my imagination.) So at the beginning of the book Brik, with his sadness and rage, is to a large extent already integrated in the American life. And that is precisely his problem.

There is a powerful and complex Biblical resonance here, since you explicitly invoke in your title and throughout your novel one of the most memorable passages from the New Testament, in which Jesus raises Lazarus from the dead. With the book he is intending to write, Brik is overtly trying to resurrect Lazarus Averbuch, to tell his true story and render justice to him. Yet Brik is a non-believer who makes fun of the figure he calls “Mr. Christ” and “the nailed gymnast.” He even questions whether Jesus did Lazarus a true service by resurrecting him. Can you discuss this?
Let me say that I am an atheist. I find religion anthropologically and culturally interesting, but I also find that it is vile and ridiculous as a means of resolving existential problems of human beings. I think that a sustained, rational argument can be (and should be) mounted against religion. Brik, on the other hand, does not build a sustained argument--he is simply angry. Eschatological questions come up as he thinks about Lazarus and death and listens to Rora’s war stories. His agnostic anger is a function of his character.

Why was it important for Rora, the photographer, to be in the novel? Why is it that Brik loves looking at Rora’s pictures but doesn’t want to be in them?
A photo of Brik is indeed in the book.

Photography was always at the heart of this book. The pictures of the dead Lazarus held up by a police captain were so astonishing to me when I found them that I instantly decided to have them in the book. But once that decision was made, the question was, what stories could the photos tell? What can we know about others, the past, the world? How can we access all that through stories, histories, photos? And that then became one of the things the novel is about.

Rora is a counterbalance to Brik. Brik is a navel-gazer, a would-be philosopher and historian, someone who has to process the sensations and information before he understands what is happening around him. Whereas Rora is a storyteller and someone who interacts instantly, with or without his camera, with the world around him.

In the book you’ve included more than twenty photographs, many by your real-life friend, Velibor Božovi?. Why? And naturally, the question arises, how closely is Rora based on Božovi??
There are twelve photos of Božovi?’s. The rest are from the Chicago Historical Society Archives. (But there are a lot more Lazarus Project photos at www.veliborbozovic.com)

I can’t remember when exactly, but very early on I knew that I would have photos in the book and that one of the characters would be a photographer. So when Velibor and I went to Eastern Europe for the Lazarus research trip, Rora was already present as a character. Velibor shot some 1,200 photos on this trip, knowing full well that I would use them in my book. Visiting places that Brik and Rora visit, we would discuss and imagine what Rora would do or shoot there. Rora is a collaborative character. He has absolutely nothing to do with Velibor, who could not be more different than Rora. Velibor, for instance, does not talk much.

Your narrator talks about the differences in attitudes toward storytelling in Bosnia and Americ
You write in the novel: “Disbelief was permanently suspended, for nobody expected truth or information, just the pleasure of being in the story and, maybe, passing it as your own. It was different in America: the incessant perpetuation of collective fantasies makes people crave the truth, and nothing but the truth — reality is the fastest American commodity.” How does this relate to your own idea of what fiction is?
I don’t like the word fiction. It is a marketing description, a bookselling label. It does not relate to anything I like in literature. It equates airport novels with Kafka. It tells the reader how she or he should approach the book. The use of the word perpetuates a situation in which “non-fiction” is more “true” than fiction. And it relegates Shakespeare and poetry to the shelves in the far corner of the bookstore.

I can tell you what literature is, though: it is human experience in language. That does not only mean that it describes or records human experience, but also that it imagines it and creates it. Stories create characters: Homer created the siege of Troy, Shakespeare imagined Hamlet, and Saul Bellow imagined Auggie March. The human knowledge formed and deposited in literature is unavailable otherwise. What is valuable in literature is not the quality of information about the past or the present. What matters is the intensity and depth of experience of reading and imagining other lives, unlived by the reader.

I believe that literature has a unique, close relation to our human realities simply because it cannot exist outside language, as we cannot understand our lives, our past and future, outside language. Language is always real, it always exists.

As for reality, it is very hard to have access to it, to see what it is these days. Nabokov said that reality is a word that should never be used outside quotation marks, and that has never been more true than it is in this country today.

Interesting Link: A podcast in which Aleksandar Hemon talks about The Lazarus Project and Love and Obstacles.

Unless otherwise stated, this interview was conducted at the time the book was first published, and is reproduced with permission of the publisher. This interview may not be reproduced or reprinted without permission in writing from the copyright holder.

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!

Books by this Author

Books by Aleksandar Hemon at BookBrowse
The World and All That It Holds jacket The Book of My Lives jacket Best European Fiction 2011 jacket Best European Fiction 2010 jacket
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!

Read-Alikes

All the books below are recommended as read-alikes for Aleksandar Hemon but some maybe more relevant to you than others depending on which books by the author you have read and enjoyed. So look for the suggested read-alikes by title linked on the right.
How we choose readalikes

  • Julian Barnes

    Julian Barnes

    Julian Barnes was born in Leicester, England on January 19, 1946. He was educated at the City of London School from 1957 to 1964 and at Magdalen College, Oxford, from which he graduated in modern languages (with honors) in ... (more)

    If you enjoyed:
    Best European Fiction 2010

    Try:
    Pulse
    by Julian Barnes

  • Phillipe Claudel

    Phillipe Claudel

    Philippe Claudel is the author of many novels, among them By a Slow River, which has been translated into thirty languages and was awarded the Prix Renaudot in 2003 and the Elle Readers' Literary prize in 2004. His ... (more)

    If you enjoyed:
    Best European Fiction 2010

    Try:
    Brodeck
    by Phillipe Claudel

We recommend 25 similar authors


Non-members can see 2 results. Become a member
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...

The only real blind person at Christmas-time is he who has not Christmas in his heart.

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 /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 05:36 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
1780292163094 ms 1.78029216309E+012 ms 1 /root/website/app_server.cfm
612 ms 612 ms 1 /root/website/author_interviews/full/index.cfm
223 ms 223 ms 1 /root/website/app_layout.cfm
183 ms 183 ms 1 /root/website/author_interviews/full/dsp_main.cfm
170 ms 57 ms 3 /root/website/adsystem/adsystem_mod.cfm
132 ms 132 ms 1 /root/website/app_globals.cfm
111 ms 111 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
101 ms 101 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
95 ms 95 ms 1 /root/website/adzones/showcase_track.cfm
75 ms 38 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
60 ms 60 ms 1 /root/website/adzones/AdZone6.cfm
56 ms 56 ms 1 /root/website/queries/qry_get_active_obc.cfm
41 ms 14 ms 3 /root/website/site/blocks/membership_advantages.cfm
39 ms 13 ms 3 /root/website/queries/qry_get_member_account_types.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
32 ms 32 ms 1 /root/website/adzones/AdZone2.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_current_competition.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
29 ms 29 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
8 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
6 ms 6 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
4 ms 4 ms 1 /root/website/actions/adstatus.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
613 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 05:36:03.003
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=16ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 05:36:03.003
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=20ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 05:36:03.003
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=20ms, Records=3) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:36:03.003
select	a.book_number, a.book_title, a.book_sub_title, book_short_summary,
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
        left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0 
   		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1 
		
       	where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)

		order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1557

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:36:03.003
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1557

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=8) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 05:36:03.003
select	a.book_number, 
        		'' AS ezine_preview_number,
                a.book_title, 
                a.book_sub_title, 
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt",
                '' as "jacket"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
		left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
		
        where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)        
        UNION

		select	'' AS book_number,
        		ezine_preview_number, 
				ezine_preview_title AS "book_title", 
				ezine_preview_subtitle AS "book_sub_title",
                ezine_preview_publish_dt AS "publish_dt",
                ezine_preview_jacket_image as "jacket"
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		ezine_preview_bb_link < 1
        
        order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1557
Parameter #2(CF_SQL_INTEGER) = 1557

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=20ms, Records=5) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 05:36:03.003
select	ezine_preview_number, 
				ezine_preview_title, 
				ezine_preview_subtitle,
                ezine_preview_publish_dt ,
                ezine_preview_jacket_image
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		(ezine_preview_bb_link IS NULL
				 or ezine_preview_bb_link < 1)
        and		ezine_number > 0
        
		order by ezine_preview_publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1557

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=11ms, Records=25) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 05:36:03.003
SELECT		a.author_number,
			CASE	WHEN datalength(a.author_middle_initial) > 0 
					THEN a.author_first_name + ' ' + a.author_middle_initial + ' ' + a.author_last_name
					ELSE a.author_first_name + ' ' + a.author_last_name
					END AS "author_full_name",
			b.book_number, 
			f.book_title as "book",

			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 "liked_author_full_name",
			e.author_number as "liked_author_number", 
			g.book_title as "liked_book",
			c.liked_book_number as "liked_book_number" 

FROM		authors a
INNER JOIN	book_author_mapping b ON b.author_number = a.author_number
INNER JOIN	liked c ON c.book_number = b.book_number
INNER JOIN	book_author_mapping d ON d.book_number = c.liked_book_number
INNER JOIN	authors e ON e.author_number = d.author_number
INNER JOIN	books f on f.book_number = b.book_number
INNER JOIN	books g on g.book_number = c.liked_book_number

WHERE		a.author_number = ?

ORDER BY 	e.author_last_name, e.author_first_name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 1557

get_ads (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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) = adzone2
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:03.003
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_book_image (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/udfs.cfm @ 05:36:03.003
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) = 4580

get_book_image (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/actions/udfs.cfm @ 05:36:03.003
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) = 2424

get_member_account_types (Datasource=bookbrowse_com_new, Time=13ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:03.003
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=14ms, Records=5) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:03.003
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1252
Parameter #2(CF_SQL_INTEGER) = 1252
Parameter #3(CF_SQL_INTEGER) = 1252

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:03.003
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1252

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=35ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:03.003
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1347
Parameter #2(CF_SQL_INTEGER) = 1347
Parameter #3(CF_SQL_INTEGER) = 1347

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:03.003
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1347

get_member_account_types (Datasource=bookbrowse_com_new, Time=13ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:03.003
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=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:36:03.003
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=16ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:36:03.003
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=28ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 05:36:03.003
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 @ 05:36:03.003
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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=58ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:03.003
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/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFID=4089539; CFGLOBALS=urltoken%3DCFID%23%3D4089539%26CFTOKEN%23%3Dfc2e5af7702468ea%2D10CFB09F%2DDF96%2D0424%2DC7FFEC28361769DE%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2005%3A36%3A02%27%7D%23hitcount%3D84%23timecreated%3D%7Bts%20%272026%2D06%2D01%2005%3A35%3A48%27%7D%23cftoken%3D85377496813ce83%2D10CFA14C%2DBCD4%2D2943%2D0FCDF348B6F8E93B%23cfid%3D4089535%23; CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/1557/author/aleksandar-hemon
PATH_TRANSLATED=/root/website/author_interviews/full/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/author_interviews/full/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=4089535
cftoken=85377496813ce83-10CFA14C-BCD4-2943-0FCDF348B6F8E93B
hitcount=87
lastvisit={ts '2026-06-01 05:36:03'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 05:35:48'}
urltoken=CFID=4089539&CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
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#=4089539&CFTOKEN#=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE#lastvisit={ts '2026-06-01 05:36:02'}#hitcount=84#timecreated={ts '2026-06-01 05:35:48'}#cftoken=85377496813ce83-10CFA14C-BCD4-2943-0FCDF348B6F8E93B#cfid=4089535#
CFID=4089539
CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
FREEACCESSCOUNT=0
Session Variables:
cfid=4089539
cftoken=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
sessionid=BOOKBROWSE_4089539_fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
urltoken=CFID=4089539&CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
URL Parameters:
author=aleksandar-hemon
author_number=1557
Debug Rendering Time: 73 ms