BookBrowse interviews This month we feature four book clubs, linked because one avid reader, and BookBrowse member, Judy Krueger is a member of all four! about all aspects of their book club.

Book Club Interview (see full list)

This month we feature four book clubs, linked because one avid reader, and BookBrowse member, Judy Krueger is a member of all four!

Added to which she also finds time to work as a bookseller, private tutor, freelance writer, singer/songwriter and reviewer for BookBrowse!

If you’ve ever wondered what sort of book club would be right for you – big or small, social versus book focused, in-home versus meeting in a public place etc., you’ll find much of interest in this month’s interview.

Hello Judy, firstly please tell us a little bit about each of the book clubs you belong to, and how you manage to find the time to fit them all in?

The first is Bookie Babes: We meet at a Barnes & Noble store in Burbank, CA on the 4th Wednesday of each month at 7:30 pm. The group is fairly small (only about 8 members are attending regularly) but we get along great and have a lot of fun. We are all women and range in age from 40 to late 70s. All but one of us has children and some have grandchildren. Our interests and careers vary widely. We have a motto which we stand by faithfully. “Take a chance on a book!”

We start each meeting with a thumbs up/ thumbs down/ thumbs somewhere in between vote. This group involves lots of laughter which begins right with the vote. Then we also know right away where everyone stands. Sylvia is our moderator for which she has an innate talent. She usually starts by asking someone why she voted as she did and then we are off. The discussion just flows smoothly with everyone getting to finish what they have to say before another begins talking. I always feel satisfied with the discussion and always have additional insights into the book.

Each month, in rotation, one of us brings a list of 8-10 suggestions of books to read, with blurbs and page numbers. We vote, each member getting two votes and the book with the most votes is the one we will read two months later. I also like knowing two months ahead what is coming up. The voting method makes sure that everyone gets a chance to recommend her preferred type of book. We have mystery lovers, one who likes heart warming love stories, a historical fiction fan and then there is me, who likes somewhat dark literary stuff.

The second group doesn't have a name, but we meet at an independent bookstore called Once Upon A Time, in Montrose, CA. The group has been in existence for over 20 years and I have been a member for 2 1/2 years. This month I started working as a bookseller at Once Upon A Time! We have a couple of men in this group who are husbands of members which I like for the different perspective this sometimes brings. The age range is even wider here; from 30s to 80s and attendance can be as high as 25 people or as low as 10. We meet on the second Tuesday of each month.

The bookstore owner is the moderator, but she doesn’t have to do much moderating because this group is very well behaved. We start with the person whose pick the book was and then go around the circle, each person having his or her say. It is OK to comment on what someone else says but it is understood that one person “has the floor.” We all come prepared to speak our piece; some even bring notes. I would say that this group has the highest average education and most are big readers and have been for all their lives. I am almost always enriched by the discussion.

Once every four months, we each bring suggestions (if we want to; not everyone does) and it is a show-and-tell. You actually bring the book or pick it off the shelf and tell a bit about it. We pass the books around, look them over and then vote. The top four books are the ones we read. If one chooses to buy all four books at a time the store gives us 20% off.

The third group also meets at an independent bookstore called Portrait of a Bookstore, in Toluca Lake, CA. Currently we are meeting on the fourth Monday of each month. The group has about 20 members who are the most intrepid readers of the four groups, but we have super chaotic discussions. In fact this group got so big that the leader (an employee at the store) decided to split it in two. The original group is taking no new members and anyone new goes into the new group.

These women are all professionals and we are mostly “post-menopausal”. We meet on the patio of the coffeehouse to which the store is attached and just dive in and discuss at a mad rate. Sometimes it is hard to get heard, sometimes it gets heated and too often it gets snarky. I would call this the quintessential LA reading group.

Back in the summer of 2006, we went to a new method of selecting books. Everyone brought suggestions which we winnowed down to 12 and thus created a reading list for the whole year. I have thought of giving up this group several times because the discussions are so frustrating, but I stay because overall we read the most challenging books and many members make thought provoking observations.

The last group is The No Name Book Group: This is an offshoot of the group from Portrait of a Bookstore, started by one of the members when she became frustrated by the size and conduct of the Portrait Group. We have only been going for a few months. We meet on the third Thursday of each month at a sandwich/coffee/dessert restaurant, in Studio City, CA, eat and discuss. We are still finding our common ground on how to choose books, etc. We have about eight members, some of whom also came from the Portrait group. The leader is my best book friend. Most of the members are well read and again the discussions are high on thoughtfulness and intelligence.

We all keep in touch by email, but one aspect that bothers me is that if we choose a book and then some members don’t like it right off the bat, the selection gets changed mid-month. That doesn’t affect my ability to get the book read in time; it just violates my sense of order.


What would you say is the special characteristic of each club that keeps you attending all of them?

Bookie Babes is fun. Even if I have had a terrible day, I feel exhilarated and happy after our meetings. Some of the books we read I consider to be too light weight but I think most of the other members think my picks are weird.

The group at Once Upon A Time has the most satisfying discussions because of the orderly way in which the meeting flows. I also like the big age range, that we occasionally have men there and the fact that several members are up on history. We read mostly fiction, some memoirs and also some classics. This month we are reading Sister Carrie by Theodore Dreiser.

As I mentioned above, I stay with the group at Portrait of a Bookstore because of the willingness of the group to read challenging books. Again the range is from literary fiction to memoirs to classics. Except for last month when we read The Memory Keeper’s Daughter, which we all felt was badly written and over-hyped, we read good books. Coming up are Love in the Time of Cholera by Gabriel Garcia Marquez, A Tale of Love and Darkness by Amos Oz and Middlemarch by George Elliot.

The No Name group I stay with because the leader is my friend and because it is the only group I helped create. So it is an experiment and we try different things that some of us have picked up from reading about how to have a successful reading group. For instance, someone always starts the discussion by reading the first page of the book aloud, which effectively puts us all right into the book and ties up the end with the beginning. It gets our minds working and focused. We have read Angle of Repose by Wallace Stegner which we all loved and yet it prompted the longest and best discussion. On Beauty, by Zadie Smith is one that got rejected mid-stream as did History of Love by Nicole Krauss. These women are picky and they know what they like.

I can’t say that I have a favorite. Each group pleases me in a different way. Many people think that I am amazing because I read so much. I don’t feel amazing; I wish I could read more. I just don’t ever watch TV, I only read magazines that have to do with books and every moment that I am not at work, doing housework or other “duties”, I am reading. My dream is to make a living from reading books because I love to read better than anything else, but when I look at all the great books I have not read yet, I feel woefully ignorant. In fact, the reason I joined all these book groups is that I desperately needed people to talk to about books.


All your groups meet in public places. Do you think there are benefits of meeting publicly rather than in someone’s home?

The main reason that all these groups meet in public places is that most of the members work and have very busy lives, so no one wants to bother with having her house clean and providing food or beverages. From my experience of being in book groups for the past three years or so, keeping the conversation focused is the most challenging aspect of all. Let’s face it, women love to talk about anything. Personally, I am happy that the main subject is a book rather than children, illnesses, or TV shows.


Can you tell us what books have generated the best discussions? Have you discussed the same book in more than one group? If so it would be interesting to know how these discussions varied to understand how much a particular book “makes” the discussion and how much is the group itself.

Yes, I have discussed the same book in more than one group, which is an interesting study of the personality of the different groups. Examples are The Kite Runner, The Birth of Venus, The Curious Incident of the Dog in the Nighttime, The Known World, The Devil and the White City, The Memory Keeper’s Daughter, Gonzalez and Daughter Trucking Company by Maria Amparo Escandon by Maria Amparo Escandon and Snow Flower and the Secret Fan.

A good instance of a book bringing out the personality of a group would be The Curious Incident of the Dog in the Nighttime. In the Portrait group the discussion centered on aspects of autism and Asperger syndrome. In the Once Upon A Time group, we talked mostly about parenting and how the boy’s mother and father each influenced his development and actions. In Bookie Babes we were astounded by how cool that kid was and how much we loved him and could anyone figure out those math problems he put in there. I leave your readers to make what they will of these different reactions. I love the way an author sends a book out into the world and causes so many different reactions and interpretations in readers.


In a previous book club chat, Jane commented that she saw a difference between people’s favorite books and those that made for the best discussions. Do you think people have to “like” a book to have a good discussion?


I think most members of book groups can recall meetings when everyone loved the book but after fifteen minutes there was nothing left to say. However, I have found that liking or disliking the book is not the factor that makes a good discussion. It is the book itself.

In the Once Upon A Time group we read a book called Funny in Farsi by Firoozeh Dumas. It was almost unanimous that the book was badly written and definitely not funny, but we had a long and satisfying discussion about the experiences of immigrants in the 21st century, comparing this book to the part of The Kite Runner when the main character came to America, etc.

On the other hand, we all loved Lost Horizon by James Hilton as well as The Distant Land of My Father by Bo Caldwell yet went on discussing it way past our bedtimes. Then again, in Bookie Babes, we read Novel by George Singleton (one of my “weird” suggestions). Three fourths of the group really hated it and the discussion was a quick expression of all the ways they hated it and then over.

The bottom line is that it's sometimes hard to tell about a book, even after reading blurbs, reviews and listening to others’ recommendations. I don’t find reading any book a waste of time (well, maybe Danielle Steele books) and I love our motto in Bookie Babes: “Take a chance on a book.”


Could you give us a short list of books that have generated the most interesting discussions?

The Patron Saint of Liars by Ann Patchett
Extremely Loud and Incredibly Close by Jonathan Safran Foer
The Red and the Black by Stendahl
The Way the Crow Flies by Ann-Marie MacDonald
Their Eyes Were Watching God by Zora Neale Hurston


Are there any books that bombed? If so, why do you think they did?

Aside from Novel, the biggest bomb I recall was Quite a Year For Plums by Bailey White which we read in Bookie Babes. None of us liked the book because aside from some quirky characters, it was boring to read and had no plot. There was just nothing to discuss.

In the Once Upon A Time group one month we read both The Jane Austen Book Club by Karen Joy Fowler and Northanger Abbey by Jane Austen. We were very proud of ourselves for reading two books in one month! But it was a good thing we did, because The Jane Austen Book Club was dull and predictable and would have bombed if we hadn’t had Northanger Abbey to discuss.


Lastly, based on your wide ranging experience, can you tell us the magic formula for a successful book club?

Magic formula for success, hmm. Well I would say that all the members must like to read and should commit to finishing the book in time for the meeting. If because of some uncontrollable circumstance a member does not finish the book, she should not ask the others to keep from giving away the ending (that really annoys me!)

Those are the two top ingredients for success but in my “ideal” book group, everyone would get a chance to speak without being interrupted and that has a lot to do with the leader or moderator of the discussion. The best way of choosing books is the method we use in Bookie Babes, where each month, in rotation, a member brings a list of 8-10 suggestions with short reviews and page numbers. Then we vote and read the book no matter what because, after all, we voted for it.

Someday I would like to have a group where we picked an author and read her entire oeuvre from oldest to most recent. Some authors I would suggest would be Margaret Atwood, Toni Morrison, Simone de Beauvoir, A S Byatt, T C Boyle, Ursula Le Guin, John Steinbeck and Cormac McCarthy. I imagine this would be a very special group of readers who read for more than pleasure.

Having an author at a book group discussion is a unique kind of fun. I have experienced this three times and we all loved hearing about how the author came to write the book, some of her experiences as a writer, etc. In various groups we have had Los Angeles based mystery writer Denise Hamilton; Maria Amparo Escandon, author of Gonzales & Daughter Trucking Co; and a local self-published mystery writer who is also a friend of mine, Alice Zogg. Of course, you don’t get to slam the book with the author there, although Alice Zogg came under fire for killing off one of our favorite characters!

Sometimes members have brought special food or drinks to go with a book. When we read Devil in the White City, a member brought an etched glass bought by someone in her family at the Chicago World’s Fair. I think these things work best when they happen spontaneously.

For me, what matters is the book, the reading and the discussion. If that is happening, I am happy. Then the meeting becomes a time to share insights, new information and ideas about life. Reading fiction is a rather sacred activity to me and vital to becoming and remaining involved in society and the world. I find more truth in fiction than I do in the news and I feel strongly that it is a sort of last bastion of freedom in increasingly oppressive political and economic times. So people who read books and get together to discuss them are not revolutionary perhaps, but evolutionary for sure. If some people do not find that activity enjoyable, then it could be that they need to find another activity.


Thank you Judy, you've certainly given us a lot to think about!
This interview was first featured in 2007--->

© BookBrowse.com March 2007.

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

If every country had to write a book about elephants...

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:19 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
1780287553236 ms 1.78028755324E+012 ms 1 /root/website/app_server.cfm
315 ms 315 ms 1 /root/website/featured-bookclubs/archives/index.cfm
158 ms 158 ms 1 /root/website/app_layout.cfm
121 ms 121 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
117 ms 117 ms 1 /root/website/app_globals.cfm
61 ms 31 ms 2 /root/website/adsystem/adsystem_mod.cfm
46 ms 46 ms 1 /root/website/adzones/AdZone6.cfm
43 ms 43 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_active_obc.cfm
27 ms 27 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_current_competition.cfm
23 ms 23 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
16 ms 16 ms 1 /root/website/featured-bookclubs/archives/dsp_bookclub.cfm
16 ms 16 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
16 ms 16 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
15 ms 15 ms 1 /root/website/adzones/showcase_track.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
14 ms 14 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_member_info.cfm
8 ms 3 ms 3 /root/website/actions/act_spider_tracker.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.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/main_menu.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_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_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
315 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 04:19:13.013
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=8ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 04:19:13.013
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=13ms, Records=2) in /root/website/actions/adstatus.cfm @ 04:19:13.013
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:19:13.013
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=14ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 04:19:13.013
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=16ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:19:13.013
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:19:13.013
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:19:13.013
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=7ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 04:19:13.013
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=22ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 04:19:13.013
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=7ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 04:19:13.013
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=22ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 04:19:13.013
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) = 3

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:19:13.013
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=25ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:19:13.013
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=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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=25ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 04:19:13.013
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 @ 04:19:13.013
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:19:13.013
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; 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%3D4085581%26CFTOKEN%23%3D6efc7d6cf7f31135%2D0E0EBFCB%2DFC91%2DA983%2D5CCC21A336FA1A31%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2004%3A19%3A12%27%7D%23hitcount%3D122%23timecreated%3D%7Bts%20%272026%2D06%2D01%2004%3A18%3A48%27%7D%23cftoken%3D7f44f680374d25a1%2D0E0EBAFC%2DBCC0%2D0912%2DD76459333EF60C88%23cfid%3D4085580%23; CFTOKEN=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31; CFID=4085581
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/3
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=4085580
cftoken=7f44f680374d25a1-0E0EBAFC-BCC0-0912-D76459333EF60C88
hitcount=123
lastvisit={ts '2026-06-01 04:19:13'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 04:18:48'}
urltoken=CFID=4085581&CFTOKEN=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31
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#=4085581&CFTOKEN#=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31#lastvisit={ts '2026-06-01 04:19:12'}#hitcount=122#timecreated={ts '2026-06-01 04:18:48'}#cftoken=7f44f680374d25a1-0E0EBAFC-BCC0-0912-D76459333EF60C88#cfid=4085580#
CFID=4085581
CFTOKEN=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31
FREEACCESSCOUNT=0
Session Variables:
cfid=4085581
cftoken=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31
sessionid=BOOKBROWSE_4085581_6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31
urltoken=CFID=4085581&CFTOKEN=6efc7d6cf7f31135-0E0EBFCB-FC91-A983-5CCC21A336FA1A31
URL Parameters:
bookclub_number=3
Debug Rendering Time: 21 ms