BookBrowse interviews Paging Creatives, a Zoom-based book club for creative business owners about all aspects of their book club.

Book Club Interview (see full list)

Paging Creatives, a Zoom-based book club for creative business owners

Paging CreativesRegina Garay and Cindy Howard are cofounders of Paging Creatives, a Zoom-based book club for creative business owners. Their book choices alternate between fiction, biographies and memoirs of artists or designers, and business books; and they’re open to new members!

In this Q&A they chat with BookBrowse publisher Davina Morgan-Witts about their group, providing invaluable insights for anyone running, or interested in running, a specialist book club.


Hi Regina and Cindy, it’s so good to meet you both. How did your group get started?

Regina: Cindy and I have known each other for years, and we've often proven a support system for each other. We share a love of books and thought we'd start a book club of two, meeting once a month to talk over the phone about our book selection. This quickly grew into the idea of having more join us, and having the meetings online. We put the word out and Paging Creatives officially launched in January 2022.

Cindy: Regina and I were working on building our own creative businesses and strengthening our belief in our self-worth. We felt strongly that discussing books was helping us, so we hoped others might benefit, also.


I’d love to know more about the sort of books you discuss.

Regina: The book club is for creative small business owners - or, really, anyone with an interest in arts and design. The fiction selections are all creative in nature due to the protagonist, location or theme; we also read biographies and memoirs of known artistic talents as well as business books that are beneficial to a creative small business.


Paging Creatives is such an apt name, who came up with it?

Regina: Cindy did! We each created a list of potential names and reviewed them together. When Cindy said it out loud, I immediately loved it. It was a fast call!

Cindy: Our rapid-fire brainstorming is one of my favorite things about us.


When and where do you meet?

Cindy: We meet via Zoom at 8 pm ET on the last Tuesday of the month. We both moderate the meetings which usually run for about one hour but we’ve been known to extend longer for those interested in going deeper into the subject matter.


How many generally attend a meeting and what sort of creative backgrounds do they have?

Paging Creatives Regina: We usually have between 6-12 attendees. The members are from all over the U.S., and one is from Toronto, Canada. Most are professional full-time artists, and some do the work as a side hustle. We are all in different artistic mediums. Some do decorative painting on walls, ceilings and floors; others are canvas artists; some specialize in murals and patterns; one is a mosaic artist, and I train creative small businesses in marketing and time management (while also being a former artist myself).


Wow, so much talent in one group! How do people find you and are you open to new members?

Regina: We typically find new members when our own members chat to their friends and colleagues and, yes, we are open to new members joining! We have a Facebook group called Paging Creatives and we post our monthly selections there, as well as the RSVP link to register for our monthly book chat. We’re also on Instagram @pagingcreatives. Interested creatives can also contact me at Regina@rightbrainlovesleft.com and I can send them the Zoom registration link directly.

Cindy: We are open to new members, but we do stress that we focus our book choices on creativity.


What books have you read so far?

Regina: We've tried a couple of different variations and have settled on three types of books: novels, biography/memoir, and business books. Everyone loves the mix of options! These are some of the books we’ve read so far (fiction, followed by nonfiction):

The Art Forger by B.A. Shapiro
The Cloisters by Katy Hays
The Marriage Portrait by Maggie O'Farrell
Horse by Geraldine Brooks
The Invisible Life of Addie LaRue by V.E. Schwab

Florence Broadhurst: Her Secret & Extraordinary Lives by Helen O'Neill
Julia Morgan by Victoria Kastner
Con Artist by Tony Tetro
Big Magic by Elizabeth Gilbert
Captivate by Vanessa Van Edwards
Art Money Success by Maria Brophy
Visual Thinking by Temple Grandin

What an intriguing selection! How do you pick the books?

Regina: Cindy likes to choose the non-fiction selections, and she's great at picking them. I like to choose the novels and do a lot of research, including on BookBrowse. Our members also like to recommend books, and we love that. They've suggested really good ones so far!

Cindy: It’s proven to be a great mix so far! We usually do a novel one month, followed by a memoir or biography the next, and the third month is a business book. Then we repeat. It’s tough to keep the creative parameters in mind, but we've yet to run out of books. Normally, we have a mix of opinions, but there are months when we all enjoy the book equally. Horse by Geraldine Brooks was the latest book that received thumbs up from all of us. It was so good!


I agree, it’s a wonderful book. Do you feel your book club choices are evolving over time?

Regina: Yes. We didn't have biographies in the mix until about half a year into the book club. We've also learned to balance 'heavy' books with lighter ones the following month. We've also had to keep in mind time periods and pick a mix of both modern and historical subjects.


I think it’s really interesting that you don’t just think about what books to read but how to schedule them. I’m sure that the members of your group appreciate you putting so much thought into the group. Are some of you also in other book clubs?

Cindy: A few of us are in other book clubs, but as far as we know Paging Creatives is the only one that we all attend virtually.


There is clearly so much that’s special about your group, but are there particular things that stand out to you that you’d like to share?

Regina: I truly love these women, and they are all magical in their own way. We have some time at each meeting when we update each other on what we have going on in our businesses, and we are all so supportive of one another. We've become good friends. It's just a beautiful mix of personalities, and I consider it kismet. I pinch myself at the good fortune that we all come together monthly!


Do you feel that a focused topic such as yours makes for a different book club experience?

Cindy: It does make for a different experience! We dive deep into creativity - it's not just something we touch upon for one month and then let that string go. It makes us more well-rounded creatives, keeps us informed and widens our worldview. We take that into our businesses, and it enhances them.


Are there any tips that you’d like to pass on to others who might be thinking of starting a book group on a specialist topic such as yours?

Regina: We'd be glad to. First, have a clear understanding of your focus and the parameters the selections must fall within, and also the type of members this would appeal to.

We have a mission statement which reads: "Paging Creatives is an online book club for small business owners in the art & design fields. Book selections will have a creative component, whether by subject, plot, or theme. The monthly selections will alternate between business books, biographies/memoirs, and fiction books." It's simple, but it lays out our specialty well.

Cindy: Secondly, be adaptable. The group itself will ebb and flow, and if you greet changes and requests with flexibility, both the book selections and the members will be all the better for it.


That is such good advice. I’ve seen many book clubs have challenges because the founding members have not clearly articulated what their group’s focus is, and then they sometimes run into problems later, particularly when new members join. But it’s also important to be flexible because groups can and should evolve over time.

Any other nuggets of wisdom?


Regina: A specialist book club will have a narrower range of books to select from than a general interest group, so choosing books may take more thought and planning. Ensure the selections are available in multiple formats (e.g. paper, ebook, audio) as your members will consume them differently. Also, ensure that the cost or ease of getting these books does not exclude anyone. Sometimes, if it's a newer book, there might be a waitlist at the library, so some people may not be able to get hold of a copy quickly. We keep that all in mind by planning well ahead. It's a balancing act, but well worth it!

We hope these tips will help.


I am sure they will! Thank you so much for telling us about Paging Creatives; and before we close, I’m sure BookBrowse readers would like to know a bit more about you two.

Regina: I’m based in Orlando, Florida and am the founder of Right Brain Loves Left, a company dedicated to providing small businesses with courses and training on managing their time, projects, and marketing effectively. I help entrepreneurs harness their creative and analytical sides; hence right brain loves left.

Cindy: I’m the owner of CRH Studios in Houston, Texas; I create artworks on commission for Interior Designers and clients nationwide. After 25 years as a decorative painter, I’m also very happy to be able to teach others some of the techniques and styles I use.


Thank you both; and Cindy, your artwork is beautiful!

© BookBrowse.com June 2023.

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

The single biggest problem in communication is the illusion that it has taken place

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 31-May-26 09:37 PM
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
1780263459326 ms 1.78026345933E+012 ms 1 /root/website/app_server.cfm
190 ms 190 ms 1 top level /root/website/featured-bookclubs/archives/index.cfm
114 ms 114 ms 1 /root/website/app_layout.cfm
86 ms 86 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
68 ms 34 ms 2 /root/website/adsystem/adsystem_mod.cfm
63 ms 63 ms 1 /root/website/app_globals.cfm
48 ms 48 ms 1 /root/website/adzones/AdZone6.cfm
24 ms 24 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
22 ms 22 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
21 ms 21 ms 1 /root/website/adzones/showcase_track.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_active_obc.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_current_competition.cfm
10 ms 10 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
9 ms 9 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
4 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_member_info.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/featured-bookclubs/archives/dsp_bookclub.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_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_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
191 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 21:37:39.039
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 21:37:39.039
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=5ms, Records=2) in /root/website/actions/adstatus.cfm @ 21:37:39.039
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 @ 21:37:39.039
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=1ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 21:37:39.039
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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 21:37:39.039
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 @ 21:37:39.039
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 @ 21:37:39.039
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=4ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 21:37:39.039
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=6ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 21:37:39.039
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 @ 21:37:39.039
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=9ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 21:37:39.039
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) = 85

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 21:37:39.039
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 @ 21:37:39.039
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 @ 21:37:39.039
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 @ 21:37:39.039
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:37:39.039
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=9ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 21:37:39.039
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 @ 21:37:39.039
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:37:39.039
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:37:39.039
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:37:39.039
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=CFID=4074808; CFTOKEN=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B; 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%3D4074808%26CFTOKEN%23%3D4607e8e46d035423%2DFFB56C90%2DDD15%2DF653%2DA4C1F55D469BE69B%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2021%3A37%3A39%27%7D%23hitcount%3D24%23timecreated%3D%7Bts%20%272026%2D05%2D31%2021%3A37%3A35%27%7D%23cftoken%3Ddc98a44b1e5ef0d%2DFFB562A0%2DE022%2DE401%2D19A7BA3188ACE874%23cfid%3D4074805%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/85
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=4074805
cftoken=dc98a44b1e5ef0d-FFB562A0-E022-E401-19A7BA3188ACE874
hitcount=25
lastvisit={ts '2026-05-31 21:37:39'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 21:37:35'}
urltoken=CFID=4074808&CFTOKEN=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B
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#=4074808&CFTOKEN#=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B#lastvisit={ts '2026-05-31 21:37:39'}#hitcount=24#timecreated={ts '2026-05-31 21:37:35'}#cftoken=dc98a44b1e5ef0d-FFB562A0-E022-E401-19A7BA3188ACE874#cfid=4074805#
CFID=4074808
CFTOKEN=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B
Session Variables:
cfid=4074808
cftoken=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B
sessionid=BOOKBROWSE_4074808_4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B
urltoken=CFID=4074808&CFTOKEN=4607e8e46d035423-FFB56C90-DD15-F653-A4C1F55D469BE69B
URL Parameters:
bookclub_number=85
Debug Rendering Time: 15 ms