Sy Montgomery Interview, plus links to author biography, book summaries, excerpts and reviews

Sy Montgomery
Photo: Rosemary G. Conroy

Sy Montgomery

An interview with Sy Montgomery

Sy Montgomery discusses her book, The Good Good Pig, about Christopher Hogwood who came into her life as a piglet runt and ruled her home for the next fourteen years. She also discusses many aspects of her writing, her other books and her personal views on the environment, ecology and animal husbandry.

Question: For previous books you traveled to India to research man-eating tigers, bonded with the great apes of Africa, swam with the pink dolphins of the Amazon, and tracked the golden moon bear through Cambodia. For your latest book, The Good Good Pig, you stayed a lot closer to home. Tell us about it.

Sy Montgomery: For most of my books, I travel to jungles and cloud forests and deserts and swamps, and I get a lot of credit for not being killed in the process. I'm best known for writing about rare animals and foreign cultures in remote places. This book, though, is about the pig in our barnyard (though sometimes beyond—in his youth, Christopher Hogwood, like me, had the travel bug, only he didn't get quite as far). The setting isn't glamorous. Pigs aren't endangered or exotic. Yet Christopher Hogwood's adventures and personal charisma provided as much drama and delight as any expedition I have ever undertaken. It was he—and the interspecies family who gathered around him—who sustained me on all my voyages, and anchored me, for the first time in my life, to family and to home.

Q: Some people will look at this book and think it's about a pet pig. But Christopher Hogwood wasn't a pet, was he?

SM: Not really—not in the sense that "pet" implies ownership. If anything, he owned me! In any case, I was certainly his valet, chef, butler, and maid. As well as his masseuse, public relations representative, and confidante.

Q: Christopher Hogwood became quite famous. What was the reaction of the real Christopher Hogwood to having a pig named after him?

SM: We wondered about that, actually. Not everyone would be thrilled to have a pig named after him—especially an elegant and handsome conductor who is quite famous in his own right (even more famous than our Hogwood was). But after Christopher's death made headline news, we discovered that the musician actually had a link to Chris' obit on his webpage. So he must have taken our naming a pig after him as the heartfelt compliment it was.

Q: Where do you think your affinity for animals and the natural world comes from? Why do some people seem to lack this feeling? Is it a cultural thing? Genetic?

SM: I think most humans are born with a fascination with animals—which is what you would expect from evolution. For all but the very latest moments of our existence as a species, humans who didn't have sense enough to pay attention to the natural world either couldn't find food or got eaten by something else. Unfortunately, now that so many of us have turned from hunter-gatherers into shopper-gatherers, this natural affinity is often overlooked or actively discouraged—a casualty of the rush to fill our lives with unnecessary plastic and electronic items.

Q: What led you to become, in the words of the Boston Globe, "part Indiana Jones and part Emily Dickinson"? Who were some of your influences, both literary and scientific?

SM: My biggest hero was my father, a war hero, POW, army general, world-traveler, polyglot—and absolutely fearless. And before I could even read, I discovered a lifelong heroine in the pages of National Geographic: Jane Goodall, pictured humbly in the magazine, squatting and holding her hand out to a chimpanzee in Tanzania.

From the moment I could read, I favored books about animals. I adored Charlotte's Web of course—never suspecting that I would have a pig of my own one day! I devoured everything I could find by Farley Mowat and Gerald Durrell and Hope Ryden. In college, my most profound literary influence was the man who I would later marry: Howard Mansfield, who was then and is now simply a breathtaking writer. Working with him side by side on the college paper—and since then, on our different books—has affected my own writing deeply.

Henry Beston's classic The Outermost House, which I discovered shortly after graduating college, was a great beacon. In particular, his moving and perceptive understanding of animals provided a sort of blueprint for all my work: "We need another and a wiser and perhaps a more mystical concept of animals . . . For the animal shall not be measured by man. In a world older and more complete than ours, they move finished and complete, gifted with extensions of the senses we have lost or never attained, living by voices we shall never hear. They are not brethren, they are not underlings; they are other nations, caught with ourselves in the net of life and time, fellow prisoners of the splendor and travail of the earth."

Q: Christopher Hogwood is certainly at the heart of The Good Good Pig, but the book is about so much more than his amazing life. Were you surprised as you were writing that so much personal material, especially about your mother and father, found its way in?

SM: Surprised and somewhat mortified! Why bother writing about a person if you could write about a pig? My wonderful literary agent, however—and later my excellent editor—convinced me to include my personal life as well as Christopher's in the book. My own life could provide a backdrop against which his soul could shine.

Too, this book is, at heart, a book about family. Therefore I had to write about the humans who comprised my biological family as well as the larger inter-species family my husband and I made for ourselves. The contrast is rather striking—and the story defeats the limited and rather uninteresting definition of family as merely two opposite-sexed married humans and their biological offspring.

Q: Was Christopher Hogwood a typical pig or a pearl among swine? He was clearly atypical in not being killed early in his life as most pigs are, but as I read, I couldn't help wondering how many other Christopher Hogwoods never have the chance to touch people's lives simply because they end up on people's plates.

SM: I never met a pig I didn't like. All pigs are intelligent, emotional, and sensitive souls. They all love company. They all crave contact and comfort. Pigs have a delightful sense of mischief; most of them seem to enjoy a good joke and appreciate music. And that is something you would certainly never suspect from your relationship with a pork chop.

Q: The term for the care and killing of livestock is animal husbandry,, a loaded term if ever there was one. What are your thoughts about the burgeoning animal rights and animal welfare movement as exemplified by organizations like PETA (People for the Ethical Treatment of Animals)? What can people do to make a difference in the way animals, both pets and livestock, are treated in our society?
 
SM: I have always felt that humans are just one among a plethora sea of wonderful species—all of whom we should treat honorably.

Yet in our everyday lives, many of us end up supporting unthinkable atrocities. I can't imagine that women who wear fur, for instance, have any idea of the cruelties of this unnecessary industry. My mother had a closet full of fur coats, including one of a leopard! And my father, who loved animals, had bought them for her! The same ignorance supports factory farming of food animals. Most Americans simply don't know about the conditions these animals face—and sometimes when they do learn, it's so horrible they can't believe it.

We need to reach out to those who aren't aware, in many different ways. Maybe it will be a billboard that changes someone's mind, or a television show. Or maybe a book—maybe even my book. I read Peter Singer's Animal Liberation in my early 20s, and from the moment I finished its last page, never ate meat again. Now that I am a vegetarian, I consider every meal I make an act of love, not only for the people who'll be nourished by this healthy, delicious, carefully prepared food, but also for the animals it spares and for the wholeness of the earth.

But there are many other ways to honor the many forms of life on Earth. Not only can we boycott those industries that profit from hurting animals and raping the land—we can also support those that protect the planet and its creatures. We can join a humane organization like The Society for the Prevention of Cruelty to Animals, or a conservation organization like Rainforest Conservation Fund. We can donate land, or a conservation easement, to a land trust. We can adopt animals from a shelter. We can choose to limit our family size so that we use fewer resources.

These are just a few ideas. We have so much power! In our everyday lives, by the purchases we choose or avoid every day, by the food we eat, we powerfully affect the lives of other creatures. As we learn more, and share what we learn, we'll find more and more ways to help—and in so doing, we will be honoring all of life, and enriching ourselves in the deepest and most profound sense.

Q: I was struck by the quote from St. Francis that your neighbors put up on your barn: "Not to hurt our humble brethren is our first duty to them, but to stop there is not enough. We have a higher mission: to be of service to them whenever they require it." Does this quote have value outside its specific religious context?

SM: Certainly! You don't have to believe in God to believe in kindness.

QQ: Christopher Hogwood touched so many lives in his fourteen years. What was it that made him, in the words of one of your neighbors, "a great big Buddha master"?

SM: That's a quote from Lilla Cabot, my next door neighbor, whose two little girls grew up feeding and petting and scratching and watching Christopher every day. Let me answer that in part with the rest of her words: "He taught us how to love. How to love what life gives you—to love your slops. What a soul! He was a being of pure love."

It's true. He loved company. He loved good food. He loved the warm summer sun, belly rubs from little caressing hands. He loved this life. And to show us how to relish this abundant, fragrant world would have been gift enough. But he showed us something else as well: that a pig did not become bacon but lived 14 years, pampered and adored till the day he died peacefully in his sleep—that's proof we need not accept the rules that our society or species, family or fate seem to have written for us. We can choose a new way. We can make a more compassionate world.

That is something that great teachers have tried to tell us for eons. It took a pig to get me to listen.

Q: Your writing has a spiritual dimension to it, as others have observed, and you write in The Good Good Pig about your membership in your local church. As the controversy over the teaching of evolution draws battle lines ever more starkly between proponents of science and religion, how do you keep a balance in your own work and life?

SM: When I was in the Amazon, researching Journey of the Pink Dolphins,, I met many people who told me about the dolphins' powers: they could transform themselves into humans, the stories said. In his handmade house built on stilts over the river, a very respected village elder, Don Jorge, told me quite honestly how he had met a dolphin who came to a festa—wearing a hat to cover the blowhole—and how this shape-shifter seduced all the women at the dance, who fell irresistibly in love with him.

On the same trip I also met a scientist, Gary Galbreath, who told an equally incredible story about dolphins. He told me that the ancestors of the dolphins were whales who walked! Only recently, he said, scientists had found not only the legs of these early whales—but also their HOOVES! (They were quite like pigs' hooves, actually.)

What an incredible tale! Surely, though, Don Jorge would have thought Gary Galbreath's story as impossible as Gary Galbreath considered Don Jorge's. But both, you see, are true. They are in fact mirror images: in Don Jorge's story, the dolphins come out of the water and dance on land; in the scientists' tale, the dolphins start out on land and then shape-shift into water-dwellers.

Both stories speak mirroring truths, both tell us about the possibilities of transformation. The fossils tell this story as a factual, physical, historical account. The villagers tell us the same thing, but in the same way that Jesus chose to phrase His parables: these stories are metaphors, speaking a larger ("meta") truth.

Metaphor does not need to masquerade as science. Science does not seek to replace religion. Both science and story can both be true in their own realms, both of them very real. We need only to listen for truth—and this is one thing my journeys among animals and people, from our barnyard to jungles and mountains, has helped me to learn.

Q: Is a wider balance or rapprochement possible? The biologist E. O. Wilson, writing in a recent issue of New Scientist, thinks not: "There is something deep in religious belief that divides people and amplifies societal conflict. The toxic mix of religion and tribalism has become so dangerous as to justify taking seriously the alternative view, that humanism based on science is the effective antidote, the light and the way at last placed before us." Do you agree?

SM: I am a huge fan of E. O. Wilson. He showed me his ants once—10,000 of them lived in his old office at Harvard. He said if you looked at them under a microscope you could see individual differences. His awe and delight in his ants seemed to me a holy thing. If there is a Heaven, I can't imagine the gatekeepers wouldn't let E. O. Wilson in.

Today there can be no doubt that religion can be horribly twisted and used as an incitement to violence. But there are also many people of all religious stripes who are working very hard for peace on Earth—peace for all of us, human and otherwise.

QQ: When it comes to pigs in literature, E. B. White's Wilbur is at the top of everyone's list. Like Wilbur, Christopher Hogwood was a runt not expected to survive. Did the two pigs have anything else in common?

SM: Both had the benefit of spider companions. Chris' barn always attracted many species of spiders, including talented orb-weavers like Charlotte. And both pigs were able to show their human families, as well as the wider community, the power of love to reveal and perhaps even to create radiance.

Q: You mentioned your partner, Howard Mansfield, who is also a writer. Do the two of you help each other as you work, read over each other's drafts, and so on, or do you both pretty much go your separate ways?

SM: We help one another very much. He is my most trusted editor, and I his. This book, more than any other, bears his imprint. The book is full of his recollections, gathered from his own writing and his memories, always recalled with his sharp eye and told with his marvelous sense of humor. Possibly, at least in theory, I might have struggled my way to write some of my other books, in some palsied form, if Howard were not in my life—but I certainly could never have written this one without him.

Q: As the prognosis for the health of the planet grows increasingly dire, the Bush administration displays little urgency in protecting the environment and endangered species; indeed, it seems to regard such organizations as Greenpeace as close kin to terrorists. Is there enough time to turn things around, or is it too late? Again, what can individuals do that will have any effect on the larger scale?

SM: I can't believe it is ever too late. Otherwise I would eat the cyanide pill and stop sucking down perfectly good oxygen. Of course we need to vote the bad guys out of office. And we need to vote with every purchase, with every meal, with the words we say and the sort of life we lead. We need, at heart, to vanquish our own greed. That's what's corrupting us. And worse, greed—for money, for power, for cars and clothes, for stuff—is masking for us the beauty of the real world—the myriad of good souls, animal and otherwise, that enliven and nourish this sweet, green Earth.

QQ: Christopher Hogwood came into your life when your father was dying, and his presence helped you endure that painful experience. Similarly, when your mother passed away years later, Christopher lent you support in countless ways. I think a lot of people have had similar experiences with dogs and cats, but it may surprise them to discover that pigs are also capable of providing this kind of comfort and understanding to human beings. Perhaps all animals can do so, in one way or another. What do such moments teach us about our relationship to other animals?

SM: Throughout human history, animals have been our teachers, our healers, our inspiration. North American Indians tell us that the bear was the original medicine woman, who taught humans how to use medicinal herbs. Robert the Bruce took inspiration for his deciding battle from watching a spider. In the Book of Job, the Bible advises, "Ask the animals and they will teach you; the birds of the air, and they will tell you."

Christopher certainly did. And really, it's no wonder that pigs can perceive human suffering and offer us comfort. Pigs are so like us that we borrow their skins to heal our wounds, and steal their hearts to replace our own faulty valves. We are so alike.

In fact, despite the fact that most mammals' powers of observation are vastly superior to our own, our biological and, I think, basic psychological make-up is very similar among social mammals, from dogs to pigs to whales.

What about those animals who are unlike us? What about, for instance, a wild tarantula—a creature who wears her skeleton on the outside, whose face is covered with legs and fangs and clusters of eyes, who tastes the world with her feet? It is unlikely that among her many talents is an ability to understand a human's sorrows. No matter—this beautiful creature still has the power to lessen our distress. The simple fact of her wild, vivid, precious, spidery life gives me joy—and that is powerful comfort indeed.

Q: Are there more pigs in your future?

SM: This I don't know. But, as I write in this book, I do know this: a great soul can come to us at any time, in the form of any creature. I'm keeping my eyes open.

Q: Will your next book project take you further afield?

SM: I'll always travel, I reckon, or at least till I get too creaky! Soon, I hope to begin research for a new book for adults with a co-author, my friend Brenda Peterson, on multi-species families—which will take me to Kenya and Tanzania again, and who knows where else. Also I'll be working with photographer Nic Bishop on another children's book on the highly endangered flightless giant parrot, the kakapo, which lives on a remote and windswept island off New Zealand. And after that, we'll be working together on another kids' project in Mongolia, about snow leopards. Meanwhile I hope to start a book I have been dreaming about for five years now, a book for adults about birds—and you can imagine the limitless possibilities that could offer.

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 Sy Montgomery at BookBrowse
The Good Good Pig 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 Sy Montgomery 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

  • Lynne Cox

    Lynne Cox

    Lynne Cox was born in Boston, Massachusetts, and grew up in Los Alamitos, California, where she still lives. She is the author of Swimming to Antarctica and Grayson. Her articles have appeard in The New Yorker... (more)

    If you enjoyed:
    The Good Good Pig

    Try:
    Grayson
    by Lynne Cox

  • Mark Doty

    Mark Doty

    Mark Doty's books of poetry and nonfiction prose have been honored with such distinctions as the National Book Critics Circle Award, the PEN/Martha Albrand Award, the Los Angeles Times Book Prize, a Whiting Writers' Award, a ... (more)

    If you enjoyed:
    The Good Good Pig

    Try:
    Dog Years
    by Mark Doty

We recommend 5 similar authors

View all 5 Read-Alikes

Non-members can see 2 results. Become a member
Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

BookBrowse Book Club

Book Jacket
The Cover Girl
by Amy Rossi
Find them early enough, and they will always be her girls.

Members Recommend

  • Book Jacket
    The Sister's Curse
    by Nicola Solvinic
  • Book Jacket
    The Lost Story of Eva Fuentes
    by Chanel Cleeton
    A mysterious book links three women across generations in this novel by New York Times bestselling author Chanel Cleeton.
  • Book Jacket
    The Vanishing Place
    by Zoë Rankin
Who Said...

Be sincere, be brief, be seated

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 03:14 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
1780326880142 ms 1.78032688014E+012 ms 1 /root/website/app_server.cfm
1276 ms 1276 ms 1 /root/website/author_interviews/full/index.cfm
545 ms 545 ms 1 /root/website/app_layout.cfm
439 ms 439 ms 1 /root/website/author_interviews/full/dsp_main.cfm
317 ms 106 ms 3 /root/website/adsystem/adsystem_mod.cfm
307 ms 307 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
213 ms 213 ms 1 /root/website/app_globals.cfm
191 ms 96 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
153 ms 51 ms 3 /root/website/site/blocks/membership_advantages.cfm
152 ms 51 ms 3 /root/website/queries/qry_get_member_account_types.cfm
138 ms 138 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
130 ms 130 ms 1 /root/website/adzones/showcase_track.cfm
127 ms 127 ms 1 /root/website/adzones/AdZone6.cfm
111 ms 111 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
110 ms 110 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
86 ms 86 ms 1 /root/website/queries/qry_get_active_obc.cfm
77 ms 77 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
69 ms 69 ms 1 /root/website/adzones/AdZone2.cfm
36 ms 36 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
28 ms 28 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
26 ms 7 ms 4 /root/website/actions/act_spider_tracker.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_current_competition.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
18 ms 18 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
14 ms 14 ms 1 /root/website/act_check_login.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_member_info.cfm
11 ms 11 ms 1 /root/website/actions/adstatus.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1277 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 15:14:40.040
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=10ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:14:40.040
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=9ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:14:40.040
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=1ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 15:14:40.040
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=13ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:14:40.040
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=14ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:14:40.040
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:14:40.040
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 @ 15:14:40.040
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=13ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 15:14:40.040
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=46ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 15:14:40.040
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=26ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 15:14:40.040
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=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:14:40.040
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) = 1320

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:14:40.040
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) = 1320

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 15:14:40.040
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) = 1320

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=14ms, Records=5) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 15:14:40.040
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) = 1320

get_ads (Datasource=bookbrowse_com_new, Time=49ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:40.040
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=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:40.040
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=25ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:14:40.040
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=18ms, Records=1) in /root/website/actions/udfs.cfm @ 15:14:40.040
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) = 1815

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

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=74ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:14:40.040
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) = 1350

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

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=23ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:14:40.040
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) = 1431

get_member_account_types (Datasource=bookbrowse_com_new, Time=109ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:14:40.040
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=40ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:14:41.041
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=65ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:14:41.041
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=81ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=24ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=35ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:14:41.041
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=16ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 15:14:41.041
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=48ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=33ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=35ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:14:41.041
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=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4105265; CFGLOBALS=urltoken%3DCFID%23%3D4105265%26CFTOKEN%23%3D974c74a23b4c1265%2D258311CB%2DFA88%2DADD3%2D4AD4607EA5BFBD49%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A14%3A39%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A14%3A38%27%7D%23cftoken%3D974c74a23b4c1265%2D258311CB%2DFA88%2DADD3%2D4AD4607EA5BFBD49%23cfid%3D4105265%23; CFTOKEN=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
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/1320/author/sy-montgomery
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=4105265
cftoken=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
hitcount=3
lastvisit={ts '2026-06-01 15:14:41'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:14:38'}
urltoken=CFID=4105265&CFTOKEN=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
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#=4105265&CFTOKEN#=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49#lastvisit={ts '2026-06-01 15:14:39'}#hitcount=2#timecreated={ts '2026-06-01 15:14:38'}#cftoken=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49#cfid=4105265#
CFID=4105265
CFTOKEN=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
Session Variables:
cfid=4105265
cftoken=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
sessionid=BOOKBROWSE_4105265_974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
urltoken=CFID=4105265&CFTOKEN=974c74a23b4c1265-258311CB-FA88-ADD3-4AD4607EA5BFBD49
URL Parameters:
author=sy-montgomery
author_number=1320
Debug Rendering Time: 94 ms