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

Brad Newsham
Photo: bradnewsham.com

Brad Newsham

An interview with Brad Newsham

Brad Newsham shares all the pertinent (and very interesting) facts about himself, as well as an extensive dialogue discussing Take Me with You and his own travels.

Tell us about yourself (e.g. personally, politically, and professionally).
I've heard it said that one should be able to tell the pertinent facts of one's life in two minutes, and I think I've got that down. I'm 48, born and raised in the suburbs of Washington, D.C. My mother is the daughter of Czech immigrants who moved to Western Pennsylvania in the early 1900s--her dad was an underground coal miner. My father was a CIA cartographer for 33 years. Both were Christian Scientists, and although I am a graduate of Principia College, a school for Christian Scientists, I don't claim a Religion - except, perhaps, reading. I have an older sister and two younger brothers scattered between D.C. and Tokyo. I've lived in ten different states and visited all 50, and I've circled the Earth four times. With one chain saw and no electricity, two friends and I built a big log cabin from scratch, sort of, near the Clark Fork River in northern Idaho twenty years ago. I'm in my second and last marriage, and my wife Rhonda and I have a three-year-old daughter, Sarah, who has completely seduced us. I've worked in restaurants, on newspapers, on construction jobs, and had a year-and-a-half stint in Colorado as an underground molybdenum miner. For the past 15 years I've been a San Francisco Yellow Cab driver, a job I love. Since Sarah was born I've been cab driving on weekends and spending Monday through Friday at home chasing after her. About a minute and a half, I think.

What influenced or motivated you to make your first solo trip, and where did you go?

I hitchhiked around the U.S. by myself quite a bit after college. In 1974 in a YMCA in New York City I finished reading James Mitchner's The Drifters - a book about hippies hanging out in Europe. When I finished the last page I said to myself, "I'm going to Europe." And about eight months later a friend and I flew to Europe and found work washing dishes in a Swiss train station restaurant. Later I traveled down to Morocco and around Europe, and wound up wandering as far as Afghanistan. Before I'd left the U.S., I don't think I could have found Morocco or Afghanistan on a map. I came back a different person.

But my first solo out-of-the-country trip was inspired strictly by being kicked out of my first marriage. In the book The Beach, not my favorite, Alex Garland said one thing I think is true: "Escape through travel does work." And at least for me running away certainly helped. I went to Japan, Hong Kong, China, and I rode the Trans-Siberian railroad across the old USSR in the height of a beautiful summer. Random House published my account of that trip--All the Right Places--my first book.

It seems apparent, from reading Take Me with You, that you feel as though travel has changed you and has had profound influences on your life's direction. Please elaborate on that.
I grew up in the 50's, when the prospect of going to Europe was something it seemed that only very, very rich people could even consider--and traveling anywhere else was simply not done. I lusted after travel, but I had a firm conviction that it would never happen to me--to other, really lucky people, maybe, but me? I would be lucky to get into college, lucky to find an employer and a place to live - travel dreams were way beyond me. I also used to feel the same thing about being a writer, too. I think I was probably 27 or 28 before the idea that it was in fact MY life to do with as I pleased ever reached me. And whenever I get a chance to talk to kids, I try to tell them that.

Anyway, it did seem that my best daydreams took place when we were driving around the country in the family station wagon, watching scenery go by. I always loved that - being away from homework and chores and responsibilities and letting ourselves do whatever fun thing we could conjure up, or explore whatever new place Dad drove the car to. My adult travel has been pretty much an extension of that.

Without revealing the identity of the person you chose to invite back to the U.S., can you share some of the reasons that you chose that individual?
Well, a lot of it really was chance. There were many people I would have liked to consider, but who were apparently failed by the postal systems in their countries. I collected lots of addresses during my trip, but about half the people I wrote to never responded to my post-trip letters - and I sent each of them at least four. So either they couldn't afford a stamp, or couldn't manage a letter, or my letters never reached them - I suspect the latter.

But I really LIKED the person I've invited. We spent a fair amount of time together and I probably got to know him better than I did the others. But really, in the end, although I was leaning toward him and one other guy, I did really put all the names into a hat and I drew his out. And when I did, it felt exactly right.

What do you look forward to sharing with your guest?
Well, this great country of ours, certainly. The Bay Area. I once walked from Golden Gate Park in San Francisco up the coast 45 miles to Pt. Reyes. Five days. It's a spectacular hike, and if my friend is up for it, we may go and do that. We'll also get in a car, the most American activity of all, and see a good chunk of the American West, and perhaps even drive back east, to D.C., and maybe ride the train up so he can have a peek at New York. There are so many possibilities. I'm going to play it by ear a bit. I like my trips to have a skeleton plan in advance, but I flesh them out in the moment. But most of all I think I'm hoping to share the WONDER with him. This is going to be an enormous thing in his life, I believe. And I know it's an enormous thing in my life. I clearly recall landing in Europe for the first time when I was 22. Seeing distant, different places is so very powerful, moment by moment by moment. And this will certainly be different than what my friend is used to.

What's the essence of America you'd like to share with your friend?
I'll be surprised if he doesn't notice the sense of opportunity--Capital O--that everyone else notices. The same Opportunity that drew my grandparents here from Czechoslovakia--and your ancestors, wherever they were drawn from. There's the famous sense that you can be anything you want to be here--especially in San Francisco. If you can't be who you want to be in San Francisco, you really don't have much of a chance anywhere else.

But you know--mostly I think I'll just show him some of my favorite places and my favorite activities and introduce him to as many of my friends as I can and let him figure out what HE thinks is the essence of America. We'll go hiking, I'm sure. We'll go to the beach--he's not seen much ocean, if any, in his life. We'll catch a Giants game. Harbin Hot Springs--if I get the sense he can handle the clothing optional aspect.

I don't want to ruin the surprise for anyone who hasn't read the book, but I also think I'll introduce him to some of the people in San Francisco who have immigrated to America from my friend's country--and maybe out of that I'll learn a few things myself about America.

Right now I'm thinking that after a week or so in the Bay Area, we'll get in a van and drive across the country. The Grand Canyon, Las Vegas, the Rockies, the St. Louis arch--plus I went to school at Principia College, near St. Louis. I'd like to show him Washington D.C.--my Mom still lives in the house I grew up in, right outside D.C. I'd like to show him that, like him to meet her. And I imagine us slipping up to New York for a night or two. I think a month will go pretty quickly.

You comment several times in Take Me with You about the fact that you rarely encountered women in the Third World. How have your experiences of gender segregation in other countries affected your attitudes toward feminism?
Hmmn. I don't really think so much in terms of --isms. Instead of identifying with a women's movement, per se, I identify with an underdog movement. I'm an anti-bully-ist. I remember rooting for the woman who joined my all-male crew in the molybdenum mine. More and more cab drivers in San Francisco these days are women--and I root for them. I find myself rooting harder for women athletes--it's tragic that for so long they weren't allowed even to play--and now, as professionals, they have to fight not just to win games but also to get their leagues established. When I started traveling, most of the other backpackers were men, and I found myself rooting for the women--especially the few who were traveling alone--but I also noticed that it was the women who seemed to be having the most fun. Well, this is getting off the topic maybe. Traveling in the Third World, one would have to be blind not to notice the separation--the different roles allowed to men and women. And it seems that there are fewer opportunities allowed women. If you come from a country like ours, where more than half of the college graduates are now women, and you go to a place like India or Egypt, where a woman college graduate is still a pretty rare species, well, you can't help but notice. And root for them. I don't think I had a very feminist slant in my book, but I think it's fair to say that, like most everyone, I root for the underdog.

Take Me with You is a story about how a personal act can change lives--yours, the life of a person you didn't know, and, perhaps, the lives of readers. Do you believe that cultural change might start from individual acts--do you think that exchanges between individual people can ultimately lead to global change?
I do believe in the personal act. If I do something kind, something decent, immediately the world is by a very subtle but very real degree, a kinder, more decent place. If I do something mean, the world is instantly a bit meaner. The only place I know to start is with myself. I see and understand the differences between people of different races and economic circumstances, and I don't know what to do about those things on a global level. But in my own life, I have more control. One of the reasons I love cab driving is that it puts me into contact with a broad spectrum of people. Subtract cab driving from my life, and my life looks pretty darn Caucasian. But in the cab lot I know people from all over the world, and my customers are of every racial and economic stripe.

You have traveled extensively in the "Third World," and you've met a lot of people whose day-to-day life is characterized by extreme poverty and/or lack of personal freedom due to personal and political circumstance. Can you talk about how your experiences of other peoples' life circumstances have influenced your own perspective? What do you see as the most hopeful, positive action possible on the individual level?

I don't want to pose as some Buddhist, but I do like the Dalai Lama's quote: "My religion is kindness." I fail in living up to that standard, but when I'm acting consciously, I do try. And, gosh, for a westerner visiting the Third World, I think it's impossible not to notice how much more, materially, we have. And I think it's the most natural impulse in the world to want to share. Third Worlders share what they have--mostly their warmth, their curiosity, themselves--so easily. It's actually fun for me to give them what I can. I met an American couple in Kenya who had made a pile of money in business, millions, and now they were traveling around the world, giving away $500 here, $500 there. There was an article in the paper one day about them having given $500 to a shoe repair man in Nairobi who had been kind to them. And they seemed to be having more fun than any other travelers I met.

In Take Me with You, you have a conversation one afternoon with a group of Kenyans. This is a wonderful moment in the book, full of humor and humanity, and nothing less than an open dialogue of what's important in life.
That is one of my favorite parts of the book. Just a bunch of strangers huddled in the shade, talking about their lives. I think exchanges like that will go a long way toward making the world more peaceful. I think travelers are to the earth as blood is to the body. We need a constant healthy flow to keep us healthy. Think of the parts of the world where people don't, or aren't allowed to travel. Sooner or later, they all come down with something bizarre--economic ruin or famine or war with the neighbors--or among themselves. I'm not at all a techno-guy, but I have this vision that we could start putting random t.v. links on street corners all over the world. We could put one in front of Peet's Coffee on Piedmont Avenue--Sarah and I walk down there to hang out almost every afternoon. We get tired of seeing the same old faces--and I'm sure they get tired of us. Wouldn't it be nice if we could flip a switch and see and talk to whoever is hanging out at the coffee shop near Tianemen Square this afternoon, or at the foot of the Acropolis in Athens, or Soweto, or wherever. I'm sure this'll come to pass. Maybe it already has and I haven't seen it.

You have a very unusual ability to perceive what you see with feeling but without making evaluative statements. And though you witness many people who seem less fortunate than yourself, you resist the easy response that is so common of well meaning pity: there but for the grace of God go I. You continually imagine the possibility, as you travel, that you could have just as easily been born into that experience instead of the circumstances that are your own. Is the imaginary "trying on" of other lives what makes traveling fascinating for you?
Well, I'm not so sure I have avoided the there-but-for-the-grace-of-God syndrome. Every now and then I remember one particular beggar I used to pass in Nairobi. He had this enormously swollen, scaly, puss-ridden leg--and he sat there on his sidewalk day after day, begging for alms. And I couldn't help but thank god for my own health--instead of his. It's really interesting to travel to other places and fantasize about the lives of the people there--but I really don't think I'd trade places with anyone I've met. Travel really is a luxury in that it allows one to go to other places and have these fantasies about the people who live there. And to know that we don't HAVE to stay there and live the actual reality of their lives. I lived for a year in Mexico, and I loved it there. But I'm not sure I'd have loved it so much if I'd not had the ability, any morning I chose, to get on an airplane back to San Francisco.

The impulse to apply one's own values to another culture--in essence, cultural imperialism--seems to plague many travelers. You seem able to perceive differences without judging them. What are your guiding principles?
Every life is valid--I must think this thought every day. I suppose I would draw the line at Hitler and most other murderers. But I like to think, to promote the idea that everyone should be free to interpret life and put together his/her own life in the way they see fit. I was raised a Christian Scientist--to believe that we're really divine beings--that we should judge ourselves by standards of perfection and divinity. And while that philosophy has certainly shaped a lot of what I think, I found it, for me, incomplete. Or maybe I just found it too difficult. As an adult I've been more willing, more likely to try to experience what it's like to be human, to accept this human life as real and valid, and to deal with it not only on some metaphysical level, but also on this human level. I take aspirin for a headache. I had a knee operation. I even swear like a sailor, like a friggin' cab driver, once in a while.

Throughout your journey you ask those you meet two questions: "What's the best thing that ever happened to you, and what's the worst thing that ever happened to you?" How did you first start asking these questions?
I think these questions work particularly well with my cab customers. We've usually got just a short time together, and the assumption is we're never going to see each other again, and so what the heck. People often like to talk to cab drivers--would like to talk more to strangers--but sometimes just don't know where to start. For me, talking to my passengers is absolutely the best part of the job. I think perhaps the reason I liked being a reporter when I was, and why I like being a cab driver, is that it gives me an excuse to ask just about anyone just about anything. I don't talk to EVERYONE in my cab, but when I have a sense that someone is approachable and, perhaps, interesting, I like to just toss my questions out there cold. No prelude--just, out of our silence, "What's the best thing that ever happened to you?" Once in a great while in my cab someone will say, "I'm sorry, I just don't feel like talking"--and that's perfectly legitimate--I don't always feel like it either. But 95% of the people seem to like being asked such a question. I think most people love attention--love being asked their opinion on something--which is what makes an interview like this fun for me. We don't get to do this very often, usually.

Almost everyone has to think for a while before they can identify their favorite thing. But almost everyone can instantly give you the worst thing that ever happened to him or her.

How would you answer the questions yourself--what are the best and worst things that have ever happened to YOU?
Well, every once in a while someone turns this around on me--and I like that. But I always have to look and see what my answer is THAT DAY. For a long time my answer was "Having my first book published"--but that was a long time ago and seems to have faded into the landscape of my life. Today--let's see. I guess I would say simply being born. I read an article in the New Yorker not too long ago that said that in the act leading to human conception, somewhere between 20 million and 900 million individual sperm are involved. This makes me realize that almost all of us have already, before we were born, beaten the biggest odds we'll ever face. It makes me think that life is really an afterthought, a bonus, a cooling off chat in the post-game locker room, and that maybe we don't have to take life quite as seriously as we do. Maybe we can take more chances than we think. That's my answer for today.


And my worst thing, you know, I have lots of days where I can spit out a genuine answer to that one. But lately it seems almost obscene to even think about it. My second book is being published, I'm going on a coast-to-coast book tour, and last week I saw the first review--on Amazon.com--a flat-out rave. I spent a good chunk of this beautiful afternoon we had with my daughter, splashing around in our hot tub--it was set on medium. She's three-and-a-half now, and we spend a lot of time just going around exploring together, looking for treats to eat, or parks to play in. She's become a baseball fan--a Giants' fan--"Did Barry Bonds hit one in the water last night, Dad?" I have a season ticket--the first season ticket of my life--and the whole family's been to the incredible new stadium a few times. Sarah loves garlic fries and roasted corn. This morning we both kissed Rhonda good-bye at the door and then we went back inside with the newspaper. Sarah said, "Did the Giants win last night?" When she'd gone to bed it was tied at 3-3. But Ellis Burks hit that homer in the eleventh, and when I told Sarah she yanked open the front door and screamed, "HEY MOM!" Rhonda was already halfway down the block, but she turned around. "The Giants WON last night--four to three!" I hope the whole neighborhood heard that.

My wife told me recently, "If you can't be happy NOW, you're hopeless." To most of the people I've met in my travels, the ones you can see out the window of any train or bus in the Philippines, India, Egypt, slaving over crops, my entire life has been a cruise aboard a luxury liner. Life is definitely a roller coaster, and there really are no problems like your own problems, but today it would be obscene to dwell on my problems. My wife is absolutely right: if I can't be happy right now, I really am hopeless.

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 Newsham at BookBrowse
Take Me With You 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 Newsham 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

  • Daniel Glick

    Daniel Glick

    Daniel Glick is the author of Monkey Dancing: A Father, Two Kids, and a Journey to the Ends of the Earth (2003). The book is an account of a five-month, around-the-world trip Glick took with his two children after becoming a ... (more)

    If you enjoyed:
    Take Me With You

    Try:
    Monkey Dancing
    by Daniel Glick

  • J. Maarten Troost

    J. Maarten Troost

    Travel writer J. Maarten Troost was born in 1969 in the Netherlands and is of Dutch-Czech descent. He grew up in Canada and presently lives in Washington D.C. He is the author of three books which are about his experiences ... (more)

    If you enjoyed:
    Take Me With You

    Try:
    The Sex Lives of Cannibals
    by J. Maarten Troost

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

At times, our own light goes out, and is rekindled by a spark from another person.

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:32 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
1780320742418 ms 1.78032074242E+012 ms 1 /root/website/app_server.cfm
280 ms 280 ms 1 /root/website/author_interviews/full/index.cfm
129 ms 129 ms 1 /root/website/app_layout.cfm
94 ms 31 ms 3 /root/website/adsystem/adsystem_mod.cfm
88 ms 88 ms 1 /root/website/app_globals.cfm
68 ms 68 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
66 ms 66 ms 1 /root/website/adzones/showcase_track.cfm
57 ms 57 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
52 ms 52 ms 1 /root/website/author_interviews/full/dsp_main.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_active_obc.cfm
22 ms 22 ms 1 /root/website/adzones/AdZone6.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
19 ms 6 ms 3 /root/website/site/blocks/membership_advantages.cfm
18 ms 9 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_competition.cfm
15 ms 5 ms 3 /root/website/queries/qry_get_member_account_types.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
9 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
6 ms 6 ms 1 /root/website/actions/adstatus.cfm
6 ms 6 ms 1 /root/website/adzones/AdZone2.cfm
5 ms 5 ms 1 /root/website/act_check_login.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_all_books_by_author_id.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_author_readalikes_by_id.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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_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_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
5 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
285 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 13:32: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=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 13:32: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=5ms, Records=2) in /root/website/actions/adstatus.cfm @ 13:32: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 @ 13:32: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=8ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 13:32: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=4ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:32: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=12ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 13:32: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 @ 13:32: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=11ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 13:32: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=10ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 13:32: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=11ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 13:32: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=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 13:32: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) = 596

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

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

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

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 13:32: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) = 596

get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=2ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:32: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=1ms, Records=1) in /root/website/actions/udfs.cfm @ 13:32: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) = 770

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

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 13:32: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=13ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:32: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=6ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 13:32: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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=11ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 13:32: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 @ 13:32:22.022
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=56ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 13:32: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=CFGLOBALS=urltoken%3DCFID%23%3D4102173%26CFTOKEN%23%3D104925c8f02b96a0%2D21D80398%2DA002%2D917B%2D1040984133A6E7FC%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2013%3A32%3A22%27%7D%23hitcount%3D120%23timecreated%3D%7Bts%20%272026%2D06%2D01%2013%3A32%3A04%27%7D%23cftoken%3Dafd93b5014694498%2D21D7F395%2DB8FC%2D3053%2DE812800449794E4B%23cfid%3D4102170%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4102173; CFTOKEN=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
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/596/author/brad-newsham
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=4102170
cftoken=afd93b5014694498-21D7F395-B8FC-3053-E812800449794E4B
hitcount=125
lastvisit={ts '2026-06-01 13:32:22'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 13:32:04'}
urltoken=CFID=4102173&CFTOKEN=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
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#=4102173&CFTOKEN#=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC#lastvisit={ts '2026-06-01 13:32:22'}#hitcount=120#timecreated={ts '2026-06-01 13:32:04'}#cftoken=afd93b5014694498-21D7F395-B8FC-3053-E812800449794E4B#cfid=4102170#
CFID=4102173
CFTOKEN=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
Session Variables:
cfid=4102173
cftoken=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
sessionid=BOOKBROWSE_4102173_104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
urltoken=CFID=4102173&CFTOKEN=104925c8f02b96a0-21D80398-A002-917B-1040984133A6E7FC
URL Parameters:
author=brad-newsham
author_number=596
Debug Rendering Time: 61 ms