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

John Shors

John Shors

An interview with John Shors

In two separate interviews, John Shors discusses Beneath a Marble Sky, a fascinating book about the construction of the Taj Mahal; and Dragon House, set in contemporary Vietnam.

What inspired you to write Dragon House?
For a long time, I've found Vietnam fascinating due to its history—which is dominated by its external conflicts as well as its internal ones. In part due to this fascination, I've been fortunate to travel extensively throughout the country. While exploring Vietnam I felt quite connected to its citizens, who usually went out of their way to make me feel welcome. I talked about peace with a man who once dug tunnels that were used to attack American bases. I listened to stories from people who endured tremendous hardships. Most important, at least in terms of Dragon House, was the fact that I interacted on a daily basis with some of the thousands of street children who are so visible in parts of Vietnam. I felt like the stories of these children needed to be brought to life on the page.

Can you describe your trips to Vietnam?
I first went to Vietnam in 1993. Only recently had the country opened itself back up to American tourists, and it felt almost surreal to explore the landscape. I was only twenty-four, and often thought about young men my age being sent to Vietnam to fight in the war. One thing that amazed me at the time (and to this day) was that the Vietnamese were thrilled to discover that I was American. If I met someone who fought with the United States, that person would shake my hand and tell me how delighted he was to have Americans back in his country. If I met someone who fought against the United States, that person would nod his head and say that the past was the past, and that he was glad Vietnam and America were normalizing their relationship. I felt almost no malice during my entire trip.

I returned to Vietnam in 1999 with my wife. The two of us rode in a van with a leaky roof all the way from Ho Chi Minh City to Hanoi. It was an amazing experience, one that exposed us to a diverse landscape and people who made the hardships of our trip worthwhile. During this trip I sensed my connection to Vietnam growing stronger.

To research Dragon House, I traveled to Vietnam in 2007. I was amazed at how much things had changed. Fourteen years before, it seemed as if everyone rode a bicycle. In 2007, everyone appeared to be on a motor scooter. Moreover, Ho Chi Minh City was full of fancy hotels and restaurants—things I didn't recall from my earlier visits. Of course, the people were still the same—warm and friendly and welcoming.

You've written several novels set in Asia. What fuels your passion for this part of the world?
I lived in Japan for a few years after graduating from college, and quickly fell in love with the region. I am a big fan of Asia's history, people, food, natural beauty, and weather. Driving a scooter around, I've been able to cover vast areas, experiencing cultures that have thrived for thousands of years. I've felt welcomed by people all over Asia. Strangers have brought me into their homes, taken the time to brighten my day. For me, traveling around Asia has been a wonderful adventure. As a writer, it's gratifying to bring that adventure to life through my novels.

In your experiences with street children, what did you find most compelling?
I've spoken with hundreds of street children throughout Asia, and what I've been most impressed with is the children's optimism. Though they sleep on the streets, sell trinkets for money, and dress in rags, the children haven't given up on life. They yearn for simple things—to go to school, to have a safe place to sleep. They know that these things aren't impossibilities, and they try, with the very few resources at their disposal, to make such things become realities. These children are bright and eager and quick to laugh. They're strong. They would rather work than beg. One time, when I was about to leave Vietnam, I had a bunch of Vietnamese coins in my pocket. I offered them to a young boy. He told me that he would rather work for them. So I asked him to find me a newspaper written in English. This was 1993, and such newspapers weren't exactly sitting on every corner. Nonetheless, he returned thirty minutes later with an old USA Today in his hand, grinning from ear to ear about his accomplishment.

The Vietnamese characters in Dragon House all seem to have unique and compelling voices. How did you create such memorable characters?
By meeting such people in real life. I never base a character on a particular person, but rather on memories of encounters, on bits and pieces of people I've interacted with. The characters in Dragon House were resurrected in my mind long before I sat down to try to put them on a page. I find giving life to such voices to be extremely rewarding. At first characters are tough to write. They are one-dimensional and bleak. But after many edits and a lot of thought, the characters start to speak for themselves. I love it when this transition occurs.

Why did you decide to have Noah be an Iraq War vet?
Vietnam was a land torn apart by war, and that history is a big piece of the fabric of the country today. I wanted Noah (as well as Sahn) to have experienced such strife. Somehow Vietnam has managed to find peace, and I wondered if my characters could find peace as well. I wasn't honestly sure when I started writing the novel if they would. As far as Noah goes, I felt that because of his past suffering, he'd be better able to connect with and help the street children. I wanted him to understand their pain. I did the same thing to Iris, to a lesser degree.

To you, what does the relationship between Iris and Sahn symbolize?
Well, I think that the partnership they ultimately make is symbolic in some ways of the relationship that Vietnam and America now have. Initially Sahn hates Iris and all that she stands for. But he comes to understand that she is good, and he grows to admire her. I don't think that is so different from what has happened between Vietnam and America. Five million people died in the war, which occurred only two generations ago. Craters and unexploded bombs still litter the landscape. And yet, when one is in Vietnam, the war can seem like ancient history. It's a thing of the past that is no longer dwelled on. I found the capacity of people to forgive very uplifting.

Do you consider Dragon House to be an antiwar novel?
I was born during the Vietnam War, so I can't honestly say whether or not I think the United States should have sent troops to Southeast Asia. It's sometimes hard for me to judge history if I wasn't alive during the event in question. I will say that I believe war is often rushed into, which I view as rash and naive. I think war should be entered into only as a last resort, when diplomacy has failed and the welfare of good nations is in immediate danger. In terms of how such thoughts are expressed in Dragon House, I show the suffering that the Vietnam War created on both sides of the conflict. And my character, Noah, speaks at length about how he believes the Iraq War was a mistake. Readers may or may not agree with Noah. I don't expect everyone to share his thoughts. I've certainly spoken with brave and good soldiers who support one side of the argument or the other.

What messages do you hope to pass to readers?
I don't write novels to try to pass my personal thoughts along to readers. Perhaps I have a few musings that I share during the course of a novel, but I don't write in an effort to spread my beliefs. That would be incredibly presumptuous. I will admit that through Dragon House I want to expose readers to the sufferings of street children. This problem, which is massive in scope, doesn't get the attention that it merits.

What will your next novel be about?
I'm working right now on an outline for my next book. The story I want to tell is of a father and a daughter who travel the world together, guided by the words of his deceased wife, her mother. The father and daughter will embark on this journey to once again find joy, and will experience pain and beauty, sadness and salvation. Through the landscape they travel, and the people they meet, I want to bring a series of countries and cultures to life, creating experiences that will shape the father and daughter into what the dying woman hoped that they might become.

2009




John Shors discusses his first novel, Beneath a Marble Sky

Can you tell BookBrowse about Beneath a Marble Sky, and give us an update as to how it's doing?
Beneath a Marble Sky is a work of historical fiction and is based upon the remarkable story behind the creation of the Taj Mahal. My novel is a love story at its core, but it's more than that, as the era in which the Taj Mahal was built was a period defined by wondrous arts, religious exploration, and intense conflict. Beneath a Marble Sky gives life to the characters and events that defined this beautiful but volatile era.

My novel is narrated by Jahanara, the daughter of the emperor and his wife. Jahanara witnessed her parents' legendary love affair, and was at her father's side when he dedicated the rest of his life to the creation of the Taj Mahal – a structure that was built to forever honor his beloved wife. Within Beneath a Marble Sky, Jahanara provides readers with a first-hand account of her parents' tale. She also shares the story of her own forbidden love with the celebrated architect of the Taj Mahal. Additionally, Jahanara is very much caught up in the civil war that consumes her country after the Taj Mahal's completion.

Beneath a Marble Sky was first published as a hardcover in the summer of 2004. A small, but very high-end end publishing house produced the hardcover. We received excellent reviews, hit bestseller lists, and ForeWord Magazine named Beneath a Marble Sky as a “Book of the Year”. After we won that award, Hollywood came along and bought the movie rights to my novel, and is currently developing Beneath a Marble Sky into a major motion picture. And finally, Penguin Books bought the trade paperback rights to my novel, and this summer, Penguin produced a beautiful trade paperback version of Beneath a Marble Sky that is available in about every bookstore in North America. This version is selling quite well.

What inspired you to write Beneath a Marble Sky?
I've been lucky enough to spend a great deal of time in Asia and have been powerfully influenced by its history, as well as the sights, sounds, smells, and customs found today in that part of the world. For a decade I've wanted to write a novel set somewhere in Asia but waited to find the right story—or rather to have the right story find me.

In 1999, my wife and I were traveling in India and of course made it a point to visit the Taj Mahal. We arrived at the mausoleum as soon as it opened to the public and were the first people there that day. Walking within its chambers, hearing our voices echo in the same manner as voices did hundreds of years ago, and touching its sculpted walls was an overwhelming experience. Seeing the wonder of the Taj Mahal, and understanding that a man built it for his wife—a woman he cherished above all else in life—was uniquely inspiring. Indian poets have been writing about this love story for centuries. And yet, not many people in the West know the tale. I realized that I had to tell it. Quite honestly, I was amazed and delighted to discover upon my return to America that no one in the West had ever fictionalized the story.

What impressed you most about the Taj Mahal?
People always think about the Taj Mahal from a macro level. That is, they envision it from afar and are moved by the image that arises. And while the Taj Mahal is certainly one of the world's most striking buildings from a distance, it is equally as remarkable up close. Most impressive is that millions of semi-precious stones adorn its walls. Lapis, jade, quartz, amber, emeralds, and onyx are set into the white marble in ways that defy reason. Marvelously detailed arrangements of these polished and shaped stones form garlands of flowers; timeless and impossibly exquisite. Such flowers are as beautiful as any that grace a garden, and they have thrived on the Taj Mahal for three-and-a-half centuries.

What was the hardest thing about writing Beneath a Marble Sky?
Let's just say that writing in the first person as a 17th-century Hindustani woman wasn't completely natural to me. Additionally, not only did I need to write convincingly as a woman from another place and another time, but I had to re-create the way in which Hindustanis spoke in general. Upon reading memoirs from that time, I quickly realized that the manner in which people spoke was much more formal than how people converse today. I wanted to capture some of this formality without getting carried away.

So, a great deal of work went into Jahanara's voice, as well as the other voices within Beneath a Marble Sky. I edited my novel fifty-six times. This number did not always sit well with my wife, as I was forever editing at night or during a much-needed vacation! However, I think that all of these edits allowed me to create consistent, unique voices within my novel.

How were you able to so effectively research your novel?

I spent about a year researching Beneath a Marble Sky. A fair amount of this work revolved around reading religious texts, memoirs, and historical accounts of 17th-century Hindustan. Surprisingly, the written word was not my greatest aid in terms of research material. Instead, hundreds and hundreds of period paintings provided me with a rich sense of the time and place that my novel is set in. Mughal paintings are exquisite and offered glimpses of life within the harem, of how battles unfolded, of how people ate and celebrated and loved. I could not have written Beneath a Marble Sky without such visual aids.

Whom did you model your characters after?
When possible, I based the characters in my novel on what is known about the people who were responsible for the creation of the Taj Mahal. Much of Beneath a Marble Sky is steeped in truth. Of course, elements of fiction also are present in my novel. I created several of the ancillary characters, and took a few liberties with members of the royal family. At the core, though, the royal family was much as I depict: headed by a couple very much in love and sent toward destruction by a son bent on increasing his power.

How is Beneath a Marble Sky relevant to what is going on in the world today?
Beneath a Marble Sky is extremely timely in that most of the main characters are Muslims. The two characters who are the most religious play large roles in my novel. One is a great man who tries to use Islam to bring people of all faiths together. His brother, who becomes his dreaded adversary, is a fundamentalist who uses Islam to drive a wedge between the people of his empire. These two men are Jahanara's brothers. Through the actions of these two men, Beneath a Marble Sky depicts the good and bad sides of this complicated religion, and many readers have told me that they very much appreciated learning of the good side of Islam, the side we rarely hear of today.

What do you like most about writing?
I'll be honest—most of the time writing is without question extremely hard work. Having said that, moments of clarity exist that are profoundly enjoyable. For me, during such moments, characters seem to speak of their own accord, and scenes unfold as if I've already lived them. When I am in such a groove, I type as fast as I can, not caring if words are spelled properly or if everything makes perfect sense. As I type, the outside world simply disappears. I don't think about what might be happening over the weekend or bills that need to be paid or house projects with my name on them. I'm simply consumed with writing as much as possible during this rare moment of clarity. What's best about these moments is that as I write I experience a remarkable sense of contentedness—likely because I know that I am creating something that most people will find enjoyable. When reality inevitably chases me away from the computer, I always depart with great regret.

Why did you decide to write within the historical fiction genre?
I have always loved reading novels that both were page-turners and taught me something of the world. To me, historical novels have provided escapes into new realms that I have always departed feeling a bit richer from the experience. Additionally, having encountered the wonder of the Taj Mahal made me want to share this experience with as many people as possible. Beneath a Marble Sky is my attempt at doing so.

Is there anything that you would like to share with your readers?
I am grateful for their support, and I look forward to creating other novels that they may enjoy. Readers might be interested in learning about my national book club program. Through this program, I have called into book clubs (via speakerphone) all over the U.S. and Canada. I've spoken with more than 200 book clubs so far. I created this program in an effort to give something back to readers. So far I think the program has been quite successful in that readers really seem to enjoy our chats. I do as well. If anyone is interested, additional information can be found at the back of the trade paperback version of Beneath a Marble Sky. It's really quite easy to participate. All people have to do is email me at shors@aol.com to set up a time. This is a free service.

September 2006

Unless otherwise stated, this interview was conducted at the time the book was first published, and is reproduced with permission of the publisher. This interview may not be reproduced or reprinted without permission in writing from the copyright holder.

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

Books by this Author

Books by John Shors at BookBrowse
My Midnight Sun jacket Unbound jacket Temple of a Thousand Faces jacket Cross Currents jacket
Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

Read-Alikes

All the books below are recommended as read-alikes for John Shors 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

  • Anita Amirrezvani

    Anita Amirrezvani

    Anita Amirrezvani was born in Tehran, Iran, and raised in San Francisco. For ten years, she was a dance critic for newspapers in the Bay Area. She has received fellowships from the National Arts Journalism Program, the NEA's ... (more)

    If you enjoyed:
    Beneath a Marble Sky

    Try:
    The Blood of Flowers
    by Anita Amirrezvani

  • Tracy Chevalier

    Tracy Chevalier

    Tracy Chevalier was born in Washington, DC but has lived in England all her adult life. She now has dual citizenship. She has a BA in English from Oberlin College, Ohio and an MA in creative writing from the University of ... (more)

    If you enjoyed:
    Beneath a Marble Sky

    Try:
    The Lady and the Unicorn
    by Tracy Chevalier

We recommend 9 similar authors

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

When a true genius appears in the world, you may know him by this sign...

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


Execution Time

Total Time Avg Time Count Template
1780273848538 ms 1.78027384854E+012 ms 1 /root/website/app_server.cfm
689 ms 689 ms 1 /root/website/author_interviews/full/index.cfm
226 ms 226 ms 1 /root/website/author_interviews/full/dsp_main.cfm
202 ms 202 ms 1 /root/website/app_layout.cfm
169 ms 85 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
148 ms 148 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
141 ms 47 ms 3 /root/website/adsystem/adsystem_mod.cfm
103 ms 103 ms 1 /root/website/app_globals.cfm
80 ms 80 ms 1 /root/website/adzones/AdZone6.cfm
78 ms 78 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
53 ms 53 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
45 ms 45 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
44 ms 44 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
42 ms 42 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
41 ms 41 ms 1 /root/website/adzones/showcase_track.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_active_obc.cfm
30 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
29 ms 10 ms 3 /root/website/queries/qry_get_member_account_types.cfm
27 ms 27 ms 1 /root/website/actions/adstatus.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_current_competition.cfm
20 ms 20 ms 1 /root/website/adzones/AdZone2.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
12 ms 12 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
8 ms 8 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
7 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
7 ms 7 ms 1 /root/website/site/blocks/layout/main_menu.cfm
3 ms 3 ms 1 /root/website/act_check_login.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.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_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
690 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 00:30:48.048
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=2ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 00:30:48.048
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=27ms, Records=2) in /root/website/actions/adstatus.cfm @ 00:30:48.048
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 @ 00:30:48.048
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 @ 00:30:48.048
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=10ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:30:48.048
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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:30:48.048
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 @ 00:30:48.048
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=12ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 00:30:48.048
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=7ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 00:30:48.048
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=9ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 00:30:48.048
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=62ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 00:30:48.048
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) = 1032

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 00:30:48.048
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) = 1032

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=8) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 00:30:48.048
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) = 1032
Parameter #2(CF_SQL_INTEGER) = 1032

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=52ms, Records=7) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 00:30:48.048
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) = 1032

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=9ms, Records=9) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 00:30:48.048
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) = 1032

get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:48.048
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=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:48.048
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=16ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:30:48.048
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_member_account_types (Datasource=bookbrowse_com_new, Time=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:30:48.048
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 @ 00:30:48.048
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) = 1467
Parameter #2(CF_SQL_INTEGER) = 1467
Parameter #3(CF_SQL_INTEGER) = 1467

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=86ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:30:49.049
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) = 227
Parameter #2(CF_SQL_INTEGER) = 227
Parameter #3(CF_SQL_INTEGER) = 227

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:30:49.049
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) = 227

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:30:49.049
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=15ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:30:49.049
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=28ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:30:49.049
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=42ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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=18ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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 @ 00:30:49.049
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 @ 00:30:49.049
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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=13ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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=7ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:30:49.049
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%3D4078248%26CFTOKEN%23%3Da1ba6df9e88ab737%2D05E562A8%2DF4B1%2D4C64%2DDAD7F806E1726F2F%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2000%3A30%3A48%27%7D%23hitcount%3D66%23timecreated%3D%7Bts%20%272026%2D06%2D01%2000%3A30%3A36%27%7D%23cftoken%3Da1ba6df9e88ab737%2D05E562A8%2DF4B1%2D4C64%2DDAD7F806E1726F2F%23cfid%3D4078248%23; FREEACCESSCOUNT=0; CFID=4078248; CFTOKEN=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/1032/john-shors
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=4078248
cftoken=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
hitcount=71
lastvisit={ts '2026-06-01 00:30:49'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 00:30:36'}
urltoken=CFID=4078248&CFTOKEN=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
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#=4078248&CFTOKEN#=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F#lastvisit={ts '2026-06-01 00:30:48'}#hitcount=66#timecreated={ts '2026-06-01 00:30:36'}#cftoken=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F#cfid=4078248#
CFID=4078248
CFTOKEN=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
FREEACCESSCOUNT=0
Session Variables:
cfid=4078248
cftoken=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
sessionid=BOOKBROWSE_4078248_a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
urltoken=CFID=4078248&CFTOKEN=a1ba6df9e88ab737-05E562A8-F4B1-4C64-DAD7F806E1726F2F
URL Parameters:
author_number=1032
john-shors=
Debug Rendering Time: 18 ms