Rabih Alameddine Interview, plus links to author biography, book summaries, excerpts and reviews

Rabih Alameddine

Rabih Alameddine

How to pronounce Rabih Alameddine: Rah-be Ahlah-m'dean

An interview with Rabih Alameddine

A wide ranging conversation with Rabih Alameddine, in which he discusses his first novel The Hakawati and what he hopes it will teach readers about Middle-Eastern culture, his views on modern-day Lebanon, where he found inspiration for the book, and whether it is based on a particular hakawati (story-teller).

Okay, let's begin at the beginning. Do you remember when the idea for The Hakawati came to you? In your mind's eye, what did you see?

Along time ago, in a galaxy far, far away—oh, never mind. 

The idea for The Hakawati had many beginnings, as is the case for many a novel, I presume. Which beginning would one consider to be the true one, the original?

Let's see, in 1999 I wrote a long piece that was later trimmed and published as a short story in Zoetrope. That was chapter 10 from the novel—which goes back and forth between my main character Osama al-Kharrat's visit to the UCLA campus as a teenager and his vigil at his father's hospital bed years later—in a different form. I wrote a couple more stories, one successful, the other not. The latter ended up as a part of the book. I had begun to see the al-Kharrat family in my head. It still wasn't a novel. I was floundering. I had different novels in my head and none of them seemed to make much sense.

I was teaching in Beirut 2003—annus horribilis, as the Queen would say—when my father was dying in the hospital. I couldn't follow through on any of the novels I had in my head, so I began to write something completely different: the first grandfather chapter. I can't tell you why I did that; I hadn't considered the subject before. I placed the man in Urfa because I had read a memoir based there. I discovered that Urfa was the birthplace of Abraham, so I began to reread Old Testament stories. Then I found out that the city was a hotbed of pigeon wars. Who knew?

Yet all this was simply material. I didn't have a novel. I didn't have a structure, and I had stories raging and clawing in my chest. I wanted to write about a family around a deathbed; I wanted to write a novel about parents and offspring; I wanted to write a novel about the grandfather and how a family begins, how it forms (Abraham, Ishmael, Isaac?); I wanted to tell stories.

It was a year later, in 2004, that it finally occurred to me that it was one novel, that everything fit together because the grandfather was a hakawati, and so was the entire family.  Once I had that, I had the structure. I had my novel.


Woven in with Osama's narration are stories, and stories within stories. They are Biblical tales, Arabian myths re-imagined, legends of al-Kharrats from generations past. Can you talk about the range of sources and influences for those?

I've always been influenced by my reading. For this novel it was books, books, and more books: Calvino, Homer, Ovid; Koran, Bible, Bhagavad Gita; literary, commercial, and pulp fiction; Arabic poetry and folktales, a hakawati's book, German studies of Arabic tales; Marvel comics, D.C. comics, Asterix and Obelix, Tintin; Nabokov, Borges, Nooteboom. Shakespeare's plays. Memoirs written by family members now long gone.

Everything I've ever read became story fodder.

But then I've always considered myself fortunate to be Lebanese. Once I understood what kind of book I was writing, I spread the word among family and friends that I was looking for stories. I received hundreds of calls from acquaintances, long-lost relatives, strangers who swore they were relatives, talkers all, wanting to tell me their stories. My grandfather's first cousin told me stories of growing up in the mountains of Lebanon. My grandfather's ninety-eight year-old second cousin told tales of the English missionaries and their songs. A destitute cage cleaner in the employ of a pigeoneer told me pigeon stories, muezzin stories, and even a couple of fairy tales I had never heard. The best Druze stories I heard were told to me by a Shiite psychiatrist. The best/worst seduction tale of a Lebanese woman was told to me by my mother's deliciously foul-mouthed first cousin. ("Yes," she said, luring me into her tale, "it did involve an asclepiad.")

As to stories within stories, I remember wanting to do something like that years and years ago while watching a re-released print of a convoluted Polish movie in the Castro Theater in San Francisco. The Saragossa Manuscript took my breath away.

Stories flit about us all the time. We just forget to listen. Our butterfly nets gather dust.


Part of the book takes place in 2003, when our narrator, Osama al-Kharrat, visits Beirut from California. Why did you decide on 2003?

There are two reasons for the date, February of 2003. The main one is that I didn't want to deal with the invasion of Iraq directly. There are enough crusades in the novel. The other is that in February of 2003 my own father died. This makes some things easier: what the weather was like, what was happening in Beirut when the family was in the hospital, etc. The Iraq war is the main reason, though. I felt that setting the novel after that date would overwhelm it, that the war might make for too easy a metaphor.


Osama left home twenty-some years before the novel opens, and when we meet him he is living in California and is traveling to Beirut to visit his family. You grew up in Beirut, you moved to California, you visit home often, you're about the same age as Osama. Is there anything else you and Osama share? Basically, I'm asking you the requisite 'is this autobiography in disguise' question.

I don't believe in auto-plagiarism (a Nabokovian term). There are many things that Osama and I share, but we're very different, and the novel isn't really autobiographical. What we have in common: I'm actually a little older than my character, but we both went to UCLA for undergrad. Our fathers died at the same time. Almost everything else is different: personality, family, education. I don't play the oud (or the guitar) though I love the instrument passionately. I'm much more the center of my own drama that Osama is of his. I spend more time in Beirut, and I have a much more troubling career.

I probably have more in common with a couple of the imps than I do with Osama.


How do the two strains of this novel—the modern-day narrative and all the ancient stories—speak to each other?

They interweave, they aid and abet each other. They also reflect each other, back and forth they go. In some ways, they are the same story, or the continuation of the same story. Sometimes an "ancient" story will elucidate a "modern-day" one; other times, the narrator's family story presents a different take on the mythical story.

I have always been intrigued with the question of whether, when we tell a story about ourselves, we get closer to the listener or distance ourselves. Are we becoming vulnerable or more protected? Osama tells stories to communicate, to express feelings. It's his way of relating to people, and to the reader.


One of the epigraphs to Book 2 reads, in part, "Once a story has been told, it's anyone's, it becomes common currency, it gets twisted and distorted." That philosophy is borne out in your telling of all stories in this book. Do we have any obligations to stories—especially stories that have been passed through the generations, like family stories, or shared cultural stories, or stories from the Bible or Koran?

The epigraph is by Javier Marías, who could probably discuss this subject much better, since I consider this a difficult question. Once I hear the word obligation, my lips purse, my shoulders start to shrug, and my wrists tense preparing to break imaginary shackles. My first reaction, my instinctive response, would be that a storyteller has no obligations to anyone or anything, none.  To talk about a hakawati's obligations, or a writer's, chafes and grates and itches. Astoryteller's obligation is to tell a good story; a story's obligation is to be great. Now, what makes a story great, or a great storyteller, can be argued ad infinitum.

A writer can do whatever she wishes to a story, and of course, a reader has the right to not read that story. Stories get distorted by the mere fact of being told; I never understood the need to be true to them, be they biblical, historical stories, or whatnot. Man is by nature a congenitally unreliable narrator.


While you were growing up in Beirut, were there still active hakawatis in the city? How about today? Did you go listen to them perform while you were working on this novel?

I didn't know of any while growing up. Had I known of one I certainly wouldn't have gone to listen. I grew up on "Bewitched" and Monty Python, on the flirting between Matt Dillon and Kitty Russell, between Mr. Steed and Mrs. Peel, on Dr. No, The Sound of Music, and Bruce Lee.  Mine was a relatively modern household. My friends and I pooh-pooed anything that Arabic culture offered, specially the few things that our parents enjoyed. We pitied them for enjoying Fairuz and Umm Kalthoum. I dreamed of seeing Genesis (with Peter Gabriel, of course) and Queen in concert, not of listening to a storyteller. If hakawatis existed in Beirut when I was young, my generation probably killed them.

There are none today, at least not in Lebanon. I know of one in Damascus, in a café called the Nafoura (fountain), but he plies his trade for tourists, a facsimile of a real hakawati. I heard of a couple of retired old coots in northern Syria, both Kurds. There is a theater troupe in Cairo that is trying to revive the art, but I don't know much about them. So, no, I didn't talk to a hakawati or hear one perform, not a professional. Like most things in the novel, the details of the hakawati's performances are invented.


As Osama describes it, life during the civil war in Lebanon bred a particular kind of roll-with-it attitude, and deadpan humor, in Beirutis. Air raid sirens may have gone off, and bombs may have dropped, but people weren't about to put life on hold. Do you see that attitude as part of Beirutis' cultural identity in real life, and how would you characterize it?  Has it lingered even though things are more stable now?

Yes, it has lingered. I think it's part of the Beirutis' innate character, an inherited abnormality.  The situation in Beirut right now (early 2008) is horrible and tense. We have no president because the political sides can't seem to come to an agreement. The economy has been at a complete standstill since the Israeli bombings in July 2006. Everyone is utterly depressed, and hope has left the country.

Yet, you can rarely get a reservation at any restaurant or club on Gemmaizeh Street. I have a friend who once crossed a demonstration in which the opposing sides were about to kill each other because she needed to pick up the perfect pair of jeans, which were being altered. I was told that once, when a car bomb exploded not too far from a café in Aisha Bakkar, the owner was upset with two of his customers because they stood up to investigate before having finished their cups of coffee. He assumed they didn't like his coffee and was mollified only when the other customers convinced him that the offenders were probably out-of-towners.


You paint such a vivid portrait of Fatima, Osama's emerald-festooned Jewish-Italian-Iraqi best friend, that I had to wonder if she is based on a real person. Is there a real-life Fatima?

No, there is no real-life Fatima. She's made up. When I was a child in Kuwait, there was a girl in school, a couple of years older than I was, who sucker-punched an older, blubber–bellied bully at recess. She must have been seven or eight, and I don't remember much of what she looked like other than that she had mixed Arab parentage. The Fatima in my book is probably who I imagined that girl would grow up to be.

Not surprisingly, every Lebanese woman who has read the book so far has insisted that Fatima was based on her, my agent being the first (and since I'm not dumb, if my agent insists that she was based on her, then surely she was).


Did you live in Lebanon while the civil war was going on? How did that experience influence you as a writer?

Not exactly. I left for England when the war started and then came to the U.S. I did, however, travel back and forth constantly since my family was always there, even during the most horrific times of the war. The exception was during the Israeli invasion of 1982. I was on the last flight out (I know, every Lebanese will tell you they were on the last plane out) and didn't return till 1984.  Otherwise I was there for a good chunk of every year. Unlike many Lebanese, though, I was able to leave whenever I wished and never had to suffer the horrors of the worst days, months, years.

How it influenced me as a writer? I'm not sure that can be quantified. I'm sure there is some correlation between my writing style and the civil war but I doubt causality can be inferred. I used to think that the war sharpened my wit, but I no longer do. Most Lebanese have a different sense of humor.


Do you want this novel to teach readers about Middle Eastern culture, Lebanese culture specifically? Put another way, did you feel any responsibilities or pressures writing about your homeland for an American audience?

No, no, and definitely not. I don't presume to be able to teach a reader, nor do I wish to. That's a slippery slope. I'm not fond of didactic fiction, nor do I believe that anyone can learn about Middle Eastern culture by reading one novel. Middle Eastern culture is diverse, so is Lebanese culture. In this novel, the al-Kharrat family is of a certain class, lives in a certain area, has a specific background. To assume that one is able to learn something about the Middle East from that doesn't make sense to me. No novel can do that, nor should it. Hell, War and Peace might have given me an idea of how some Russians may have seen the Napoleonic War, but I'd be naïve to think that it taught me about Russian culture or the Napoleonic War. Novels offer one perspective, the writer's.   Some writers have a wider perspective than others, but no one can teach about an entire culture, or worse, presume to speak for it. I can barely speak for myself; I can't for Lebanese culture.

But I will say this: maybe the novel can break through a reader's biases and preconceived ideas about what the Middle East is. I guess that would be a kind of illumination, to rattle misconceptions.

The question suggests that I write for an American audience. I don't. I don't write for a Lebanese audience either. I'm part of various subdivisions of humans, but I have never felt that I've belonged to any. I write and desperately hope that someday a reader will read what I've written, but I never presume that my reader is an American, an Arab, a lesbian, a soccer player, a Quaker, a left handed Inuit basket weaver, an Argentine gigolo, or whatever. Why restrict oneself to silly boundaries? I write for a human audience.


There are so many funny lines in this book. My favorite: "Sarah decided to sharpen the cutlery" in one scene with Sarah and Hagar, and I love it because of the way you use contemporary vernacular to tell a Biblical story—and you do that throughout the book. Are you conscious of "writing funny" and do you that you have to hone and refine the funny lines? Or does funny just sort of happen when you write? How important is humor in this book?

Funny sort of happens when I write. I'm not conscious of it. If I try to write funny, it comes out forced and clunky. I don't hone and refine the funny lines. I'm not a comic in that sense. If a line or scene doesn't sound funny in the first draft, it gets thrown out. Again, refining it sometimes makes it sound forced. 

Humor is essential in this book. I can't imagine a novel on storytelling not being funny.  Someday I might write a novel that isn't funny, but it hasn't happened so far. Some of my stories might rely on humor more than others but it's always there. I tend to prefer a light touch when dealing with a serious subject, and tend to prefer those writers with a sense of humor. I grew up on Dostoyevsky, and I still think he's amazing but a bit too earnest. Now, if he had Gogol's lighter touch... . Humor tends to sharpen the blunt edges of earnestness.


You are a successful painter in addition to being a writer. You also have your MBA and an engineering degree. When people meet you and ask you "what do you do," how do you answer?  And what else do we not know about you? (Do you throw the discus in your spare time?)

I write. That's how I answer. I guess that's more central than any other. I've wanted to write for as long as I can remember, so once I began to do so, it was easy to say, "I'm a writer." Also, calling myself a painter doesn't feel true right now. I haven't seriously painted in a long time. My last exhibit was in Norway in 1997, quite a while ago.

I don't throw the discus in my spare time. I play soccer. It's my one true love, my one uncomplicated intimate relationship. I've been playing for 38 years and should have retired a long time ago. (Some have suggested that I should have retired 38 years ago.) I can't, though. I still schlep my creaky joints and aged knees to the field twice a week. I've played on the same teams for decades. It's been a pleasure watching my teammates age and observing their declining skills.

Since I've never had that much skill to begin with, my fall from my peak playing days has been less dramatic. They all still play much better than I do, but I think that in a few years they'll get so bad that I'll catch up.

I don't watch soccer/football as much as I used to though, so one can say I'm finally beginning to grow up. But then I'm obsessed with UCLA basketball, have been since I was a freshman there. Every day when I first wake up, I turn the computer on so I can scan the Web for any tidbit on the UCLA basketball team. My obsession embarrasses me and makes no sense, yet I refuse to give it up.

That's about as interesting as I can make myself sound. I wish I could say that I'm a brilliant pianist or a great chef—I can't cook but last year I learned to how to wash dishes. Does that help?

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 Rabih Alameddine at BookBrowse
Comforting Myths jacket The Wrong End of the Telescope jacket The Angel of History jacket An Unnecessary 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 Rabih Alameddine 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

  • Rabih Alameddine

    Rabih Alameddine

    Rabih Alameddine is the author of the novels An Unnecessary Woman; I, the Divine; Koolaids; The Hakawati; The Wrong End of the Telescope; and the story collection, The Perv. In 2019, he won the Dos Passos Prize. (more)

    If you enjoyed:
    The Wrong End of the Telescope

    Try:
    An Unnecessary Woman
    by Rabih Alameddine

  • Anita Amirrezvani

    Anita Amirrezvani

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

    If you enjoyed:
    The Hakawati

    Try:
    The Blood of Flowers
    by Anita Amirrezvani

We recommend 40 similar authors


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

BookBrowse Book Club

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

Members Recommend

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

Fanaticism consists in redoubling your effort when you have forgotten your aim

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


Execution Time

Total Time Avg Time Count Template
1780262513848 ms 1.78026251385E+012 ms 1 /root/website/app_server.cfm
542 ms 542 ms 1 /root/website/author_interviews/full/index.cfm
177 ms 177 ms 1 /root/website/app_layout.cfm
161 ms 161 ms 1 /root/website/app_globals.cfm
148 ms 148 ms 1 /root/website/author_interviews/full/dsp_main.cfm
117 ms 117 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
114 ms 38 ms 3 /root/website/adsystem/adsystem_mod.cfm
81 ms 81 ms 1 /root/website/queries/qry_get_current_competition.cfm
73 ms 37 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
55 ms 55 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
54 ms 54 ms 1 /root/website/adzones/showcase_track.cfm
47 ms 47 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
46 ms 46 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
44 ms 44 ms 1 /root/website/adzones/AdZone6.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_active_obc.cfm
37 ms 12 ms 3 /root/website/site/blocks/membership_advantages.cfm
35 ms 12 ms 3 /root/website/queries/qry_get_member_account_types.cfm
21 ms 21 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
17 ms 17 ms 1 /root/website/adzones/AdZone2.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
12 ms 12 ms 1 /root/website/actions/adstatus.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
7 ms 2 ms 4 /root/website/actions/act_spider_tracker.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
6 ms 6 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
5 ms 5 ms 1 /root/website/act_check_login.cfm
4 ms 4 ms 1 /root/website/act_libraryIPLogin.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_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/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
544 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 21:21:53.053
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=3ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 21:21:53.053
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=12ms, Records=2) in /root/website/actions/adstatus.cfm @ 21:21:53.053
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 @ 21:21:53.053
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 @ 21:21:53.053
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=64ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 21:21:53.053
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=16ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 21:21:53.053
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 @ 21:21:53.053
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 21:21:53.053
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=6ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 21:21:53.053
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=16ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 21:21:54.054
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=13ms, Records=3) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 21:21:54.054
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) = 1551

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

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=6ms, Records=5) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 21:21:54.054
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) = 1551
Parameter #2(CF_SQL_INTEGER) = 1551

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=19ms, Records=2) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 21:21:54.054
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) = 1551

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

get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 21:21:54.054
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=7ms, Records=1) in /root/website/actions/udfs.cfm @ 21:21:54.054
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) = 4337

get_book_image (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/udfs.cfm @ 21:21:54.054
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) = 2995

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

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 21:21:54.054
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) = 1551

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=41ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 21:21:54.054
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1467
Parameter #2(CF_SQL_INTEGER) = 1467
Parameter #3(CF_SQL_INTEGER) = 1467

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 21:21:54.054
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1467

get_member_account_types (Datasource=bookbrowse_com_new, Time=15ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 21:21:54.054
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=26ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 21:21:54.054
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=18ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 21:21:54.054
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=23ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=6ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=21ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 21:21:54.054
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 @ 21:21:54.054
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=20ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 21:21:54.054
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%23message%3DFull%20access%20to%20%3Ci%3EThe%20BookBrowse%20Review%3C%2Fi%3E%20is%20for%20members%20only%2E%3Cbr%3E%0A%09%09%09%09%09%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Fjoin%22%3E%3Cb%3EBecome%20a%20member%3C%2Fb%3E%3C%2Fa%3E%20%7C%20%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Flogin%3Fnext%5Furl%23%3D%2Fmag%22%3E%3Cb%3EMember%20login%3C%2Fb%3E%3C%2Fa%3E%20%7C%20%3Ca%20href%23%3D%22https%3A%2F%2Fwww%2Ebookbrowse%2Ecom%2Flibrary%22%3E%3Cb%3ELibrary%20patron%20login%3C%2Fb%3E%3C%2Fa%3E%23; CFGLOBALS=urltoken%3DCFID%23%3D4074558%26CFTOKEN%23%3Df2a9fc8989943c2f%2DFF25B546%2D9E5F%2D45E6%2D027B54DE9D600981%23lastvisit%3D%7Bts%20%272026%2D05%2D31%2021%3A21%3A53%27%7D%23hitcount%3D2%23timecreated%3D%7Bts%20%272026%2D05%2D31%2021%3A21%3A53%27%7D%23cftoken%3Df2a9fc8989943c2f%2DFF25B546%2D9E5F%2D45E6%2D027B54DE9D600981%23cfid%3D4074558%23; CFID=4074558; CFTOKEN=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
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/1551/rabih-alameddine
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=4074558
cftoken=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
hitcount=3
lastvisit={ts '2026-05-31 21:21:53'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-05-31 21:21:53'}
urltoken=CFID=4074558&CFTOKEN=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
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#message=Full access to <i>The BookBrowse Review</i> is for members only.<br>
					<a href#="https://www.bookbrowse.com/join"><b>Become a member</b></a> | <a href#="https://www.bookbrowse.com/login?next_url#=/mag"><b>Member login</b></a> | <a href#="https://www.bookbrowse.com/library"><b>Library patron login</b></a>#
CFGLOBALS=urltoken=CFID#=4074558&CFTOKEN#=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981#lastvisit={ts '2026-05-31 21:21:53'}#hitcount=2#timecreated={ts '2026-05-31 21:21:53'}#cftoken=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981#cfid=4074558#
CFID=4074558
CFTOKEN=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
Session Variables:
cfid=4074558
cftoken=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
sessionid=BOOKBROWSE_4074558_f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
urltoken=CFID=4074558&CFTOKEN=f2a9fc8989943c2f-FF25B546-9E5F-45E6-027B54DE9D600981
URL Parameters:
author_number=1551
rabih-alameddine=
Debug Rendering Time: 17 ms