Aysegül Savas Interview, plus links to author biography, book summaries, excerpts and reviews

Author Image Not Available

Aysegül Savas

How to pronounce Aysegül Savas: EYE-shi-gool sha-VAS

An interview with Aysegül Savas

The author discusses her novel, The Anthropologists with Amy Omar for The Markaz Review


AO: Your third novel The Anthropologists follows on your first child's birth. Did you question your work in relation to becoming a mother?

AS: I didn't ever question why I was writing, but I did ask myself when I was editing The Anthropologists, how I could relate to these characters who are smoking and having these lengthy discussions. I asked myself who wrote this? Who even has time for any of that? The positive is that now I have much more clarity on what my priorities are — I only want to write full time and it was a nice clarification for me that this is all I want to do with the little time that I have.

AO: In a way, you are living the future version of the characters in The Anthropologists.

AS: I think this is true for many writers, that their characters grow up, but they're always lagging in some years. In Walking on the Ceiling, I wrote about a character in her early 20s, and I was in my late 20s. In White on White, I wrote about a graduate student, and now I'm writing about a postgraduate student. Probably next I'll be writing about someone in their late 30s.

AO: The Anthropologists originated from a short story published in the New Yorker in 2021, "Future Selves," but how did you get the initial idea for the story and then why did you decide to expand it into a novel?

AS: I wrote the short story really rapidly, which isn't true for my writing in general. I typically write very slowly. There was such a clear moral orientation that I knew exactly where I was going. I wanted to explore that feeling of one's own life going so well but then living alongside tragedy. This sounds like a cliché, but I wrote it in one sitting. I had that feeling of having a direction that was so strong, I thought why not?

As I started expanding "Future Selves" into The Anthropologists, I had so much more to say on the theme of how does one make a life as a foreigner. I used the character's hunt for an apartment as a skeleton for containing and exploring that topic.

In the story, and then in my own life as well, I was feeling this yearning for a very near past of being young and not having responsibilities, but also being an adult. Now you can pay your own rent, and you know what your career is, and you don't have children and you're not paying a mortgage. Maybe you have a few friends that are up for spontaneously hanging out and you all know that this will last for only a short period of time. That's when I knew I wanted to write that novel.

AO: On the theme of making a life as foreigner, you are Turkish and have lived in many places. How long have you been in Paris?

AS: I've lived in Paris for twelve years, the longest I've ever lived anywhere. I lived in California previously and when my husband, who is a researcher, had a job offer in Paris, we figured we both speak French so we decided to move. It was closer to both of our home countries without being in our home countries. I do feel a love for the city and while I feel like it's my home, I still feel like a foreigner. But you know, if I moved back to Istanbul, it would feel foreign as well. It's that sense of feeling mostly at home in many places, but not entirely at home.

The Anthropologists is very autobiographical, because I always grew up in different places. I'm married to a Latvian and though this is my partner in life, we also know that we'll never really fit into one another's native countries. There's that anxiety of wanting to create something that feels meaningful and have that meaning not be something imposed on us. For example, here's a holiday we have to celebrate because our families celebrate it. Instead we want something authentic and important to us. 

I also have an anthropology background, so innately I have this lens of looking at life and habits like an ethnographer. I give importance to these very small aspects of daily life. What specific values and rituals bring people together in a foreign place so that you're not a floating, cultureless being?

When I was writing this novel, I would ask people what are your rituals in lifewhat are the things that give meaning? Many of our friends are secular, global citizens, and would initially say they have no rituals. But then, they would bring up things like Friday night pizza or when any of our writer friends gets a story published, we go out to celebrate at this restaurant. These are all actual rituals. This is how one creates a culture.

 

AO: Has living in Paris influenced your writing? I know your first novel, Walking on the Ceiling, was set in Paris.

AS: When I first moved to Paris, I was so enchanted by the city, I started taking notes right away and wanted to put it in a book. Walking on the Ceiling, has an eagerness and extreme love for the city. For my other novels, I stopped being such a foreigner and the sites seemed less exciting to me.

AO: Both White on White and The Anthropologists are set in unnamed cities.

AS: I wanted to shift my focus to a universal sense of estrangement, rather than this specific immigrant's experience or this specific city's atmosphere. I'm more interested in the experience of being estranged or in the experience of finding one's identity, then I am in the experience that a specific city gives to its residents.

AO: I found it interesting that you made the decision to give your characters names, some of which I found to be culturally identifying i.e. Asya, Ravi, Manu but you never identify the cultures that the "foreigners" come from nor do you designate where they live.

AS: Asya can be Turkish, but could also be from the Balkans. I often am on the lookout for geographically ambiguous names. I'm always writing them down whenever I hear one, but at the same time, no name is 100% from one culture. It's the same with Manu, his name does not belong to just one part of the world, it could be from a number of places. It's just enough to give the sense that these two characters are foreign to the other's culture, but then leave that exact culture narrow but also open to a handful of different places.

AO: Do you see Asya as an anthropologist of others, to apply their ways of life to her own or is she rather trying to define her and Manu's own existence?

AS: I think it's both. They have their own quirky way of living, but she is also at the age where everything is a possibility. Why not have a ritual of going for a walk every Friday morning at sunrise? You have that level of curiosity and energy in life. She's looking at things that they could integrate into their own lives.

AO: This is also a source of anxiety for her too, because she second guesses the way they live. What happens when you are creating your own culture from scratch?

AS: Exactly, she's always considering this better version of their lives. Should we live in this house because it would present this sort of identity? Are we the type of people who go to the Sunday Market? Or are we the type of people who mingle with neighbors in a faraway suburb? Of course, there is no right answer to these questions. It's simpler when you're married to someone from your own country and following a certain rhythm of life rather than constantly Facetime your community, scattered around the world. Asya and Manu see themselves as having come from different cultures and creating a world for themselves. They are living a very different life than their parents and wonder if they should fully enjoy it or should be committing to other things.

AO: There is a section in the novel called "Native Tongues" where Asya and Manu understand each other more by learning words from the other's culture. Could you speak to this more?

AS: There are definitely words I've taught my partner in Turkish because I can't find an equivalent in English. But at the same time, I even see this with couples, whose only language is English, create a language unique to themselves with terms of endearment for the other. It is its own language. And it's so difficult to express but you have to belong to that tribe to understand and to be able to speak in that register. My brother actually first mentioned it to me, that my husband and I speak in a different tone to each other. I realized we did have a higher pitched voice and our endearments probably sounded totally insane to anyone on the outside.

It's funny, now that I have a baby, it's not embarrassing to talk to a baby with a baby voice, but it's really embarrassing to talk to a partner with a baby voice. Yet we're always adapting these characters of speaking to different people. I feel so much love for Asya and Manu, for their quirks and for how silly they are, but I didn't want to ridicule them or even make a huge deal out of something that quite banal. It's more of an observation in how people anchor themselves to a place or person.

AO: From an anthropological perspective, Asya and Manu are just humans creating their own language and way of  communicating with the other to define their emotions.

AS: Yes, exactly.

AO: I really like how you capture the simplicity, and the mundane of a young relationship and the lives around them. It almost felt like a French film, reminiscent of Agnes Varda's work like Daguerreotypes, especially Asya's filming in the park.

AS: Well, when I wrote the character, The Great Dame, I was thinking of Agnes Varda. We live close to where she lived in Paris and our entire area is like a love letter to Varda. There is a municipal hall that has a whole wall of drawings of her films.

As I was writing The Anthropologists, I thought, what if she popped into this novel. What if she had been alive when I lived here and I could see her at the cafe. What if Asya, who is a documentary filmmaker, kept running into her? If we were to ask Aysa who her inspirations were, she would have said Varda.

AO: I'm so happy I picked up on that! I tend to wonder, when I'm reading different novels, who their influences were.

AS: You know that Éric Rohmer film, the really, really short about this young student in a park?

AO: Nadja à Paris?

AS: Oh yes, exactly. As I was writing, I was thinking about how it's so mundane and how she has a drink at the café and then runs to the university. It's such a beautiful film and unfortunately I think it's his first film, which kills me.

AO: Are you familiar with the filmmaker Hong Sangsoo? Like Rohmer, everything and nothing happens in his films. He takes daily life and makes it important.

AS: This is my favorite type of movie and book — one that focuses on daily life and doesn't belittle it and doesn't say, this isn't important to write about. The goal is that you describe daily life to an extent that it regains its poetry and shows us the way in which we live and how we put meaning into simple actions. I was asking my friends about their rituals and so many people said how they make their morning coffee. The fact that the first thing one does in the morning for many people is a ritual, is quite moving.

AO: In your introduction to Tezer Özlü's Cold Night of Childhood, you write about enrolling in a Turkish literature class in an effort to find your voice, but then how reading Özlü gave you the confidence to pursue your own voice. I'm curious about this initial internal pressure to go back to Turkish literature. 

AS: At some point, I asked myself, Do I have an obligation to be a Turkish writer or do I have an obligation to write about certain topics? But then, this literature is quite foreign [to me]. The greater scope of Turkish literature is Ottoman and it's a language that changed overnight. Even though I went to high school in Turkey, I never read the classics. I had an amazing literature teacher who basically summarized the classics for us because we couldn't understand the written text. When you start reading post-Republic era works, it's a very short history for literature and you don't learn about them as literary works because their purpose is to represent a New Republic and its ideals. 

So then it's difficult, as a young woman reading literature you don't really identify with. When I first read Özlü, I couldn't believe I hadn't heard of her. She was a writer I could hold onto. When I was asked to write the introduction, I panicked because I had no idea how to fit her within the canon of Turkish literature. It was such a weight and responsibility because I didn't know this canon myself; I didn't belong to it.  So I had to find a way of situating her but also saying that she's a writer who spoke to me. She's an example of how literature doesn't function because it fits into a linear history, but [instead it functions] because it inspires and moves its readers and everyone makes their own cannon as they come of age as writers and readers and artists.

AO: It's really exciting that there has been this resurgence over the past few years of English translations of radical Turkish feminist literature.

AS: Transit Books is actually publishing [an English translation of] her second novel, Journey to the End of Life. I initially had wanted to translate Özlü's works but then my editor suggested it would be more interesting if I wrote about her rather than translating her work and then years later I was asked to write the introduction to Cold Night of Childhood.

AO: It's interesting how the universe responds when you are passionate about something. Sometimes these opportunities find you.

AS: When you're curious about something, the curiosity sorts to trickle in. This is something I feel so strongly in my writing career. Whenever I'm superficially interested in something or have to make an effort to be interested in it, like the Ottoman literature class, it doesn't go anywhere; it's like rolling against the current. But the moment I let myself be interested in my curiosities and let myself go in that direction, without any self judgment, I find my kindred audience. That gives me the confidence to lean into my voice, even if the story feels small to the outside world, it's important to me and then you realize other people find it important too.

But then, I'm always thinking, is craft possible? Or am I up to my old tricks again. I have to distinguish between a real curiosity and something that feels comfortable. It's this constant mindset, you have to ask yourself, am I curiousDo I have an authentic voice for this? With, The Anthropologists, I wondered who would ever read a book about daily rituals. This is such a small book, but I like finding a small community of readers this way.

AO: What's next?

AS: Funny enough, I may now have grown a little bit tired of the unnamed cities and now in my new project, it's very much in a very specific place: Mexico City. Now, I'm constantly on Google Maps, going down the streets of Mexico City. I'm headed there in January to teach and fact check details of my book which centers around some archaeological finds. 

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 Aysegül Savas at BookBrowse
Long Distance jacket The Anthropologists jacket White on White jacket Walking on the Ceiling 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 Aysegül Savas 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

  • Rachel Cusk

    Rachel Cusk

    Rachel Cusk is the author of Second Place, the Outline trilogy, the memoirs A Life's Work and Aftermath, and several other works of fiction and nonfiction. She is a Guggenheim Fellow. She lives in Paris. (more)

    If you enjoyed:
    The Anthropologists

    Try:
    Outline
    by Rachel Cusk

  • Jhumpa Lahiri

    Jhumpa Lahiri

    Jhumpa Lahiri, a bilingual writer and translator, is the Millicent C. McIntosh Professor of English and Director of Creative Writing at Barnard College (Columbia University). She received the Pulitzer Prize in 2000 for ... (more)

    If you enjoyed:
    The Anthropologists

    Try:
    Whereabouts
    by Jhumpa Lahiri

We recommend 3 similar authors

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

Chance favors only the prepared mind

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:20 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
1780273218868 ms 1.78027321887E+012 ms 1 /root/website/app_server.cfm
820 ms 820 ms 1 /root/website/author_interviews/full/index.cfm
397 ms 397 ms 1 /root/website/author_interviews/full/dsp_main.cfm
262 ms 131 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
161 ms 161 ms 1 /root/website/app_layout.cfm
131 ms 44 ms 3 /root/website/adsystem/adsystem_mod.cfm
131 ms 131 ms 1 /root/website/app_globals.cfm
106 ms 106 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
73 ms 73 ms 1 /root/website/queries/qry_get_active_obc.cfm
65 ms 22 ms 3 /root/website/site/blocks/membership_advantages.cfm
63 ms 63 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
61 ms 61 ms 1 /root/website/adzones/AdZone6.cfm
60 ms 20 ms 3 /root/website/queries/qry_get_member_account_types.cfm
41 ms 41 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
39 ms 39 ms 1 /root/website/adzones/showcase_track.cfm
32 ms 32 ms 1 /root/website/adzones/AdZone2.cfm
32 ms 32 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
26 ms 26 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
16 ms 16 ms 1 /root/website/actions/adstatus.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_current_competition.cfm
10 ms 10 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
9 ms 9 ms 1 /root/website/act_check_login.cfm
9 ms 9 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 7 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
3 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/main_menu.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.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/head.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/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
3 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
823 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 00:20:18.018
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=8ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 00:20:18.018
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=15ms, Records=2) in /root/website/actions/adstatus.cfm @ 00:20:18.018
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:20:18.018
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=5ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 00:20:18.018
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=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:20:18.018
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 00:20:18.018
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:20:18.018
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=7ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 00:20:18.018
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=52ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 00:20:18.018
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=11ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 00:20:18.018
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=40ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 00:20:19.019
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) = 3971

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

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=4) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 00:20:19.019
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) = 3971
Parameter #2(CF_SQL_INTEGER) = 3971

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=29ms, Records=3) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 00:20:19.019
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) = 3971

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=17ms, Records=3) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 00:20:19.019
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) = 3971

get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=26ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:20:19.019
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=25ms, Records=1) in /root/website/actions/udfs.cfm @ 00:20:19.019
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) = 4847

get_member_account_types (Datasource=bookbrowse_com_new, Time=14ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:20:19.019
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=45ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:20:19.019
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) = 2575
Parameter #2(CF_SQL_INTEGER) = 2575
Parameter #3(CF_SQL_INTEGER) = 2575

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=169ms, Records=5) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:20:19.019
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) = 929
Parameter #2(CF_SQL_INTEGER) = 929
Parameter #3(CF_SQL_INTEGER) = 929

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=36ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 00:20:19.019
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) = 929

get_member_account_types (Datasource=bookbrowse_com_new, Time=18ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 00:20:19.019
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=10ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:20:19.019
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=16ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 00:20:19.019
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=36ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=9ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 00:20:19.019
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:20:19.019
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 00:20:19.019
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=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53; CFGLOBALS=urltoken%3DCFID%23%3D4077981%26CFTOKEN%23%3D78f61de552c0f8c8%2D058685F4%2D9EB4%2D8AC0%2DD2F7029629EDBB53%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2000%3A20%3A18%27%7D%23hitcount%3D12%23timecreated%3D%7Bts%20%272026%2D06%2D01%2000%3A20%3A14%27%7D%23cftoken%3D78f61de552c0f8c8%2D058685F4%2D9EB4%2D8AC0%2DD2F7029629EDBB53%23cfid%3D4077981%23; CFID=4077981
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/3971/ayseg&uuml
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=4077981
cftoken=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
hitcount=20
lastvisit={ts '2026-06-01 00:20:19'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 00:20:14'}
urltoken=CFID=4077981&CFTOKEN=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
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#=4077981&CFTOKEN#=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53#lastvisit={ts '2026-06-01 00:20:18'}#hitcount=12#timecreated={ts '2026-06-01 00:20:14'}#cftoken=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53#cfid=4077981#
CFID=4077981
CFTOKEN=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
Session Variables:
cfid=4077981
cftoken=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
sessionid=BOOKBROWSE_4077981_78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
urltoken=CFID=4077981&CFTOKEN=78f61de552c0f8c8-058685F4-9EB4-8AC0-D2F7029629EDBB53
URL Parameters:
author_number=3971
ayseg&uuml=
Debug Rendering Time: 10 ms