BookBrowse interviews The Bookies about all aspects of their book club.

Book Club Interview (see full list)

The Bookies

Joan Kingsley tells us about The Bookies, a book club she formed at the First Presbyterian Church of Oyster Bay in Long Island, New York. The group welcomes anyone to participate and enhances their wide variety of book choices with food. Elisabeth Cook interviews Joan:

Hi, Joan! So, you started The Bookies at your church back in 1998. Can you tell me how the idea for the club came about?

It was such a long time ago that I’m not sure I can remember! It just came to me that a book club would be a great idea for the church and might encourage more people to come. At any rate, I just came up with the thought and talked to my friends Jane Byrd McCurdy and Carol Johnston about it. They thought it was a possibility. I decided that we should start a club, whether it succeeded or not. When I came up with the name The Bookies I knew it would work. I loved it because it was a double entendre.

The Bookies It’s a great name. How did you let people know about the group?

We made an announcement in church and quite a few women came through and have been with us since. There were no men, though I wanted it to be all-inclusive, men and women. I also wanted people to come whether they read the book or not, whether they read part of it or none of it. They were and are all welcome. The reason is because we discuss not only the nature of the book but the concept and ideas from the book. You don’t have to read the book itself to talk about issues beyond it.

That sounds like a very comfortable and welcoming way of running a book club. How did people like the first books and meetings?

Mostly they loved the book choices, and if they didn’t that was okay and was part of the discussion. No one was ever forced to participate, but almost everyone did whether they read the book or not. The discussions were always open to all and everyone jumped in. I think that everyone appreciated that they could come to The Bookies no matter what. It was a real team and we all loved the meetings, especially when we added the food which I think was right away.

That’s right, you mentioned that the club has always had food related to the books, at least during in-person meetings. Can you tell me a little about that?

Joan with Three Cups of Tea dessert We always have had the food of the book. Believe it or not, when we read Babette’s Feast we made the meal from the book and had 25 people for dinner. There was no live turtle, however. Depending on the book, we invite people to join us. When we read a book about the Holocaust we invited a Jewish temple to join us in the discussion. We had over 100 people and kosher food. Normally we only have 10 to 12 people, more or less. We read a book on the jungle and had insects for dinner. Yum! When we read Three Cups of Tea, we went to a restaurant that had the food of the book, and the owner made us the dessert with "three cups of tea" (see photo).

Another special feature of your club is that you alternate between fiction and nonfiction. What is it that you like about this approach?

Three Cups of Tea by Greg Mortenson and David O. Relin cover One of the major ideas is to pick books that are not only interesting and different but also give us lots to think about. Changing from fiction to nonfiction to historical fiction is always a challenge. We do this for the love of reading and to stretch our minds with new ideas and concepts. Through variety, we see and learn about different approaches to stories and history. With every book, we grow a little more. We have read everything from great classics, to history, to math and science. What we love about this approach is that it opens the world and the universe to us. It is so interesting to have the variety even if a book is not your first or favorite choice.

I can see how that would be really interesting, especially over a longer period of time.

Just two books ago, we read Neil deGrasse Tyson’s Astrophysics for People in a Hurry. We learned about the nature of space and time. And, more importantly, we learned about our place in the universe. It was fun even though many had not read it. We had a great discussion. I couldn’t resist picking that book.

What is it like having a club that’s part of a church community?

It is great being part of the church community but it doesn’t leave out people who don’t come to the church. Everyone is invited and friends often come. Not as much as I would like, but they do come and stay as part of the group. No one is ever left out. At least, I hope not.

How does a typical club meeting go?

We put our food in the kitchen and then go to the little conference meeting room. There is small talk, then we get down to business. Discuss the book and then have dessert. At which time we discuss the next book.

How do you go about choosing books for your club?

We all decide on the book together. It has to be either fiction, nonfiction or historical fiction. Just not comics… though I am wavering on that.

What are some of the books your group has enjoyed the most over the years?

We enjoyed most of the books. Even if it was a book that we didn’t particularly care for, we still enjoyed the discussion and analysis and, of course, the food of the book. That’s why Babette’s Feast was such a hit. We all enjoyed the analysis and discussions and debates. We never knew what anyone was going to say and that made it a very interesting meeting.

You mentioned that you sometimes bring in authors or guest speakers. Who have some of your favorites been?

The Bookies with Talia Carner We have had a couple of authors of the book we were reading, including Talia Carner for Jerusalem Maiden. One of the books we read had to do with the Amazon jungle and we had an expert come and discuss it with us. She was even named in the book. I so appreciated all who gave their time to our club. In recent years I have not had so many people come. It has mostly been just us.

Speaking of that, how have you handled meetings during the pandemic? What changes have you made to your usual way of doing things?

Jerusalem Maiden by Talia Carner cover We made use of Zoom and it worked amazingly well. Unfortunately, there was no food. We had people who had moved away and because we were on Zoom they could join us. I am going to miss them if and when we go in person. I may try a mixture of Zoom and live. I have no idea how that will work out.

As someone who has started a book club that has lasted a long time, do you have any advice for others on how to be successful with their own groups? What do you think makes people want to keep coming back?

I’m not sure how to explain it exactly. I think that everyone who comes feels comfortable and that what they have to say matters. No one is left out. Everyone can express themselves without fear of mockery or worse. We have had many disagreements about the books’ ideas and the conversation was always interesting even if we didn’t agree. Also, we get to read so many different kinds of books that we might not otherwise read and it has broadened the way we see things. Finally, I think the food of the books ultimately brings us together.

Photos:
The Bookies
Joan with the book Three Cups of Tea and "three cups of tea" dessert
The Bookies' meeting for Jerusalem Maiden with author Talia Carner (back row, third from left)

© BookBrowse.com July 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...

Courage - a perfect sensibility of the measure of danger, and a mental willingness to endure it.

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 04:21 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
1780287690368 ms 1.78028769037E+012 ms 1 /root/website/app_server.cfm
675 ms 675 ms 1 /root/website/featured-bookclubs/archives/index.cfm
356 ms 356 ms 1 /root/website/app_layout.cfm
287 ms 287 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
252 ms 252 ms 1 /root/website/app_globals.cfm
143 ms 143 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
96 ms 48 ms 2 /root/website/adsystem/adsystem_mod.cfm
93 ms 93 ms 1 /root/website/queries/qry_get_active_obc.cfm
54 ms 54 ms 1 /root/website/adzones/AdZone6.cfm
46 ms 46 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
45 ms 45 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
45 ms 45 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
43 ms 43 ms 1 /root/website/adzones/showcase_track.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_current_competition.cfm
40 ms 40 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
32 ms 32 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
28 ms 28 ms 1 /root/website/act_check_login.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_member_info.cfm
25 ms 25 ms 1 /root/website/actions/adstatus.cfm
16 ms 16 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
13 ms 4 ms 3 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/head.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/featured-bookclubs/archives/dsp_bookclub.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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_previous_arcs_for_ad.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_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
5 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
680 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 04:21:30.030
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=26ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 04:21:30.030
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=24ms, Records=2) in /root/website/actions/adstatus.cfm @ 04:21:30.030
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 04:21:30.030
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=31ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 04:21:30.030
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=20ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:21:30.030
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=21ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:21:30.030
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 04:21:30.030
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=24ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 04:21:30.030
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=29ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 04:21:30.030
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=37ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 04:21:30.030
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=40ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 04:21:30.030
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) = 81

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

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

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

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

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

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

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

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

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

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

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

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

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

get_type (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:21:31.031
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=FREEACCESSCOUNT=0; CFID=4085645; 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%3D4085645%26CFTOKEN%23%3Dca272794048eab4a%2D0E20E8EF%2DB400%2D3304%2DDA3CE58CFC6257F5%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2004%3A21%3A30%27%7D%23hitcount%3D221%23timecreated%3D%7Bts%20%272026%2D06%2D01%2004%3A20%3A47%27%7D%23cftoken%3Dca272794048eab4a%2D0E20E8EF%2DB400%2D3304%2DDA3CE58CFC6257F5%23cfid%3D4085645%23; CFTOKEN=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
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/81
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=4085645
cftoken=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
hitcount=222
lastvisit={ts '2026-06-01 04:21:30'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 04:20:47'}
urltoken=CFID=4085645&CFTOKEN=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
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#=4085645&CFTOKEN#=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5#lastvisit={ts '2026-06-01 04:21:30'}#hitcount=221#timecreated={ts '2026-06-01 04:20:47'}#cftoken=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5#cfid=4085645#
CFID=4085645
CFTOKEN=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
FREEACCESSCOUNT=0
Session Variables:
cfid=4085645
cftoken=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
sessionid=BOOKBROWSE_4085645_ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
urltoken=CFID=4085645&CFTOKEN=ca272794048eab4a-0E20E8EF-B400-3304-DA3CE58CFC6257F5
URL Parameters:
bookclub_number=81
Debug Rendering Time: 34 ms