Literary Quizzes, Games & Much More

Literary Fun!

Free Sample Issue:

July 30, 2025

Read Issue

Support BookBrowse

Become a Member
and discover exceptional books!

Join Today!

Who Said...

A library is a temple unabridged with priceless treasure...

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

Win Free Books

Sorry, we don't have a giveaway active at this time.

Please check back later!

Why Do We Say...

You can't go home again

Click Here to find out the origins of this well-known expression, and many others!

  • Discuss this book
    Book Jacket

    Birdie Rhodes was only thirteen when legendary modeling agent Harriet Goldman discovered her in a ...

    Join the discussion!

More Discussions

  1.  The Cover Girl:
    Amy Rossi

All Discussions

Discover the Reader Within

Take our fun quiz to discover your true reading personality

Take the quiz

Discover your next great read here.We're readers just like you.

Word Play

Solve this clue:

W the C A the M W P

and be entered to win..

Did You Know?

The Booth Family and Shakespeare in the 19th Century United States

Karen Joy Fowler's Booth features several characters who are Shakespearean actors, starting with Junius Brutus Booth, who was born in England in 1796 and emigrated to the United States in 1821. He managed the Adelphi Theatre in Baltimore in the 1830s and also toured internationally, becoming very well-known in the U.S. and abroad. All told, he featured in almost 3,000 stage performances. His son Edwin would go on to be lauded as one of the greatest American actors of the 19th century, especially noted for his role as Hamlet. Older son Junius Booth Jr. was an actor in his own right, as well as ...
Learn More
Author Pronunciations

Guidance on how to pronounce those tricky author names

The pronunciation of each author's name has been verified by the author's publisher. If you are the author, or personally familiar with the author, and disagree, please tell us. More pronunciations

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 /fun/index.cfm
Time Stamp 31-May-26 07:45 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
1780256732510 ms 1.78025673251E+012 ms 1 /root/website/app_server.cfm
1865 ms 1865 ms 1 /root/website/fun/index.cfm
1631 ms 1631 ms 1 /root/website/fun/dsp_main.cfm
1242 ms 1242 ms 1 /root/website/site/blocks/dsp_article.cfm
87 ms 29 ms 3 /root/website/adsystem/adsystem_mod.cfm
83 ms 83 ms 1 /root/website/app_globals.cfm
53 ms 53 ms 1 /root/website/adzones/AdZone6.cfm
28 ms 28 ms 1 /root/website/adzones/AdZone5.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_active_obc.cfm
14 ms 4 ms 4 /root/website/actions/act_spider_tracker.cfm
14 ms 14 ms 1 /root/website/app_layout.cfm
12 ms 12 ms 1 /root/website/act_check_login.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_member_info.cfm
9 ms 9 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
7 ms 7 ms 1 /root/website/actions/adstatus.cfm
7 ms 7 ms 1 /root/website/adzones/showcase_track.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_current_competition.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.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/main_menu.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/articles/btb_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/mag/detail/act_free_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_news_for_rss_feed.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_promo_blocks.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1866 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 19:45:32.032
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=11ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 19:45:32.032
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=7ms, Records=2) in /root/website/actions/adstatus.cfm @ 19:45:32.032
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 @ 19:45:32.032
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=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 19:45:32.032
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=3ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 19:45:32.032
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=2ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 19:45:32.032
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 @ 19:45:32.032
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=6ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 19:45:32.032
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 19:45:32.032
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=14ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 19:45:32.032
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_random_author (Datasource=bookbrowse_com_new, Time=84ms, Records=4) in /root/website/fun/index.cfm @ 19:45:32.032
SELECT 		TOP 4 a.author_number, a.author_first_name + ' ' + a.author_last_name AS "author_full_name",
					b.author_info_image
	FROM 		authors a
	INNER JOIN 	author_info b ON b.author_number = a.author_number
	WHERE		datalength(b.author_info_image) > 1
	ORDER BY  	NEWID()
get_random_author_pronunciation (Datasource=bookbrowse_com_new, Time=50ms, Records=1) in /root/website/fun/index.cfm @ 19:45:32.032
SELECT 		TOP 1 a.author_number, a.author_first_name + ' ' + a.author_last_name AS "author_full_name", a.author_pronunciation,
					b.author_info_image
	FROM 		authors a
	INNER JOIN 	author_info b ON b.author_number = a.author_number
	WHERE		datalength(b.author_info_image) > 1
	AND			datalength(a.author_pronunciation) > 1
	ORDER BY  	NEWID()
get_freezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/fun/index.cfm @ 19:45:32.032
select		ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
		from		ezines
		where		ezine_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 643

get_news_for_rss_feed (Datasource=bookbrowse_com_new, Time=0ms, Records=10, Cached Query) in /root/website/queries/qry_get_news_for_rss_feed.cfm @ 19:45:32.032
SELECT TOP 10 *
    FROM news
	where news_item_dt <= getdate()
    ORDER BY news_item_dt DESC, news_item_number DESC
get_quotes (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/fun/dsp_main.cfm @ 19:45:32.032
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_expressions (Datasource=bookbrowse_com_new, Time=252ms, Records=1) in /root/website/fun/dsp_main.cfm @ 19:45:32.032
SELECT 		top 1 a.wordplay_puzzle_number, a.wordplay_puzzle_answer
    
        FROM 		wordplay_puzzles a
        INNER JOIN	wordplay_puzzle_mapping b on b.wordplay_puzzle_number = a.wordplay_puzzle_number
        INNER JOIN	wordplays c on b.wordplay_number = c.wordplay_number
        
        WHERE 		datalength(a.wordplay_puzzle_meaning) > 1
        AND			getdate() > (	select		top 1 z.wordplay_dt 
                                    FROM		wordplay_puzzles x
                                    inner join	wordplay_puzzle_mapping y on y.wordplay_puzzle_number = x.wordplay_puzzle_number
                                    inner join	wordplays z on z.wordplay_number = y.wordplay_number
                                    where		x.wordplay_puzzle_number = a.wordplay_puzzle_number
                                    order by	z.wordplay_expiration_dt DESC)
        
        ORDER BY	newid()
get_messagecount (Datasource=booktalk_new, Time=27ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 19:45:33.033
select sum(messages) as "messagecount"
			from booktalk_threads
			where forumidfk = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 0

get_ads (Datasource=bookbrowse_com_new, Time=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:33.033
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=20ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:33.033
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 @ 19:45:33.033
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_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:33.033
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) = adzone5
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=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:33.033
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) = adzone5
Parameter #2(CF_SQL_INTEGER) = 1112

get_article (Datasource=bookbrowse_com_new, Time=1232ms, Records=1) in /root/website/site/blocks/dsp_article.cfm @ 19:45:34.034
SELECT		top 1 d.book_number, d.book_title, ezine_boxed_content, ezine_boxed_content_title
	FROM		ezines a
	INNER JOIN  ezine_edition_mapping b on a.ezine_number = b.ezine_number
	INNER JOIN 	editions c on  c.edition_number = b.edition_number
	INNER JOIN	books d on d.book_number = c.book_number

	WHERE	datalength(ezine_boxed_content_title) > 0
	AND		a.ezine_active_flag = 1
	AND		a.ezine_dt > dateadd(year, -5, getdate())
	AND		ezine_edition_mapping_number IN (
								SELECT		top 1 ezine_edition_mapping_number 
								FROM		ezine_edition_mapping x 
								INNER JOIN 	editions y on  y.edition_number = x.edition_number
								INNER JOIN	books z on z.book_number = y.book_number
								WHERE	y.book_number = d.book_number
								ORDER BY ezine_edition_mapping_number DESC
								)
    ORDER BY NEWID()
check_editors_choice (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/articles/btb_udfs.cfm @ 19:45:34.034
SELECT 	count(*) as "count"
	    FROM 	books
	    WHERE 	book_number = ?
	    AND		book_number IN (SELECT		top 4 a.book_number
	                            FROM		editors_choice a 
	                            WHERE		editors_choice_dt < getdate()
	                            ORDER BY	editors_choice_dt DESC)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4410

check_free_ezine (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/articles/btb_udfs.cfm @ 19:45:34.034
SELECT 		count(*) as "count"
	    FROM    	ezine_edition_mapping AS a
	    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
	    INNER JOIN	editions c ON c.edition_number = a.edition_number
	    WHERE 		c.book_number = ?
		AND			ezine_edition_free_review_flag = 1
		AND			dateadd(ww,4,b.ezine_dt) > getdate()
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4410

check_cat_73 (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/articles/btb_udfs.cfm @ 19:45:34.034
SELECT 		count(*) as "count"
	    FROM    	books AS b
	    INNER JOIN 	category_book_mapping AS c ON c.book_number = b.book_number
	    WHERE 		b.book_number = ?
		AND			c.category_number = 73
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4410

check_old_ezine (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/articles/btb_udfs.cfm @ 19:45:34.034
SELECT 		count(*) as "count"
	    FROM    	ezine_edition_mapping AS a
	    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
	    INNER JOIN	editions c ON c.edition_number = a.edition_number
	    WHERE 		c.book_number = ?
		AND			datediff(mm,b.ezine_dt,getdate()) > 12
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4410

get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 19:45:34.034
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:34.034
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:34.034
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 19:45:34.034
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/fun/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFID=4072750; CFGLOBALS=urltoken%3DCFID%23%3D4072750%26CFTOKEN%23%3Da29c66d5bafe32cc%2DFBB33C18%2DA053%2DC055%2D6301FA12924B4E53%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2019%3A45%3A32%27%7D%23hitcount%3D12%23timecreated%3D%7Bts%20%272026%2D05%2D31%2019%3A45%3A30%27%7D%23cftoken%3D25a80ee697fa70fb%2DFBB336D6%2D9171%2D0C03%2D629315F1F2FF901B%23cfid%3D4072749%23; CFCLIENT_BOOKBROWSE=next%5Furl%3Dhttps%3A%2F%2Fdev%2Ebookbrowse%2Ecom%2Freadinglists%2Findex%2Ecfm%23order%3Dp%23member%5Factive%5Fflag%3D0%23member%5Fnumber%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFTOKEN=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
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=
PATH_TRANSLATED=/root/website/fun/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/fun/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=4072749
cftoken=25a80ee697fa70fb-FBB336D6-9171-0C03-629315F1F2FF901B
hitcount=23
lastvisit={ts '2026-05-31 19:45:34'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
next_url=https://dev.bookbrowse.com/readinglists/index.cfm
order=p
timecreated={ts '2026-05-31 19:45:30'}
urltoken=CFID=4072750&CFTOKEN=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
view=books
Cookie Variables:
CFCLIENT_BOOKBROWSE=next_url=https://dev.bookbrowse.com/readinglists/index.cfm#order=p#member_active_flag=0#member_number=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4072750&CFTOKEN#=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53#lastvisit={ts '2026-05-31 19:45:32'}#hitcount=12#timecreated={ts '2026-05-31 19:45:30'}#cftoken=25a80ee697fa70fb-FBB336D6-9171-0C03-629315F1F2FF901B#cfid=4072749#
CFID=4072750
CFTOKEN=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
Session Variables:
cfid=4072750
cftoken=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
sessionid=BOOKBROWSE_4072750_a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
urltoken=CFID=4072750&CFTOKEN=a29c66d5bafe32cc-FBB33C18-A053-C055-6301FA12924B4E53
Debug Rendering Time: 7 ms