What do readers think of Where Monsters Dwell by Jørgen Brekke? Write your own review.

Summary | Reviews | More Information | More Books

Where Monsters Dwell by Jørgen Brekke

Where Monsters Dwell

by Jørgen Brekke

  • Critics' Consensus (4):
  • Readers' Rating (45):
  • Published:
  • Feb 2014, 368 pages
  • Rate this book

About this book

Reviews

Page 3 of 3
There are currently 24 reader reviews for Where Monsters Dwell
Order Reviews by:

Write your own review!

Juliet F. (Clarendon Hills, IL)

Excellent! Da Vinci Code-esque, but much smarter and darker
I really enjoyed this book! It was very suspenseful and fun to read. The plot lines span Norway in the 1500's to modern-day Norway and Richmond, Virginia. Eventually the lines weave together, revealing an intriguing tale of serial killing in the setting of rare, historical book collecting.
I especially liked the cast of characters. It was interesting that as the plot got more twisted and dire, the two main characters experience sort of re-birth out of prior personal traumas. It made for a more uplifting and hopeful tone than I usually expect from a Scandinavian author. Very good book!
Joe S. (Port Orange, FL)

An exciting and enjoyable read.
As an avid reader of Scandinavian mysteries, I looked forward to reading this book and found it to be an enjoyable read and hard to put down. The book switches from the sixteenth century to the present and back but the changes are well handled and were not at all confusing to me. Historically, the book has been well researched. The characters are interesting and well developed but a little too complex. Every one of them has a troubled past. The The American and Norwegian detectives obviously connect from their first meeting but the intensity of the relationship appears to increase too rapidly for the short time that they are together. Overall, I enjoyed the book and hope to see more from this author.
Wendy E. (Mechanicsville, VA)

Transcending time and space
There are a lot of layers to this mystery that spans centuries and continents. We get to know several characters, both in the present and past. While is seemed that this might be the second in the series, all the pertinent information was slowly revealed about the characters' backstories. In a sense this is a mystery on several levels - the good guys, the bad guys, the history, the old and new murders, and the motives. Once it is all pieced together, the puzzle is a gruesome one!
Colleen L. (Casco, ME)

Excellent Debut...
"Where Monsters Dwell" is an solid debut from Norwegian author Jorgen Brekke. Two gruesome murders occur - one in Richmond, VA and the other in Trondheim, Norway. Both of them are linked; although, it does take a while before investigators tumble to that fact.

I really enjoyed the novel. The author does a good job keeping you guessing as to whom the culprit is. What I enjoyed more, however, was the historical information presented pertaining to 15th Century dissections. The author jumps between historical perspectives which makes the story more interesting and enables the reader to gain a clearer perspective of the famous Johannes Book. It did get a bit confusing at times when it jumped back into Felicia's background and then into present which is why I didn't mark the book higher.

All in all, though, this is a book that captures your attention. Once you start reading, it is difficult to stop. You find yourself saying "just one more chapter" as you get closer to finding out who the killer is.

I hope this author continues to write other books as he has an excellent first start.
Monica G. (San Antonio, TX)

Definitely Not For the Squeamish
Two gruesome murders of an almost identical nature that occur almost simultaneously would normally lead a good investigator to the belief that only one killer is responsible, but what happens when the two murders occur in two vastly different locations? Can the same killer be responsible for both? This is the premise of Where Monsters Dwell by Jorgen Brekke.

Homicide detective Felicia Stone from Virgina and Odd Singsaker from Trondheim, Norway, eventually come together to unravel the mystery of the murders and find not only similarities in the killings, but a common theme to both murders involving a rare book from the 1500's.

The novel is written in two different narratives, one set in the 1500's and one set in the current time and the reader moves back and forth between circumstances in the 1500's that shed light on why these murders may be connected now.

The first part of the book was a little hard to get through for me but about a third of the way in, the story picked up and moved easily from there.

Characters are well formed, if a little clunky, and the story is well thought out. I think the translation was commendable and helped keep the storyline flowing well between periods.

There are lots of red herrings but I think it's pretty easy to figure out "who done it", maybe not so easy to figure out why. Overall, this is a solid mystery with a solid plotline and likeable characters. I hope detectives Stone and Singsaker continue to work together in future novels. On a side note, if 1/2 stars were available, I would rate this book at 3 and a 1/2 stars.
Marcy C. (Minneapolis, MN)

Where Monsters Dwell
I was unimpressed by this book. I found it to be far more macabre than suspenseful. Much of the dialogue was very unnatural and the language was very redundant - words like, laugh or laughter must have been used well over 500 times and the subject was not in the least funny. I didn't care for the characters, especially the females, Felicia, and Silvia - they were not believable characters. And the crime committed against the murder's wife didn't seem possible to execute (literally) based on the logistics of the setting where the crime was committed. Although I thought this was a very mediocre book, it might appeal to those who enjoyed "Girl with the Dragon Tattoo" - it is not as compelling of a story but it would may be of interest to those who like suspenseful novels. I would not recommend it for my book club to read - it was not that thought provoking.
Nona F. (Evanston, IL)

I really wanted to like this more
I really was eager to read this book because the premise of related historical/contemporary crimes is one of my favorite narrative devices, and to have it revolve around a book was like hot fudge on top of a sundae. Things seemed very promising since the book starts with one of the most exciting openings that I have read in the recent past. However, the narrative is extremely choppy with two contemporary story lines as well as the historical one, and there are time shifts within each of the 3 narrative lines. The pacing of the book is also uneven, slow and drawn-out in the first 200 pages or so, then rushed in the last parts. Characters are presented rather than developed; the most interesting character is peripheral to the narrative. Some good ideas, but clearly a first time author in terms of execution.
Power Reviewer
Lee M. (Creve Coeur, MO)

A Tale of Evil
Two intriguing mysteries, seperated by centuries, but connected. Grisly descriptions. Author employes far too many 'tricks of the trade,' like skipping back and forth from character to character, century to century, end before beginning, when the stories were more than adequate to capture readers. I awarded the one star for the breadth of the undertaking rather than the execution.
  • Page
  • 1
  • 2
  • 3

More Information

Read-Alikes

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

Great political questions stir the deepest nature of one-half the nation, but they pass far above and over the ...

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 /reader_reviews/index.cfm
Time Stamp 01-Jun-26 11:36 AM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780313769163 ms 1.78031376916E+012 ms 1 /root/website/app_server.cfm
761 ms 761 ms 1 /root/website/reader_reviews/index.cfm
153 ms 153 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
142 ms 142 ms 1 /root/website/app_layout.cfm
115 ms 115 ms 1 /root/website/app_globals.cfm
109 ms 109 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
67 ms 67 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
65 ms 65 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
50 ms 25 ms 2 /root/website/adsystem/adsystem_mod.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_active_obc.cfm
43 ms 43 ms 1 /root/website/reader_reviews/dsp_briefshell.cfm
43 ms 43 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
34 ms 34 ms 1 /root/website/adzones/showcase_track.cfm
32 ms 32 ms 1 /root/website/reader_reviews/dsp_reviews.cfm
30 ms 30 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_current_competition.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
18 ms 18 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
16 ms 16 ms 1 /root/website/adzones/AdZone6.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_obc_number.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm
10 ms 10 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
8 ms 3 ms 3 /root/website/actions/act_spider_tracker.cfm
7 ms 7 ms 1 /root/website/actions/adstatus.cfm
4 ms 4 ms 1 /root/website/site/blocks/layout/main_menu.cfm
3 ms 3 ms 1 /root/website/act_check_login.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_preview_awards_by_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_top_brief_block.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/reader_reviews/dsp_views.cfm
0 ms 0 ms 1 /root/website/site/blocks/act_book_view_tracking.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
762 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 11:36:09.009
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 @ 11:36:09.009
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=6ms, Records=2) in /root/website/actions/adstatus.cfm @ 11:36:09.009
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 11:36:09.009
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 @ 11:36:09.009
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=15ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:36:09.009
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=6ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 11:36:09.009
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 11:36:09.009
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=21ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 11:36:09.009
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=8ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 11:36:09.009
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=13ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 11:36:09.009
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_book_number (Datasource=bookbrowse_com_new, Time=41ms, Records=1) in /root/website/reader_reviews/index.cfm @ 11:36:09.009
SELECT 	ezine_preview_bb_link, ezine_preview_title
		FROM 	ezine_previews
		WHERE 	ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_reader_reviews_power_reviewers (Datasource=bookbrowse_com_new, Time=0ms, Records=50, Cached Query) in /root/website/queries/qry_get_reader_reviews_power_reviewers.cfm @ 11:36:09.009
SELECT 		top 50 reader_review_reviewer_email_address, count(reader_review_reviewer_email_address) as "count"
	FROM 		reader_reviews
	WHERE 		reader_review_reviewer_email_address like '%@%'
	AND 		reader_review_reviewer_email_address <> 'reviews@bookbrowse.com'
	GROUP BY 	reader_review_reviewer_email_address
	
	
	ORDER BY 	count desc
get_preview_by_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 11:36:09.009
select 			a.ezine_preview_number,
				a.ezine_number, 
				a.ezine_preview_category_number, 
				a.ezine_preview_title, 
				a.ezine_preview_subtitle, 
				a.ezine_preview_author, 
				a.ezine_preview_publisher,
				a.ezine_preview_publish_dt,
				a.ezine_preview_number_of_pages, 
				a.ezine_preview_jacket_image,
				a.ezine_preview_reviews,
				a.ezine_preview_short_summary,
				a.ezine_preview_jacket_desc,
				a.ezine_preview_reading_guide,
				a.ezine_preview_bb_comments, 
				a.ezine_preview_isbn,
				a.ezine_preview_isbn13,
				a.ezine_preview_rating,
				a.ezine_preview_bb_link,
                a.ezine_preview_bb_author_link,
                a.ezine_preview_firsts_flag,
                a.ezine_preview_reading_level,
                a.ezine_preview_paperback_flag,
				b.*,
                c.ezine_dt, c.ezine_description
,(select publisher_holding_company from publishers where ezine_preview_publisher like publisher_imprint AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
 				
from ezine_previews a 
inner join ezine_preview_categories b ON b.ezine_preview_category_number = a.ezine_preview_category_number
left join ezines c ON c.ezine_number = a.ezine_number

where ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 11:36:09.009
select a.book_award_number, a.book_award_name, a.book_award_image, c.book_award_dt
    from book_awards a 
    inner join book_awards_category b on b.book_award_number = a.book_award_number
    inner join book_awards_mapping c on c.book_awards_category_number = b.book_awards_category_number
    where ezine_preview_number =  ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=64ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 11:36:09.009
SELECT	(CAST(AVG(CAST(rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) >= 50 AND right(CAST(AVG(CAST(rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
			ELSE 0
			END) AS "avrating",
            count(rating) as "ratcount"
            
	FROM (
		SELECT reader_review_rating AS rating
		FROM reader_reviews
		WHERE ezine_preview_number = ?
		
		AND reader_review_rating > 0
		
		UNION ALL
		
		SELECT reading_list_book_rating AS rating
		FROM reading_lists
		WHERE book_number LIKE 'p%'
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) = ?
		AND reading_list_book_rating > 0
		AND TRY_CAST(SUBSTRING(book_number, 2, LEN(book_number)) AS INT) IS NOT NULL
	) combined_ratings
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995
Parameter #2(CF_SQL_INTEGER) = 8995

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=108ms, Records=24) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 11:36:09.009
SELECT 		a.reader_review_number, a.book_number, a.ezine_preview_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.ezine_preview_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    FROM 		reader_reviews a
    INNER JOIN	ezine_previews b ON a.ezine_preview_number = b.ezine_preview_number
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number
	WHERE 		a.ezine_preview_number = ?
    AND			a.book_number = 0
    AND 		a.reader_review_approved_flag = 1
    

	ORDER BY a.reader_review_rating DESC, a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_arc_idfk (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 11:36:09.009
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8995

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 11:36:09.009
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_number = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1 AND a.discourse_flag = 0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 8995

obc_discussions (Datasource=booktalk_new, Time=114ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 11:36:09.009
SELECT 		t.name,
                m.title, m.body,
                u.username, t.id,
				(SELECT COUNT(*) from booktalk_messages where threadidfk = t.id) AS	"responses"
                
    FROM 		booktalk_forums f
    INNER JOIN	booktalk_threads t on t.forumidfk = f.id
    INNER JOIN	booktalk_messages m on m.posted = t.lastpostcreated
    INNER JOIN	booktalk_users u on u.id = m.useridfk
    
    WHERE 	f.id = ?
    AND 	f.active = 1
	AND		t.active = 1
    
    ORDER BY t.name, t.messages DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) =

searchResults (Datasource=bookbrowse_com_new, Time=24ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 11:36:09.009
SELECT book_number, post_id, topic_id, blurb, username, topic_title
					FROM DiscourseSearchResults
					
        WHERE 		book_number = ? 
                    AND topic_id IS NOT NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p8995

ya_check (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 11:36:09.009
select ezine_preview_reading_level 
from ezine_previews 
where ezine_preview_number = ?
and ezine_preview_reading_level = 2
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_books_by_brief (Datasource=bookbrowse_com_new, Time=12ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 11:36:09.009
select 			top 20
				a.ezine_preview_reading_level,
				b.category_name,
				c.category_number, 
				d.book_number, d.book_title,
				f.author_number, f.author_first_name, author_middle_initial, author_last_name
				
from 			ezine_previews a 
inner join		categories b on b.ezine_preview_category_number = a.ezine_preview_category_number
inner join		category_book_mapping c on c.category_number = b.category_number
inner join		books d on d.book_number = c.book_number
inner join		book_author_mapping e on e.book_number = d.book_number
inner join		authors f on f.author_number = e.author_number

where			a.ezine_preview_number = ? 

order by 		d.book_number DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 8995

get_author_bookcount (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 11:36:09.009
select		b.book_title as "title", 1 as "bb_flag", b.book_number as "number"
        from		book_author_mapping a
		inner join	books b on b.book_number = a.book_number
        where		a.author_number = ?
union
    	select		c.ezine_preview_title as "title", 0 as "bb_flag", c.ezine_preview_number as "number"
        from		ezine_previews c
        where		c.ezine_preview_bb_author_link = ?
        and			c.ezine_preview_bb_link = 0
		and 1=0
order by title DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0
Parameter #2(CF_SQL_INTEGER) = 0

get_obc_number (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_obc_number.cfm @ 11:36:09.009
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 8995.0

IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'fallahj1@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'borofolks@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'readtome@clearwire.net'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'clahey@maine.rr.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'moniraq@yahoo.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'chamber210@aol.com'
IsPowerReviewer (Datasource=, Time=0ms, Records=0) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'ncflores52@gmail.com'
IsPowerReviewer (Datasource=, Time=1ms, Records=1) in /root/website/reader_reviews/dsp_reviews.cfm @ 11:36:09.009
select *
			from get_reader_reviews_power_reviewers
			where reader_review_reviewer_email_address LIKE 'lee12336@yahoo.com'
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:36:09.009
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=15ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 11:36:09.009
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 @ 11:36:09.009
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:36:09.009
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:36:09.009
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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 11:36:09.009
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=16ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 11:36:09.009
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 11:36:09.009
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:36:09.009
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 11:36:09.009
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/reader_reviews/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=4097766; CFGLOBALS=urltoken%3DCFID%23%3D4097766%26CFTOKEN%23%3D14d9ffc97d387c5d%2D1DB25DD6%2DDF33%2D0400%2DC867973D970FE520%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2011%3A36%3A09%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D06%2D01%2011%3A36%3A07%27%7D%23cftoken%3D14d9ffc97d387c5d%2D1DB25DD6%2DDF33%2D0400%2DC867973D970FE520%23cfid%3D4097766%23; CFTOKEN=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520; 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=/ezine_preview_number/8995/page/3/order/bw/where-monsters-dwell
PATH_TRANSLATED=/root/website/reader_reviews/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/reader_reviews/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=4097766
cftoken=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
hitcount=2
lastvisit={ts '2026-06-01 11:36:09'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 11:36:07'}
urltoken=CFID=4097766&CFTOKEN=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
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#=4097766&CFTOKEN#=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520#lastvisit={ts '2026-06-01 11:36:09'}#hitcount=2#timecreated={ts '2026-06-01 11:36:07'}#cftoken=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520#cfid=4097766#
CFID=4097766
CFTOKEN=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
Session Variables:
cfid=4097766
cftoken=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
sessionid=BOOKBROWSE_4097766_14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
urltoken=CFID=4097766&CFTOKEN=14d9ffc97d387c5d-1DB25DD6-DF33-0400-C867973D970FE520
URL Parameters:
ezine_preview_number=8995
order=bw
page=3
where-monsters-dwell=
Debug Rendering Time: 60 ms