BookBrowse interviews Meet the Novel Ideas book club of Chicago, who take food as seriously as discussion, combining good literature with ethnic dining. Discover the books they've enjoyed, and the ones they haven't; and the types of restaurants that have proved conducive to discussion and those that haven't! about all aspects of their book club.

Book Club Interview (see full list)

Meet the Novel Ideas book club of Chicago, who take food as seriously as discussion, combining good literature with ethnic dining. Discover the books they've enjoyed, and the ones they haven't; and the types of restaurants that have proved conducive to discussion and those that haven't!

Hello Erica.  Thanks for taking the time to chat with us today about your book club.  First off, what makes your group special to you?
 
Our club combines good literature with ethnic dining.  Living in Chicago, we have a huge choice of ethnic and regional restaurants.  For the first two years, we would decide on a cuisine we wanted to eat ,or a restaurant we wanted to try, and find a book set in the ethnic or regional area of the food we were going to eat.  That caused us occasionally to read some really bad books, so we now are book driven, finding restaurants that act as a good backdrop to books we want to read.

Clockwise: Sue Schneider, Helene Steen, Fern Bogot, Rosa Garcia & Erica Minchella


How did your group get started?
 
We've been together three years.  My sister, another friend and I had started a group many years ago and just didn't have enough reading friends to keep it going.  About three and a half years ago we all realized that our circle of friends had changed and we each knew more readers and people who were interested in joining us for a book club.  We worked on recruiting members and started when we had about eight people interested.
 

How did you find people interested in joining your club?

We recruited based on friends we thought would enjoy being part of a book club and who liked to eat out.  Some people who I approached - because I wanted the chance to see them on a regular basis - were either too busy, or were only interested in reading books on their own list and not having choices dictated to them.  Even the ability to pair the books with good food and conversation was not enough to entice them. 
 

Do you have a name?

 
Yes, "Novel Ideas".  I had heard the name of another book club, which had a cute turn-of-phrase name and suggested "Novel Ideas" or "Literary Figures" as a name.  The former won the vote.

 

Clockwise: Fadge Pincham, Jody Lowenthal, Patti McCanna, Jon Shimberg, Linda Crohn, Erica Minchella

Tell us a little about your group
 
We have 12 members and usually 6 – 8 attend each meeting.  We have one man! (My sister's husband)  He is not at all intimidated by being the only man and adds a wonderful dimension to our discussions.  We have been trying to get more men to join us, so far without success.  We range in age from mid 40s to late 50s.

 
How would you describe your group's personality?  
 
We tend to be a little lawyer-heavy (5 of us are lawyers), but there is enough variety of other professionals that provide for interesting and intellectual discussions.  We are all college educated, and almost all have children.  We are all overloaded with work and family obligations, but all read more than just book club selections.


What's your favorite thing about belonging to "Novel Ideas"?
 
Only one?  I love coupling the dining experience with the books we read.  Eating Indian food with a book set in India or Afghani food with a book set in Afghanistan has truly added a dimension to our discussions.  Sometimes the restaurant's staff will help with background information.  We had Iranian food brought in (complete with explanations by our caterer/member) for our discussion of Pomegranate Soup and included our discussion of our menu with Marsha Mehran when she called us.
 

Did you contact Marsha through BookBrowse's Invite The Author program?

We did contact Marsha through Invite The Author and we hope to make inviting an author to a meeting an annual event.  Marsha joined us by phone.  It was GREAT!  She was wonderful communicator.  We may have convinced her to come visit Chicago and have offered to help her locate bookstores where she might do readings or book signings.


Anything else you particularly enjoy about your book club?
 
I enjoy getting other people's take on what I've read.  It is also one of the few things I have time for socially, so it helps me maintain contact with certain friends whom I only see at meetings.  Next to reading, or reading about what I should be reading, I enjoy talking about what others are reading best, so I get a chance to do that at out meetings – or through our online discussions – as well.
 

Tell us a little about your meetings.
 
We meet every 4 –5 weeks based on how everyone's schedule is going and we try to accommodate as many people as possible. We don't meet in December and we usually do something different in August, like reprising a novel some people missed the discussion of.

We generally meet on Tuesday evenings from 7 –9. (It's usually easy to get reservations on that night of the week). We spend some time socializing, ordering, talking very generally about the book. I prepare a list of questions to get us to a deeper understanding of the book, looking at themes, foreshadowing, writing style. Anyone can interrupt or move the discussion to a point of interest. The discussion usually lasts 45 minutes to an hour, depending on the depth of the book.  The last 15 minutes to half hour is spent on club business – what books to read next, what restaurants will be a good fit, closing or adding to membership, etc. Final socializing is done as we leave the restaurant.  If we want to do something different – like "High Tea" or "Invite the Author", we find a Saturday that works for everyone.

 
Who runs the meetings?
 
I do. I wound up as leader by default. We were going to change leaders each month, but everyone seemed to like the way I lead the discussions and everyone is so busy, they were happy to let me take over. I had taught High School English in a former life and was trained in "The Great Books Method of Discussion" which I try to use as the basis of our discussions.  If I find it difficult to prepare questions, either because I'm too busy or there is something about the book that makes it difficult for me, I usually ask my sister or whoever suggested the book to help out; but if anyone wants to pursue a particular aspect of the book, I become a participant rather than a leader.  
 

How do you communicate in between meetings?
 
 
Over the years, things have worked themselves out.  We use Yahoo Groups to send out messages to everyone, keep a calendar, keep a database of books to read and restaurants we might want to go to.  When an issue arises, we use postings on Yahoo Groups to talk to each other and usually come to a final decision at a meeting.  (We recently had an issue with not being able to hear each other at restaurants and solved that by agreeing to either go to restaurants that could accommodate us at a round table or go to someone's house and order in).


Is it difficult to keep things fresh after 3 years?

We're not afraid to make adjustments and work as a democracy – the majority wins.  After we read some books that no one enjoyed, we had no problem changing the focus to the books rather than the food.  Finding new restaurants and new books keep the group fresh. We have members who watch for other book events too, especially book signings by authors we have read or book readings and some members will go to those and report back on our Yahoo Groups page.
 

What sort of books you read?
 
We usually choose fiction, although there have been a number of non-fiction choices as well, because they were interesting topics and fit well with a restaurant we wanted to go to.  Sometimes we tend toward current fiction, other times we feel we need to go back to a classic.  We try to read books that offer some intellectual challenge and may not be something we, individually, might read if not for the book club.  We particularly look for books that will allow us a stimulating discussion.
 
We used to choose books based on what kind of food we wanted to eat.  Now someone will just suggest a book, or a topic, or a genre and we go from there.  We created a list of books about a year ago and often will refer to that for choices.  We hadn't read any mysteries and I knew that we had some members who loved mysteries, so I suggested we do that for a change.  A number of books were suggested by our mystery lovers, and we voted as a group. (We post a poll on our Yahoo Groups site and pick the book with the most votes.) Sometimes we just need a good Graham Greene novel, or we'll want to try out a particular restaurant and a good book or author fit well. One time, we read James Hilton's novels back-to-back and in addition to the discussions of the books, compared and contrasted the styles.  It varies.  Everyone's ideas are respected and at some point acted on.

 
What are some of the books that have generated the most interesting discussions? 
 
The Rule of Four by Ian Caldwell & Dustin Thomason
, The Time Traveler's Wife by Audrey Niffenegger, Our Man in Havana by Graham Greene, Postville by Stephen G. Bloom, The Color of Water by James McBride, Mama Day by Gloria Naylor, The Kite Runner by Khaled Hosseini and The Motorcycle Diaries by Ernesto Che Guevara.

Sometimes the discussions are particularly good because of the food or the setting, Non-fiction books have led to good discussions, although I have a difficult time preparing questions for them.    It often helps if someone has read the book and can vouch for it, rather than our deciding blindly on a book because it would go well with a cuisine we want to eat. 

 
Any Duds?
 
We enjoyed Master Butchers Singing Club by Louise Erdrich but the German restaurant we chose had a band setting up while we were talking.  I raced through my questions – to a point where it was almost comical.  Another time, we wanted to eat Tapas and were looking for a good Spanish book and decided on The Sun Also Rises by Ernest Hemingway, both because it had a Spanish setting and it was a classic.  We all hated the book, but actually had a good discussion about it.
 
 Middlesex by Jeffrey Eugenides and God of Small Things by Arundhati Roy divided the group – half absolutely hated them, half loved them.  Alice in Wonderland by Lewis Carroll turned out poorly as well.  We wanted to have "High Tea" but the restaurant we chose didn't really serve "High Tea" and it was hard to lead a good discussion about Alice.
 
 Also Dreams of my Russian Summers by Andrei Makine was not a success.
 
 
 Do you have any fixed system for getting copies of books, such as through your library or a bulk deal from a bookstore?
 
 
Everyone is on their own to get the book, although we'll help each other out.  We have a great library system in the Chicago area, so some members get their books there.  Others go to book stores, online, or we share amongst ourselves. Sometimes we choose hardcovers, sometimes paperbacks.

 
Do you have any events that are special to your book club?  Field trips, annual events? 

Since our discussion with Marsha Mehran, we would like to have a discussion with an author annually.  Other than that, if there is a book event, we'll circulate information on our Yahoo Group and whoever wants to goes.


Are there any fun ideas that you've tried that might be of interest to other clubs who are looking for ways to liven things up?
 
Finding unusual restaurants like Tapas or Fondue have always added a fun dimension to our meetings.  One of our favorite things to do at our meetings is to order as many desserts as there are people at our meeting and pass them around and each take a taste.  On our anniversary each year, I provide a list of the books we read and the cuisines we've had along with the prior years' lists.  I can provide that to you if you'd like!
 
Yes please! (see below for list)

Have you faced any challenges as a group? 
 
The biggest challenge, and one that almost came to splitting the group up, was over making sure we had a venue where we could hear each other.  One group lobbied for holding the meeting in members' homes and ordering in; one group lobbied for continuing our restaurant visits and looking for restaurants that could better accommodate us.  We compromised and agreed to look for restaurants with better acoustics, round tables or smaller rooms and if we can't find one that fits the cuisine we're looking for, then we'll hold the meeting at someone's home and order in.  We resolved the problem through postings on our Yahoo Groups page and by voting at a meeting. (It was a well-attended meeting!)

 
Are there any tips that you'd like to pass on to other book clubs? 
 
 Use Yahoo Groups.  It is a great way to communicate, to keep a calendar and keep databases of books read and to read.
 

Thanks Erica, this has been a great discussion.  We wish you and the other Novel Ideas members many more happy years of reading and discussing books!


The Novel Ideas Reading & Restaurant List (all restaurants are in the Chicago area)
 
Year One

Year Two

  • Frankenstein by Mary Shelley. Fondue Stube.
  • The Color of Water by James McBride. Robinson's Ribs (Oak Park).
  • Dreams of My Russian Summers by Andrei Makine. Zhivagos.
  • Mama Day by Gloria Naylor. South.
  • The God of Small Things by Arundhati Roy.  Tippen Restaurant & Essence of India.
  • Anna and the King of Siam by Margaret Land. Bangkok Restaurant.
  • The Kite Runner by Khaled Hosseini. Kabul House.
  • Motorcycle Diaries: Notes on a Latin American Journey by Ernesto Guevara.Tango Sur.
  • For Whom the Bell Tolls by Ernest Hemingway. Barcelona Tapas.
  • Alice in Wonderland by Lewis Carol. Leonidas

Year 3

  • Feb. The Rule of Four by Ian Caldwell and Dustin Thomason.  La Piazza (River Forest)
  • Mar. Chocolat by Joanne Harris - La Bocca della Veritas (plans for Lutz's aborted)
  • Apr. The Time Traveler's Wife by Audrey Niffenegger. Opart Thai and Cafe Selmarie
  • May. When the Emperor was Divine by Julie Otsuka. Matsu Shita
  • June. Our Man in Havana by Graham Greene. Cafe LaGuardia.
  • July. The Power of One by Bryce Courtenay. Mirabel.
  • Aug. Confederacy of Dunces by John Kennedy Toole (Reprise). Fadge's House.
  • Sept. Goodbye Mr. Chips by James Hilton. The Red Lion Pub.
  • Oct. Lost Horizon by James Hilton. Phoenix.
  • Nov. The Ninth Life of Louis Drax by Liz Jensen. Bistrot Margot.


This interview first ran in June 2007

© BookBrowse.com June 2007.

If you feel that your book group has something unique to offer, and you would like to tell others about it, please contact us with brief details, and maybe we can feature you in the future.

BookBrowse Book Club

Book Jacket
The Cover Girl
by Amy Rossi
Find them early enough, and they will always be her girls.

Members Recommend

  • Book Jacket
    The Sister's Curse
    by Nicola Solvinic
  • Book Jacket
    The Lost Story of Eva Fuentes
    by Chanel Cleeton
    A mysterious book links three women across generations in this novel by New York Times bestselling author Chanel Cleeton.
  • Book Jacket
    The Vanishing Place
    by Zoë Rankin
Who Said...

The truth does not change according to our ability to stomach it

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /featured-bookclubs/archives/index.cfm
Time Stamp 01-Jun-26 02:32 AM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780281157676 ms 1.78028115768E+012 ms 1 /root/website/app_server.cfm
328 ms 328 ms 1 /root/website/featured-bookclubs/archives/index.cfm
181 ms 181 ms 1 /root/website/app_layout.cfm
137 ms 137 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
119 ms 119 ms 1 /root/website/app_globals.cfm
86 ms 43 ms 2 /root/website/adsystem/adsystem_mod.cfm
56 ms 56 ms 1 /root/website/adzones/AdZone6.cfm
54 ms 54 ms 1 /root/website/queries/qry_get_active_obc.cfm
44 ms 44 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
32 ms 32 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
30 ms 30 ms 1 /root/website/adzones/showcase_track.cfm
30 ms 30 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
25 ms 25 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_current_competition.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 2 ms 3 /root/website/actions/act_spider_tracker.cfm
6 ms 6 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.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/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_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_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
330 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

get_member_info (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:32:37.037
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=8ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:32:37.037
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:37.037
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=8ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:32:37.037
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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:37.037
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:32:37.037
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:37.037
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

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

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

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:37.037
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=17ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:37.037
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=28ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 02:32:37.037
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=24ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 02:32:37.037
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) = 6

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:37.037
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=22ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:32:37.037
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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:37.037
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=33ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:37.037
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:37.037
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=30ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:32:37.037
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:37.037
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:37.037
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 @ 02:32:37.037
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:32:38.038
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%3A37%27%7D%23hitcount%3D164%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/6
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=165
lastvisit={ts '2026-06-01 02:32:37'}
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:37'}#hitcount=164#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=6
Debug Rendering Time: 13 ms