BookBrowse interviews Rosemary Toland, one of the sixteen members of the San Antonio based book club Las Revistas, discusses how they've kept the discussion flowing over 25 years and more than 200 books! about all aspects of their book club.

Book Club Interview (see full list)

Rosemary Toland, one of the sixteen members of the San Antonio based book club Las Revistas, discusses how they've kept the discussion flowing over 25 years and more than 200 books!

Hello Rosemary, thanks for chatting with BookBrowse.  I understand that your book club has been together for twenty-five years.  That’s longer than many people reading this have been reading books at all!  Tell us, what first brought you together?

Our book club actually began in 1980 when Patty Horridge, who had belonged to two different book clubs, moved to San Antonio. She recruited four friends and asked each to invite two more friends. The group started with around 10 women, met once a month during the day, brought sack lunches and the hostess provided dessert. Because of San Antonio's rich Mexican culture, the group chose the name Las Revistas (meaning "the readers").


Standing at the corner of a historic hotel in Jefferson, TX, is (l. to r.) Barbara Anne Stephens, Judith Wood, Rosemary Toland, Tina Thomas (member-al-large from Placitas, NM), Patty Horridge, Suzan O’Connor, Nancy Lodes (member-at-large from Tyler, TX), and Rebecca Harrison.



Are any of the founding members still with the group?

Four of the original members still belong, including Patty. As the club grew, by-laws were drawn up and the membership was limited to 16 members. This was the number most felt they could comfortably accommodate in their homes.


Some of your members must have moved away from the area over the years, do you manage to stay in contact with them?

At the present time we have three members (or members-at-large) who have moved away but keep in close contact with the club. One of the women, who moved to New Mexico, formed a book club within months of relocating. Whenever one of our "members-at-large" is in town we make an effort for the whole club to get together.


Has the format of your meetings stayed the same through the years?

With kids grown and schedules starting to change, the group decided to move from day to evening meetings. A group of our husbands decided this would to the ideal time to hold "poker night", which they have done for many years.


Can you tell us a little about how your meetings are structured?

Our year runs from August to May with book selection night held in April. One book is always chosen with our husbands in mind as we have a combined meeting usually in February. In December we either have a Christmas or a New Year’s party which includes spouses (or guests). No book is reviewed during this month. At this time we also support a charity (donating books to a children’s organization, supporting our local library, providing teddy bears to the Children’s Bereavement Center, etc).


Having been together for so long you must have got selecting books down to a science.  Please can you tell us how you do this?

During book selection night each member is encouraged to bring a list of books she would like to see selected for the new year. If a member is unable to attend that night, she can still send a list of books to be considered. We take turns promoting our choices and everyone writes down the titles being suggested. Those present then vote for eight books by secret ballot. Often we have to hold run-offs. If a book is promoted by more than one member, it is almost always a “shoo-in”. Since we have members with very varied interests, we usually have a wide variety to select from. One member, a retired English teacher, pushes us to read at least one classic each year, which we try to do. We have also done plays, poetry and short stories.


How about other logistical matters, such as who leads the meetings and staying in touch outside of meetings?

At the April meeting we decide which book will be reviewed each month, who the leader will be and who will host the meeting in their home. Usually the person whose book is selected volunteers to be the discussion leader. That person is responsible for providing background info on the author in addition to reviewing the book. It is up to the reviewer to keep the discussion moving and provide any interesting info she has found through her research, such as reviews, interviews with the author, etc. During this meeting we also elect a president and treasurer for the new year. The president is responsible for sending out the new schedule to each members and reminding them monthly about the meeting or any changes. She does this by email.


Are there some books that stand out as favorites, and any that you recollect not being a success?

Of the 200 plus books the club has read, three come to mind that the members did not like. They are Neighbors by Thomas Berger, First Among Equals by Jeffery Archer and Fly Fishing through Mid-Life by Hal Raines.

The group does seem to have some favorite authors: Barbara Kingsolver (Animal Dreams, Bean Trees, Pigs in Heaven, Poisonwood Bible and Prodigal Summer), Margaret Atwood (Alias Grace, The Robber Bride and Oryx and Crate), Michael Dorris (Yellow Raft in Blue Water and Paper Trail) and Sandra Cisneros (House on Mango Street and Carmello).


How do you keep the discussions fresh year after year?  

Our group is not shy about jumping in with their impressions and "take" on a book. Many times someone will announce that they didn't like the book and didn't finish it, only to change their mind after our discussion and say they plan to go home and finish it.

Most of our reviewers go above and beyond just discussing the book. They look for different angles which will enhance the discussion. The year my husband and I were in charge of reviewing Lincoln by Gore Vidal for the joint meeting we looked for a way to keep the discussion interesting since many found the book dry. My husband put together a Powerpoint presentation with scenes from the Civil War to present America set to the background music of Elvis’ American Trilogy. I rented a civil war costume and recruited one of the husbands who stands over 6 feet to wear a tux and top hat. As the members and their husbands arrived, we greeted them as Lincoln and Mary Todd.

The couple who followed us the following year quickly announced not to expect to see them wear coon skin hats when they reviewed The Gates of the Alamo by Stephen Harrigan. Members have also worn costumes for roles in the play we were reviewing and when we read The Life of Pi by Yarn Martel, the reviewer enlightened us on the various meanings of "pi" and even performed a magic trick. Leaders have used charts, games, quizzes, etc. to enhance our meetings. And occasionally, we have been served food that follows the theme of the book.


Sounds fun!  How about guest speakers?

Over the years we have had several guest speakers attend our meetings. They have included John Phillip Santos (Places Left Unfinished at the Time of Creation), Becky Crouch Patterson (Hondo, My Father), Paulette Jiles (Enemy Women), and Bob Flynn (North to Yesterday).

The first book read this year was Suite Francaise by Irene Nemirovsky. The reviewer invited Hanna Davidson Pankowsky, author of East of the Storm: Outrunning the Holocaust in Russia, to be our guest speaker. None of us had read her book but we bought copies that evening, and discussed it at our last meeting. One of our members has become acquainted via email with Rita Golden Gelman (Tales of a Female Nomad). Gelman has expressed interest in attending one of our meetings, but has not made it to our part of Texas yet during her travels.  Although Cisneros (one of our favorite authors) lives in San Antonio, we have never been able to get her to attend one of our meetings.



Visiting with author John Phillip Santos (Places Left Unfinished at the Time of Creation) are (l. to r.) Suzanne Stewart, Barbara Higdon, Kay LePage and Lynnell Burkett.




Are there any events that stand out as being particularly memorable?

Over the years we have discovered that it is fun (and a great way to get to know each other better) to plan an outing or short trip visiting an area depicted in one of the books we have read. After reading True Women by Janice Woods Wendle, we spent a weekend in Seguin, Texas and toured the surrounding areas mentioned in the book. We were fortunate to be invited into the home of the author’s mother to view many of the items she has from her ancestors, including the table her father laid on while having his broken leg set. After reading Bel Canto by Ann Patchett, we visited Santa Fe, New Mexico, where we attended an opera.

Love is a Wild Assault
(Harriet Potter’s life story) by Elithe Hamilton Kirkland led to a trip to Jefferson, Texas. Highlights of the trip included attending a one-woman play on the life of Harriet Potter, touring Caddo Lake and visiting Potter’s point. We have also visited New York City (several members had children there aspiring to be actors) and this year made a trip to Rockport, TX to view the whooping cranes. Not all members are always able to go on each trip.

As a whole, our club is very close knit. We have weathered the illness and death of a charter member from cancer in 2001, the death of a member’s son, divorces, job losses, etc. Members have also provided meals for those recovering from surgery or a major illness.


Looking back over the years, are there particular themes, authors, or even books that you revisit? 

Almost all of our members have worked professionally at one time (some are still working) in the fields of education, business, architecture, journalism and real estate. Each of us has certain interests which are often reflected through our book recommendations. I feel that most of our members strive to select books that show good character development and have a compelling story.  Through Las Revistas I have been introduced to authors I would have probably never known. Because our members recommend so many good books each year, we have never reread any. Of course, this doesn’t include classics that many of us read while in school or college. For all the years I have been a member of Las Rivistas (I was not a charter member), the discussions have always been lively with most members participating.


A friend, who's been in the same book club for about a quarter century, shared with me recently that she thought the breadth of discussion has narrowed with the arrival of the internet, because people now tend to come to meetings having read reviews on the internet, and thus express a greater conformity of opinion. Do you think the wealth of online information helps or hinders good discussion?

Personally, I feel that the internet has made research much easier (especially for us who work) and has actually contributed to better informed discussions. Most of our members use the internet to become better informed if the subject of the book is centered on autism, Alzheimer’s, cloning, etc. As a result, one of the most thought provoking discussions we have had in recent years was triggered by reading Never Let Me Go by Kazuo Ishiguro, whose characters exist for one purpose---to have their organs harvested. A few of our members might read reviews, but the majority does not. Our discussions are centered on how each of us interprets the book and as one of our members so aptly stated, "we all read the same book, but hear differently based on our experiences". This to me sums up my main reason for belonging to a book club.


Thank you very much, Rosemary; I know I speak for all reading this when I wish you and Las Revistas many more happy years reading and talking together.

This interview first ran in July 2007

© BookBrowse.com October 2011.

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 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
1780281147213 ms 1.78028114721E+012 ms 1 /root/website/app_server.cfm
307 ms 307 ms 1 /root/website/featured-bookclubs/archives/index.cfm
135 ms 135 ms 1 /root/website/app_globals.cfm
128 ms 128 ms 1 /root/website/app_layout.cfm
84 ms 84 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
56 ms 56 ms 1 /root/website/queries/qry_get_active_obc.cfm
51 ms 26 ms 2 /root/website/adsystem/adsystem_mod.cfm
40 ms 40 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
37 ms 37 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
36 ms 36 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
27 ms 27 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
26 ms 26 ms 1 /root/website/adzones/AdZone6.cfm
26 ms 26 ms 1 /root/website/adzones/showcase_track.cfm
17 ms 17 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_current_competition.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
10 ms 10 ms 1 /root/website/act_check_login.cfm
10 ms 10 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_member_info.cfm
9 ms 9 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
3 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.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
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/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
309 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:27.027
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=9ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:32:27.027
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=9ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:32:27.027
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:27.027
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 @ 02:32:27.027
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:27.027
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:27.027
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=1ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 02:32:27.027
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:27.027
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=21ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:27.027
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=20ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:27.027
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 @ 02:32:27.027
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) = 9

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:27.027
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=23ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:27.027
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=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:27.027
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:27.027
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:27.027
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=16ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:32:27.027
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:27.027
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:27.027
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:27.027
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:27.027
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=CFGLOBALS=urltoken%3DCFID%23%3D4082280%26CFTOKEN%23%3Dd212645547face24%2D0A3DBFFE%2DB1C0%2DE232%2D51BC45D01A6FD596%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2002%3A32%3A27%27%7D%23hitcount%3D110%23timecreated%3D%7Bts%20%272026%2D06%2D01%2002%3A32%3A05%27%7D%23cftoken%3Da601a27c55bfea80%2D0A3DB643%2DB9A2%2DB01B%2D99C92278ECD8134B%23cfid%3D4082278%23; FREEACCESSCOUNT=0; CFID=4082280; CFTOKEN=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
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/9
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=4082278
cftoken=a601a27c55bfea80-0A3DB643-B9A2-B01B-99C92278ECD8134B
hitcount=115
lastvisit={ts '2026-06-01 02:32:27'}
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=4082280&CFTOKEN=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596
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#=4082280&CFTOKEN#=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596#lastvisit={ts '2026-06-01 02:32:27'}#hitcount=110#timecreated={ts '2026-06-01 02:32:05'}#cftoken=a601a27c55bfea80-0A3DB643-B9A2-B01B-99C92278ECD8134B#cfid=4082278#
CFID=4082280
CFTOKEN=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596
FREEACCESSCOUNT=0
Session Variables:
cfid=4082280
cftoken=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596
sessionid=BOOKBROWSE_4082280_d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596
urltoken=CFID=4082280&CFTOKEN=d212645547face24-0A3DBFFE-B1C0-E232-51BC45D01A6FD596
URL Parameters:
bookclub_number=9
Debug Rendering Time: 16 ms