Brad Meltzer Interview, plus links to author biography, book summaries, excerpts and reviews

Brad Meltzer
Photo: bradmeltzer.com

Brad Meltzer

An interview with Brad Meltzer

Brad explains how he started writing, gives advice to aspiring writers and answers questions about each of his books.

I. WRITING

How did you get started writing?
It wasn't until I graduated from college. I was coming out of the University of Michigan and I had a job offer from the man who used to run Games magazine. He told me, "If you love the job, you'll stay. If you hate it, you'll leave a year later with some money in your pocket." Since I had some debt to pay off, that seemed like a fair deal. So I moved all my stuff to Boston. But when I got there, the publisher left the magazine. (Surprise!) The whole reason I went there was to work for him. I thought I'd wrecked my life. I had no idea what to do. So I did what all of us would do in that situation. I said, "I'm gonna write a novel." And I just started writing. Every day, I just fell more and more in love with the process.

Did you always know you wanted to be a writer?
No, but I always liked writing. Even back in high school, I tried to write all my papers using tons of dialogue. But it never hit me until I left college. Where I grew up, writing wasn't "a real job." And, thankfully, it still isn't.

Where do you get your ideas?
Research, research, research. You can invent all the stuff you want, but if it doesn't smell real, readers will know in a nanosecond (and rip your head off). To me, fiction is at its best when it has one foot in reality. That's why I need to go out and see the places myself. I need to see what they look like, and smell like, and taste like (yum, hamburger) — and those details drive the ideas. Everything else is a gift from God.

Locations like the White House, Congress, and the Supreme Court, even Disney World — how do you research these places?
Call up and ask. Seriously. If there's one thing I've learned (besides that ice doesn't get gum out of your hair), it's that people are genuinely nice. Once they realize you're writing fiction, and not looking for an expose, they love to talk. And that's the only way to get the details real. Also, try to find people who recently left the job you're trying to research. Those're the ones you want to meet (funny, honest, and no longer worried about impressing the boss).

How did you handle rejections from publishers?
I gave their e-mail addresses to my mother. You don't know pain until you've met Teri Meltzer. Fear it.

How long does it take to write a book?
About a year, to a year and a half. I spend about two months doing character sketches (Who are these people? What are they like?) and anywhere from two to six months researching. The rest of the time, I'm writing (and playing Parcheesi).

How do I get an agent?
First off, write the best book you can. Period. After that, you can find a list of agents in books like The Guide to Literary Agents. As a trick (which I recommend), you should pick out a few authors you like and check the Acknowledgements section of their hardback books. Most, if not all, writers thank their agents — and that's one way to get a list of agents who have actually sold things.

Beyond that, write a short (short!) cover letter to send out to prospective agents. As someone once told me, write it like you're writing the inside flap copy for the book. (Don't say, "In Chapter One, this happens; then in Chapter Two, this happens; then in Chapter Three…). They get hundreds of letters. And the sad truth is, agents want what they can't have, and whatever they can have, they don't want. Also, there's a fine line between enthusiasm and desperation. What does that mean? Don't be a nudge (I know, because I was — and none of those agents wrote me back). Just be concise and clear, and send out the best book you can.

Do you know the ending when you start?
I know what happens to the main characters simply because I have to. Each book is a journey. Ben, Sara, Michael, Oliver, Charlie, Harris, Matthew, Viv — each of them is a different person by the time the last page hits. So I need to know where they're going. Still, a novel is a process. It takes me over a year. During that year, I'm constantly changing my mind, adding new twists, and moving things around.

Do you outline?
Only about fifty to a hundred pages at a time. That way, I'm in control, but there's still plenty of room to let the creative process happen. If I just start typing and say "Let's see where the day takes me," I'll just meander around and it'll be a rambling mess.

How do you edit?
I give it to my wife, she tears it apart, then I pick my heart up off the linoleum and go to bed.

When I'm finished with the first draft, I start over again and continue layering, always trying to add more to the characters. A good plot is fine, but if the characters aren't real, no one'll care.

What do you like to read?
While I'm writing, I won't read in the genre and I try not to read novels. It's the only way I can keep my voice my own. Still, I love to read, so I consume graphic novels. Alan Moore…Neil Gaiman…all the usual suspects. I eat that stuff like candy.

Advice to other authors?
Don't let anyone tell you "No." I got twenty-four rejection letters on my first novel. It's still sitting on my shelf, published by Kinko's. I had twenty-four people tell me to give it up — that I couldn't write. But the day I got my twenty-third and twenty-fourth rejection, I said to myself, "If they don't like this novel, I'll write another, and if they don't like that one, I'll write another." Why? Because I fell in love with writing. A week later, I started the book that became The Tenth Justice.

Does that make everyone who sent me objections wrong? Not a chance. The best and worst part of publishing is that it's a subjective industry. All it takes is one person to say "Yes." You just have to find that person. If you love what you do, it'll show on the page. If you don't, it won't. That's the x-factor in every book. And that's what helps you move forward as a writer.

Do you get the plot…then the characters, or do the characters create your plot?
I start with a nugget. In The Tenth Justice, it was a Supreme Court clerk. In Dead Even, it was married attorneys. And in The First Counsel, it was a White House lawyer. Then I take the characters and throw them into the plot. If I'm doing it right, I hit a point where I stop telling them what to do, and they start telling me what they want to do. If all else fails, it's back to Parcheesi.

What's a typical day like for writing? (Do you commit to finishing a particular scene or commit to x amount of pages?)
I get up, I walk around the block, and then I sit down with my imaginary friends. At the end of the day, I try not to count pages, but I can't help myself. I'm sad that way.

What's going on with Hollywood? Are they making a movie?
Right now, Fox 2000 owns the rights to The Tenth Justice. They're working on a script, they're rewriting that script, and they're doing everything they should be doing. The people on it are some of the nicest people I've encountered — but does that mean we'll see a film? I have no idea. Would I love them to make it? Of course. But as far as I'm concerned, movies are icing on an already great cake. If it happens, I'm thrilled. If not, there're more important things to worry about in life.

As for The Zero Game, it was recently bought by Universal for producer Kathleen Kennedy and director Gary Ross, who recently did Seabiscuit.

On the TV side, we've recently sold a TV show called Jack & Bobby to the Warner Brothers TV network, which we're developing with Steve Cohen, Greg Berlanti, and Tommy Schlamme — and another show to F/X called The Thirteenth Floor, which Steve Cohen and I are developing with Frank Spotnitz of the X-Files.

And in terms of Dead Even, The First Counsel and The Millionaires, we still own the rights to all of them.

If you had to cast the movies, who do you see?

Honestly, I never see anyone. Personally, I don't want to write someone else's characters. I want to write mine. For that reason, I can tell you what every single character looks like, but it'd be no one you recognize. Ben, Sara, Jared, Nora, Oliver, Charlie, Harris, Matthew, Viv — to me, they just look like people.

Any new comic book projects in the works?
Yes — a brand new one called "Identity Crisis" from DC Comics, which'll come out in June of 2004. It's a murder mystery set in the DC Universe and will star Superman, Batman, Wonder Woman and just about everyone else I could get my hands on. Without a doubt, I'm as proud of it as almost anything I've ever written. And with Rags Morales and Michael Bair on art, and Alex Sinclair on colors...oy, I can't wait. Please, like they really had to twist my arm to get me to write Superman, Batman, and — oh, you'll see...


II. THE BOOKS

The Tenth Justice

Was The Tenth Justice your first book?

No. The first book I ever wrote was a book called, Fraternity. It got twenty-four rejection letters, and still sits on my shelf. Will I ever go back to it? I don't know. It's kinda like a ‘68 Mustang. You can clean it up, and put in a new engine, and install new air conditioning and a CD player, but on some level, when you do that, you rob it of its soul.

What I love about Fraternity is that, whatever I think about it, it's a book with a soul. It's me figuring out how to write. And on every page, it has the passion of someone who's falling in love with the process. That's what's great about it. So, yes, I can take it, update it, and put in the new CD player, but sometimes, AM/FM is more than enough.

Are the roommates in the house based on you and your friends?

The funny, handsome ones are me. All the losers are my friend Chris.



Dead Even

Rafferty is an evil character. Do you find writing this type of antagonist therapeutic? And is a character with that base level of psychology (pure evil) more difficult to write than a character like Sara, who finds herself faced with moral ambiguity?
Rafferty was actually much harder to write because he was always the bad guy. That's what he did. Name: Rafferty. Occupation: Bad Guy. Sure, he's there to scare, but as a character, I'm far more interested in his back story as a loser kid from Hoboken (which only appears on two or three pages).

And is it therapeutic? I'm betting I saved at least seventy-five bucks worth of shrink's bills just on the final scene alone.

Both yourself and your wife are lawyers. Were the characters of Dead Even based on you and your wife?
No. Okay, that's a lie. I've known my wife since ninth grade. I know how we interact. The opening scene — where Sara and Jared take on the coupon lady? Pretend it didn't happen in a bagel store; pretend it was in Bethesda, Maryland; pretend Jared had a lot less hair. But are Sara and Jared us? Not a chance (which I can only prove by the fact that half our friends say I'm Jared and that my wife is Sara, while the other half say the reverse).


The First Counsel

Were you thinking of any President in particular when you wrote this book?
No — I was thinking of all of them. Sadly, you don't get to be President by being Father of the Year.

While you write thrillers, most people think of you as a "legal thriller" writer. However, this book really deals more with politics than the law. What was the reason for that decision?
It really wasn't a decision. I just try to write the best book I can. When I researched this one, I thought, "Hey, this White House place is pretty keen." That was it. As for genres, that just seems silly. Genres can be great, but they're also a trap. Don't write for genres. Write for yourself.

Let's talk about The West Wing. What's the story? Do you watch it?
Ah, The West Wing. First, it's a brilliant show, and yes, I love the writing. Second, I'd be a liar if I said it didn't make me nuts. Why? Here's the history: The week I started researching The First Counsel was the same week the Monica Lewinsky scandal broke. The Washington Post then wrote this big story about how the Washington thriller was dead, and how no one could compete with reality. And there I was, thinking, "Oh, God — I'm about to start a Washington thriller. How can it be dead?"

Little did I know that two years later, The West Wing would be one of the best shows on television. Of course, by the time it aired, I was already in the editing stage. Then I watched the first show. They deal with the census. In The First Counsel, the opening meeting talks about the census. Their President's name is Bartlet. In The First Counsel, the politician running against the President is named Bartlett. I almost ate my remote right there. Obviously, it was just a coincidence (the census is always a good, solid, play-at-any-time issue), but it was still nuts. As for Bartlet, that was just freaky weird. Yes, I could've changed it — there was time — but that was the name I picked and I wasn't changing it for anyone. Now, in the book, it just seems like a inside joke.

Is Nora based on a real first daughter?
No (and even if it was Yes, I'd lie).


The Millionaires

Is Charlie real and can I date him?
No, he's not real — so save your smutty come-ons for those porn sites. He's a pure figment of my imagination, with far more hair than I have. And can you date him? Sure, right after your date with the Tooth Fairy.

The Millionaires centers around two brothers. Do you have a brother?
Nope. I have a sister (the Charlie to my Oliver and the Oliver to my Charlie) — but to write the book, I spent months interviewing all my friends who had brothers, trying to pick out the subtle things only brothers can share. In the end, Charlie and Oliver just came to life in my head — and I still think about them, if that makes sense.

The climax of The Millionaires takes place in the underground tunnels under Disney World. Are those real or just urban legend?
Real. Real, real, real (creepy, ain't it?). And after researching books on the White House, the Supreme Court, and the Capitol, I can honestly say that Disney keeps its secrets better than all of them combined. No lie. You wanna know who should be the head of Homeland Security? Michael Eisner. I love the place, but they don't play around. They'll throw you in Mickey-jail without batting an eye. Scarier than Oz.

Is that really your Grandmother's condo in the book?
Could I possibly make that up? Of course it's her condo. When I was little, they wouldn't let us jump in the pool, but I never held a grudge. (They'll pay one day, though.)

In this book, you used first person narrative (telling the story from Oliver's point of view). Did this present problems since you had two main characters?
Point of view is always tricky. Get too cute and you risk losing your reader. In fact, when I wrote the first draft of the book, I had each chapter alternating between Oliver's and Charlie's POV — but it quickly got so confusing that I switched to just one. It was the hardest decision I made with The Millionaires, but I still think the right one.

What was it like writing Miami for the first time?
Great. When I needed to know what restaurant was on a particular corner, I just called my Dad. He majors in restaurants.


The Zero Game

Could The Zero Game really happen, and do you think that right now, there's a "Zero Game" being played on Capitol Hill?
To be honest I made it up, but so far, two different government employees have told me they've seen a smaller variation being played (i.e., people betting on how many votes will be cast for a certain bill). That's just scary. Also, I'm honestly amazed by how many staffers on the Hill, when they hear the plot, say, "I wouldn't be surprised if someone was doing that right now." God bless America!

On the site, you have a "deleted chapter" from The Zero Game. How much of what you write never makes it into the final book?
I wish I could say all of it makes it into the final version, but that's just not the case. For me, it's the early chapters of a book that get cut down the most. When I'm done with my research and ready to start a new novel, I've got so much I want to put in there, I just vomit it all out in the opening chapters. Those are the same chapters that all my family and friends read and say, "Nice research, but can you get on with the book?" So the early chapters get cut. In The Zero Game, the first seventy pages were originally a hundred and twenty. And the scene in the mine was another thirty pages longer. Welcome to the cutting room floor. (BookBrowse note: You can read the deleted chapter at Brad Meltzer's website)

Did you really go down into that mine?
Yep. Probably not the smartest move, but I did — eight thousand feet straight down. The first time I went, because of a flood, we could only go down two thousand feet. I went back two weeks later and they took me to the very bottom. Two weeks after that, those miners got trapped in that Pennsylvania mine. They were 240 feet down; I was 8,000. My wife wanted to kill me — but for my readers, I'll risk my life.

How hard was it to write the character of Viv?
Far harder than I thought. Viv is a young, black female Senate page. So let me put it this way: There are three things that, no matter what I do, I know I'll never be in my life: young, black and female. But I just didn't want to write a walking cliché, so I spent months researching...talking to friends...interviewing people...anything that would put me in that character's brain. The gender part I could manage — the race issue was tougher. I hope I did her justice.

What was the most fun you had researching this book?
Tie. Crawling around the basements and attics of the Capitol — and going down into the mine (c'mon, they let me wear that hat with the flashlight — what beats that?).

What are you currently working on?
New book. Yes, it's a thriller. And no, it doesn't have a lawyer. Wait…actually, that's not true. There's one really cool lawyer, but not how you think.

Is there anything you've written, where after you saw it in print, you wished were different?
All my author photos. Real quote from someone: "Who taught you how to smile? Mussolini?"

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 Brad Meltzer at BookBrowse
The JFK Conspiracy jacket The Nazi Conspiracy jacket The Book of Lies jacket The Book of Fate 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 Brad Meltzer 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

  • Charlie English

    Charlie English

    Charlie English is a former journalist for the Guardian, where he held several positions including arts editor and head of international news. A fellow of the Royal Geographical Society and the author of two previous books, ... (more)

    If you enjoyed:
    The Nazi Conspiracy

    Try:
    The Gallery of Miracles and Madness
    by Charlie English

  • Jack Fairweather

    Jack Fairweather

    Jack Fairweather is a former war reporter in Iraq and Afghanistan. He has been a correspondent for the Washington Post and the Daily Telegraph, where he served as the Baghdad and Persian Gulf bureau chief. His reporting ... (more)

    If you enjoyed:
    The Nazi Conspiracy

    Try:
    The Volunteer
    by Jack Fairweather

We recommend 14 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...

There is no such thing as a moral or immoral book. Books are either well written or badly written. That is all.

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 05:36 AM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780292182535 ms 1.78029218254E+012 ms 1 /root/website/app_server.cfm
357 ms 357 ms 1 /root/website/author_interviews/full/index.cfm
149 ms 149 ms 1 /root/website/app_layout.cfm
133 ms 133 ms 1 /root/website/author_interviews/full/dsp_main.cfm
106 ms 106 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
101 ms 34 ms 3 /root/website/adsystem/adsystem_mod.cfm
70 ms 35 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
55 ms 55 ms 1 /root/website/app_globals.cfm
54 ms 54 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
53 ms 53 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
41 ms 41 ms 1 /root/website/adzones/AdZone6.cfm
37 ms 37 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
35 ms 35 ms 1 /root/website/adzones/showcase_track.cfm
26 ms 26 ms 1 /root/website/adzones/AdZone2.cfm
22 ms 7 ms 3 /root/website/site/blocks/membership_advantages.cfm
20 ms 7 ms 3 /root/website/queries/qry_get_member_account_types.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_active_obc.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
8 ms 8 ms 1 /root/website/actions/adstatus.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
6 ms 6 ms 1 /root/website/act_check_login.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_current_competition.cfm
5 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_header.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_bb_briefs_by_author.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.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
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/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_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
359 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 05:36:22.022
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 05:36:22.022
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=3ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 05:36:22.022
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 05:36:22.022
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 05:36:22.022
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 @ 05:36:22.022
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=4ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 05:36:22.022
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=8ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 05:36:22.022
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=2ms, Records=4) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:36:22.022
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) = 545

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 05:36:22.022
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) = 545

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=2ms, Records=7) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 05:36:22.022
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) = 545
Parameter #2(CF_SQL_INTEGER) = 545

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=1ms, Records=3) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 05:36:22.022
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) = 545

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=3ms, Records=14) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 05:36:22.022
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) = 545

get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:22.022
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=9ms, Records=1) in /root/website/actions/udfs.cfm @ 05:36:22.022
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) = 4562

get_member_account_types (Datasource=bookbrowse_com_new, Time=9ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:22.022
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=23ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:22.022
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) = 3564
Parameter #2(CF_SQL_INTEGER) = 3564
Parameter #3(CF_SQL_INTEGER) = 3564

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:22.022
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) = 3564

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:22.022
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) = 3239
Parameter #2(CF_SQL_INTEGER) = 3239
Parameter #3(CF_SQL_INTEGER) = 3239

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 05:36:22.022
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) = 3239

get_member_account_types (Datasource=bookbrowse_com_new, Time=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 05:36:22.022
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=22ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:36:22.022
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=29ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 05:36:22.022
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=21ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=8ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 05:36:22.022
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 @ 05:36:22.022
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 05:36:22.022
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=4089539; CFGLOBALS=urltoken%3DCFID%23%3D4089539%26CFTOKEN%23%3Dfc2e5af7702468ea%2D10CFB09F%2DDF96%2D0424%2DC7FFEC28361769DE%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2005%3A36%3A22%27%7D%23hitcount%3D226%23timecreated%3D%7Bts%20%272026%2D06%2D01%2005%3A35%3A48%27%7D%23cftoken%3D85377496813ce83%2D10CFA14C%2DBCD4%2D2943%2D0FCDF348B6F8E93B%23cfid%3D4089535%23; CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=0
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/545/brad-meltzer-josh-mensch
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=4089535
cftoken=85377496813ce83-10CFA14C-BCD4-2943-0FCDF348B6F8E93B
hitcount=229
lastvisit={ts '2026-06-01 05:36:22'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 05:35:48'}
urltoken=CFID=4089539&CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
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#=4089539&CFTOKEN#=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE#lastvisit={ts '2026-06-01 05:36:22'}#hitcount=226#timecreated={ts '2026-06-01 05:35:48'}#cftoken=85377496813ce83-10CFA14C-BCD4-2943-0FCDF348B6F8E93B#cfid=4089535#
CFID=4089539
CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
FREEACCESSCOUNT=0
Session Variables:
cfid=4089539
cftoken=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
sessionid=BOOKBROWSE_4089539_fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
urltoken=CFID=4089539&CFTOKEN=fc2e5af7702468ea-10CFB09F-DF96-0424-C7FFEC28361769DE
URL Parameters:
author_number=545
brad-meltzer-josh-mensch=
Debug Rendering Time: 19 ms