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

Rachel Joyce

Rachel Joyce

An interview with Rachel Joyce

Rachel Joyce discusses her first book, The Unlikely Pilgrimage of Harold Fry, with author Charlotte Rogan, explaining how the book, which started as a radio play, is inspired by her father and how strong a presence the English countryside is in the book.

A Conversation Between Rachel Joyce and Charlotte Rogan

Charlotte Rogan worked at various jobs, mostly in the fields of architecture and engineering, before teaching herself to write and staying home to bring up triplets. The Lifeboat, her first published novel, was one of the 2012 Waterstones 11, a recognition for debut novels published in the United Kingdom; it was also chosen by the Barnes & Noble Discover Great New Writers Program and was nominated for the Guardian First Book Award. It is currently being translated into twenty-five languages. After many years in Dallas and a brief stint in Johannesburg, Rogan and her husband now live in Westport, Connecticut.

Charlotte Rogan: When my protagonist Grace Winter came to me, she was defending herself to some unseen authority for things she had done in an overcrowded lifeboat. The story grew from there. Did Harold Fry or the idea of a pilgrimage come to you first, or were the situation and the character inseparable from the start?
Rachel Joyce: The truth is that I don't know where the story came from. Harold and his journey to Queenie turned up in my head and I realized I wanted to write about them. I think I often don't understand what stories are about and why they are with me (and where they have come from) until I have finished—and sometimes only years later. But maybe if we understood from the offset we wouldn't need to write them? If they were clear and complete, they would already be stories as opposed to an idea. Or an inspiration. What I do know is that I began writing this as a radio play when my father told me he was dying. He had spent years battling cancer, and after several brutal operations, surgeons told him there was nothing left to be done. He was very frightened and so was I. I was appalled at the idea of not having my father. I was appalled at the idea of watching him die. But both happened, and while they did I wrote this story about a man who sets off to save someone else. It was my escape. My way of making sense. And somehow also my way of finding the flip side to my complicated, wild grief.

I like what you said about not understanding what your stories are about until much later. I remember the feeling of panic when my publisher first asked me to distill what my novel is about into a couple of sentences. Perhaps most writers think that the book itself is the best and maybe only answer to that question.
Whenever someone asks me what my book is about, it occurs to me that I am the worst person in the world to put it in a nutshell. I remember people talking about an exercise where you supposedly have an elevator ride—twenty seconds, maybe—in which to sell your story. And my heart sinks when I imagine that. It would take me at least thirty seconds to pluck up the courage to open my mouth, let alone say something about the book.
So, yes—being a bit of a tongue-tied person—this is the side of becoming a published writer that I didn't anticipate. When you write for radio, no one wants to know anything about you. It is the actors who do all the "shiny" publicity, and I was always, as a writer, very happy with that. So I have found it strange that suddenly people want to know about my life and who I am. The truth is, I am very private and very quiet. If you met me at a dinner party, I'd be completely underwhelming. (I would smile a lot.) But again, this, I think, is why I write. Because I need to say the things that don't get voiced for me in everyday life.

As I think about it, the way Harold's pilgrimage becomes public and attracts media attention makes a nice parallel to the way your novel became public. Just as you wrote the story for very personal reasons, Harold embarks on his journey with no thought of what it might mean to anyone but Queenie, yet people want statements from him. They want not only reasons, but Meaning. Have you been surprised by the public side of becoming a published novelist? (We need to mention your nomination for the Man Booker Prize here!)
I have been bowled over by the worldwide reaction to the book. I thought of it as such a personal story. The part I have loved most is readers getting in touch with me and sharing their own stories. That has been very moving.
The Booker nomination was a complete shock. I didn't see it coming at all. But I am glad I didn't see it coming, because I saw it as an honor—and that was enough.

I wrote for twenty-five years without any sort of audience for my work, so for me, too, it has been both terrifying and enlightening to emerge from the writing closet. One of the many things I have learned from readers in recent months is that they complete a novel in a way that reminds me of the question: If a tree falls in the forest and no one is there to hear it, does it make a sound?
I wholeheartedly agree about readers completing a book. The story cannot come alive without a willingness on the part of the reader to make an imaginative leap. Without that leap (and you could call it a leap of faith), Harold and Maureen are simply in my head. I once told someone about a book I had read and how much I wished I'd written it. She said to me, "But in feeling the way you do, you have written it." I had never thought of reading in this way before, but I think about it a lot now. Reading is a creative process. As writers, we must do everything we can to make a world that stands up as if it could be a real one. Not necessarily the real one; not necessarily the world the reader knows. But within its own confines, that world must be plausible. It must add up. After that, the reader meets you halfway. The reader fills out your words with pictures, with breath, with feeling.

Clearly, your story has been heard. The world reaction is a testament to the fact that The Unlikely Pilgrimage of Harold Fry is wonderful on so many levels. For one thing, the language is gorgeous, and I want to get back to that. But the story is also an illustration of how the universal emerges through the particular.
Harold is an ordinary man. I have gone so far as to call him an everyman. By that I mean he doesn't consider himself to be any different from anyone else or in any way unique. He accepts his part in the bigger picture—and I think that gives him both humility and openness, despite his sheltered life and his reserved nature.
To me, the universal is in the small. That is the paradox. And it is also where drama lies. It is the basic human struggle between wanting to amount to something and recognizing our mortality. I happened to give a talk about the book recently at a Quaker meetinghouse. And I was very touched when one of the women who looks after the building told me about the graves there, all of which were unmarked. It made me think. Even in our dying, we generally want people to know who we are. We want recognition. We want to stand out from all the other graves.
So I tend to write about small, ordinary people who find themselves at an extraordinary point in their lives, equipped with only small, everyday words. This moves me. Sometimes our vocabulary can seem so clichéd, so overused, so undersized— but we keep on trying. That's the thing. We keep trying to connect up.

You use the word "ordinary" in the second line of the book— you are describing the day, but of course it applies to Harold as well.The entire first page is terrific.There is so much in it that not only draws the reader in but also telegraphs what the story is about. You mention a few pedestrian (pardon the pun) details of Harold and Maureen's life together, such as the clean washing and the slice of toast, but other details hint at a deeper, darker layer. The yard is "trapped" by its fence, and the word "vacuum" appears twice. Within this claustrophobic context, you place a "telescopic washing line." When I reread the paragraph, the telescope allusion jumped out at me as a signal that Harold's world- view is about to expand. I also love the understated sentence "He thought he might like to go out..."
Writing is an odd mixture of instinct and intention, of creative impulse and painstaking revision. Did your original radio play open in a similar fashion? If not, was it hard to decide how to start the novel?

The radio play was a completely different beast. I had 7,500 words in which to tell the whole story, not to mention a tight budget that stretched only as far as three actors. So when I began to write this tale as a novel, I knew I was starting from scratch. Besides, with a radio play, you only have the dialogue through which to tell your story. You only have what people (inadvertently) give away as they talk. With the book, I suddenly had so many other tools at my fingertips. There is the setting, there is the physical detail; not to mention the past and the thought processes. It was like having a whole new set of colors to play with.
However, whenever I begin a story, I like to ask myself, What is the situation here? What is the thing that has to change? All the clues—I think—should lie in the opening scene. But they mustn't have rings round them, signifying, LOOK AT US! WE ARE CLUES! The story must work on a superficial level, and it must also work on a deeper level for someone like you who cares to look back and re-examine. That is the delight of storytelling for me: that it can be what it is, and that it can also carry reverberations, when you go back and look a second time. It's like life, I think. Life has clues and sometimes we are so busy living we don't see them.
So I write very carefully. And I keep refining and tweaking. I don't think anything should be in a story for nothing. And likewise, I don't think anything should appear in a story from absolutely nowhere. There is a bit I always remember from Jane Austen where she uses a pop-up character right at the climax of the plot and she adds that actually this woman passed through the story earlier, carrying some washing. That makes me laugh.

Your experience writing radio plays, with their emphasis on dialogue, must account for the subtlety with which you insert information about settings and characters. I tend to dislike long bits of exposition and exhaustive descriptions of people or places—as a reader, I would rather feel as if I am discovering those things through telling details scattered along the way. In fact, we don't learn anything about Harold's looks until chapter 4, when we you tell us only that he is tall and stooped. But because he comes alive through his perceptions and speech, I had a very clear picture of him from the beginning.
Even more than the dying Queenie, David personifies the open wound of the story—the Big Thing that will never be fixed. It was very fitting that the last scene shows Harold and Maureen looking out at the ocean and laughing. The ocean not only confirms the fact that Harold has reached his goal of walking the length of England, it is also the thing that dwarfs all our earthly concerns. And there is hope for anyone who can laugh.

RJ: That is very kind of you. You have actually said it all so succinctly I am not sure what to add. Like you, I enjoy discovering things in a story for myself. I remember, when I was acting, a director talking about how you have to earn silence in a play; if you have all the actors dropping pauses whenever they feel they have said something significant, the play grinds to a halt. For me, it's the same with backstory. These details must come out of the real story. You have to earn them.
I agree, too, that there are things in life that cannot be fixed. Maybe the best we can do is be open to change—and to accepting who we are. And this is what Harold becomes through his walk. There is a tiny suggestion at the end that even though there is hope, there is also the possibility of loss. But that is life, I think. Besides, Harold could not make the journey he has and not know these things. Yes, he and Maureen have rekindled—or rediscovered how to speak—the love that David's loss forced to a stand- still. But inevitably there will be other trials ahead. That is why I wanted to finish with those two small figures holding hands at the edge of the ocean. For me, laughter is the key.

Language is the first thing that attracted me to writing— how the words can convey character and philosophy and action, but also have a poetry and rhythm of their own. Here are two examples of terrific sentences from the book, although there are so many, I could open to almost any page and find one. But I like these because they do several things at once without being self-consciously showy, the way some contemporary writing can be.
He stopped referring to his guidebooks because the gap between their sense of knowing and his own of not knowing was too unbearable. It was as if Harold had taken off his jacket, followed by his shirt, and then several layers of skin and muscle.
What helps you to get into a literary mindset? I know you mentioned writing very carefully, and refining and tweaking, but are there other techniques or habits that allow you to better hear the music of your work?

It is a wonderful feeling when you get inside a sentence. It is the most frustrating feeling when you are floundering around on the outside of one. I am envious of people who can write pithy, elaborate prose, and it has taken me years to accept that what I do is write things simply.
Of course, I read The Lifeboat and I want to be Charlotte Rogan. I want to use your bold, stark sentences. I want to have a lifeboat full of characters, with wildly different backgrounds and objectives. But I can't be you. I can admire you, but then I have to get back to the business of being me.
Having said this, my first drafts are shocking. I reread them and I want to give up. After that, I go back and I go back and I go back. And every time I look at a scene—or I scrape at the surface—I see things a little more clearly. As for inspiration, sometimes I read poetry. Sometimes I look at writers I admire. But the thing is, I can only be who I am—so I have to keep whittling away. Besides, no one knows the story you are writing as well as you know it. And so you have to keep challenging yourself. You have to keep asking, Is this true, as I know truth?
Being an actor has definitely had an influence on me. I think many actors have a good ear for dialogue and the rhythm of dialogue. We all (and I mean human beings, not actors) talk in verse of the simplest kind. We use names, repetition, assonance, alliteration, exaggeration, metaphor—all those things to help us put across our point of view. For me, there is poetry in the simplest things. Listen to people. That is the best advice I can give myself. And keep hacking away.

Things are stark in a lifeboat, so that affected the way my story was told. In the case of Harold Fry, England is almost a character, and your reverence for her shines through. Once Har- old commits to his journey, he starts to see his surroundings in a new way: There were so many shades of green Harold was humbled. I imagine that writing so closely about the country gave you a new appreciation for it.
I don't know whether it is because I have spent years writing plays, but I am more comfortable taking the objective voice on a story. I like to be able to stand slightly to one side. It doesn't mean you are not inside your characters but it enables you to step away sometimes and place them as passing specks in a bigger landscape.
I relished the setting of The Lifeboat—your descriptions of the sky and sea, and the way they influence the human action. I am very interested in how we relate to the bigger things. How small we are against them.
I think I already loved the English landscape before I began to write about Harold Fry. In fact, I think the story partly came from that love. I am a Londoner, born and bred. We moved out eleven years ago when I was pregnant with my fourth child because I had a sudden and violent reaction against city living. I needed to see sky, not into another house—and I needed to see green, real green, not city green. We live now in a very old farm- house on the edge of a valley. The wind rattles through. We get small puddles inside the hall when it rains. But I step outside and I can see the sky from east to west. And I don't know how to explain this, but I feel contained at last.
So writing about Harold's awakening sense of the English countryside was like eating sweets for me. I wrote about what I see every day when I step out of my door.

Being true to your setting is one of the ways that truth in- forms fiction, and earlier you mentioned your father's illness as part of your inspiration for the book. Are some of the other incidents or vignettes based on things that happened to you, or are they wholly imagined?
As I said before, I draw on what I know and then I fabricate and weave from there. So a lot of the characters in the book are people I have seen, if only briefly. The man in the dress I watched once in Stroud. The arguing couple I overheard in a garden center. I had a summer job when I was a teenager in the craft shop where Harold buys place mats. I take what I see, what I feel, and I imagine from there. I couldn't write, I don't think, without feeling solid ground beneath me.
There is more pillaging too. My husband grew up in Kingsbridge. In fact, Harold and Maureen's house is pretty much where Paul was brought up. I am a terrible magpie. I hear little stories and they tend to stick in my head and reappear. So Paul as a boy did swim out on Bantham Beach, much to the horror of his parents. (He was never allowed to swim in the sea again.) My father's family all worked in pubs. I have a friend who was given a coat for his sixteenth birthday and shown the door. These details, these small pieces of truth, must play in my head, I suppose, and rearrange themselves however many years later into a story.
My children briefly pop up in the book, as does our dog, Leaf, a Border terrier, who was forever fetching stones. The sad ending to that particular story is that we realised Leaf had can- cer this summer, and that the cancer was too far gone to operate. I had to go to to Canada to do some promotion for the book and I asked him to wait for me—but, you see, he couldn't. He died quietly (like Queenie, and like my father too) when my back was turned.
I have a feeling that is how life often goes.

Copyright © 2013 by Random House, Inc.

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 Joyce at BookBrowse
Maureen jacket Miss Benson's Beetle jacket The Music Shop jacket The Love Song of Miss Queenie Hennessy 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 Joyce 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

We recommend 35 similar authors


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

Flaming enthusiasm, backed up by horse sense and persistence, is the quality that most frequently makes for ...

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 03:46 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
1780285613417 ms 1.78028561342E+012 ms 1 /root/website/app_server.cfm
391 ms 391 ms 1 /root/website/author_interviews/full/index.cfm
147 ms 147 ms 1 /root/website/app_layout.cfm
130 ms 130 ms 1 /root/website/author_interviews/full/dsp_main.cfm
80 ms 80 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
78 ms 26 ms 3 /root/website/adsystem/adsystem_mod.cfm
52 ms 52 ms 1 /root/website/app_globals.cfm
52 ms 26 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
37 ms 37 ms 1 /root/website/adzones/AdZone6.cfm
27 ms 9 ms 3 /root/website/site/blocks/membership_advantages.cfm
26 ms 9 ms 3 /root/website/queries/qry_get_member_account_types.cfm
24 ms 24 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
21 ms 21 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
19 ms 19 ms 1 /root/website/adzones/showcase_track.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_active_obc.cfm
14 ms 14 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_competition.cfm
7 ms 7 ms 1 /root/website/actions/adstatus.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/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/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
392 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 03:46:53.053
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=2ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:46:53.053
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

adactive (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:46:53.053
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 @ 03:46:53.053
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=4ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:46:53.053
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:46:53.053
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 @ 03:46:53.053
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 @ 03:46:53.053
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=2ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:46:53.053
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=3ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:46:53.053
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=6ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:46:53.053
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=4ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:46:53.053
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) = 2196

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 03:46:53.053
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) = 2196

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=2ms, Records=6) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 03:46:53.053
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) = 2196
Parameter #2(CF_SQL_INTEGER) = 2196

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=3ms, Records=4) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 03:46:53.053
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) = 2196

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=5ms, Records=35) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 03:46:53.053
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) = 2196

get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:46:53.053
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=4ms, Records=1) in /root/website/actions/udfs.cfm @ 03:46:53.053
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) = 3701

get_member_account_types (Datasource=bookbrowse_com_new, Time=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:46:53.053
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=15ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:46:53.053
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) = 2498
Parameter #2(CF_SQL_INTEGER) = 2498
Parameter #3(CF_SQL_INTEGER) = 2498

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:46:53.053
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) = 2498

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:46:53.053
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) = 3200
Parameter #2(CF_SQL_INTEGER) = 3200
Parameter #3(CF_SQL_INTEGER) = 3200

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 03:46:53.053
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) = 3200

get_member_account_types (Datasource=bookbrowse_com_new, Time=16ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:46:53.053
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=8ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:46:53.053
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=13ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:46:53.053
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=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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 @ 03:46:53.053
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=13ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:46:53.053
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 @ 03:46:53.053
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:46:53.053
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 @ 03:46:53.053
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=FREEACCESSCOUNT=1; CFTOKEN=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3; CFID=4084648; CFGLOBALS=urltoken%3DCFID%23%3D4084648%26CFTOKEN%23%3Dc926739703812947%2D0CEA16B2%2DE946%2DB841%2DD783ED93B4E97CE3%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A46%3A53%27%7D%23hitcount%3D16%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A46%3A50%27%7D%23cftoken%3Dc926739703812947%2D0CEA16B2%2DE946%2DB841%2DD783ED93B4E97CE3%23cfid%3D4084648%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/2196/rachel-joyce
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=4084648
cftoken=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
hitcount=20
lastvisit={ts '2026-06-01 03:46:53'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:46:50'}
urltoken=CFID=4084648&CFTOKEN=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
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#=4084648&CFTOKEN#=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3#lastvisit={ts '2026-06-01 03:46:53'}#hitcount=16#timecreated={ts '2026-06-01 03:46:50'}#cftoken=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3#cfid=4084648#
CFID=4084648
CFTOKEN=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
FREEACCESSCOUNT=1
Session Variables:
cfid=4084648
cftoken=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
sessionid=BOOKBROWSE_4084648_c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
urltoken=CFID=4084648&CFTOKEN=c926739703812947-0CEA16B2-E946-B841-D783ED93B4E97CE3
URL Parameters:
author_number=2196
rachel-joyce=
Debug Rendering Time: 36 ms