BookBrowse interviews Marianne Paterniti, Book Groups Coordinator at the Darien Public Library in Connecticut talks with BookBrowse about the library's very comprehensive book club programs. about all aspects of their book club.

Book Club Interview (see full list)

Marianne Paterniti, Book Groups Coordinator at the Darien Public Library in Connecticut talks with BookBrowse about the library's very comprehensive book club programs.

Hello Marianne, thank you for taking the time to talk to us about Darien Library's book group programs. First off, please tell us about your community.

Darien is a town of just under 23,000 people. It's an hour train ride from New York City so many citizens are commuters. Residents tend to be college graduates with above average income. They are well read and strong supporters of the library. In addition, our school system is highly ranked and we attract many young families.


It sounds like you have your work cut out providing services to such a well-read population; and I know you have a vibrant book club program; please tell us about this.

That's true, and as a result "extreme customer service"' has been our working banner for some time.

Darien Library formalized its book group program back in 2004 after we recognized that book group members were our core readership. The goal was to maximize our adult readership and to ensure the quality of their reading experience. Today, with about 100 registered book groups, our focus is more on the quality of the program. Ever dynamic, our strategies to achieve our goal include:

  • A book collection of 200 titles, available through the Books in a Bag (BIAB) program, targeted at improving the quality of the reading experience.
  • Author, Publisher and Training programs designed to maintain book group interest and improve their effectiveness.
  • Library sponsored book groups to satisfy transient and special interests, help unaffiliated readers organize and provide a vehicle to test new approaches.
  • Promotional programs aimed at maintaining a high interest in book groups.
  • Communications' vehicles for delivering timely news to book group members.

Can you expand on some of these elements, for example, are the library sponsored book clubs ones that the library runs itself?


Yes, these groups meet at the Library. At times we will conduct an "outreach"' meeting off site to help a new group get started. For example, most recently we supported the newly established historical museum, Mather Homestead, to set up a book group as part of their programming. We supported this effort by providing books and then moderating their first few discussions. In addition, we support about 100 registered local book clubs that meet in the community.


That's interesting, let's break this down. First off, what book groups does the library run itself?


The library currently runs three book groups:
  • Our Monthly Book Group reads primarily contemporary, literary fiction. Some members have been in the group since its beginning in 2004.
  • The Business Book Group meets quarterly.
  • The Fifty/Fifty Group (fiction/non-fiction) meets monthly and alternates fiction with non-fiction.
In addition:
  • Pop-up Book Groups are held when there is supporting interest in a specific topic
  • Books by the Fire is a weekly group that meets to discuss what individual members are reading. This used to be run by the library but has now been turned over to members of the group to run at the library.
  • The Library also sponsors a short story discussion program that takes place weekly from May through November which is run by a professional leader.

Could you give us an example of your pop-up book groups?


Our last pop-up book group took place in the fall of 2019. We teamed up with the local nature center to discuss the Pulitzer prizewinning, The Overstory by Richard Powers. About 15 people came to the nature center to discuss the book and then took a guided tour through the center's adjacent woods.


That sounds wonderful! Where are the groups meeting during the pandemic?


All are currently meeting regularly on Zoom.


So, now on to the registered book clubs. How does Darien Library support these?


Books in a Bag is a direct support program to help book groups conduct their meetings. With approximately 200 titles, these bags with multiple copies of a single title are made available to book groups. The idea is to make the book group meeting process easy. Beyond that, BIAB program provides a broader communication link between the Library and the book group.

Another element of direct support is Book Group planning wherein we invite interested groups to meet with us on an individual basis to select reading choices for their upcoming season. This activity has inevitably morphed into a much broader and important discussion of books, genres and authors, an important communication link that we informally call Book Talking.

Also, we directly support book groups with periodic workshops. The most popular, and one we've repeated, has been the "How to Lead a Better Book Discussion" program.

In addition to direct support activity, we have communication programs to deal with news and calendar related events. For example, our monthly e-newsletter and our dedicated Web Page for Book Groups highlight new acquisitions to the books in a bag collection and advertise upcoming programs.

To complement the direct support, we arrange author events which have proven to be very popular with book groups. We join forces with our programming staff to offer a variety of author events and invite book groups and the public to attend.

In a similar category of support, we conduct publisher programs. Our primary event is a yearly evening gala with 10 publishing representatives and with some 125 attendees, called Book Buzz for Book Groups. During the pandemic we resorted to a remote zoom approach where we featured a different publisher every week for 8 weeks.

Finally, we have promotional programs that include simple displays, book marks, and pictures of book groups displayed on our electronic panels during National Book Group Month in the Library's main lobby. Social media is another means we use to promote our events.


What do your Books in a Bag consist of and why do you limit them to just registered book clubs?


Each book bag consists of 10 copies of a title, usually in hardcover. Early on, we provided hard copy supplemental information, but now we generally provide links to enrichment materials available online. Additionally, we post sources for discussion questions and additional information on the Book Groups Page on the Library web site.

We've found that requiring every book group to be registered promotes fairness in the distribution of our collection and a commitment and sense of belonging to the Library. It justifies the personal and individualized service our program provides. Also, the book collection is in great demand and funding plays a role here. All of our materials and programs are supported by donations by the Friends of the Darien Library.


What happens if a group has more than 10 members?


We promise ten copies of each title. We try to augment that when extra copies are needed.


I see that you ask for contact information for all members of the group? What is the purpose of collecting this information, and are they automatically signed up for mailings?


The book group format often has different individuals run individual meetings and in doing so they need to interact with the Library. In order to maintain continuity with the book groups, we need to know which individuals belong to which group. And for effective communications we need to have individual names.

Registration helps us keep track of how many members are in each group. Based on this, we can determine whether or not we're purchasing the right number of books.

We've also found that registration makes for a closer relationship between group members and the Library.

Regarding mailings, there are two ways that happens. Either the book group gives permission initially or individuals sign up themselves.


So, if I understand correctly, in addition to one person completing the registration form, each member of the group also registers at the library. How does this work if some members do not live within the library's boundaries?


We do expect book group members to register as individuals with the Library, at which time they become a patron of the Library and are then able to check out books. From a statistical point of view, it makes the number of people using the Library more accurate. This service is not limited to residents; in our area, a person doesn't have to be a town resident to use most of our Library services. Distance has not been a factor for non-residents as geographically, we're in a rather densely populated metropolitan area. And so members generally live fairly close to each other.


Do you allow groups to request specific titles for BIAB?


The titles are carefully selected to represent the books of most interest. For practical reasons we manage the program to 200 titles. However, we will consider requests for other titles as we are continually reviewing our line-up.


How do you keep your records up to date when people join or leave a group?


Book club registrations expire every three years. At that time, we ask for an update to the membership.


What happens to the BIAB books that are no longer in demand?


Once we determine the titles are no longer active, we channel them for general Library use or to a book purchasing service.


I see that you also offer book club kits for children. Are these popular? And are they checked out by the children or are they the province of parents and perhaps homeschoolers?


Krishna Grady (Head of Youth Services) and Mia Orobona (Assistant Head of teen services) manage this part of the program. Here are their responses: The kits are checked out occasionally and usually at the province of parents. In the past we have had some homeschool groups check them out but they are usually interested in books that we have not made into book club kits.


What about BIAB for teens?


In the past, the Library has tried to run teen book club events but rarely have we had success. We have found that the teenagers generally want to read for pleasure and select their own titles as they have so much assigned reading in school.

That lines up with what I've heard from a number of other libraries who run thriving book clubs for those of elementary school age but not for the teen years.

We do have a handful of teen titles with 5-10 copies that we used for the Forever Young Adult group, and once or twice I've had parents or teachers take a bunch for small groups. In the four years that Krishna has been with the library she says she's been asked for help with a teenaged book group perhaps five times.

Many times, we will give patrons multiple copies of books that we have on hand such as past Nutmeg nominees or anything that we have multiple copies of that kids would be interested in discussing in a book club. The Nutmeg Book Award encourages children in grades 2 through 12 to read quality literature and vote for their favorite titles. Jointly sponsored by the Connecticut Library Association and the Connecticut Association of School Librarians, the Nutmeg Committee is comprised of children's librarians and school library media specialists. The Darien Library Youth Services Department orders many of these titles in multiples.


Very interesting, thank you. Getting back to your adult book groups, what is the typical profile of your registered book groups?


Most groups in town are made up of women from ages 50-90+. We have several male and female groups, as well as several male-only groups. One of the most fervent groups we have is the Darien Mens' Association whose interest centers on World War ll titles.


Once a group registers, approximately, how many of their future book selections come from Darien Library?


We don't track that statistic directly because groups in any given year sign up in a random pattern.


Do you have any sense of how many book groups there are in your community that are not registered with you?


That's hard to judge but we do occasionally hear of groups who read very specific genres e.g.18th century classics. Also, we have worked with other town organizations, assisting them in starting in-house book groups as part of their programming; and those book groups later registered with us.


That's a really interesting idea – to set the expectation that you'll help a book club get on its feet, but after the initial set up it will be on its own. That sounds like a formula that other libraries could use to support book clubs without taking on the commitment of running them permanently. You mentioned the Mather Homestead book club earlier, are there any other examples of book clubs you've helped form in this way?


Yes, we find this approach works very well. It is not only a great way to start a relationship but it's an effective way to leverage our resources. The local YWCA is another example; they recently organized the Y Newcomers' book group and were interested in having some start-up help which we are providing. We also used this approach with two of our in-house groups that I mentioned earlier.


Do people ask for ebooks as part of the BIAB?


No, we're seldom asked for ebooks.


This does sound like a very comprehensive program. I am sure that many librarians reading this are wondering how much time it takes to run. Would you be able to give an approximation?


First, it's important to understand that our library is very team oriented. We dedicate about 30 hours a week, split between two people, to orchestrating our book group efforts but we could not approach doing all that we do without considerable cross function support from other library staff. For example, we have a dedicated communications team who are deeply involved in all of our communications and promotional undertakings. Also, when we have our annual big tent “Book Buzz" with some 125 attendees and 10 publishers participating, we call on the assistance of a good number of our library staff.


What advice would you offer to librarians interested in developing a similar program; and particularly to librarians that would like to offer more to their book groups but don't have the resources to develop as complete a program as yours?


As I mentioned, we formalized our book group work in 2004. Since then, it's been a continual learning process as we look to what we can do better, listen to our patrons to understand their needs and talk to our fellow libraries about new ideas.

As we look back, we realize we've learned a great deal about planning and developing a measurement system to help understand what works and what doesn't. Having said that, we recognize that we are blessed with a stimulated reading patronage who motivate us to step-up our game. Finally, we clearly recognize that we are still a work in progress!


Thank you very much Marianne, I so appreciate you telling us about Darien Library's book club programs. I have found it fascinating and I am sure that the many who will read this will do so as well.

Images:
Pop-up book group to discuss The Overstory by Richard Powers
Book Buzz event


Interview by Davina Morgan-Witts, BookBrowse publisher

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

Good as it is to inherit a library, it is better to collect one.

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
1780281148459 ms 1.78028114846E+012 ms 1 /root/website/app_server.cfm
415 ms 415 ms 1 /root/website/featured-bookclubs/archives/index.cfm
277 ms 277 ms 1 /root/website/app_layout.cfm
217 ms 109 ms 2 /root/website/adsystem/adsystem_mod.cfm
190 ms 190 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
189 ms 189 ms 1 /root/website/adzones/showcase_track.cfm
121 ms 121 ms 1 /root/website/app_globals.cfm
75 ms 75 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_active_obc.cfm
29 ms 29 ms 1 /root/website/adzones/AdZone6.cfm
29 ms 29 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_competition.cfm
16 ms 5 ms 3 /root/website/actions/act_spider_tracker.cfm
15 ms 15 ms 1 /root/website/act_check_login.cfm
15 ms 15 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_member_info.cfm
13 ms 13 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
5 ms 5 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/main_menu.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/featured-bookclubs/archives/dsp_bookclub.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.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_current_ezine.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_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
416 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 02:32:28.028
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=14ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:32:28.028
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:28.028
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:28.028
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=9ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:32:28.028
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=12ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:28.028
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:28.028
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 02:32:28.028
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=11ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:28.028
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=11ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:28.028
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=19ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:28.028
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=13ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 02:32:28.028
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) = 80

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:28.028
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=14ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:28.028
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=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:28.028
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:28.028
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:28.028
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=14ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:32:28.028
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:28.028
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:28.028
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:28.028
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=173ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:28.028
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%3A28%27%7D%23hitcount%3D122%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/80
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=123
lastvisit={ts '2026-06-01 02:32:28'}
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:28'}#hitcount=122#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=80
Debug Rendering Time: 26 ms