Charlie Lovett Interview, plus links to author biography, book summaries, excerpts and reviews

Charlie Lovett

Charlie Lovett

An interview with Charlie Lovett

Charlie Lovett discusses his debut novel, The Bookman's Tale, and its roots in Shakespeare and the sometimes exclusive world of antiquarian booksellers.

Are Ridgefield University and its incredible library based upon a real institution?
Ridgefield is an amalgam of several North Carolina institutions—Wake Forest University, where my father taught English for forty years and where I spent many happy hours in the library as a child; Davidson College, where I received my B.A. in 1984; and Duke University, which several of my family members attended. The Devereaux Collection is fictional, but there are certainly many American institutions that have fine collections of rare books. Among those that I have visited most frequently and which helped inspire both the Devereaux Collection and the Devereux Room are Princeton University, Harvard University, New York University, Emory University, and the New York Public Library.

You are an avid book collector and former antiquarian bookseller. Can you discuss how you became interested in both and pursued them?
My father is a book collector, and in the 1970s he began collecting editions of Robinson Crusoe. This turns out to be a great book to collect, since it has been in print constantly for nearly three hundred years. As a teenager, I would often look for copies in secondhand bookshops. In college I began to collect for myself, focusing on editions of Alice's Adventures in Wonderland. This was the beginning of a collection that now covers all aspects of Lewis Carroll and his world. I chose Alice because I was inspired by my father to collect a single title and because, as a child, on rainy days I had listened to old records of Cyril Ritchard reading the Alice books. I got my first job out of college working for an antiquarian bookseller and my first wife and I soon decided to go into business for ourselves. Because of our interest in Lewis Carroll, one of our specialties was antiquarian children's books. I was active in the antiquarian book business for about a decade and traveled widely in England and the United States to visit dealers, go to book fairs, and make purchases from estates and individuals. Like Peter, I spent time in Hay-on-Wye, and took driving trips through New England. Though I am no longer an active dealer, I have continued to collect, and remain active in Lewis Carroll Societies in both North America and England. My favorite thing about both book collecting and bookselling has been the wonderful people to whom those pursuits have introduced me all around the world.

Do most antiquarian booksellers also repair their finds or is restoration usually a separate profession?
There are certainly some people who do both, but I'd say it's more usual that some dealers dabble in restoration and some restorers dabble in dealing. I wanted to introduce my readers, through Peter, to as many aspects of the world of rare books as I could.

What was your most incredible find? Do you yourself, like Peter, seek a particular grail?
As a dealer I'd say my greatest find came when I was called out to appraise some books for an estate. When I arrived, I found a house that was little more than a shack in the woods, and I figured the trip was a waste of time. But inside the house were about six thousand volumes, including hundreds of first editions of modern literature, all in superb condition in their original dust jackets. The man who had owned this collection hadn't ever done business with a rare book dealer; he had simply bought all these books when they were brand-new and kept them in perfect condition. I ended up buying most of the books for my business. At one point, I was on the verge of tossing a couple of paperbacks into the twenty-five cent box, when I decided to give them a closer look. They turned out to be the two-volume first edition of Vladimir Nabokov's Lolita. I sold them with a single phone call to another dealer, and the next month saw them catalogued for $3,000. As a collector I've made many finds. While the rarest books (like the true first edition of Alice's Adventures in Wonderland that I obtained in 1986—one of five privately owned copies) usually show up at auction, my favorite acquisitions have some sort of story behind them. Looking over my books is like looking through a scrapbook of friends, colleagues, travels, and adventures. My favorite recent acquisition was Lewis Carroll's actual typewriter. He loved gadgets of all kinds, and this was a special favorite of his. And it still works! As far as what grail I seek—it's a question we book collectors ask one another often, a way to get a window into someone else's collecting. For myself, the holy grail of Lewis Carroll collecting would have to be the four volumes of his personal diary that went missing back in the 1930s. Of course, if they were ever discovered, they would belong to his family, but that would be a thrill to pull the top off a box and find those lost volumes with that familiar handwriting. You could write a novel about something like that.

What do you think Shakespeare would have thought about all the controversy surrounding his plays' authorship?
It's hard to say. Though W. H. Smith exaggerates the case in his work on Shakespeare quoted in The Bookman's Tale, it is true that we don't know much about Shakespeare. And outside the plays themselves, what we know is mostly factual. We don't know what his personality was like. This is great if you happen to be writing a novel in which Shakespeare appears as a character. I could make him whatever sort of person I wanted. But it also means it's hard to guess how he would feel about a particular situation. I like to think that he would be amused by the authorship controversy and amazed that people still care about his plays four hundred years later.

Did you create the character of Bartholomew Harbottle—the supposed inspiration for Autolycus—after watching or reading Shakespeare's A Winter's Tale?
Early on in the process of making notes about what became The Bookman's Tale, I hit upon the idea of having three booksellers in three different time periods. While Benjamin Mayhew (the Victorian bookseller) became a less central character in his story line than Bartholomew Harbottle and Peter Byerly, I kept that idea. I also thought it would be interesting if they were each dishonest in some way. Ultimately, Peter didn't have this particular character flaw, but I loved that Bartholomew Harbottle was a bit of a rogue. I wanted the Shakespearean artifact Peter discovered to be something both believable and unusual —a lost play seemed too easy. I liked the idea of an annotated source for one of Shakespeare's plays and ultimately chose Pandosto because it fit all my criteria: written by an Elizabethan, not generally known to modern readers, and exceptionally rare in its original printing. I had seen a wonderful production of A Winter's Tale at the Globe Theatre in London in 1997 in which Autolycus entered from the audience wearing a trench coat, holding a brown bag with a bottle in it. As the novel developed it struck me that Harbottle was like Autolycus in many ways, so it seemed a great connection to make.

Is it true that the Grolier Club didn't admit female members until sometime in the 1970s? Is there a real Hroswitha Club and was it founded as a response to the Grolier Club's ban on women?
I'm proud to be a member of the Grolier Club, however, it is true that women were not admitted until 1976. While Amanda Devereaux is fictional, many of the collectors and dealers she encounters, like Henry Clay Folger and A.S.W. Rosenbach, were real people in an age when book-collecting was largely male dominated. The Hroswitha Club of women book collectors was founded in New York in 1944 and while it may not have been in direct response to the Grolier Club's "boys only" policy of the time, it seems likely that, had the Grolier Club accepted women, there would have been less demand for a club such as Hroswitha. The archives of the Hroswitha Club are now held in the Grolier Club library.

You include some pretty serious crimes in The Bookman's Tale, including murder. Is the world of antiquarian books as sensational as your novel makes it seem?
Most of the time, no. Some of the nicest people I've ever met have been my fellow book collectors, librarians, and dealers. However, there are certainly plenty of examples of criminals in the world of rare books. One reason I wanted to include the true stories of the forger Thomas Wise and the forger and murderer Mark Hoffman was to show that putting danger and criminal activity into the world of rare books was not out of keeping with reality.

In addition to The Bookman's Tale, you are also the author of numerous plays and books of nonfiction as well as books for children. What inspired you to write your first novel for adults?
I had always been interested in writing fiction and in 1997 earned my MFA in creative writing. The genesis of The Bookman's Tale came in 2005 I was walking alone in the Yorkshire countryside on a chilly day. I had just finished devouring the latest Harry Potter book and I was thinking about what I might like to write next when I hit on the idea of a hiding a secret in an old family chapel. I think this idea must have come from recalling a previous trip to the north of England during which some friends had taken me to see a tomb in just such a chapel. Like Evenlode House, the house near the chapel had fallen into disrepair and the residents lived in trailers in the garden. When I returned from my walk, I began to make notes and ended up with several pages of ideas about a Victorian English painter and a modern day American expatriate bookseller. With the exception of those two characters and the settings of the falling down house and hidden chapel, almost nothing of my original notes made it into the novel. In fact, it was two years later before I started working on the book in earnest. During the same time that I was working on revising the early drafts of the novel, my wife and I bought and renovated a cottage in Oxfordshire village of Kingham—the same cottage we had lived in for six months ten years earlier. With a few modifications, our cottage became Peter's cottage, and my own familiarity with rare books and the English countryside helped me create the world of the novel.

Who are some of your literary influences?
There are so many—Jane Austen and Charles Dickens for the way they draw characters, John Irving for his masterful storytelling, P. G. Wodehouse, David Lodge, and Tom Sharpe for their senses of humor, and of course A. S. Byatt for the way she can weave together literary history and contemporary fiction in books like Possession and The Children's Book.

Several of your nonfiction books are about Lewis Carroll and Peter contemplates his original drawings in The Bookman's Tale. Do you feel a particular affinity to the creator of Alice in Wonderland?
I came to Lewis Carroll first as a book collector, having no idea about the man himself. Over the years I've discovered that not only was he a fascinating figure, but he lived in a fascinating time. I feel an affinity to him not because of similarities in our characters, but simply because I feel I know him so well after years of researching him and his times. The biggest thing my interest in Carroll has taught me is the importance of having a passion. It doesn't really matter what that passion is—mine happens to be Lewis Carroll—but if you have one your life will be so much richer. Because of Carroll I have traveled to amazing places, met wonderful people, read great books, and explored a whole world of books and book collectors that ultimately led me to create The Bookman's Tale.

What are you working on now?
I'm working on the follow-up book (not a sequel exactly) to The Bookman's Tale. This is a novel (working title First Impressions) about a lost Jane Austen artifact which could rewrite the history of the English novel. The protagonist is a young woman, but that's about all I can say right now.

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 Charlie Lovett at BookBrowse
The Bookman's Tale 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 Charlie Lovett 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

We recommend 8 similar authors

View all 8 Read-Alikes

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

It is among the commonplaces of education that we often first cut off the living root and then try to replace its ...

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 01:51 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
1780321868929 ms 1.78032186893E+012 ms 1 /root/website/app_server.cfm
1370 ms 1370 ms 1 /root/website/author_interviews/full/index.cfm
580 ms 580 ms 1 /root/website/author_interviews/full/dsp_main.cfm
334 ms 167 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
310 ms 310 ms 1 /root/website/app_globals.cfm
247 ms 82 ms 3 /root/website/adsystem/adsystem_mod.cfm
230 ms 230 ms 1 /root/website/app_layout.cfm
147 ms 147 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
140 ms 140 ms 1 /root/website/queries/qry_get_active_obc.cfm
138 ms 138 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
123 ms 123 ms 1 /root/website/adzones/AdZone2.cfm
92 ms 31 ms 3 /root/website/queries/qry_get_member_account_types.cfm
92 ms 31 ms 3 /root/website/site/blocks/membership_advantages.cfm
69 ms 69 ms 1 /root/website/adzones/AdZone6.cfm
59 ms 59 ms 1 /root/website/queries/qry_get_current_competition.cfm
59 ms 59 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
58 ms 58 ms 1 /root/website/adzones/showcase_track.cfm
50 ms 50 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
49 ms 49 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
39 ms 39 ms 1 /root/website/act_check_login.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_member_info.cfm
36 ms 36 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
22 ms 22 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
19 ms 5 ms 4 /root/website/actions/act_spider_tracker.cfm
18 ms 18 ms 1 /root/website/actions/adstatus.cfm
16 ms 16 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
8 ms 8 ms 1 /root/website/site/blocks/layout/dsp_header.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_top_author_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/queries/qry_get_current_ezine.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_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
1371 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:51:08.008
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

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

adactive (Datasource=bookbrowse_com_new, Time=18ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:51:09.009
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 @ 13:51:09.009
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=27ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:51:09.009
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=34ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:51:09.009
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=23ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:51:09.009
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

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

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

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

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

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=27ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:51:09.009
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=42ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:51:09.009
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=73ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:51:09.009
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) = 2326

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=73ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:51:09.009
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) = 2326

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=25ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 13:51:09.009
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) = 2326
Parameter #2(CF_SQL_INTEGER) = 2326

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=34ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 13:51:09.009
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) = 2326

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=39ms, Records=8) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 13:51:09.009
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) = 2326

get_ads (Datasource=bookbrowse_com_new, Time=29ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:09.009
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=91ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:09.009
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=42ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:51:09.009
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=12ms, Records=1) in /root/website/actions/udfs.cfm @ 13:51:09.009
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) = 2903

get_member_account_types (Datasource=bookbrowse_com_new, Time=42ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:51:09.009
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=173ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:51:09.009
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) = 1587
Parameter #2(CF_SQL_INTEGER) = 1587
Parameter #3(CF_SQL_INTEGER) = 1587

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:51:09.009
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) = 1587

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=104ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:51:10.010
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) = 1018
Parameter #2(CF_SQL_INTEGER) = 1018
Parameter #3(CF_SQL_INTEGER) = 1018

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=35ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:51:10.010
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) = 1018

get_member_account_types (Datasource=bookbrowse_com_new, Time=5ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:51:10.010
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=27ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:51:10.010
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=21ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:51:10.010
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=48ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:51:10.010
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=21ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 13:51:10.010
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:51:10.010
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/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=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4102523%26CFTOKEN%23%3Dd577525e9351fdfb%2D228404D7%2DE0F8%2D7FE3%2D360E953BF0167DEB%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A51%3A08%27%7D%23hitcount%3D46%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A50%3A51%27%7D%23cftoken%3Dd577525e9351fdfb%2D228404D7%2DE0F8%2D7FE3%2D360E953BF0167DEB%23cfid%3D4102523%23; CFID=4102523; CFTOKEN=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB; 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/2326/author/charlie-lovett
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=4102523
cftoken=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
hitcount=52
lastvisit={ts '2026-06-01 13:51:09'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:50:51'}
urltoken=CFID=4102523&CFTOKEN=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
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#=4102523&CFTOKEN#=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB#lastvisit={ts '2026-06-01 13:51:08'}#hitcount=46#timecreated={ts '2026-06-01 13:50:51'}#cftoken=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB#cfid=4102523#
CFID=4102523
CFTOKEN=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
FREEACCESSCOUNT=0
Session Variables:
cfid=4102523
cftoken=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
sessionid=BOOKBROWSE_4102523_d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
urltoken=CFID=4102523&CFTOKEN=d577525e9351fdfb-228404D7-E0F8-7FE3-360E953BF0167DEB
URL Parameters:
author=charlie-lovett
author_number=2326
Debug Rendering Time: 22 ms