Rachel Lyon Interview, plus links to author biography, book summaries, excerpts and reviews

Rachel Lyon
Photo: Pieter M. van Hattem

Rachel Lyon

An interview with Rachel Lyon

Rachel Lyon discusses her novel, Fruit of the Dead, in an interview with Ashley Rubell for Write or Die Magazine.

Ashley Rubell: Tell me about the first time you heard the Greek myth of Persephone and Demeter. What was your first impression?

Rachel Lyon:  The D'Aulaires book is sort of indelibly printed on my memory. I was really interested in princesses and goddesses and I think that was probably what interested me in Persephone, if anything did. But to be honest, I didn't embark on writing this book with the intention of writing a retelling of Persephone. I actually started the book a couple years before I started incorporating the myth into it. It was almost happenstance. 

I was thinking a lot about the #MeToo movement and sexual assault and how these stories were revived in our culture with this incredible force around 2017 and 2018. What really got me about the dialogue then, which got so intense so quickly and then faded so quickly, was the reaction of some men that I was seeing who were like, Why now? You know, How is it possible that this is all happening right now? And I was really angered by that, and I really wanted to tell a story that showed that this was an ancient problem. This is not a "Why now?" problem.

AR: I remember reading an interview you did a while back with Michele Filgate about her anthology, and you two discussed the ways we tend to mythologize our mothers, both as this distant origin story and as the home we're always trying to return to, and I'm wondering if becoming a mother played any part in what drew you to giving this particular story of Persephone and her mother Demeter a contemporary retelling? 

RL: Ironically, I was trying not to include the mother character in this book when I first wrote it. Initially, once I sort of understood that I was going to be using the Persephone story as a touchstone and structural model, I was looking for versions that were told from Persephone's perspective and I couldn't find any. I was like, this feels important to me to write the story of the "victim," the character who in the myth is abducted and negotiated over. She's not given any agency. My project was really to give her that agency and try to write a version of this story where the character who is abducted, who is negotiated over, who is raped, still plays an active role in her story. And that brought up some really gnarly, interesting gray area that I really was fascinated in writing.

I felt like there was enough out there from Demeter's perspective. I didn't want to include Demeter's perspective, but as I kept working on the book and the years went by and I did become a mother, it kind of became inevitable. Not because I was writing them then, but because of a few reasons. My character Cory (who is cast as the Persephone in the story) is a teenager and unable to see herself clearly or understand really where a lot of her decisions are coming from. She's impulsive. Her self-image is really unstable. Over the course of the book, she sees herself in many, many different ways and she's very unsure of herself. So I needed a character who knew her really well and could see her really clearly for the reader. So the reader could feel sure of who this girl is and be validated in their concern for her, basically. 

Then there was also this inevitable draw toward writing about the difficulty of early parenthood and what a mindfuck it is. It's so difficult and it's so profound to make a person and then have to wrestle with that person for the rest of your life. They are who they are. I don't have teenagers—my kids are one and three—but I've always been drawn to writing toward the next stage of life. And in this case, that question really interested me. Not just how hard it is at the beginning, but how that difficulty will change and evolve in future stages.

AR: That takes me back to one of my favorite lines in this book, from one of Cory's chapters in that close third person perspective: "When she finds herself this ugly, the self-loathing runs so deep, it feels like grief." It's such a simple statement but it really captures that level of self-disgust that you can have as a young female, even without the uncomfortable situation Cory finds herself in, but especially within it. I loved reading that familiar level of obsession in the chapters about Cory. When did you decide to play with the POV in your drafting process? 

RL: I think it was about three or four years into working on it. It was relatively late. This book went through many different identities. Initially I thought I was writing some sort of beach read about a babysitter getting involved with her employer. Once I started incorporating the mythological element, I tried versions that included more of Mount Olympus, with Zeus as a character. And that felt campy in a way that I wasn't sure I could manage. And then eventually I had enough material in this kind of breathless, overwrought, teenaged third person voice that I was like, this is the story. This is the book. But again, I knew I had to sort of balance that with an external voice that was sober and that would eventually descend into madness too. It took a few years to get there.

AR: That's really refreshing to hear. 

What gets you in and started on an idea? And how did the chapter titles play into your structuring of later drafts?

RL: I like to sort of break things up into workable pieces. So my first book [Self-Portrait with Boy] was broken up into four sections, one for each season of the year. Fruit of the Dead is separated into twelve sections. I thought twelve was a nice number for the story of Perseophone, which is about this yearly cycle, living six months below, six months above. More than that, it's just a good working guide. Novels are so long. It's nice to have things broken up into smaller bits. 

When I first submitted this book it was in three parts. The first section was purely in Cory's voice, the second section was purely in Emer's voice (cast as the mother, Demeter), and there was a very short third section which is kind of like the final chapter as it is now. You know that part that's written sort of like a play, when it's just dialogue? 

AR: Oh I loved those pages. I honestly thought it would be so cool to scale and print those pages and have them framed because I just loved how beautiful it looked on the page. 

RL: That makes me really happy. I really loved that too. I loved when I landed on that as their moment of reuniting after a whole book of being kept apart. There's no time for narrative, no time for describing what it's been like, it's just boom boom boom boom boom. So that was the final bit and the rest of it was like these two novellas. When I started working with my editor at Scribner, she suggested shuffling them up like a deck of cards and interweaving them. I was reluctant at first but once I tried it I saw how much it really improved the reading experience and made things so much more suspenseful and engaging. Then I was able to use these chapter titles. I had lines from the book that I was already using as chapter titles in that three part draft. But once I had twelve chapters, I went back through the Homeric Hymn to Demeter, which was really my source text for the whole book, and extracted some of my favorite lines to use there.

AR: Let's talk about Rolo for a moment, our modern interpretation of Hades, a Pharma CEO. How did you get in touch with a character like him, to know how to strike that balance on the page of someone whose presence is enticing and frustrating, mysterious and alluring, all at once? And how much of his character was provoked by the recent stories of what's gone down these last few years in regard to major pharmaceutical companies?

RL: He didn't start as a Pharma CEO. He started as a writer, believe it or not. The people that I was researching were guys like Harvey Weinstein and Jeffrey Epstein. What I was interested in was the relationship between power and assault. These guys really don't think they're doing anything wrong. I was really fascinated by that. It seemed like such an interesting project to try and write someone who anyone else would look at this guy, at what he's doing and think, that is fucked up. He doesn't have that voice in his head. He has other voices that are a lot more interesting honestly because the voice of judgment is one we all have—that's the voice of society speaking. But what's going on for him? We get that in bits and pieces in the book. I wanted to show the frailty of someone who feels so put upon by the world. He's tried very hard and he feels very unattractive and wants beautiful things. 

AR:  And is so controlling. 

RL: Yes, but he doesn't know how controlling he is, right? I think that's what's really important. People like that don't really understand the amount of power they wield, or they do and they're getting off on it. There's a strange balance there where when they finally get a taste of what it feels like to really wield power over another person, another body, they need to seize it. 

All these documentaries, the articles, the witness statements, all this material that was out there to work with as research was incredibly helpful, but it only told this one side of the story that said: this person is a monster and they acted monstrously. And while I agree with that, it's not interesting to read a character that's just a monster. It was a challenge. 

I had an early reader, a man, read the book as a draft, and he said something I'll never forget. He said, "Is it ok that you're making this man so charming and seductive on the page? Is that unethical as a writer?" Girls do have to be seduced. They're not dumb. People who find themselves in these scenarios are not stupid. 

AR: It's not so black and white. I was really amazed that you could capture a character like him at all, to take an unbelievable type of person and make them so believable on the page. 

As far as setting goes, most of the novel takes place on an island. I think I read somewhere that it was loosely based on your college campus? Or a college experience?

RL: No, not exactly. It was informed by this island I worked on in my early twenties. 

AR: And the camp that Cory attends in the beginning of the novel—was that influenced by a camp your husband grew up going to?

RL: Yeah, as a teenager. And I ended up working there for two summers later, when we were dating. 

AR: Did you have these two experiences in your mind as places you knew you'd someday want to write about? Or did you find yourself in the middle of a story needing to draw upon something that you vividly knew? 

RL: It was definitely the latter. For Rolo's home I knew I needed a secluded place that would act as a trap, where Cory couldn't leave without some level of difficulty. At first she was on the coast, then on a lake. But she was never trapped enough, so I knew she had to be on an island. And I have only spent significant time on this one island, which I only know as an employee, not as a person who summers on an island. That's how that came to be. 

Figuring out the abduction part was hard. Initially, Cory was a writer's assistant and then quickly she became either a nanny or a babysitter. I knew from the beginning she would be doing childcare. So for the initial seduction, the way Cory and Rolo come together, it eventually made sense that it would be at a summer camp. And I only have limited experience with summer camps.

AR: In one of your Substack posts from early last year you wrote about messiness and alluded to writing your first book and how it felt less precious than writing this book: 

"...this book, it happens to be about a messy girl caught up in a messy situation, and the deep dark mess her mother becomes. So, you know, maybe, in this case, the mess is the message."

How was the process behind drafting this novel different from the first? What sort of hindsight do you have now, having written two books, and how do you think that will influence your writing moving forward? 

RL: I think I took the same amount of time on each book, approximately five years each. I mean, I didn't have kids when the first one came out. It's not that I didn't have demands on my time, I was working a full-time job. But now that I have children, I understand how much time I actually had, even though I surely felt very busy. 

I remember spending hours on the manuscript of Self-Portrait with Boy. It was also my first book, and I was nervous about it. I didn't have an agent yet. I was very meticulous and almost self-conscious about it. And I think that was the part of me that came out in the character of Emer, too. Meticulous, self-conscious, worried. She was also all of those things. 

With this book, I couldn't really afford to be quite as obsessive. I still read and reread it and revised it line by line, but people keep using the word lush. There's a lot of overgrowth in Corey's voice. I hope that's balanced somewhat by the sort of tenseness of Emer's voice. It was intentional, but also a product of my process.

AR: I'm always curious about what other writers are reading during a project, knowing how carefully selective I personally have to be when I'm writing. What did your reading life look like while you were working on this book?

RL: My first year of work on it, I read a lot of the books that came out around the same time as my first book did because I wanted to be in conversation with writers who were working in the same space as I was. Then there was a lockdown, my first pregnancy and then my second pregnancy, so I was reading a lot of books I wouldn't otherwise have read. I read Moby Dick for the first time. I don't think Moby Dick had any bearing on this book, but it certainly freed me up. Talk about a freewheeling, capacious narrative voice. That book is super flexible in what Melville is doing. It's all over the place. And I was like, if this absolute giant of American literature can be all over the place, maybe I can too.


Interview used with permission from Kailey Brennan DelloRusso, founder and editor-in-chief of Write or Die Magazine. Click here to subscribe to Kailey's newsletter, In the Weeds.

Unless otherwise stated, this interview was conducted at the time the book was first published, and is reproduced with permission of the publisher. This interview may not be reproduced or reprinted without permission in writing from the copyright holder.

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!

Books by this Author

Books by Rachel Lyon at BookBrowse
Fruit of the Dead jacket Self-Portrait with Boy jacket
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

All the books below are recommended as read-alikes for Rachel Lyon but some maybe more relevant to you than others depending on which books by the author you have read and enjoyed. So look for the suggested read-alikes by title linked on the right.
How we choose readalikes

  • Asale Angel-Ajani

    Asale Angel-Ajani

    Asale Angel-Ajani is a writer and Professor at The City College of New York. She's the author of the nonfiction books Strange Trade: The Story of Two Women Who Risked Everything in the International Drug Trade and Intimate: ... (more)

    If you enjoyed:
    Fruit of the Dead

    Try:
    A Country You Can Leave
    by Asale Angel-Ajani

  • Marcial Gala

    Marcial Gala

    Marcial Gala was born in Havana in 1963. He is a novelist, a poet, and an architect and is a member of UNEAL, the National Union of Writers and Artists of Cuba. He won the Pinos Nuevos Prize for best short story in 1999. The ... (more)

    If you enjoyed:
    Fruit of the Dead

    Try:
    Call Me Cassandra
    by Marcial Gala

We recommend 5 similar authors

View all 5 Read-Alikes

Non-members can see 2 results. Become a member
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...

Men are more moral than they think...

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 /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 05:10 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
1780290647543 ms 1.78029064754E+012 ms 1 /root/website/app_server.cfm
298 ms 298 ms 1 /root/website/author_interviews/full/index.cfm
106 ms 106 ms 1 /root/website/app_globals.cfm
94 ms 94 ms 1 /root/website/author_interviews/full/dsp_main.cfm
65 ms 65 ms 1 /root/website/app_layout.cfm
54 ms 18 ms 3 /root/website/adsystem/adsystem_mod.cfm
45 ms 23 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_active_obc.cfm
37 ms 37 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
21 ms 21 ms 1 /root/website/adzones/AdZone2.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
20 ms 20 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
18 ms 18 ms 1 /root/website/adzones/showcase_track.cfm
16 ms 16 ms 1 /root/website/adzones/AdZone6.cfm
15 ms 4 ms 4 /root/website/actions/act_spider_tracker.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
12 ms 4 ms 3 /root/website/site/blocks/membership_advantages.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_current_competition.cfm
10 ms 3 ms 3 /root/website/queries/qry_get_member_account_types.cfm
10 ms 10 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
8 ms 8 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
4 ms 4 ms 1 /root/website/act_check_login.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_member_info.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/formurl2attributes.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.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/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_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
299 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 05:10:47.047
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=3ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 05:10:47.047
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=4ms, Records=2) in /root/website/actions/adstatus.cfm @ 05:10:47.047
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 @ 05:10:47.047
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 05:10:47.047
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=5ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 05:10:47.047
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 @ 05:10:47.047
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 @ 05:10:47.047
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=11ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 05:10:47.047
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=10ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 05:10:47.047
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=18ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 05:10:47.047
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:10:47.047
select	a.book_number, a.book_title, a.book_sub_title, book_short_summary,
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
        left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0 
   		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1 
		
       	where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)

		order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3934

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:10:47.047
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3934

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 05:10:47.047
select	a.book_number, 
        		'' AS ezine_preview_number,
                a.book_title, 
                a.book_sub_title, 
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt",
                '' as "jacket"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
		left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
		
        where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)        
        UNION

		select	'' AS book_number,
        		ezine_preview_number, 
				ezine_preview_title AS "book_title", 
				ezine_preview_subtitle AS "book_sub_title",
                ezine_preview_publish_dt AS "publish_dt",
                ezine_preview_jacket_image as "jacket"
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		ezine_preview_bb_link < 1
        
        order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3934
Parameter #2(CF_SQL_INTEGER) = 3934

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 05:10:47.047
select	ezine_preview_number, 
				ezine_preview_title, 
				ezine_preview_subtitle,
                ezine_preview_publish_dt ,
                ezine_preview_jacket_image
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		(ezine_preview_bb_link IS NULL
				 or ezine_preview_bb_link < 1)
        and		ezine_number > 0
        
		order by ezine_preview_publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3934

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=5) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 05:10:47.047
SELECT		a.author_number,
			CASE	WHEN datalength(a.author_middle_initial) > 0 
					THEN a.author_first_name + ' ' + a.author_middle_initial + ' ' + a.author_last_name
					ELSE a.author_first_name + ' ' + a.author_last_name
					END AS "author_full_name",
			b.book_number, 
			f.book_title as "book",

			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 "liked_author_full_name",
			e.author_number as "liked_author_number", 
			g.book_title as "liked_book",
			c.liked_book_number as "liked_book_number" 

FROM		authors a
INNER JOIN	book_author_mapping b ON b.author_number = a.author_number
INNER JOIN	liked c ON c.book_number = b.book_number
INNER JOIN	book_author_mapping d ON d.book_number = c.liked_book_number
INNER JOIN	authors e ON e.author_number = d.author_number
INNER JOIN	books f on f.book_number = b.book_number
INNER JOIN	books g on g.book_number = c.liked_book_number

WHERE		a.author_number = ?

ORDER BY 	e.author_last_name, e.author_first_name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3934

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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) = adzone2
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=6ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:10:47.047
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_book_image (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 05:10:47.047
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	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 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 4798

get_member_account_types (Datasource=bookbrowse_com_new, Time=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:10:47.047
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_books_by_author_id (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:10:47.047
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3785
Parameter #2(CF_SQL_INTEGER) = 3785
Parameter #3(CF_SQL_INTEGER) = 3785

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:10:47.047
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3785

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:10:47.047
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3318
Parameter #2(CF_SQL_INTEGER) = 3318
Parameter #3(CF_SQL_INTEGER) = 3318

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:10:47.047
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3318

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

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

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

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=4ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:10:47.047
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=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 05:10:47.047
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=2ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 05:10:47.047
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:10:47.047
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/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFTOKEN=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2; 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%3D4089040%26CFTOKEN%23%3Dee0c223b6da592d8%2D0FE1F9DE%2DA061%2D9B10%2D146F11A6AB077BD2%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2005%3A10%3A47%27%7D%23hitcount%3D328%23timecreated%3D%7Bts%20%272026%2D06%2D01%2005%3A09%3A50%27%7D%23cftoken%3Dee0c223b6da592d8%2D0FE1F9DE%2DA061%2D9B10%2D146F11A6AB077BD2%23cfid%3D4089040%23; CFID=4089040
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=/author_number/3934/rachel-lyon
PATH_TRANSLATED=/root/website/author_interviews/full/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/author_interviews/full/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=4089040
cftoken=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
hitcount=334
lastvisit={ts '2026-06-01 05:10:47'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 05:09:50'}
urltoken=CFID=4089040&CFTOKEN=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
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#=4089040&CFTOKEN#=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2#lastvisit={ts '2026-06-01 05:10:47'}#hitcount=328#timecreated={ts '2026-06-01 05:09:50'}#cftoken=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2#cfid=4089040#
CFID=4089040
CFTOKEN=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
FREEACCESSCOUNT=0
Session Variables:
cfid=4089040
cftoken=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
sessionid=BOOKBROWSE_4089040_ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
urltoken=CFID=4089040&CFTOKEN=ee0c223b6da592d8-0FE1F9DE-A061-9B10-146F11A6AB077BD2
URL Parameters:
author_number=3934
rachel-lyon=
Debug Rendering Time: 15 ms