BookBrowse interviews Meet the Muse & Views book club of Ottawa, Canada - a group of ten women who meet monthly for good conversation about a wide range of books. about all aspects of their book club.

Book Club Interview (see full list)

Meet the Muse & Views book club of Ottawa, Canada - a group of ten women who meet monthly for good conversation about a wide range of books.

Michèle Dextras chats with BookBrowse's editor, Davina, about Muse & Views...

Hello Michèle, thanks for taking the time to chat with us. Please tell us a bit about Muse & Views

Muse & Views, is in its 13th year of existence. We have ten women members who meet the 4th Monday of every month from September to June, excluding December. There are still two members from the original group in 1998.We have high school English literature teachers, primary school teachers, a University professor, government employees and members who are retired. The atmosphere is very collegial and warm. As one of the newer members, I feel very lucky to have been invited to this club.

With just two members from the original group, it sounds like there's been a lot of change over the years. How did Muse & Views get started and how did it evolve into today's group?

The group took shape when two former members happened to be attending a service club meeting at the same time and began discussing their love of books. They invited friends from other circles to come out once a month and give a new book club a try. The group has grown and gradually evolved as people have joined and left because their lives have changed (our numbers have varied from six to ten for most of the Club's existence). Family moves, health issues, and priority shifts, rather than difficulties within the group itself, account for departures. New people have been welcome to attend, although from a practical point-of-view, most of our living rooms could not accommodate more than ten at a time, and I think the opportunity to hear everyone's opinions would be difficult with more than ten members.

Is Muse & Views the first book club you've been in?

No, it's the third but it's been the best experience overall. The mood is relaxed, collegial but sufficiently serious so that we expect members to have read the book being discussed and there is almost always a good discussion. There is also an excellent  atmosphere of respect amongst the women.

Tell us about your meetings

Because we meet nine times each year, each member has the opportunity to host once a year with one of our ten members "sitting out" on a rotational basis. The host provides light refreshments such as cheese, a dip, finger foods, a dessert, wine and coffee or tea. Sometimes the food provided will refer to the theme of the book. When we read Sarah's Key by Tatiana de Rosnay, Beth has some lovely French cheese and "petits gateaux" in honour of France where the story was situated. When we read Joanne Harris' Five Quarters of an Orange I prepared an apple and apricot clafoutis that was featured in the book.

Muze & Views


We normally begin the meeting catching up on news, about 20 minutes and then the member whose book we are discussing will give a short biography of the author and sometimes, why she chose that particular book. Then we go around the room and talk about what we liked or disliked about the book. Some of our members take careful notes as they are reading and some prefer to discuss liberally. We discuss the characters, the plot, the writing style and sometimes compare the book to others that we have read individually or as a club.

What about reading guides? Do you ever use them?

As long as I have been a member we have not used reading guides.

How do you choose your books?

Normally in September we determine who will host and recommend the books by month for the following year. Books are chosen by club members, with each picking one book a year and, again, one "sitting out" on a rotational basis. When choosing books we each try to take into consideration, as much as possible, the availability of the book. As much as possible, members try to choose books that are available at our local library. Since Ottawa has a population of almost one million, we have quite an extensive available choice. Members will pick up the hardcover or paperback, whatever is available to them. Sometimes we share a bought copy.

How do you organize yourselves outside of meetings? Your blog is impressive, who manages that and how much time does it take? 

We have a Club secretary - which is me at the moment. Previously, Jolene, one of the senior members, had been secretary for almost 10 years. I suggested creating the blog in 2008 and I maintain it most of the time. When I am absent, there are two other members who are able to post the summary after a meeting. It doesn't take much more than an hour per month and I enjoy it.

A blog is easy to create and maintain. You can keep it as simple as you want or make it more elaborate. For example, I've added sidebars that link to lists of books we've previously read, book websites and so forth. Previously the secretary would summarize the meeting and send it to all the members via e-mail. Now any member can refer to the blog to see what we discussed and what books we have read. It also allows members to add comments, especially if they were absent at the meeting or if they want to add to the summary published on the blog. The blog was private for the first two years with only those who had the exact URL able to access. Since we have made it public, few people have actually looked at it besides members. We never publish family names or addresses of members to ensure privacy.

Do you pay anything to host your blog on BlogSpot? If not, do you have to display advertising or have any other restrictions? Would you recommend BlogSpot to others?

Blogspot is free software so a blog can be created by anyone without the requirement to pay or advertise. It is a google service at www.blogspot.com . There are several other blogging software services but I am most familiar with this one. It is very easy to use, and there is no requirement to learn html language.

Tell us about the sort of books you read? 

Each member chooses a book. There are no restrictions. The majority of the books that we have read are fiction. However, we have also read biographies and autobiographies such as Unbowed by Wangari Maathai who won the Nobel Peace Prize in 2004. We almost always read at least one book a year written by a Canadian author but this is not by design, simply because we have some wonderful Canadian authors. A couple of great Canadian authors that might interest your readers are Mary Lawson who wrote Crow Lake and The Other Side of the Bridge or Ian Brown who wrote the heart felt account of his journey with his disabled son called The Boy in the Moon.

Have there ever been times when you've been frustrated by picking books a year ahead? Perhaps because you've wished you could leap into read a book that everyone's talking about, or found too many books of a similar type in a row because you've each been free to choose the title of your choice without looking at the schedule as a whole?

Actually, we determine a year ahead of time who is responsible to choose a book for each meeting but we do not require that members give us the title of their chosen book until three months before - which gives those of us who like to read ahead of time the chance to get the books. You will see on our blog, if you pull up the Books and Meetings in 2011, that we now have the books until June but not yet for the Fall meetings.

As to leaping into reading a book that everyone's talking about, we always share books that we have read outside of the Muse and Views Book Club readings with our members. The only one that I can think of that was a "book that everyone's talking about" that we read was The Guernsey Literary and Potato Peel Pie Society by Mary Ann Shaffer & Annie Barrows, which Colette chose in March for June.

Please name some of the books that have generated the most interesting discussions

The books that have a theme that touches some of us have generated the most discussion. Charles Martin's Where the River Ends developed into a discussion about personal struggles with illness some of us have witnessed or lived. The Boy in the Moon by Ian Brown brought the discussion to the challenges and impact special needs children have in the classroom and the lack of support from the health and education communities.

Perfume by Patrick Suskind, which was the first book I recommended, was not at all enjoyed by the great majority of members. It, however, generated a lot of discussion about well-written stories and the power of the written word on our emotions. There was considerable discussion also about the symbolism in the book.

What books have been the group's favorite books?

Each year in January we vote on our favorite book of the previous year and give a prize to the person who chose it. The prize might be a book, a journal or a bottle of wine. In the past 4 years The Book of Negroes by Lawrence Hill (US title: Someone Knows My Name), The Guernsey Literary and Potato Peel Pie Society, A Thousand Splendid Suns by Khaled Hosseini, and City of Joy by Dominique Lapierre have been the favourite books. As you can see, there is quite a variety.

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

The book Summer Sisters by Judy Blume was not a big hit. It's been so long that it is hard to recall details, although the theme and writing quality did not seem to be popular. The chooser was unable to attend that night, so perhaps she would have been able to defend the novel and cast it in a better light. Other book choices have sometimes polarized opinion:  for instance, Perfume by Patrick Suskind and The Poisonwood Bible by Barbara Kingsolver were either "best" or "worst" reads for members, depending on taste.

What types of books tend to make for good discussions in your group; are there any that haven't worked?

The polarizing effect of books such as those mentioned above often generates the best discussion. We tend to learn a lot when members defend their opinions, particularly about books we may have disliked. I really can't think of any that did not generate good discussion or that everyone found uninteresting. It is unusual that a member will choose a book that she has not already read, so we tend to choose books that we enjoyed and that we feel will be enjoyed by other members or at the very least, generate animated discussion. That was definitely the case with Perfume. It is one of my favourite all time books but I knew there was a chance that several members would not like it, but even though they didn't, they still read it!

What books are coming up on your reading schedule soon? 

We've just read Half a Yellow Sun by the Nigerian author Chimamanda Ngozi Adichie. In March we will read Notes from a Small Island by Bill Bryson and in April In the Skin of the Lion by Canadian author Michael Ondaatje. Wouldn't you say that these are quite varied?

Indeed, they are varied choices but there is a common theme in that they are all books that expand a reader's horizon - the sort of book that when you've finished you know something new about the world, or perhaps yourself, that you didn't before (which is just the type of book will look for at BookBrowse).

Yes, our members particularly like books that allow them to learn something new about an era or country. Tatiana de Rosnay's book Sarah's Key and autobiographies such as Unbowed are good examples.

Do you feel the type of books chosen over the years has changed?


Book choices have changed somewhat over the years, as members have departed and new people have come on board. At the start, we had some quilters and philosophical ladies who brought books with themes that reflected these interests. As they have left, new ladies have contributed choices out of different passions.

The way we approach our discussion has likewise changed. In the beginning, members did not tend to bring notes to meetings, keeping discussion light, though still animated. Members now, many from academic or political backgrounds, often bring written materials, to jog memory or highlight important passages. We have become somewhat more serious in our discussion, yet just as friendly in our relationships. In fact, friendships have deepened over time, as people have gotten to know each other well. Interestingly, this has not seemed to prevent newcomers from feeling welcome because we all have a love of reading and discussion in common. And we also all love a good hors d'oeuvre!

And who doesn't! Any special events you've held, visits taken, activities and so forth?

In 2001, the Book Club read Whelan, an autobiography of Eugene Whelan who was a member of our parliament and was at the time a Senator. Since one of our members worked in Parliament, she arranged a meeting with Mr.Whelan. In 2008 we discussed the film The Last King of Scotland  based on the book by author Giles Foden. We also met with a prominent member of our Senate who is originally from Uganda and who  was able to tell us about her family's exodus from Uganda. This year we read The Collaborator of Bethlehem by Matt Benyon Rees.Our host that month, Colette, invited a friend who worked at the Canadian Embassy in Israel who had prepared a slide show and gave us a lot of very interesting information about the region.

Looking back over the years, do you have any nuggets of wisdom for other book clubs, especially those who are just starting out?

Try to be flexible, within reason. We have had members who have missed several months for family reasons or illness; others, especially the retired members, are sometimes away for two or three months. So we organize the schedule so they can take their turn hosting and choosing a book. A couple of time we have had a member who does not show up. After a few months, we simply remove their name from the e-mail notices of meetings.

It's important that all members respect each other and that book choices, no matter what, are accepted without complaint. One of the reasons I joined a book club was to force me to read books I would not normally pick up. The Muse & Views Book Club, because it has no particular theme, allows for a good variety.

Thank you very much Michèle. I'm sure I speak for everyone reading this in wishing you and the other members of Muse & Views many more happy years reading and discussing great books!

© BookBrowse.com June 2012.

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

Most of us who turn to any subject we love remember some morning or evening hour when...

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 11:30 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
1780313420698 ms 1.7803134207E+012 ms 1 /root/website/app_server.cfm
314 ms 314 ms 1 /root/website/featured-bookclubs/archives/index.cfm
175 ms 175 ms 1 /root/website/app_layout.cfm
134 ms 134 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
127 ms 127 ms 1 /root/website/app_globals.cfm
73 ms 37 ms 2 /root/website/adsystem/adsystem_mod.cfm
51 ms 51 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
50 ms 50 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
42 ms 42 ms 1 /root/website/adzones/AdZone6.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_active_obc.cfm
38 ms 38 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
35 ms 35 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
32 ms 32 ms 1 /root/website/adzones/showcase_track.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_competition.cfm
18 ms 6 ms 3 /root/website/actions/act_spider_tracker.cfm
15 ms 15 ms 1 /root/website/act_check_login.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_member_info.cfm
12 ms 12 ms 1 /root/website/actions/adstatus.cfm
9 ms 9 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/featured-bookclubs/archives/dsp_bookclub.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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
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_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_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
315 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 11:30:20.020
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=13ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 11:30:20.020
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=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 11:30:20.020
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 @ 11:30:20.020
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 @ 11:30:20.020
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:30:20.020
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=15ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:30:20.020
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 @ 11:30:20.020
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=12ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 11:30:20.020
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=13ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 11:30:20.020
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=16ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 11:30:20.020
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=8ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 11:30:20.020
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) = 36

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=34ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:30:20.020
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=15ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:30:20.020
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=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:20.020
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:20.020
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:20.020
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=37ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 11:30:20.020
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 @ 11:30:20.020
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:20.020
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:20.020
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:30:21.021
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=CFTOKEN=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E; CFID=4097351; CFGLOBALS=urltoken%3DCFID%23%3D4097351%26CFTOKEN%23%3D6d1b7122cafe7ce6%2D1D7CE9D8%2D9997%2DD094%2DB764C3195832D30E%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2011%3A30%3A20%27%7D%23hitcount%3D7%23timecreated%3D%7Bts%20%272026%2D06%2D01%2011%3A30%3A16%27%7D%23cftoken%3D6d1b7122cafe7ce6%2D1D7CE9D8%2D9997%2DD094%2DB764C3195832D30E%23cfid%3D4097351%23; FREEACCESSCOUNT=1; 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/36
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=4097351
cftoken=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
hitcount=8
lastvisit={ts '2026-06-01 11:30:20'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 11:30:16'}
urltoken=CFID=4097351&CFTOKEN=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
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#=4097351&CFTOKEN#=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E#lastvisit={ts '2026-06-01 11:30:20'}#hitcount=7#timecreated={ts '2026-06-01 11:30:16'}#cftoken=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E#cfid=4097351#
CFID=4097351
CFTOKEN=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
FREEACCESSCOUNT=1
Session Variables:
cfid=4097351
cftoken=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
sessionid=BOOKBROWSE_4097351_6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
urltoken=CFID=4097351&CFTOKEN=6d1b7122cafe7ce6-1D7CE9D8-9997-D094-B764C3195832D30E
URL Parameters:
bookclub_number=36
Debug Rendering Time: 9 ms