BookBrowse Privacy Statement

BookBrowse.com has created this privacy statement in order to demonstrate our firm commitment to privacy. The following explains the information gathering and dissemination practices for this website.

GDPR
On May 25, 2018, the European Union implemented the General Data Protection Regulation (EU GDPR). Similar legislation has also been passed in the United Kingdom. Although this law only effects EU companies or visitors from the EU, we collect and use your personal information within that framework.

CCPA
The California Consumer Privacy Act (CCPA) took effect on January 1st, 2020. This new privacy law also requires businesses to fully disclose how they treat consumer's personal information. The law was passed specifically to address privacy concerns for companies that sell customer data; as BookBrowse does not sell any customer data, it is not directly effected by the CCPA. However, where possible, we have adopted processes to comply with the CCPA.

We have provided a brief summary on the GDPR here.
Specific rights accorded to you by the CCPA can be found here.
Our terms of service can be found here.

Purpose and Data Minimization

BookBrowse is an online magazine for booklovers - including reviews, previews,
"beyond the book" articles, author interviews, and reading guides.
We collect and use your personal information with your approval, and within the privacy frameworks such as the CCPA, the European Union General Data Protection Regulation (EU GDPR), and the legislation of the United Kingdom related to data protection.



Personal Information

When you visit BookBrowse.com, certain information is collected automatically through cookies and tracking technologies, including your IP address, browser type, device information, and browsing behavior on our site. This information may be considered personal information under applicable privacy laws. Additional personal information is only collected when you explicitly provide it, such as when creating an account or subscribing to a newsletter.

Members
In the case of members, we store basic contact information required to provide the services you have requested. Specifically this includes your name, address, email, telephone number (if supplied). We do not store your credit card information.

If you use the "My Reading Lists" feature, we store your reading lists.

Library Patrons & Staff
BookBrowse has no access to any information about individuals visiting BookBrowse via a library subscription. Patrons and staff access in one of three ways: IP recognition within a library building; library authentication (such as EZ-Proxy); or authentication by BookBrowse of the visitor's library card number, this authentication process is based on the parameters of the library card number (e.g. 14 digits starting with 32124), and the library card number entered is not stored.

Newsletter Subscribers
If you subscribe to one of our free newsletters, we use a third-party email host for mailings, so your name and email address are not stored on BookBrowse at all but instead are securely stored at our email host, Beehiiv. You can unsubscribe to any of our emails, or manage your subscriptions, by going to our subscriptions page. Newsletter services at newsletters.bookbrowse.com are hosted by Beehiiv and are subject to Beehiiv's own privacy policy.

Competitions and Giveaways Email addresses collected when people enter BookBrowse giveaways, quizzes or take part in surveys are used only to select the winning names unless explicitly stated otherwise (for example, if a giveaway offers the opportunity to receive information from a publisher, the email address and first name of those who choose to opt-in will be provided to the publisher.)

If you win a book in a giveaway, or are a member and request a book to read for either our First Impressions or Book Club program, we will give your name and mailing address to the publisher as part of the mailing list for the book but always with explicit instructions that the list is to be used only to mail the specific book to the specific people listed, and is not to be stored for future use. From time to time the books being mailed may be e-books, in which case we would provide your first name and email address to the publisher, with the same explicit instruction that the list is only to be used for the one-time mailing.


Financial Information

We make every effort to protect BookBrowse from malicious attack, and comply with industry best practices and standards such as Payment Card Industry (PCI) Security Standards.

We do not store any credit card information on BookBrowse - it is passed directly to our payment processor, Paypal.

For common questions about internet security, and some of BookBrowse's specific security, please click here .


Cookies and Tracking Technologies

BookBrowse (like the majority of websites) uses "cookies," pixels, and other tracking technologies. When you visit us, BookBrowse's server sends a tiny file (cookie) to your computer containing a sequence of letters and numbers. This is stored on your computer in a special folder for cookies.

If you visit BookBrowse again, your computer will check its files to see if a cookie matches, and if so it will send this little file back to BookBrowse, so that you are recognized as a returning visitor. First-party cookies set by BookBrowse are used for site operation and do not track your visits to other websites.

In addition to our own cookies, we use third-party analytics and advertising cookies and pixels from partners including Google, Meta (Facebook), Reddit, and others. Information collected through these cookies and other tracking technologies may be shared with third parties for purposes including analytics, advertising, and campaign measurement. These third-party technologies may collect identifiers such as IP addresses, browser information, and browsing behavior on our site, which may be considered personal information under applicable privacy laws.

You can manage your cookie preferences at any time using the "Cookie Settings" link in our website footer, or by clicking "Reject Non-Essential" on the cookie banner displayed when you first visit.

The cookies used by BookBrowse fall into the following categories:

1) Website Operation
Information essential in order to enable you to move around the website and use its features, such as (in the case of members) accessing secure areas of the website. Without these cookies, services you have asked for, such as managing your account information, cannot be provided. You cannot opt out of these cookies.

Strictly Necessary: These are essential for the operation of the website.

Cookie Name Originating Company Purpose
cfid
cftoken
BookBrowse Website Operation


User Selected: These are applied if the you interact with the website.
Cookie Name Originating Company Purpose
bpop BookBrowse Records if you have been offered to subscribe to our newsletter
ck_priv BookBrowse Manages display of privacy alert.


2) Performance
We collect information about how visitors use BookBrowse, for instance which pages visitors go to most often. These cookies don't collect information that identifies a visitor individually; all information is aggregated and therefore anonymous; it is only used to improve how BookBrowse works.

BookBrowse uses the following third-party cookies to track website useage and performance.

Cookie Name Originating Company Purpose Opting Out
_ga
_gid
_gat
Google These cookies allow us to count user visits and traffic sources so that we can measure and improve the site performance using Google Analytic services. Click here to opt-out of Google Analytics
_rdt_uuid Reddit These cookies help Reddit track user interactions on the site (when coming from reddit) and deliver personalized content and ads to improve user experience. Click here to opt-out of Reddit cookie tracking
_fbp Facebook This cookie is used by Facebook to deliver a series of advertisement products such as real-time bidding from third-party advertisers. Click here to opt-out of Facebook cookie tracking
__stripe_mid
__stripe_sid
Stripe These cookies are essential for the payment processing services provided by Stripe and are used to prevent fraud. Click here to view Stripe's cookie policy
ph_* PostHog These cookies are used for website analytics, including tracking page views, user sessions, and site performance. Click here to view PostHog's privacy policy
_gcl_* Google These cookies are used by Google Ads to track conversions and measure the effectiveness of advertising campaigns. Click here to manage Google Ads settings


Data Protection Declaration for the Use of Google Analytics as a Web Analysis Tool

This website uses Google Analytics, a web analysis service of Google Inc. ("Google", 1600 Amphitheatre Parkway Mountain View, CA 94043, USA). The information about your visit produced by cookies are transmitted to a Google Server in the United States and stored there. In case of IP-anonymisation on our website, your IP address is shorted by Google within EU members States or other contracting States of the European Economic Area prior to transmission.

In exceptional cases, the full IP address is transmitted to a Google Server in the US and shorted there. Google will use this information to assess your use of the website, compile reports on website activities and render other services connected to website and internet use. The IP address transmitted by your browser within the service of google Analytics will not be connected to other Google data.


Advertising

Occasionally publishers running ads on BookBrowse use third-party advertising companies to serve their ads. If you click on these ads, the advertiser may then use cookies to track your visits to their and other websites in order to provide ads that may be of interest to you. If you would like more information about this practice, or you would like to opt out from having your data collected by some advertising networks, visit the DAA opt-out program (currently available at http://www.aboutads.info/choices/) or the NAI opt out program (currently available at http://www.networkadvertising.org/choices/).

European visitors may wish to visit the EDAA opt-out program (currently available at http://www.youronlinechoices.eu/).


Tell-A-Friend

Visitors sometimes wish to tell a friend about a particular page at BookBrowse, or send themselves a reminder. For this reason, like many other websites, BookBrowse provides a convenient 'tell-a-friend' tool that allows you to send a personal message to a friend telling them about BookBrowse.

Email addresses are used only to send this one-time message, and are not stored or recorded by BookBrowse in any way.


"My Reading List"

Members have the option of creating and storing book lists on BookBrowse - for example to keep track of books read and to read. Members can also record their personal thoughts on these books. At this time, member reading lists can only be viewed by the individual member when that member is logged in. They are not available to the general public to view at all. Some members have requested that BookBrowse provide the ability for lists to be made public - either so that the member can provide access to specific people or so that their lists are freely available to all internet users. At the moment BookBrowse does not allow this, but if we were to in the future, the default setting would be that a list remains private unless an individual member specifically opts to make his or her list(s) public.


Information Provided by Third Parties

Third Party Content
BookBrowse contains a considerable amount of information provided by third parties, including, but not limited to, advertising, excerpts, reviews, interviews, book summaries and text links. As such, content at BookBrowse.com does not necessarily represent the views of the owners of BookBrowsers LLC and is not endorsed by us.

Third Party Links
This site contains links to other sites, including but not limited to, banner advertising and text links. BookBrowsers LLC is not responsible for the privacy practices or the content of any third party sites, and a link to a third party site should not be seen as an endorsement by BookBrowse of that site.

The "Buy This Book" links contain affiliate information, which means BookBrowse may receive a small commission if you purchase the book using these links. For example, as an Amazon Associate BookBrowse earns from qualifying purchases at Amazon.



Security

While no online service is 100% secure, we work very hard to protect information about you against unauthorised access, use, alteration, or destruction, and take reasonable measures to do so.

As has been described, we do not store credit card information at BookBrowse. Your passwords are encoded, and not readable by us. The entire website is secured using HTTPS, meaning all communications between your browser and the website are encrypted. And finally, we comply with the Credit Card Industry PCI guidelines, which provides a long list of security requirement to minimise the risk of unauthrixed data access.



Your Rights

Under both the CCPA and the EU GDPR and at any time, you have the right to address the controller or our data processing officer and request information on how your data is stored and used. You also have a right to rectification of your data. Or you can have the processing restricted, meaning a right to have processing limited to parts of your data.

At any time, you may object to the processing of your personal data. When you do so, we will check whether there are any conflicting legal transmitting and processing obligations and inform you accordingly. You also have a right to data portability, meaning that we hand over your data in a structured, commonly used and machine-readable format determined by us upon your request.

You may also request that we delete your personal data.

In addition, if you feel that we do not treat your personal data properly and as laid out in this Policy, you have a right to complain to the supervisory authority responsible for your country.

When you've given your consent to the processing of your data you may, of course, revoke your consent at any time.

If you receive emails from us, you also have a right to object at any time so that we stop sending you emails.

Name of the controller:
BookBrowsers LLC (Limited Liability Company)

Chief Executive Officer:
Nick Stager
BookBrowsers LLC
88 White Horse Rd,
Plymouth, MA 02360
E-Mail: info@bookbrowse.com

Data Protection Officer:
Nick Stager
BookBrowsers LLC
88 White Horse Rd,
Plymouth, MA 02360
E-Mail: privacyofficer@bookbrowse.com



Scope

This privacy statement applies to bookbrowse.com and community.bookbrowse.com, which share the same privacy practices. Newsletter services at newsletters.bookbrowse.com are hosted by Beehiiv and are subject to Beehiiv's privacy policy.


Contacting BookBrowse.com

If you have any questions about this privacy statement, the practices of this site, or your dealings with this website, please contact us.


Last updated April 2026

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

Use what talents you possess: The woods would be very silent if no birds sang there except those that sang best

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 /privacy/index.cfm
Time Stamp 31-May-26 06:29 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
1780252153938 ms 1.78025215394E+012 ms 1 /root/website/app_server.cfm
105 ms 105 ms 1 top level /root/website/privacy/index.cfm
49 ms 49 ms 1 /root/website/app_layout.cfm
36 ms 36 ms 1 /root/website/app_globals.cfm
31 ms 31 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
21 ms 11 ms 2 /root/website/adsystem/adsystem_mod.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_active_obc.cfm
12 ms 12 ms 1 /root/website/adzones/AdZone6.cfm
11 ms 11 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
10 ms 10 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
9 ms 9 ms 1 /root/website/adzones/showcase_track.cfm
5 ms 5 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
4 ms 4 ms 1 /root/website/actions/adstatus.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_competition.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
2 ms 2 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/information/dsp_privacy.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/queries/qry_get_member_info.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/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_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
6 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
111 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

get_member_info (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 18:29:13.013
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=2ms, Records=2) in /root/website/actions/adstatus.cfm @ 18:29:13.013
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 @ 18:29:13.013
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=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 18:29:13.013
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=2ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 18:29:13.013
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 18:29:13.013
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 @ 18:29:13.013
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=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 18:29:13.013
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=4ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 18:29:13.013
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=4ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 18:29:13.013
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_arcs_for_ad (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 18:29:14.014
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=4ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 18:29:14.014
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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 18:29:14.014
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 18:29:14.014
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 18:29:14.014
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=4ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 18:29:14.014
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=1ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 18:29:14.014
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 18:29:14.014
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 18:29:14.014
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 @ 18:29:14.014
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/privacy/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=
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=http://dev.bookbrowse.com/privacy/
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/privacy/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/privacy/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=4071338
cftoken=278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
hitcount=1
lastvisit={ts '2026-05-31 18:29:13'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 18:29:13'}
urltoken=CFID=4071338&CFTOKEN=278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
view=books
Cookie Variables:
CFID=4071338
CFTOKEN=278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
Session Variables:
cfid=4071338
cftoken=278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
sessionid=BOOKBROWSE_4071338_278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
urltoken=CFID=4071338&CFTOKEN=278b506d335ae08d-F8F8F358-DDB1-10A2-F5C7190226C4EEFF
Debug Rendering Time: 7 ms