John Dunning Interview, plus links to author biography, book summaries, excerpts and reviews

John Dunning
Rykken Johnson

John Dunning

An interview with John Dunning

Dunning explains the story behind Two O'Clock Eastern Wartime?, his novel set in the world of 1930s and '40s radio.

What's the story behind Two O'Clock Eastern Wartime?
It's a novel I've wanted to write for years -- to show what it was like to work in radio when it was the top entertainment medium in the country. Even movies took a back seat to radio in the Thirties and Forties, especially in the Thirties. The country was in the middle of a depression and people couldn't afford to go out. It cost a dime or a quarter to see Eddie Cantor on the screen -- you got him free on the radio, and it was all live, that was the excitement and magic of it, it was happening right then as you were listening to it. There was no phony laugh track, a comic lived or died by his material, and there were a dozen ways a dramatic show could fall apart. But when it worked, ah, man!...there were some great shows, some almost perfect pieces of air. Radio was a wonderfully creative business then, but everything you read and see plays it as high camp, as if the entire radio era was directed by Woody Allen. It wasn't like that, not to the actors who did fifteen shows a week, not to the writers who created what went on the air. To them it was the stuff of life. And at its best it approached high art. That's what my book is about. The lost art of radio.

At the same time, this is a mystery, right? How did you come up with a mystery for radio?
With great difficulty. Nobody likes to hear how hard a writer's job is, so I'll spare you most of it. Let's just say that, as far as the writing goes, this was my ultimate seek-and-hope-to-find book. I probably wrote 5,000 pages on the various drafts of this book, and most of it was groping through a wilderness, trying to find something I could only feel and couldn't adequately define.
Now I look back at it and I see why so many ideas were fully written out and then rejected. I needed a plot that enhanced the notion of radio as a medium of the mind, not a story that merely stated that or played on it. The reader has to see it, step into it, become part of it, or it doesn't work. I didn't want a hint of nostalgia in this book, I wanted it to be as real as a man pouring a cup of coffee in the morning. That's what Jack Webb said about his goals for Dragnet 50 years ago, and that's how I felt about this.

On the face of it, the mystery story is a great way to get into something. But in a traditional mystery the puzzle takes top billing over everything. That's a rule as old as mystery writing itself, and it's almost impossible to break it. That was the main problem with the writing of this book, how to be true to the mystery and still keep the radio story on an equal level.

How did you do that?
I can tell you how I tried to do it. For months I groped around and wrote hundreds of pages, looking for away into it. I must have tried a dozen different plot ideas before I realized that the book's only chance was for the mystery and radio stories to become one. Radio would not be a simple backdrop, it demanded to be at the heart of it. And that set up more problems than I ever imagined because I wanted the hero, Jack, to come to it cold. I wanted him to get his radio experience from the ground up, as a novice, as any reader might if he stepped back in time to 1942, when the novel is set, and found himself at that radio station. Hopefully, it then becomes a voyage of discovery for both the character and the reader. In the beginning he's not only an outsider, he has a rather negative opinion of broadcasting. Radio is frivolous in his mind, it's not a forum for serious dramatic expression. Jack is a novelist who never would have gone into radio on his own. It's the mystery that forced him there. The mystery involves his old flame, Holly, and it's her trouble that pulls Jack all the way across the country to this noisy little beach town in New Jersey, and to work at the radio station where Holly sings with a small band every Saturday night.

It sounds like the mysteries of the flesh play a fairly large part in it.
That's true in everything I write. There's always an erotic foundation, some male-female business at the heart of it. The thing between Holly and Jack had to be strong stuff in my mind or I couldn't have written it.

Where do you get your characters?
From myself, mostly. This doesn't mean that I am literally anybody in the book, but I am certainly as much Holly as I am Jack. There are people who get inside your heart, and parts of them swirl together and come out when you need a Holly or a Jack. She is a mix of women who have come my way. Sometimes it's somebody you barely knew, sometimes it's someone as close as your father. My dad was a big man like Jack, and like Jack he was from South Carolina: he was a cabinetmaker like Jack's father, but he is certainly not Jack, and Holly bears no resemblance to anybody in my family.

What was it about radio that got you going? Why did you turn away from your Cliff Janeway book hunter series just when they were perhaps on the verge of real success?
In some ways this is a lot like the book world, it's a big part of my life. And I'm not just talking about the 20-odd years I spent doing a radio show. I grew up with radio drama, I can remember so well the incredible involvement the listener had with those radio shows. That stays with you, it's something you never really forget. I don't care how many special effects movies or TV develop, after a while even the destruction of the universe is just another explosion, something to watch from a distance. But radio came from inside you. Of course when you're a kid you don't realize that -it wasn't until many years later that I came to know how great some of the shows really were. I'm not talking about The Shadow now, or The Lone Ranger. Most of the shows that were great are virtually unknown today.

What were some of them?
You could start with the lesser-known Norman Corwin shows -- not the patriotic stuff, which was great in its own way but was produced for a specific purpose -- I'm thinking more of Corwin's one-shot stories, running from heavy drama to whimsy. Then there was Vic and Sade -- Paul Rhymer, who wrote that series, was compared to Mark Twain as a great American humorist. It was John O'Hara I believe who made that comparison, and I second it. Or how about Destination Freedom, Richard Durham's courageous and powerful 1948 series about the struggles of the black race in a Jim Crow world? I used that series as a model for my own black show in Two O'Clock Eastern Wartime. I wanted to illustrate what could be done in a crusading way with radio drama under an eccentric but sympathetic station owner. Even series shows, thriller dramas like Suspense, westerns like Gunsmoke and Frontier Gentlemen, had their high spots that stand out in the mind. But maybe my favorite radio show was On Stage with Cathy and Elliott Lewis, which ran on CBS in1953-54. Each week they did one self-contained short story with a strong male-female conflict. It was just superb, and the recordings that survive today prove that radio should never have been discarded for TV. As a medium radio deserved better. It was the perfect vehicle for short story dramatization, the ideal partner for the printed word. You should hear what NBC Presents Short Story (another great series) did with Shirley Jackson's horror classic, The Lottery.

I hate to use this line because it's overworked, but it's true: by requiring you to use your imagination, radio had a far greater canvas than TV can ever hope to have. I think it was Stan Freberg who said, "I like radio because the pictures are better."

A project like this must have involved years of research.
Yeah, but it was ongoing, so that -- like the background for books in the Janeway novels -- I absorbed it over a period of years. We were very lucky with radio, in that the technology for preserving the shows was available from at least the early 1930s on. Most of network radio was done live, but engineers had the capability to make airchecks of what was heard: recordings of live radio shows as they were happening. These airchecks were saved by the thousands -- by tens of thousands -- and by 1969 I had become aware that many of these programs had been transferred from their cumbersome acetate discs onto recording tape. It was fascinating to hear these things again, not only the shows I had heard as a kid but the whole range of radio broadcasting -- band remotes, newscasts, comedy, drama, you name it. I began to collect this stuff, and then one day in 1972 a local station heard about me and my radio shows and asked me to do a program. I did it for years on various stations in Denver. At KADX, the late great jazz station, they gave me the whole Sunday afternoon to play with. I would play a few shows, always in their entirety, always uninterrupted with all the original commercials and announcements, and then I'd play old music -- some jazz, some schmaltz, whatever fit the theme. And for a couple of years I conducted live interviews by telephone with some of the stars, sound effects people, writers, producers, from the old days. Most of them were in their seventies then. I had to do some real detective work to track them down, then I'd call them up and I'd interview them for an hour or more. And I picked up a lot of folklore doing that. Most of the people I interviewed then are dead now, but I recorded our talks and they are on file at the Broadcast Pioneers Library.

Who are some of these people you talked to?
Oh, God, let me see...I did at least 125 of these interviews, and I had a great sponsor, the Public Service Company of Colorado, which was satisfied to have its message aired around the edges of the programs, so I never had to interrupt anything. They sponsored me for something like ten years, and I could do long continuous live interviews with anybody I could get on. I had Corwin on twice, and Elliott Lewis three times. Richard Durham came on and told me how they'd done Destination Freedom in Chicago. That was such a strong series. They had no budget and they were tucked away on Sunday morning, but Durham's writing was so strong that a group of white supremacists came out and picketed his station. And I had Howard Duff, who played Sam Spade on the air, and on one show I had Janet Waldo and Sam Edwards, who were Corliss and Dexter, long ago on Meet Corliss Archer. I had Jim Jordan, who played Fibber McGee, but he was just as cantankerous as his character and he spent the whole time arguing with me and my assumptions. And Phil Harris and Dennis Day from The Jack Benny Program, and George Balzer, who was one of Benny's writers, and Frank Nelson, who was such a memorable stooge -- Frank told me his whole purpose was just to "annoy the hell out of Jack Benny" every week. For one show I found a BBC engineer who used to go up on the rooftops with Murrow in London during the blitz -- I found him living in Minnesota, and he came on and was great. I remember him telling me about Murrow standing on the edge of the building when a German bomb fell in the streets a block or two away. "If it just got a little closer," Murrow said, "we could pick it up on mike." But the BBC guy said that was plenty close enough for him.

Let's see, who else? -- I had both Parley Baer and Georgia Ellis on one show. Parley had played Chester and Georgia was Kitty on the radio Gunsmoke. I tried to get William Conrad, who was Matt Dillon, but he was a tough man to pin down and I never did get him. I did have Paul Frees, who was one of Conrad's best friends and with Conrad was one of the two lead voices on the great CBS adventure series, Escape. And I had Berne Surrey, the CBS sound effects man, who did all the early versions of Sorry, Wrong Number with Agnes Moorehead on Suspense. Then there were the newsmen, Charles Collingwood and Eric Sevaried and Larry Lesueur. Collingwood was a great guy -- I later met him in Denver and he told me that when he was covering the war in North Africa he was known as the only man in the press corps who knew where to get his pants pressed. Sevareid didn't want to come on at first, but I dubbed off a piece of tape I had of his coverage on the Italian front around 1944, and I sent it to him at CBS. He told me his wife was reduced to tears when she heard it, and he agreed to come on for a few minutes. He stayed the whole hour. And Larry Lesueur was one of my favorite shows -- he was also one of "Murrow's boys" in London. He and Sevareid roomed together in 1940, when the blitz was at its worst. I started the show by playing an actuality with Lesueur from that summer. It was a wonderful piece in great sound, and just as he began his report the air raid sirens cut loose. I tell you, there is no other sound on earth like that.

Are any of these people actually in the book?
No, they are just part of my own past, of my gradual enlightenment and understanding of how radio was done. I never intended to write what they call a roman-a-clef, or one of those books where real celebrities of the past do walk-ons and help the hero solve the mystery. Fred Allen Solves the Murder -- that's not my thing. No, this is a story about one man and how he comes from nowhere to work in a medium he couldn't care less about, how he discovers his true calling in that world, and how it finally comes to mean everything to him. There are very few real shows even mentioned in the book. When it opens Jack is sitting in a jail cell listening to The Charlie McCarthy Show, and later to Walter Winchell, on the deputy's radio. But this is just background. At some point one of the characters mentions her own favorite shows, Vic and Sade and One Man's Family, and Jack himself is aware of the station's network schedule. He knows when band shows like Jimmy Dorsey or Lionel Hampton come on: he knows about the soap operas, John's Other Wife, and Amanda of Honeymoon Hill. But in the main this is Jack's story. In a way it's a coming-of-age piece, this is the beginning of his radio journey, and it doesn't matter if he's 32 years old or any age.

What about actual library research? -- you still, must have had to do a lot of that.
Oh yeah. Not specifically for this book, but there's a lot of digging through old radio schedules, poring over old Radio Guide and Radio Life magazines, in my past. All through the early and mid-Nineties I was writing a nonfiction book on radio (On the Air, for Oxford University Press). I really had to knuckle down and do some hard research for that. It took five or six years all told. By the time I was ready to start Two O'Clock Eastern Wartime, I was pretty well grounded in radio. So though I really didn't do any specific research for this novel, in another sense I had been researching it forever.

Does this book have series possibilities?
That's not likely, given the way it ends. And I have never believed in long-running series characters anyway. You write a book and use up all your energy, and very seldom can you go back and recapture that spark that got you into it. I can't imagine writing a book a year for 20 years with the same character. The longer you go, the staler you get. There's a good reason why Raymond Chandler is still considered a mystery icon after 60 years. He only wrote half a dozen novels. If he had written 20 Marlowe books, would we still care as much? I believe that in series novels, fewer is always better than more, and these books should never be written to contract, with a schedule that must be met.

Does this mean we have seen the last of Janeway?
In fact, I do have a Janeway idea cooking, but God knows, given the way I write, when it will come to pass. I didn't intend to turn away from Janeway, I only wanted to give him a rest and let his bookman's cup fill up again. But the last thing I wanted to do with Janeway was beat him into the ground with a long run of book-of-the-year problems. I'd rather use the Chandler model of six books max. I'd like to tell the story of the book trade as I know it in four, five, six Janeway books, whatever it turns out to be. In that span I want to tell about all the craziness in the book world today. At the heart of each is a book or a book theme that illustrates some different aspect of that world, some new thing each time.

Now this is going to be more difficult than I imagined. The book world has changed so much even since The Bookman's Wake came out in 1995. I can't just have Janeway operating in that old world before computers took us over, and at the same time I don't want him to age too fast. It's amazing, isn't it? -- if I write about the book world as it was just ten years ago, it's a period piece.

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 John Dunning at BookBrowse
The Bookwoman's Last Fling jacket The Sign of The Book jacket Two O'Clock, Eastern Wartime 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 John Dunning 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 7 similar authors

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

The silence between the notes is as important as the notes themselves.

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 01:35 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780320906293 ms 1.78032090629E+012 ms 1 /root/website/app_server.cfm
809 ms 809 ms 1 /root/website/author_interviews/full/index.cfm
332 ms 332 ms 1 /root/website/author_interviews/full/dsp_main.cfm
206 ms 206 ms 1 /root/website/app_layout.cfm
200 ms 100 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
177 ms 177 ms 1 /root/website/app_globals.cfm
162 ms 54 ms 3 /root/website/adsystem/adsystem_mod.cfm
147 ms 147 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
61 ms 61 ms 1 /root/website/adzones/AdZone2.cfm
59 ms 59 ms 1 /root/website/queries/qry_get_active_obc.cfm
55 ms 55 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
54 ms 54 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
54 ms 54 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
53 ms 53 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
52 ms 52 ms 1 /root/website/adzones/showcase_track.cfm
50 ms 50 ms 1 /root/website/adzones/AdZone6.cfm
40 ms 13 ms 3 /root/website/site/blocks/membership_advantages.cfm
39 ms 13 ms 3 /root/website/queries/qry_get_member_account_types.cfm
39 ms 39 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
31 ms 31 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/formurl2attributes.cfm
20 ms 20 ms 1 /root/website/actions/adstatus.cfm
13 ms 13 ms 1 /root/website/act_check_login.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_member_info.cfm
11 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.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/dsp_border_booktalk.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/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_previous_arcs_for_ad.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
811 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:35:06.006
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=11ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 13:35:06.006
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=19ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:35:06.006
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 @ 13:35:06.006
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=8ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:35:06.006
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=11ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:35:06.006
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:35:06.006
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 @ 13:35:06.006
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=19ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:35:06.006
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:35:06.006
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=31ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:35:06.006
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=20ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:35:06.006
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) = 552

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=33ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:35:06.006
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) = 552

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=3) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 13:35:06.006
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) = 552
Parameter #2(CF_SQL_INTEGER) = 552

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 13:35:06.006
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) = 552

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=11ms, Records=7) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 13:35:06.006
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) = 552

get_ads (Datasource=bookbrowse_com_new, Time=36ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:06.006
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=22ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:06.006
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=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:35:06.006
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=14ms, Records=1) in /root/website/actions/udfs.cfm @ 13:35:06.006
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) = 1542

get_book_image (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/udfs.cfm @ 13:35:06.006
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) = 716

get_member_account_types (Datasource=bookbrowse_com_new, Time=13ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:35:06.006
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=62ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:35:06.006
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) = 1160
Parameter #2(CF_SQL_INTEGER) = 1160
Parameter #3(CF_SQL_INTEGER) = 1160

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:35:06.006
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) = 1160

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=44ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:35:06.006
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) = 1029
Parameter #2(CF_SQL_INTEGER) = 1029
Parameter #3(CF_SQL_INTEGER) = 1029

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=76ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 13:35:06.006
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) = 1029

get_member_account_types (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:35:06.006
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=27ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:35:06.006
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=24ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:35:06.006
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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:06.006
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:06.006
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:07.007
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=38ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:35:07.007
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 @ 13:35:07.007
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:07.007
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:07.007
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=18ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:35:07.007
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=CFID=4102203; CFGLOBALS=urltoken%3DCFID%23%3D4102203%26CFTOKEN%23%3D8ac4642405ddf913%2D21F3ADEC%2DF93E%2D9636%2DD2C9348E4183A520%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A35%3A06%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A35%3A05%27%7D%23cftoken%3D8ac4642405ddf913%2D21F3ADEC%2DF93E%2D9636%2DD2C9348E4183A520%23cfid%3D4102203%23; CFTOKEN=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520; 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/552/john-dunning
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=4102203
cftoken=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
hitcount=2
lastvisit={ts '2026-06-01 13:35:06'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:35:05'}
urltoken=CFID=4102203&CFTOKEN=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
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#=4102203&CFTOKEN#=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520#lastvisit={ts '2026-06-01 13:35:06'}#hitcount=2#timecreated={ts '2026-06-01 13:35:05'}#cftoken=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520#cfid=4102203#
CFID=4102203
CFTOKEN=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
Session Variables:
cfid=4102203
cftoken=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
sessionid=BOOKBROWSE_4102203_8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
urltoken=CFID=4102203&CFTOKEN=8ac4642405ddf913-21F3ADEC-F93E-9636-D2C9348E4183A520
URL Parameters:
author_number=552
john-dunning=
Debug Rendering Time: 9 ms