Anita Rau Badami Interview, plus links to author biography, book summaries, excerpts and reviews

Anita Rau Badami

Anita Rau Badami

How to pronounce Anita Rau Badami: a-NEE-ta row (rhymes with how) ba-DAHM-ee

An interview with Anita Rau Badami

Anita Rau Badami talks about her childhood traveling on the Indian railroad system, as the daughter of an officer in Indian Railways, and how this influenced the writing of Tamarind Woman.

When I was eight or nine, my parents bought me a green canvas travel bag for the frequent trips that we made as a railway family. I was allowed to paint my name and a flower on the bag and use it for my toys, a change of clothes, paper, and color pencils. It accompanied me on our travels for many years--the contents changing as I grew older. That bag was finally discarded along with my father's black Gladstone bag, eighteen steel trunks, five bedding rolls, a wooden crate that had carried our refrigerator, and several bags of assorted packing material. After thirty years as an officer in the Indian Railways, my father had died, and we were leaving that spacious world of bungalows and clubs, swimming pools and tennis courts to move into a small apartment. "There would be no more transfers or tours, no more packing and unpacking," my mother told us with a small sigh. She had enjoyed the life of a railway memsahib, but hated the constant movement it involved.

While my mother was glad to be free of an existence bound by train schedules and the need to pull up roots and travel every three years, I regretted the loss of that existence. I loved the clackety-clack of racing wheels, the hoarse whistle of an approaching engine, the excitement of a new house, another set of friends.

As a child, we often traveled by saloon--a sort of house on tracks designed for the railway engineer who was obliged to tour remote landscapes for extended periods of time. These "homes" usually had three bedrooms, living and dining rooms, and an office. In some saloons the rear wall would be a large sheet of glass. I would sit in front of this window pane for hours, mesmerized by miles of track slipping away into the distance as the train sped forward. If we happened to be traveling through the state of West Bengal, we would pass checkered squares of paddy in a hundred shades of green and yellow. Once, while on a trip to Darjeeling, a town in the lower reaches of the Himalayas, we found ourselves in an inspection carriage that was a sort of oblong glass bubble. The train moved slowly up the steep inclines through dense forest shrouded in silence. Now and again we would catch sight of a brilliant orchid high up in a tree or exclaim delightedly over a picturesque little waterfall tumbling down among the ferns. Traveling south from Calcutta to Madras, my father never failed to point out Lake Chilka, huge and placid in the dawn light, as the largest saltwater lake in the whole world. Following this would inevitably be a brief lesson on lakes the world over. And staring out at the flat expanse of water dotted about with meditating storks, we would be transported to Lake Baikal in Russia or the Great Lakes of North America.

In that distant childhood, I did not once think that my travels would take me in ever-widening circles away from the place where I was born and that, eventually, I would find myself flung right across the planet to Canada. Neither did I imagine that memories of that childhood would become the backdrop for an entire novel. In a sense, then, my book Tamarind Woman began as a way of preserving the past, of holding on to a way of life that I loved. It was only after I left India for Canada that I realized how unusual that life had been. I met other immigrants who talked about the problems they had adjusting to a new culture here and realized that I did not seem to have their problems. Adjusting to new situations came easily to me. In India, my geographies were in a permanent state of flux; I was always moving away somewhere, perennially settling in. Change was my only constant, and my perspective was that of a nomad. The only difference was that now, in the green canvas travel bag of memory, instead of toys and a change of clothes, I carried words and stories. These were the tools of my craft, these would travel with me wherever life took me. With them I could create and re-create the worlds I remembered, longed for, or wondered about.

This interview was first published in the The Algonkian, Algonquin's Literary Magazine.



A Conversation with Anita Rau Badami

Eliza McCarthy has written for Elle, New York, The Washington Post, and other publications. She lives in Westchester County, New York.

Eliza McCarthy: In the book, you mention a dance-step called the hero's walk. And, of course, the book is called that...

Anita Rau Badami: This book is my interpretation of a dance-step. The step I'm talking about is in a classical Indian dance-form called Bharat Natyam, a pretty common dance-form in India. When I was young, I noticed that the hero in dance-dramas always came in with this strutting gait. When the demons came on they used the same kind of walk, except that there were some embellishments. The demon, or the bad guy, or the villain--call him what you want to--would twirl his moustache, thump his chest, flex his muscles. And that immediately set him apart from the hero, who had a certain humility to his gait. The clown in the piece would stumble and fall and trip, so it seemed to me a fine metaphor to use for the way each of us lives his or her life. I don't think anybody in the world is perfect. I don't think anybody is absolutely good or bad or stupid. [laughs] Each one of us combines all those qualities in our daily lives, I think. So that's the metaphor.

EM: Was each of your characters walking--or at least trying to walk--the hero's walk?

ARB: I think so.

EM: By my count, you have seven important characters in the book--Sripathi, Nirmala, Ammayya, Nandana, Putti, Arun, and, of course, Maya. In your imagination, which of these characters did you begin with? Or did they come to you all at once, as a family?

ARB: Curiously enough, the book began with Ammayya and Putti. I had written a short story with these two characters years ago, and somehow the short story kept growing a little bit each year. It never seemed to end--and I didn't know how to make it end. So it was just sitting there in my notebook, and I'd look at it and think, "Well, I've got to do something about this!" So when this book started, I thought that I was actually going to be writing a book about these two women. But they didn't seem to have enough going for them for a whole novel.

At about that same time, I was reading Joseph Campbell's The Hero With A Thousand Faces, and I was just thinking that we always connect the hero with the large, big, wonderful character who plunges into all kinds of adventures and comes back with a trophy of some sort. There's no doubt that the hero is going to come back triumphant, and I was just thinking, "Well, what about ordinary people just leading their everyday lives?" I find just ordinary people very heroic--just the whole business of living, I think, is an act of heroism. Just to carry that hope through, you know? You try to realize those hopes, and there are all kinds of pitfalls along the way. If you make it to the end of your life relatively sane and relatively happy, then I think it's heroic.

EM: Can you give examples of everyday heroism that any one of your characters embodies?

ARB: Well, there's Sripathi's wife, Nirmala. I think she is a timid woman, who has spent most of her life observing what she considers are the Rules--rules set down by family, or society, or whatever. It's heroic that she has the courage to look at herself in the mirror, as it were, and realize that heroism isn't simply about following rules. Sometimes it's about doing what you think is right, at the cost of displeasing people around you. The fact that she comes to this realization, and the fact that she holds on to those principles of goodness--I think she is the only character in the book who is really a decent sort, no matter what life throws at her. She is just a good soul. And I find her heroic in a sort of daily, ordinary kind of way.

EM: What about her husband? Was one of your ideas with Sripathi's character that it's all too easy to get lost in the details of everyday life?

ARB: Well, actually Sripathi, more than anything else, was a man who was too taken up with the whole notion of duty, and what people in the world around thought about him. Of the characters-- other than his mother, Ammayya--he was the most self-absorbed, and everything revolved around his notion of duty. As a result he made a lot of mistakes--he became this kind of unforgiving, obdurrate character. Even though he thought he was doing the right thing all the time, unlike Nirmala, he wasn't doing it for anyone else. He was doing it for himself.

EM: Why was he that way?

ARB: He suffered humiliation when he was ten years old. His father embarrassed him and his mother by walking out with his mistress. Sripathi is trying all his life to get over that humiliation.

EM: Speaking of his mother, Ammayya, I know that she was a rather hateful character, but at the same time, I felt that the narrative came even more to life when she was around. Did you feel that way about her?

ARB: Oh, I was really fond of Ammayya! I took a great deal of pleasure working on Ammayya. She was sort of tragic--even though she was a nasty character. She had been dealt a bad hand. And I'm one of those optimists who believes that nobody is completely rotten. There is something that makes them do things that are rotten. And Ammayya was one of those. She's been dealt nothing but disappointment and unhappiness and betrayal, so it's not surprising that her whole nature curdled. I did enjoy working on her, because she was the one character that just let loose, did what she wanted, and said what she wanted to say.

EM: Did you ever write a draft in which Maya spoke? In the book, she doesn't.

ARB: Yes. Actually, there was. I had a chapter in which Maya interacted with her father. I dropped it, because it just became too much. There were too many characters, and I thought, "Well, I'll focus on this family that's here, that's alive." Maya can be a memory, and by her silence, I thought she'd be more powerful than if I had her actually doing things and talking.

EM: It seems like a lot of the women and girls in the story measure themselves against Maya--Putti, Maya's daughter, and even her mother.

ARB: Right, because she was the one who got away. And she was successful by anyone's standards. In the book, Putti thinks about it, and she thinks that Maya, even though she died young, had lived as full a life as most people who live to old age.

EM: In the book, most of your main characters are women. Were you consciously interested in exploring women's roles in India?

ARB: Not consciously, really. But in most homes, from what I know of them, even though the woman's place in that particular home might be in the home, still, she is queen of her house. So I like exploring the many different incarnations of women in that country, actually. You find quite a range of these women in this book--each one of them embodies a completely different personality type. And how can you write a book that's only full of men, anyway? I mean, half the population of this world is women.

In the last fifty years, since India got its independence, you find women in every sphere of life. Whether they're at home, or going out to work, they work as doctors, as nurses, as women who come in to clean your house, so to not include this range would be to do them a deep injustice.

EM: Speaking of writing about India, did you feel that you were writing for an Indian or a non-Indian audience? Or both?

ARB: Actually, when I was writing the book, I was just writing for the sheer pleasure of writing. Because I had a story that I wanted to explore, I had a bunch of characters I wanted to play with, and that's why I wrote the book. I wasn't thinking about an audience. It's only after a book is done that I start wondering about who is likely to read it. Because you're right, an audience here in North America is going to react to the book differently. And an audience in India will look at it differently.

EM: It's a very textured book. There are so many details included about Toturpuram, the imaginary town, so it made me wonder: Did you do any research about Indian life, or is it all from your imagination?

ARB: This is a life that has always fascinated me. There are these narrow streets in Madras, a south Indian city, and we have some relatives who live in those little alleys and streets.

And these are people who had lots of money. They were very well-educated, but they still lived in these tiny, ugly, filthy houses on these messy streets. And they were so crazy--the whole lot of them! They lead these bizarre lives full of ritual and cling to the most peculiar old-fashioned conventions and rituals, and at the same time, they all had the latest in technology in their homes. They'd have the latest computers, the latest televisions, but that's it--they'd be sitting on the floor, and watching these TVs and working on the computers. It was the most peculiar kind of lifestyle and it used to fascinate me. So this whole book is a recreation of those little roads and alleys, the little communities that were so different--I just loved it. It's almost completely imagined or reconstructed from what I remember of those roads.

When I used to visit, I didn't mind going there and sitting for hours, absorbing all the little nuances and details and things, because they were so peculiar.

EM: The Raos are Hindu, but they seem to be surrounded by a wild mixture of religions. Can you talk about the mix that you were trying to get across?

ARB:
It's something that exists on a daily basis on practically every street in India. You have people who are Hindus, Muslims, Christians--not just Catholics, but Protestants, you name it, all kinds of Christians--a hundred other religions, living side by side. And the kind of personal religion that people end up practicing is a bizarre concoction of ritual drawn from each other. So everybody ends up celebrating everyone else's festivals. Unless, of course, someone is a real stickler, like Ammayya. There are people like her, who sort of hate everybody else around them. They are convinced that their way of life is superior or more relevant than anybody else's.

So, on the one hand, you have that easy integration-- especially people like Sripathi, who was brought up in a generation that was preoccupied with other things, such as getting over the British occupation, so religion and caste hardly mattered. Then you have younger people who just don't care. For them, it's more important to go out there, find a job, make a living, build a flat. Finally, there are people like Ammayya who really care about preserving the traditions, and they make a big fuss. That's all part of the landscape, and it's bewildering! It's also very interesting for a writer.

EM: Do people care about caste in India today? Ammayya seemed to care about it, but for others, everything seemed more integrated.

ARB: Especially in urban areas, nobody cares so much, because you are forced to live in the same buildings. There is so, so little space. You can't be thinking about whether you are living in a street that has only Brahmins, or in a building that has been touched only by Muslims or Christians. You just live there, because that's the only place that you can find. So such distinctions just crumble away. There are people who maintain them, at all costs. But for the most part, it doesn't matter.

Having said that, though, it would be totally incorrect for me to say the caste system doesn't exist, because I think it exists in lots of villages. You find lots of atrocities committed in the name of caste. But the kind of milieu I grew up in, which was largely urban, largely middle-class, there wasn't any space for those distinctions, really.

EM: When did you last travel to India, and what is your relationship with India?

ARB: My relationship is still very, very affectionate. That's the country that made me what I am, it gave me a wonderful education, it gave me a lot of stories, a lot of characters. Five years ago, I was still teetering between whether to stay here [in Canada] or to go back. I was totally torn. I'd sit over here and long for all that chaos, and contradiction, and the challenges that that country represents, and I'd want to go back. But then I go back and start yearning for the silence of this place.

EM: You think of North America as silent?

ARB: Yes, I do, actually. When I say silent, I mean there seems to be a singular lack of people-noise. In India, you have people coming out of every hole you can imagine. It's a whole different setup. People love talking to each other. You know everything about your neighbor, and the whole street in fact. So there's a kind of sense of community that you don't always find here. Here, you can smile at your neighbor, but you know nothing about the neighbor! And it's bad form to be curious.

EM: Do you find your neighborhoods in Canada as fascinating as the ones in Madras, on which you based Toturpuram?

ARB: Well, the neighborhoods may not be as diverse or interesting here in Canada; they are more orderly. Where you have order, there's not much interest! Where every tree is clipped neatly, and every hedge is perfect, the roads are always covered over, there's little chance that anything strange could happen-- as a result of the landscape, that is.

But people add color to any street, anywhere in the world. I mean, you can't chain people down: They are who they are, and they do what they want to do. In the new book I'm working on now, which is set in Canada, I am focusing on the people, and letting them color the landscape.

Reproduced by permission of the publisher, Random House.

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 Anita Rau Badami at BookBrowse
Tamarind Woman 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 Anita Rau Badami 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

  • Kiran Desai

    Kiran Desai

    Kiran Desai was born in India in 1971, she lived in Delhi until she was 14, then spent a year in England, before her family moved to the USA.  She completed her schooling in Massachusetts before attending Bennington ... (more)

    If you enjoyed:
    Tamarind Woman

    Try:
    The Inheritance of Loss
    by Kiran Desai

  • Chitra Banerjee Divakaruni

    Chitra Banerjee Divakaruni

    Chitra Banerjee Divakaruni is an award-winning and bestselling author, activist, and professor. Her work has been published in over fifty magazines, including The Atlantic and The New Yorker, and included in The Best American... (more)

    If you enjoyed:
    Tamarind Woman

    Try:
    Queen of Dreams
    by Chitra Banerjee Divakaruni

We recommend 7 similar authors

View all 7 Read-Alikes

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

BookBrowse Book Club

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

Members Recommend

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

Choose an author as you would a friend

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 04:10 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
1780287039715 ms 1.78028703972E+012 ms 1 /root/website/app_server.cfm
1150 ms 1150 ms 1 /root/website/author_interviews/full/index.cfm
599 ms 599 ms 1 /root/website/author_interviews/full/dsp_main.cfm
435 ms 218 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
235 ms 235 ms 1 /root/website/app_layout.cfm
185 ms 185 ms 1 /root/website/app_globals.cfm
144 ms 144 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
143 ms 48 ms 3 /root/website/adsystem/adsystem_mod.cfm
73 ms 24 ms 3 /root/website/site/blocks/membership_advantages.cfm
71 ms 24 ms 3 /root/website/queries/qry_get_member_account_types.cfm
68 ms 68 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
64 ms 64 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
64 ms 64 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
55 ms 55 ms 1 /root/website/queries/qry_get_active_obc.cfm
55 ms 55 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
53 ms 53 ms 1 /root/website/adzones/AdZone6.cfm
48 ms 48 ms 1 /root/website/adzones/showcase_track.cfm
43 ms 43 ms 1 /root/website/adzones/AdZone2.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_current_competition.cfm
38 ms 38 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
23 ms 23 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
17 ms 17 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
17 ms 17 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
14 ms 14 ms 1 /root/website/actions/adstatus.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
10 ms 10 ms 1 /root/website/act_libraryIPLogin.cfm
10 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
6 ms 6 ms 1 /root/website/act_check_login.cfm
5 ms 5 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/head.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/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/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1152 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 04:10:39.039
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 @ 04:10:39.039
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=14ms, Records=2) in /root/website/actions/adstatus.cfm @ 04:10:39.039
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 @ 04:10:39.039
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=27ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 04:10:39.039
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 @ 04:10:39.039
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=22ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 04:10:39.039
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 @ 04:10:39.039
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=5ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 04:10:39.039
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 @ 04:10:39.039
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=39ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 04:10:39.039
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=37ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 04:10:39.039
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) = 779

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=30ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 04:10:39.039
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) = 779

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=20ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 04:10: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) = 779

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=23ms, Records=7) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 04:10: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) = 779

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:10: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=31ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:10: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 @ 04:10: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=41ms, Records=1) in /root/website/actions/udfs.cfm @ 04:10: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) = 1047

get_member_account_types (Datasource=bookbrowse_com_new, Time=14ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 04:10: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=167ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:10: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) = 229
Parameter #2(CF_SQL_INTEGER) = 229
Parameter #3(CF_SQL_INTEGER) = 229

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 04:10: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) = 229

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=30ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 04:10: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=13ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:10:40.040
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=50ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 04:10:40.040
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=31ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:10: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) = adzone6
Parameter #2(CF_SQL_VARCHAR) = 0
Parameter #3(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:10: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) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:10:40.040
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=23ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 04:10:40.040
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 @ 04:10:40.040
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=30ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 04:10: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.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

	AND     (b.category_number IN (	SELECT	category_number
									FROM	category_book_mapping
									WHERE	book_number = ?)
      		OR 	b.category_number = ?)
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112
Parameter #3(CF_SQL_VARCHAR) = 0
Parameter #4(CF_SQL_VARCHAR) = 0

get_ads (Datasource=bookbrowse_com_new, Time=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:10:40.040
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 04:10:40.040
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; CFTOKEN=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240; CFID=4085248; CFGLOBALS=urltoken%3DCFID%23%3D4085248%26CFTOKEN%23%3D5a10aba3c810052d%2D0DBAF540%2DD0BE%2D1CAF%2D3744D7690F181240%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2004%3A10%3A39%27%7D%23hitcount%3D307%23timecreated%3D%7Bts%20%272026%2D06%2D01%2004%3A09%3A39%27%7D%23cftoken%3D7a728b3b0bea3b56%2D0DBAF9CC%2DCA9E%2D62C7%2D707B97464D80548A%23cfid%3D4085249%23; FREEACCESSCOUNT=0
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/779/author/anita-rau-badami
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=4085249
cftoken=7a728b3b0bea3b56-0DBAF9CC-CA9E-62C7-707B97464D80548A
hitcount=310
lastvisit={ts '2026-06-01 04:10:40'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 04:09:39'}
urltoken=CFID=4085248&CFTOKEN=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240
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#=4085248&CFTOKEN#=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240#lastvisit={ts '2026-06-01 04:10:39'}#hitcount=307#timecreated={ts '2026-06-01 04:09:39'}#cftoken=7a728b3b0bea3b56-0DBAF9CC-CA9E-62C7-707B97464D80548A#cfid=4085249#
CFID=4085248
CFTOKEN=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240
FREEACCESSCOUNT=0
Session Variables:
cfid=4085248
cftoken=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240
sessionid=BOOKBROWSE_4085248_5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240
urltoken=CFID=4085248&CFTOKEN=5a10aba3c810052d-0DBAF540-D0BE-1CAF-3744D7690F181240
URL Parameters:
author=anita-rau-badami
author_number=779
Debug Rendering Time: 40 ms