BookBrowse interviews Lesley Fitzpatrick and Maggie Thompson are the co-founders of the History Book Group in San Diego, CA. They join us to talk about their approach to history, and offer up some great advice and selections. about all aspects of their book club.

Book Club Interview (see full list)

Lesley Fitzpatrick and Maggie Thompson are the co-founders of the History Book Group in San Diego, CA. They join us to talk about their approach to history, and offer up some great advice and selections.

How did your group get started?

We're a spinoff from another group at the book store where we meet. We (Lesley and Maggie) belonged to a nonfiction group at The Book Works (an independent bookstore just north of San Diego, in Del Mar) for about 2 years. As the book choices became progressively more politically charged, we realized that our interests tended more toward social history from ancient to near-modern rather than strictly contemporary topics. Our first meeting was October, 2008 so we're coming up on our second anniversary and the beginning of our third year.

Tell us about your members?

The core group is 10 strong, with 6 women and 4 men in that contingent; we often have a drop-in or two. Half the group is retired (some of them former history teachers), and the other half ranges between 40 and 60. We don't advertise in any fashion that encourages a specific age group, this is just the way it played out. All the members are interested in history; some are even history buffs But one of the things that makes the group so enjoyable is the diversity of interests and significant knowledge in other fields. We all appreciate that about each other. Although we're not exactly history geeks, we do enjoy the subject. Because history is not a popular cocktail conversation topic, the meetings are a chance for us to socialize with like-minded people, so we're all eager for the meetings.

How did you come together?

We invited a few friends we thought might be interested in our idea. Not all of them joined, but a few of them are still with us as members of the core group. The Book Works includes information about the group on their website and posts fliers at the store; some of the core members joined us as a result.

Very importantly, The Book Works supports us by providing a meeting place. Because the bookstore is centrally located, it's easy for patrons of the store from all over the county to join us. Meeting at the store eliminates hosting duties for the members and brings business to the small, independent book store.

Did you have an idea about the way you wanted to approach history?

We wanted to explore history without getting bogged down in names and dates, battles and lists of kings, presidents, and empires and discover the stories behind the scenes. At one point, we identified ourselves as Everyman's History Book Group. A good example of that type of history is 1215, The Year of Magna Carta. It details the political and economic conditions that lead to the creation of the Magna Carta, and also gives a look at what it was like for the everyday people who lived at that time.

How do you decide which books to read?

Lesley subscribes to The New York Review of Books, belongs to the History Book of the Month Club, is member of BookBrowse, and does extensive research to find books appropriate to the mission. As we narrow the list a little, Maggie does more research to be sure that we haven't missed anything. Group members also make suggestions from similar sources, including authors whom they're familiar with, or books they've discovered and want to read. We take part of a meeting every so often to make the choices as a group, usually selecting 3 to 4 books at a time for the coming months. We've found that it's best to do this at the beginning of the meeting, rather than at the end when everyone wants to head for home.

Tell us about some of the books that have generated the most interesting discussions?

We're reading A History of the World in 6 Glasses by Tom Standage for the second time by group popular demand. Standage is a great storyteller. And this book in particular presents a very accessible approach to world history. When we read Rounding the Horn, we invited some sailors as guest speakers to discuss some of the sailing terminology, and they immediately joined the core group. The Man who Loved China, by Simon Winchester, attracted many drop-ins (people who'd been to China, or who had relatives visiting China). Collapse by Jared Diamond, brought in several members of the nonfiction group for that particular meeting. Our discussion about The Victorian Internet, also by Tom Standage, was one of our liveliest, followed closely by Barbarians, by Terry Jones and Alan Ereira, which changed the mind of one of our most well-read members about the Roman Empire's influence on western civilization.

Are there any that haven't worked?

Very little doesn't work for our group because of our members' broad minds and curiosity. We try to choose books that stay close to our mission statement.

Are there any tips that you'd like to pass on to other book clubs?

We've found that letting the group choose the books and asking different people to lead the discussions keeps everybody involved and participatory.

Show and Tell has been fun sometimes as well. For The History of the World in 6 Glasses we had samples of wheat beer, wine, spirits, coffee, tea and Coke! It was great fun to sample the different glasses as the discussion progressed through world history. We did it again with Salt by Mark Kurlansky, sampling various kinds of salt with and without iodine, raw, processed, sea salt, and kosher salt.

When we discover an article in a current magazine, newspaper, or online which relates to the book we're reading, we'll point it out to the group. It could be as simple as a cartoon in the daily paper. This reinforces the relevance of history.

Sometimes members suggest supporting books or books on related topics as follow-up for anyone who is hooked on a topic.

When we can, we will bring along an author's bio or a related story about the author. We even shared around a DVD one time. Sometimes we are lucky enough to be reading a book when an author is on tour and The Book Works will arrange for a special author visit. It usually brings in quite a crowd.

What books are coming up on your reading schedule soon?

A History of the World in 6 Glasses, by Tom Standage (the encore!)
Certain drinks have done much more than quench our thirst. Six of them have had a surprisingly pervasive influence on the course of history during pivotal epochs, from humankind's adoption of agriculture and the birth of cities to the advent of globalization. This is an original, well-documented vision of world history.

An Edible History of Humanity by Tom Standage
Throughout history, food has had a huge impact on civilization as a catalyst for social change, political organization, geopolitical competition, industrial development, military conflict, and economic expansion. This is a pithy, entertaining account of how a series of changes - caused, enabled, or influenced by food - has helped to shape and transform societies around the world. (The Book Works is going to approach Mr. Standage about making a speaking engagement at the store, open to the public, but especially for us.)

A Brave Vessel by Hobson Woodward
In 1609, the ship Sea Venture set sail for the New World. It met a hurricane along the way. Among the passengers was aspiring writer William Strachey, who wrote a vivid account of the trip and struggles for survival on an island set against England's first colonial efforts in America. Shortly thereafter, Strachey learned that William Shakespeare's new play, "The Tempest", bore a striking resemblance to the adventures of the Sea Venture. Could this be yet another instance of alleged "literary collaboration" by Shakespeare? A Brave Vessel is a gripping account of Strachey's exploits and a fascinating investigation into literary process.

The King and the Cowboy by David Fromkin
How two colorful figures - Edward VII and Theodore Roosevelt - assumed leadership of the English-speaking world at the beginning of the twentieth century. Working together, secretly, they turned the alliance structure of the civilized world upside down.

Near the top of the list in the future:

Ceasar's Druids by Miranda Aldhouse-Green
For centuries, the Druids have been alternately feared and reviled. No archaeological evidence can be linked conclusively to this ancient priestly caste. Julius Caesar is one of the most reliable sources - did he embellish with bad press to make the Romans look good? Aldhouse-Green, professor of archaeology at Cardiff University and world-renowned expert on Druids, shows the elusive group to be more significant than previously believed. She shows that they were not just priests but also scientists, judges, healers, and power brokers - a highly complex, intellectual, and sophisticated group. They even traveled with and advised the Gallic military. The book addresses issues that remain relevant today: propaganda, theocracy, resistance and colonialism, and clashing ideologies.

Time Lord by Clark Blaise
The story of Sir Sandford Fleming, the man who created, and then convinced all the nations of the world to adopt, a unified standard for telling time. Standard time was one of the crowning achievements of Victorian progressives and one of the few innovations to have survived practically unchanged into our era.

Time Traveler's Guide to Medieval England by Ian Mortimer
An amazingly detailed social history, and "a gem for history buffs as well as travelers" (Booklist), this is not your typical look at a historical period. Revelations abound from the horrors of the plague and war to the ridiculous excesses of roasted larks and medieval haute couture. "After The Canterbury Tales this has to be the most entertaining book ever written about the Middle Ages." (The Guardian)

Longitude by Dava Sobel
The story of a lone genius, John Harrison, who, in the mid-1700s, solved the greatest scientific problem of his time. How to tell precise time at sea had baffled scientists and their patrons for the better part of two centuries, and Harrison's chronometer would save thousands of lives and increase the fortunes of nations.

Those are great suggestions for our readers! Thanks so much for joining us to talk about your group. It's always wonderful to meet BookBrowse members.


This interview first ran in August 2010. Sadly, The 35-year old Book Works closed in July 2011.

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

I like a thin book because it will steady a table...

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 12:58 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
1780318706824 ms 1.78031870682E+012 ms 1 /root/website/app_server.cfm
482 ms 482 ms 1 /root/website/featured-bookclubs/archives/index.cfm
242 ms 242 ms 1 /root/website/app_layout.cfm
205 ms 205 ms 1 /root/website/app_globals.cfm
138 ms 69 ms 2 /root/website/adsystem/adsystem_mod.cfm
129 ms 129 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
90 ms 90 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
88 ms 88 ms 1 /root/website/adzones/showcase_track.cfm
69 ms 69 ms 1 /root/website/queries/qry_get_active_obc.cfm
54 ms 54 ms 1 /root/website/queries/qry_get_current_competition.cfm
50 ms 50 ms 1 /root/website/adzones/AdZone6.cfm
40 ms 40 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
39 ms 39 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
35 ms 35 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
21 ms 21 ms 1 /root/website/actions/adstatus.cfm
20 ms 20 ms 1 /root/website/queries/qry_admin_get_bookclub_by_id.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
19 ms 19 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
17 ms 17 ms 1 /root/website/act_check_login.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_member_info.cfm
16 ms 5 ms 3 /root/website/actions/act_spider_tracker.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/site/blocks/dsp_border_booktalk.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/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_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/head.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
483 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 @ 12:58:26.026
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=16ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 12:58:26.026
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=20ms, Records=2) in /root/website/actions/adstatus.cfm @ 12:58:26.026
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 @ 12:58:26.026
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=19ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 12:58:26.026
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=24ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 12:58:26.026
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=28ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 12:58:26.026
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 @ 12:58:26.026
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=30ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 12:58:26.026
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 12:58:27.027
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=17ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 12:58:27.027
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()
get_bookclub_by_id (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_admin_get_bookclub_by_id.cfm @ 12:58:27.027
select bookclub_number, bookclub_name, bookclub_title, bookclub_summary, bookclub_interview, bookclub_image, bookclub_entry_dt, bookclub_display_flag
	from bookclubs
	where bookclub_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 32

get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=20ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 12:58:27.027
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1
and getdate() <= dateadd(day,1,a.arc_off_ad_dt)

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=17ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 12:58:27.027
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=34ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 12:58:27.027
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=18ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 12:58:27.027
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=26ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112
Parameter #3(CF_SQL_VARCHAR) = 0
Parameter #4(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=32ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 12:58:27.027
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/featured-bookclubs/archives/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFTOKEN=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14; CFID=4101050; CFGLOBALS=urltoken%3DCFID%23%3D4101050%26CFTOKEN%23%3Dce5a70615efd2c04%2D20A00057%2DE2C8%2D0294%2DBE1E0F419B595F14%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2012%3A58%3A26%27%7D%23hitcount%3D118%23timecreated%3D%7Bts%20%272026%2D06%2D01%2012%3A57%3A59%27%7D%23cftoken%3Dce5a70615efd2c04%2D20A00057%2DE2C8%2D0294%2DBE1E0F419B595F14%23cfid%3D4101050%23; FREEACCESSCOUNT=0; 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/32
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=4101050
cftoken=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
hitcount=121
lastvisit={ts '2026-06-01 12:58:26'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 12:57:59'}
urltoken=CFID=4101050&CFTOKEN=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
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#=4101050&CFTOKEN#=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14#lastvisit={ts '2026-06-01 12:58:26'}#hitcount=118#timecreated={ts '2026-06-01 12:57:59'}#cftoken=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14#cfid=4101050#
CFID=4101050
CFTOKEN=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
FREEACCESSCOUNT=0
Session Variables:
cfid=4101050
cftoken=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
sessionid=BOOKBROWSE_4101050_ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
urltoken=CFID=4101050&CFTOKEN=ce5a70615efd2c04-20A00057-E2C8-0294-BE1E0F419B595F14
URL Parameters:
bookclub_number=32
Debug Rendering Time: 7 ms