Book Summary and Reviews of Before You Knew My Name by Jacqueline Bublitz

Before You Knew My Name by Jacqueline Bublitz

Before You Knew My Name

A Novel

by Jacqueline Bublitz

  • Critics' Consensus (2):
  • Readers' Rating (2):
  • Published:
  • Nov 2022, 320 pages
  • Rate this book

About this book

Book Summary

This is not just another novel about a dead girl. Two women—one alive, one dead—are brought together in the dark underbelly of New York City to solve a tragic murder.

When she arrived in New York on her eighteenth birthday carrying nothing but $600 cash and a stolen camera, Alice Lee was looking for a fresh start. Now, just one month later, she is the city's latest Jane Doe. She may be dead but that doesn't mean her story is over.

Meanwhile, Ruby Jones is also trying to reinvent herself. After travelling halfway around the world, she's lonelier than ever in the Big Apple. Until she stumbles upon a woman's body by the Hudson River, and suddenly finds herself unbreakably tied to the unknown dead woman.

Alice is sure Ruby is the key to solving the mystery of her short life and tragic death. Ruby just wants to forget what she saw…but she can't seem to stop thinking about the young woman she found. If she keeps looking, can she give this unidentified Jane Doe the ending and closure she deserves?

A "heartbreaking, beautiful, and hugely important novel" (Rosie Walsh, New York Times bestselling author), Before You Knew My Name doesn't just wonder whodunnit—it also asks who was she? And what did she leave behind?

Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

Reviews

Media Reviews

"Using keenly rendered characters and poignant prose, Bublitz crafts a richly textured, deeply feminist murder mystery that spotlights the victim rather than her killer. Readers will eagerly await Bublitz's next." - Publishers Weekly (starred review)

"This is undeniably a crime story, but Bublitz's creativity, affectionate descriptions of a New York City she obviously adores, and strong character development make this novel stand out in a crowded genre. A unique, feminist take on the suspense genre and our fascination with violence." - Kirkus Reviews

"A brave and timely novel which will fuel the debate on women's rights to walk safely through our streets. I raced through the pages, anxious for resolution, yet at the same time not wanting this beautiful writing to finish." - Clare Mackintosh, author of I Let You Go

"Unflinching and heartbreaking; powerful and empowering, the story of Alice and Ruby is our story, the story of every woman, everywhere. I know I'll be thinking about it — and them — for a very long time to come." - Carole Johnstone, award-winning author of Mirrorland

"Before You Knew My Name will make you cry, make you angry, make you think. Jacqueline Bublitz pushes the boundaries of crime fiction in all the right ways. It's a deeply moving, deeply original, story that, hands down, is one of the best novels of the year." - Alex Finlay, author of The Night Shift

This information about Before You Knew My Name was first featured in "The BookBrowse Review" - BookBrowse's membership magazine, and in our weekly "Publishing This Week" newsletter. Publication information is for the USA, and (unless stated otherwise) represents the first print edition. The reviews are necessarily limited to those that were available to us ahead of publication. If you are the publisher or author and feel that they do not properly reflect the range of media opinion now available, send us a message with the mainstream reviews that you would like to see added.

Any "Author Information" displayed below reflects the author's biography at the time this particular book was published.

Reader Reviews

Write your own reviewwrite your own review

Janie-Hickok-Siess

Heartbreakingly Tragic, Yet Life-Affirming Featuring Characters Readers will Long Remember
Author Jacqueline Bublitz wrote Before You Knew My Name, her debut novel, after spending a summer in New York City where she "hung around morgues and the dark corners of city parks (and the human psyche) far too often." Her manuscript was rejected many times during a more than five-year journey to publication, but the book is now receiving stellar reviews and numerous awards.

Bublitz says she drafted the ending of the book first, and continued penning the narrative in reverse chronological order, which made sense because on the first page she reveals that " our narrator has not survived." She crafted the book's propulsive opening later -- it came to her "really strongly" when she had become "intimately acquainted with Alice Lee, one of our two storytellers in the book, so intimately connected to her voice." She kept hearing, "If I tell you my story . . . and it wouldn't leave me alone," so she sat down and wrote the opening in just two or three minutes.

The second narrator is Ruby Jones, who arrives in New York City from Melbourne on the same day as Alice arrives from the Midwest. Ruby is twice Alice's age -- 36. "She knows what she's getting away from but she doesn't know what she's going to." She chose New York from an "if I can make it there" unrealistic, from Bublitz's perspective, outlook. She's "a bit of a romantic and a hot mess as well." She's escaping a toxic romantic relationship -- her lover is engaged to marry another woman but continues his dalliance with her as she hopes against hope that he will finally choose her. Bublitz says "she's absolutely aimless and she knows it," and while jogging early one morning in New York, she discovers Alice's body.

Bublitz was inspired by an actual case in Melbourne. A young woman was chased into the Tenant Gardens around 5:00 a.m. and murdered in an area that was considered safe. "I could identify with this young woman," Bublitz says. Her body was discovered by a jogger. A jogger herself, Bublitz could not stop wondering, "What if that had been me? I could not get that trauma out of that mind." She researched the impact upon people who happen upon bodies under similar circumstances, but she could only locate one archived article discussing how a gentleman was so effected by the experience that he returned to the scene every year to commemorate the victim's death. That's when Bublitz knew she was "on to something" because no one had ever told the story of the connection between the person who found the body and the victim. She felt she could craft the “very human” tale.

She tells the story beautifully. From the very first page, when Alice begins relating her experiences, Bublitz endears readers to the dead girl who came to New York in search of a fresh start after enduring poverty, the death of her mother, being foisted on various relatives, and, eventually, an inappropriate relationship with one of her teachers. When he realizes how reckless and potentially destructive his behavior has been, Alice flees. She boards a bus from Milwaukee to New York City, taking with her a small amount of cash and his cherished antique camera. It is a Leica from the 1930s that belonged to his mother and she steals it from him because she knows losing it will cause him pain. “I am a survivor. I will turn eighteen years old tomorrow, and I am leaving on my own terms. Nothing – no one – can hold me back now,” she declares.

Alice finds a room for rent in the home of an older man named Noah. She has no job and her money won’t last long, but she works out an arrangement with Noah, who is clearly lonely. Is he a kind-hearted person who feels genuine fondness for Alice and wants to help and protect her by providing her a safe place to stay? Or is he a predator? Alice enjoys living in his beautiful apartment and working for him in exchange for room and board. Their arrangement ensures she can remain there. She walks and walks, learning her way around the city and snapping photographs, and begins to believe that perhaps dreams can come true. But her life ends abruptly and violently. Senselessly. Alice explains that a man murdered her in the park by the river. Is Noah her killer? Readers will find themselves hoping Noah is the kind-hearted man he initially appears to be, and not a cold-blooded murderer.

Simultaneously, Ruby, who is “approximately three years past pretty,” drinks heavily when she first arrives in New York. She stays in the dreary little room she has rented, staring at the ceiling, considering the choices she has made and her feelings for Ash, the man she loves more than she respects herself. She knew he was planning to marry another woman when she got involved with him, but believed that over time he would change his mind. He didn’t. So she escaped to New York for a sabbatical. After she wallows for a week, she finally decides to get up and moving, her anger inspiring her to go for a jog even though it is raining. She feels better, realizing “there is a whole world outside” the brick walls of the apartment building, and “she’s finally ready to crash her way through.”

But as Ruby approaches the marina, she steps on a plastic object – it is round and black, and now shattered. She notices something on the rocks, and quickly realizes she is looking at fingernails and blond hair. Comprehending that she has happened upon the body of a young woman, she summons help. Indeed, she has found Alice’s mangled body. “Ruby Jones is my only witness,” Alice explains. From the waterfront path, Ruby can’t get to Alice, but Alice is able to “make my way to her” but is dismayed to find that Ruby “can only see the husk of me, left down on the rocks.” But her spirit has aligned with and will remain with Ruby as the police search for Alice’s killer and a traumatized Ruby tries to understand the ways in which her life is forever changed that morning.

Before You Knew My Name is a unique and inventive tale, related from the perspective of a young woman whose life ends tragically and wants justice because she has been robbed of the future she was just beginning to envision and create for herself. “I really fought hard to stay in my body. I tried my best, but I just couldn’t hold on. I did not want to die.” At first, the police are unable to identify Alice because she had no wallet or form of identification with her, so she becomes yet another “Jane Doe” whose plight will fade from the headlines quickly. The media dubs her “Riverside Jane” but she wants to be identified so that she can be remembered and mourned by her best friend back at home, and her killer can be prevented from murdering again, even though she acknowledges that when the man who murdered her is identified, “he’ll be the one they want to now, the one who takes over the narrative.” When no one comes to the morgue to claim her body, she fears no one will care about her because she will be classified as “the wrong kind of victim.” Meaning, the kind who remain invisible. Alice looks to Ruby to ensure that she is not forgotten, whispering to Ruby, “I’m Alice,” again and again. But Ruby cannot hear her over the din of the city noises.

Ruby recognizes that she can never go back to being the woman she was before that morning. The media reports that Alice’s body was discovered by a jogger, but “why did they never say what happened to the jogger after that?” She wants to help. She wonders why only some victims’ stories are deemed worthy of being told. She can’t stop thinking about Alice; she feels connected to her. She seeks out other “finders of the dead” and discovers a small group who call themselves the Death Club. Led by a mortician, the members include Josh, who survived a near-death experience and suffers from survivor’s guilt, and a grieving mother. They are an eclectic and fascinating group of supporting characters who reveal their own tragic stories and the personal demons they are striving to overcome. Their ponderings about death are absorbing.

Fortunately, the detective assigned to Alice’s case is seasoned, and determined to solve it. As Alice remains beside Ruby, Bublitz takes readers on their journey of discovery. It is poignant, frequently heartbreaking, and powerful as a result of the achingly simple yet captivating way in which Bublitz describes Ruby’s encounters with the members of the Death Club, the relationships she forms with them, and the myriad ways in which she grows and matures, unwilling to be aimless any longer. At the center of the story is a cleverly-imagined mystery and the believable procedural tale about how Detective O’Bryne follows sometimes obscure clues that would be missed by a less diligent investigator.

But the real power of Before You Know My Name is the way in which Bublitz examines female empowerment from the perspectives of her two female protagonists. As noted, for Alice, it is about being valued. Even though her life was short, she wants to ensure that it was not without merit and meaning, and that she will be remembered as a person who mattered. The same things are important to Ruby, but from the perspective of her continuing life. Bublitz makes a strong statement about the importance of safety to women in New York City, in particular, but wherever they find themselves, and the vast power imbalance that still leaves women vulnerable and too often victimized.

Bublitz explores, from a decidedly feminist and fresh vantage point, the often surprising and frequently profound ways in which people’s lives intersect and become intertwined, and how those connections impact not just emotions, but decision-making, and shape the future. She also offers a sly indictment of the ways in which the media sensationalize crime, especially crimes against women. And the shamefully fleeting and superficial attention paid to cases that lack “legs,” meaning the ones the public grows tired of hearing about because they are not flashy or titillating enough to sustain interest from an industry focused on soundbites rather than substance. Bublitz makes clear that Alice’s killer should never overtake the narrative or overshadow the significance of the life he stole from her. Bublitz also challenges readers to consider their beliefs about the afterlife. Could those nudges and urgings we all feel emanate from spirits of the dead who remain with us and, as Alice struggles to communicate with Ruby, whisper to us?

Before You Knew My Name is a richly emotional, riveting, and thought-provoking debut from a talented and promising new thriller writer. It is a hauntingly tragic, yet life-affirming story of two women readers will not soon forget. And it is one of the best books of 2022.

Thanks to NetGalley for an Advance Reader's Copy of the book.

Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

Author Information

Jacqueline Bublitz

Jacqueline Bublitz is a writer, feminist, and arachnophobe who lives between Melbourne, Australia, and her hometown on the west coast of New Zealand's North Island. She wrote her debut novel Before You Knew My Name after spending a summer in New York, where she hung around morgues and the dark corners of city parks (and the human psyche) far too often.

More Author Information

Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

Read-Alikes

Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

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

From the moment I picked your book up...

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 /bb_briefs/detail/index.cfm
Time Stamp 01-Jun-26 01:53 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
1780278829162 ms 1.78027882916E+012 ms 1 /root/website/app_server.cfm
866 ms 866 ms 1 /root/website/bb_briefs/detail/index.cfm
240 ms 240 ms 1 /root/website/app_layout.cfm
220 ms 220 ms 1 /root/website/bb_briefs/detail/dsp_main.cfm
178 ms 178 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
157 ms 157 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
145 ms 36 ms 4 /root/website/adsystem/adsystem_mod.cfm
94 ms 94 ms 1 /root/website/queries/qry_get_briefs_reader_rating.cfm
87 ms 87 ms 1 /root/website/app_globals.cfm
68 ms 68 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
61 ms 15 ms 4 /root/website/site/blocks/membership_advantages.cfm
57 ms 14 ms 4 /root/website/queries/qry_get_member_account_types.cfm
54 ms 54 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
53 ms 53 ms 1 /root/website/adzones/AdZone6.cfm
53 ms 53 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
46 ms 46 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
45 ms 45 ms 1 /root/website/adzones/showcase_track.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_active_obc.cfm
34 ms 34 ms 1 /root/website/adzones/AdZone3.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_preview_by_id.cfm
15 ms 15 ms 1 /root/website/actions/adstatus.cfm
15 ms 15 ms 1 /root/website/adzones/AdZone11.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_books_by_briefs_category.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_liked_by_brief_id.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_current_competition.cfm
11 ms 11 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_obc_number.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_author_bookcount.cfm
6 ms 1 ms 5 /root/website/actions/act_spider_tracker.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_preview_awards_by_id.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 2 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/Application.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/dsp_top_brief_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.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_free_newsletters.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/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
867 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 01:53:49.049
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 @ 01:53:49.049
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=15ms, Records=2) in /root/website/actions/adstatus.cfm @ 01:53:49.049
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 @ 01:53:49.049
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=3ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 01:53:49.049
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:53:49.049
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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 01:53:49.049
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 @ 01:53:49.049
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=13ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 01:53:49.049
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=14ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 01:53:49.049
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=8ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 01:53:49.049
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_preview_by_id (Datasource=bookbrowse_com_new, Time=19ms, Records=1) in /root/website/queries/qry_get_preview_by_id.cfm @ 01:53:49.049
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) = 17112

get_preview_awards_by_id (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_preview_awards_by_id.cfm @ 01:53:49.049
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) = 17112

get_briefs_reader_rating (Datasource=bookbrowse_com_new, Time=94ms, Records=1) in /root/website/queries/qry_get_briefs_reader_rating.cfm @ 01:53:49.049
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) = 17112
Parameter #2(CF_SQL_INTEGER) = 17112

get_reader_reviews_by_preview_number (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_reader_reviews_by_preview_number.cfm @ 01:53:49.049
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) = 17112

get_arc_idfk (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:53:49.049
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) = 17112

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:53:49.049
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) = 17112

obc_discussions (Datasource=booktalk_new, Time=99ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:53:49.049
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=37ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 01:53:49.049
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) = p17112

ya_check (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 01:53:49.049
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) = 17112

get_books_by_brief (Datasource=bookbrowse_com_new, Time=6ms, Records=20) in /root/website/queries/qry_get_books_by_briefs_category.cfm @ 01:53:49.049
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) = 17112

get_author_bookcount (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/queries/qry_get_author_bookcount.cfm @ 01:53:49.049
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=9ms, Records=0) in /root/website/queries/qry_get_obc_number.cfm @ 01:53:49.049
select a.arc_forumidfk
    from arcs a
    
    	where a.ezine_preview_number = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_numeric) = 17112.0

existingResults (Datasource=bookbrowse_com_new, Time=92ms, Records=1) in /root/website/actions/udfs.cfm @ 01:53:49.049
SELECT id, last_updated
        FROM DiscourseSearchResults
        WHERE book_number = ?
        ORDER BY last_updated DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = p17112

get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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) = adzone3
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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) = adzone3

get_member_account_types (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:53:49.049
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_member_account_types (Datasource=bookbrowse_com_new, Time=15ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:53:49.049
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_ads (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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) = adzone11
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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) = adzone11

get_member_account_types (Datasource=bookbrowse_com_new, Time=19ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:53:49.049
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_liked_by_brief_id (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_liked_by_brief_id.cfm @ 01:53:49.049
SELECT
		ep.ezine_preview_title AS book_title,
		'p' + CAST(ep.ezine_preview_number AS VARCHAR) AS book_number,
		b.book_title AS "referenced_book_title",
		CAST(b.book_number AS VARCHAR) AS "liked_book_number",
		b.book_short_summary AS "liked_short_summary",
		CASE
			WHEN datalength(e.author_middle_initial) > 0
			THEN e.author_first_name + ' ' + e.author_middle_initial + '. ' + e.author_last_name
			ELSE e.author_first_name + ' ' + e.author_last_name
		END AS "author_name",
		(select top 1 edition_publish_dt from editions where editions.book_number = b.book_number order by edition_publish_dt DESC) AS 'sortdate',
		(select count(*) from book_author_mapping m where m.author_number = d.author_number)
		+ (select count(*) from ezine_previews where ezine_preview_bb_author_link = d.author_number and ezine_preview_bb_link =0) AS 'liked_author_bookcount',
		0 AS 'is_brief'

	FROM 		liked a
	INNER JOIN	ezine_previews ep ON ep.ezine_preview_number = ?
		AND a.book_number = ep.ezine_preview_number
	INNER JOIN	books b ON b.book_number = a.liked_book_number
	INNER JOIN	book_author_mapping d ON d.book_number = b.book_number
	INNER JOIN	authors e ON e.author_number = d.author_number

	UNION

	
	SELECT
		ep.ezine_preview_title AS book_title,
		'p' + CAST(ep.ezine_preview_number AS VARCHAR) AS book_number,
		b.book_title AS "referenced_book_title",
		CAST(b.book_number AS VARCHAR) AS "liked_book_number",
		b.book_short_summary AS "liked_short_summary",
		CASE
			WHEN datalength(auth.author_middle_initial) > 0
			THEN auth.author_first_name + ' ' + auth.author_middle_initial + '. ' + auth.author_last_name
			ELSE auth.author_first_name + ' ' + auth.author_last_name
		END AS "author_name",
		(select top 1 edition_publish_dt from editions where editions.book_number = b.book_number order by edition_publish_dt DESC) AS 'sortdate',
		0 AS 'liked_author_bookcount',
		0 AS 'is_brief'

	FROM 		readalikes_cache rc
	INNER JOIN	ezine_previews ep ON ep.ezine_preview_number = ?
		AND rc.source_book_number = 'p' + CAST(ep.ezine_preview_number AS VARCHAR)
	INNER JOIN	books b ON b.book_number = rc.recommended_book_number
	INNER JOIN	book_author_mapping bam ON bam.book_number = b.book_number
	INNER JOIN	authors auth ON auth.author_number = bam.author_number

	ORDER BY 	sortdate desc, referenced_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 17112
Parameter #2(CF_SQL_INTEGER) = 17112

get_member_account_types (Datasource=bookbrowse_com_new, Time=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 01:53:49.049
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=31ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:53:49.049
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=21ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 01:53:49.049
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=34ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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=0ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:49.049
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=67ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 01:53:49.049
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 01:53:49.049
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=23ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:50.050
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 01:53:50.050
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 @ 01:53:50.050
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/bb_briefs/detail/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=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0; CFGLOBALS=urltoken%3DCFID%23%3D4081516%26CFTOKEN%23%3D956707c451ae6aad%2D08DADFBB%2DB406%2DFFA4%2D375C904AF9F43EA2%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2001%3A53%3A49%27%7D%23hitcount%3D158%23timecreated%3D%7Bts%20%272026%2D06%2D01%2001%3A53%3A20%27%7D%23cftoken%3D318a88a65ade1e65%2D08DADB71%2DFEDE%2D2BDC%2D5A0C0C2C419CC058%23cfid%3D4081515%23; CFTOKEN=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2; CFID=4081516
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/17112/before-you-knew-my-name
PATH_TRANSLATED=/root/website/bb_briefs/detail/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/bb_briefs/detail/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=4081515
cftoken=318a88a65ade1e65-08DADB71-FEDE-2BDC-5A0C0C2C419CC058
hitcount=164
lastvisit={ts '2026-06-01 01:53:50'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 01:53:20'}
urltoken=CFID=4081516&CFTOKEN=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2
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#=4081516&CFTOKEN#=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2#lastvisit={ts '2026-06-01 01:53:49'}#hitcount=158#timecreated={ts '2026-06-01 01:53:20'}#cftoken=318a88a65ade1e65-08DADB71-FEDE-2BDC-5A0C0C2C419CC058#cfid=4081515#
CFID=4081516
CFTOKEN=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2
FREEACCESSCOUNT=0
Session Variables:
cfid=4081516
cftoken=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2
sessionid=BOOKBROWSE_4081516_956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2
urltoken=CFID=4081516&CFTOKEN=956707c451ae6aad-08DADFBB-B406-FFA4-375C904AF9F43EA2
URL Parameters:
before-you-knew-my-name=
ezine_preview_number=17112
Debug Rendering Time: 10 ms