BookBrowse interviews The Recycle Book Club about all aspects of their book club.

Book Club Interview (see full list)

The Recycle Book Club

Lloyd Russell has been the leader of the Recycle Book Club in Campbell, California since 2014. They not only read and discuss books, but also always have the authors of those books come to their meetings. BookBrowse first talked with Lloyd in 2017, and then followed up in 2021 to find out what the group has been up to and how they responded to the pandemic.


2017

Hi Lloyd! Please tell us a bit about your book group.

We are the Recycle Book Club – or RBC. We meet at Recycle Bookstore in Campbell, CA. We have about 125 people on our email list.

Wow, that's a huge number!

The Recycle Book ClubWell, we average about 12-18 members per meeting. We usually meet once a month – with a couple of exceptions – and it’s normally on the 3rd of 4th Wednesday night, also with some exceptions.

What age range are your members?

They tend to skew toward the baby boomer generation, with a few millenials and tweeners thrown in for some balance.

What is the most unique thing about the Recycle Book Club?

We definitely do something that most other groups don’t do. We have the author of the book we have read come to the meeting to answer our questions and sign books.

Wow again! That is definitely special! You always do this?

Yes, this is a given. We don’t do it by Skype or phone – we tried it once and didn’t like it.

But you're able to find enough authors who can come?
The number of excellent authors in the Bay Area is staggering. Many of them are nationally prominent, Queen Sugarsuch as Meg Waite Clayton, Cara Black, Keith Raffel, Marina Adair – she’s already had two of her books turned into movies on The Lifetime Channel, Ellen Sussman, Natalie Baszile – her book, Queen Sugar, is a series on the Oprah Winfrey Network, currently in the middle of Season 2), and Vanessa Diffenbaugh, to name just a few.

This is so cool.

Something else that differentiates us from most other book clubs is that we read a wide variety of genres – mystery, historical fiction, memoir, romance, young adult, contemporary fiction, women’s fiction (even though I’m not a fan of this nomenclature), young adult fantasy, dark fiction, paranormal, and legal murder mystery.

It sounds like there's no genre that's off limit for your group.

That is right. We even read romantic comedy!

How did the Recycle Book Club get started?

We started the book club in January of 2014 at Village House of Books in Los Gatos. (They have, unfortunately, recently gone out of business). We then moved it to Recycle Bookstore in September of 2014, and we’ve been there ever since. The amount of support we get from the store manager, Stacy, and her staff has been outstanding.

Can you tell us a little about your meetings?

We meet from 6:30-7:00. We each give a synopsis and a rating for the book on a scale of 1-4.

With the author there?

No, no! Then the author comes at 7:00, and we fire questions at her/him. There is no order or protocol, and everybody just gets to ask what they want. When we have exhausted all of our questions, the author sticks around to sign books for those who actually read print –

Ha! Good point.

There are still a few of us left! We are normally done by 8:00-8:15. Oh, and we don’t do food or beverages since we are inside of a bookstore. Plus, we’re not social. We don’t talk about personal stuff. We are just author/book-driven.

That's interesting. Can you tell us how you choose your books? We already know you choose from the widest possible array of genres!

How the books/authors are picked is really by a committee of one.

You?

Yes. This is a dictatorship, not a democracy! Having been a book blogger for over six and a half years, and having been to countless author events, I have come across many local authors. And I’m being introduced to new ones all the time. It’s just a matter of finding out which authors are interested in coming to the RBC, and determining if I think it’s a book that the members will like. Not every book has to be a 4/4, but I try to at least make sure it’s something that people can finish.

How do you do?

I'm successful most of the time. But I have definitely had a few duds along the way. Most importantly, our members are absolutely committed to reading different genres. Without exception, everybody likes reading books that they would otherwise never pick up or try.

Have you held any special events, or taken visits, or done different activities?

The Language of FlowersWe normally feel that having the author come to the meeting is special enough. We tried a book exchange earlier this year that was sparsely populated. It seems to have gathered momentum after the event itself. We might try it again, but I'm not sure. When we had Vanessa Diffenbaugh (The Language of Flowers), we had to move our meeting down the street to a coffee roasting cafe because of the number of people who attended.

How many came?

We had 45 people at the event! And in October 2017, we have an author coming from Marin County on a late Sunday afternoon. So we’re going to have dinner after and open it up to the entire membership.

Okay Lloyd. One more question for you. Do you have advice for other book club groups?

The only advice I have is this: If you are reading a book by an author in your area, you might want to check and see if that author wants to come to your book club meeting. Most authors are very happy to mix with their reading public, if their schedule permits.

Oh yes, I know this is true from first hand experience. Authors feel so grateful to the people who read their books. And they love to connect with them.

I can tell you it’s enormous fun to be able to get the backstory to a novel – How were you published? How long did it take to write your book? Where did you get your idea?, etc – directly from the author.

I agree. It's wonderful to learn about the behind-the-scenes details of an author's journey writing a book. And thank you Lloyd for sharing the behind-the-scenes of your book club!

Thank you!


2021

Hi Lloyd, so what have the Recycle Book Club been up to these past four years?

We've been growing in numbers over the years, we were at 125 in 2017 and we're now at 165, but the most dramatic shift has been transitioning from having all the authors coming to our book club in person to now having the authors Zooming in. And what the pandemic is doing is allowing us to have a whole host of very high profile authors including Kristin Harmel, Susan Meissner, Robert Dugoni, Barry Eisler, John Hart, Susan Wiggs, and Renee Rosen. Some of these are among my favorite authors, but they are all good.  

That's interesting as back in 2016, you said the group had tried Skype once but didn't like it, but of course Zoom is a different experience.

It is, in fact, a number of our new members now Zoom in from different parts of the country. This is probably a main reason why we won't ever go back to in-house meetings exclusively. We want to make sure that all of our members can continue to enjoy these authors and their back-stories. We are booked through the end of 2021 and already have three authors scheduled in the first four months of 2022. We continue to enjoy how gracious authors are toward book clubs.

It is interesting you say this, as we heard from many book clubbers when researching our "Book Clubs in Lockdown" report that one of the positives of meeting on Zoom was that it had opened up the possibilities of inviting authors much more easily than before; I've also heard from a number of authors who really like meeting with groups by Zoom as it is both more personal and easier than Skype or phone.

How many generally attend your Zoom meetings?

It varies from 10 or 11 to 30.  The average is probably 15-20.

Did you have teething problems getting people to use Zoom? And do your meetings follow broadly the same format as before?

We really haven't had any connection/getting on issues; nobody has said they have left the club because of tech issues. Our meetings on Zoom follow the same format as our in-person meetings did. We meet, just club members, 30 minutes before the author comes on, giving everybody time to rate the book and give their opinion. If there is any remaining time, I give updates and miscellaneous info.

Do you record the sessions for those who aren't on the live call? If so, how do people access them after the event?

We record each session and then send the link out to the entire RBC membership along with a couple of screen shots. All emails are sent bcc.

Are you still affiliated with the Recycle Bookstore?

I've actually been working there a few hours a week since last November. The store manager still brings in copies of each book because many of our members read print books, and some buy from Recycle so as to support the store.

You say you won’t ever go back to in-house exclusively. Now that you have a virtual element among your membership, how will you manage this?

I don't know when we will have in-store meetings again. But if we do, we will make sure that out-of-town members will have access. We'll cross that bridge when we get there; perhaps we'll set up a Zoom link so they can join the in-person discussion, if not, then I'll share the recording with all, as I do now.

Do you feel Zoom is equal, better or worse than meeting in person – or just different?

It definitely has pluses and minuses. Nothing matches getting to see the author in person because not only is it more personal, but people can also get their print books signed. On the other hand, being virtual not only gives members the opportunity to be involved, but it also allows us to bring in some very good authors from around the country. On balance, I would say that more people prefer Zoom than in-person.

Thank you Lloyd, it's been a pleasure to catch up with you and find out how the RBC has evolved.



The Recycle Book Club is open to new members. Interested readers can follow Lloyd's blog at booksage.blogspot.com and contact him at: lloydrrussell@gmail.com.

Photo shows a 2017 meeting of the Recycle Book Club: Judy, Renee, Tina, Mike, Susan, Killian McRae (author), Rich, Ann Bridges (author), Nancy, Val, Laurie, Joni, and Ann

2017 interview by Tamara Ellis Smith; 2021 update by BookBrowse publisher, Davina Morgan-Witts

© BookBrowse.com October 2021.

If you feel that your book group has something unique to offer, and you would like to tell others about it, please contact us with brief details, and maybe we can feature you in the future.

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

No pleasure is worth giving up for the sake of two more years in a geriatric home.

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 /featured-bookclubs/archives/index.cfm
Time Stamp 01-Jun-26 02:32 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
1780281125947 ms 1.78028112595E+012 ms 1 /root/website/app_server.cfm
149 ms 149 ms 1 top level /root/website/featured-bookclubs/archives/index.cfm
82 ms 82 ms 1 /root/website/app_layout.cfm
64 ms 64 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
53 ms 53 ms 1 /root/website/app_globals.cfm
41 ms 21 ms 2 /root/website/adsystem/adsystem_mod.cfm
33 ms 33 ms 1 /root/website/adzones/AdZone6.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_active_obc.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
12 ms 12 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
12 ms 12 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
10 ms 10 ms 1 /root/website/adzones/showcase_track.cfm
7 ms 7 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
4 ms 4 ms 1 /root/website/actions/adstatus.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_competition.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_ezine.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
1 ms 1 ms 1 /root/website/featured-bookclubs/archives/dsp_bookclub.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.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/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_bookclubs_links.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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
152 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 02:32:05.005
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=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:32:05.005
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=3ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:32:05.005
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 @ 02:32:05.005
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=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:32:05.005
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:05.005
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:05.005
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 @ 02:32:05.005
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=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:05.005
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=4ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:05.005
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=11ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:05.005
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_bookclub_by_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 02:32:06.006
select bookclub_number, bookclub_name, bookclub_title, bookclub_summary, bookclub_interview, bookclub_image, bookclub_entry_dt, bookclub_display_flag
	from bookclubs
	where bookclub_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 65

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:06.006
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=10ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:06.006
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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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=6ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:32:06.006
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 @ 02:32:06.006
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:06.006
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/featured-bookclubs/archives/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=
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=/bookclub_number/65
PATH_TRANSLATED=/root/website/featured-bookclubs/archives/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/featured-bookclubs/archives/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=4082279
cftoken=d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
hitcount=1
lastvisit={ts '2026-06-01 02:32:05'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 02:32:05'}
urltoken=CFID=4082279&CFTOKEN=d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
view=books
Cookie Variables:
CFID=4082279
CFTOKEN=d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
Session Variables:
cfid=4082279
cftoken=d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
sessionid=BOOKBROWSE_4082279_d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
urltoken=CFID=4082279&CFTOKEN=d9b13c3e5959c51c-0A3DBA8D-CA3F-D46F-433C7E87FCCD57AA
URL Parameters:
bookclub_number=65
Debug Rendering Time: 9 ms