Siobhan Fallon Interview, plus links to author biography, book summaries, excerpts and reviews

Siobhan Fallon
Photo: Larry Nordwick

Siobhan Fallon

How to pronounce Siobhan Fallon: Sh-vawn

An interview with Siobhan Fallon

Two interviews with Siobhan Fallon, discussing The Confusion of Languages, and her first book, You Know When The Men Are Gone

The Confusion of Languages is your debut novel. How was writing this story different than writing your story collection You Know When The Men Are Gone?

The Confusion of Languages' genesis was a short story I began writing in May 2011. By the time I finished, it was sixty pages—that's not really a "short" story at all. Then it grew into a collection of interconnected stories that spanned about two years, from before Margaret and Crick even met. This collection moved from California to Oman to Jordan. I have early drafts where each story/chapter is told from the point of view of a different character; for example, Crick would have his say, then it would go to Margaret, then it would go to Dan, then Cassie, onward to other characters who aren't even in the novel anymore.

But I soon realized that the short story–collection model of jumping from character to character wasn't giving me enough space to delve deeply enough into the intimate thoughts of Margaret and Cassie, and it was their intertwined story that fascinated me the most. So I'd say The Confusion of Languages is an evolution of short stories into a novel. Ironically, the actual novel you have in your hands right now is quite close to the first sixty-page short story version. I wish I had figured that out in 2012 and saved myself a couple of years' work.

What inspired you to write this novel?

It's impossible to narrow it down to one thing. I think of writing as a huge, messy path that you slowly and blindly navigate. Something—some hunger or a streak of irrational stubbornness—drives you to the end of that road no matter what. You trip, you kick rocks out of your way, you climb a tree or two in hopes of seeing how much longer you have to go, you get lost, you turn back, then turn around again, you just doggedly keep going until you reach a destination you can live with and that you hope readers will enjoy.

There were a few ideas I wanted to explore while I was flailing all over the place. Expats abroad are always recounting the crazy things that happen in the country they are currently residing in. Cocktail parties are full of these anecdotes, like how an Italian man put his hand on a covered female police officer's arm in a mall in Dubai when asking for directions and was deported for it. Or a how an American woman in Abu Dhabi couldn't get a cell phone without the permission of her husband (that actually happened to me). And it's all very funny to listen, too. It's easy to think our Western ways are always the right way and to be indignant at the local response. I wanted to write about a well-intentioned American woman caught in a misunderstanding that spirals out of control, to show how these events, however accidental and amusing they might seem, can involve severe repercussions.

I'm also always aware of my characters being human and flawed, and I like to tease out ways good and decent people manage to do rotten things that hurt the people they care about. And the character who tries to be the most decent, Margaret, in trying to do what she thinks is right, nearly destroys a man. Sometimes a small, unthinking action has the power to haunt more than any deliberate cruelty.

Why did you choose to set this story in Amman, Jordan? Did you ever consider setting it elsewhere?

I lived in Jordan with my family in 2011. Like Margaret, my family and I arrived just as the Arab Spring was taking hold across the Middle East. There was so much going on, so much uncertainty and tension, but also so much hope. The whole world seemed to be watching Egypt's Tahrir Square and cheering on a people who were trying to shape their own destiny. And in 2011, America had been finally winning the war in Iraq; the surge of US soldiers had established a certain level of peace, or at least gotten to a stable enough place for a tentative handover. There was, of course, a genuine desire to see the people of the Middle East reclaim power from dictators, but I also think Americans, from politicians to the taxpayer watching late-night news, desperately wanted to believe our military presence had had a positive effect, that toppling Saddam helped pave the way to the end of Mubarak in Egypt, Qadaffi in Libya, and Ali Abdullah Saleh in Yemen, and that protests across the Middle East would lead to political reform and freedoms for all.

But then the United States pulled out of Iraq, in a much more sudden way than many in the US military thought we should. Now we see ISIS has risen from the ash of America's departure, and so much has been squandered, so many American soldiers and countless Iraqi civilians have died in vain, not to mention the continued slaughter of innocents in Syria. We see that Egypt has swung back into the control of a military government, Libya is still in the midst of a civil war, and Yemen is a completely failed state.

Jordan, thank goodness, has a much beloved and fairly progressive monarch, King Abdullah, and continues to be stable, but the refugee numbers there from neighboring countries (Syria, Iraq, and Palestine, among others) are critical.

So I wanted that specific and precarious perspective of Jordan, how it is perched between Iraq and Syria. Jordan managed to offer both a front row seat to the Arab Spring unfurling around it, yet was also safe enough that American families continued to live there throughout, rather than being evacuated the way the embassy communities were in Egypt and Tunisia. I also appreciated how Jordan offers a balance of East and West. Cassie can remain cloistered in Abdoun, the ritzy area where all of the embassies are located and the wealthy Jordanians live. You could find coffee shops, a French bakery, and a few nice restaurants in the vicinity when I lived there in 2011. But if you drive across the highway to downtown Amman, or an hour farther toward the smaller towns, you'll find something very, very different: Beduoin encampments with camels grazing outside, children selling eggs on the side of the road, and makeshift shwarma stands, the "authentic" Middle East that would appeal to a person like Margaret.

All of the above creates the illusion that I made many clear and rational decisions when writing this novel. But to be honest, much like the idea of "inspiration," I can't quite describe what makes me write about one location rather than another, why one story line goes electric in my brain and demands I spend years concentrating on it when countless others have been mused over for a few minutes and discarded. People are always giving me ideas or plot suggestions and saying "You should write about this," or "This story would make you a million bucks," and heck, I want a million bucks!

But to sit down day after day for years and write about a handful of characters, their traits and mistakes, their homes and back stories and the moments that break them, well, you just love them, and you love your setting, and you love your story no matter how unwieldy it might be. And love is impossible to define or plan or schedule. It grabs you and doesn't let go until it is done with you. Jordan was exhilarating, all the unknowns, the sweeping history, the contradictions, I couldn't help but love the country, and though I left it years ago, writing about it let me live there a little while longer, and know it a little better.

Cassie and Margaret are both so real on the page. How did you come up with each of their characters? Are you more like one than the other?

As I mentioned above, this novel has gone through many, many rewrites and transformations. A character who I had to almost completely excise, Karen, (the woman in the photo Margaret finds) was, at one point, the third weightiest voice in the novel. Her role was as large as Cassie and Margaret; the novel opened with her meeting Crick at a Monterey party, she came out to Jordan to visit him, and she originally is the one who goes to the Turkish baths with Margaret. At that stage of writing, Karen was the character most like me. But the book was getting unmanageable and everyone was telling me that Karen wasn't unique enough, her voice was either too similar to Cassie's, or too similar to Margaret's.

When I kicked Karen to the curb, I had to really think long and hard about the two remaining female characters, and the details and mannerisms that would define them. And though not all of it was conscious, Margaret was born out of the more naïve and overly optimistic side of me. She embodies all the well-meaning but stupid things I have managed to do in my life. And Cassie took on the other side, the sarcastic and cynical Siobhan, older and maybe wiser but less able to appreciate the small and lovely things life has to offer. Which was sort of terrifying and enormously fun at the same time, being able to skewer myself on the page, or at least different facets, and letting these alter egos play against each other. It was also terrifying to realize how schizophrenic I might be.

You're known for writing about military families. What draws you to these stories? What influence, if any, does your own connection to the military have on your writing?

I'm part of a military family. My husband has been an officer in the US Army since I met him in 2000. When we got married, I realized how little the rest of us understood military life. Which was part of my motivation for writing my collection of stories, You Know When The Men Are Gone. I naturally draw from my own experiences, and I like exploring themes that seem to touch all of us (how families work, as well as how families fall apart) but I also like to examine communities that mainstream America is less familiar with, such as our military communities at home, or our embassy communities abroad.

Margaret and Cassie both have very different assumptions about what is acceptable behavior for Western women in the Middle East and at the US embassy. How realistic are Cassie's rules? Do you have any advice for American women traveling to or living in the Middle East?

I do tend to think more like Cassie when it comes to the image I want to present here as both an American and a woman. On the one hand, I want to be seen as respecting the culture I live in, but I'm also motivated to dress conservatively in order to not draw undue attention to myself. When I lived in Jordan I tried to cover from ankle to wrist, unless I was in a tourist area, or attending a predominantly Western event, or out with my husband. So I'd wear linen pants and a light cardigan over a T-shirt in the summer if I was headed out to shop, etc. Here in Abu Dhabi, there are more expats and Emirati culture is more accepting of international styles (it's also much hotter here in the Gulf) so I'll occasionally wear short-sleeve shirts and summer dresses. But I try to cover my shoulders and arms if I can and oftentimes there are signs outside of the malls or public parks that spell out the dress code and proper behavior, such as NO TANK TOPS or NO PUBLIC DISPLAYS OF AFFECTION.

To be completely honest, as an American woman raising two young daughters, both of whom have spent a majority of their lives living in the Middle East, I can't help but be bothered by some of the social expectations put on women and how their adherence to the idea of modesty seems to be different than that of men. According to what I've read of Islam, men and women are supposed to uphold similar modes of dress: it is recommended that men also wear loose clothing that covers much of their bodies. So I can't help but bristle when I see a man in a T-shirt and pair of shorts, or with no shirt at all and a bathing suit at the beach, accompanying a woman who is covered head to toe, in long robes and veil, perhaps with a niqab over her face. And I have had my own awkward moments, when I unthinkingly tried to shake a man's hand, or smiled at a man in an elevator, and been quickly made aware that some of the social niceties we take for granted in the West made these particular Middle Eastern men very uncomfortable.

But ultimately, I'm the foreigner here. As a guest, it's my responsibility to abide by the local customs just as I would want visitors to the United States to respect our way of life. Jordan welcomed me and my family, it was a place I called home for a very exciting year, and I ought to honor its traditions and culture.

What kind of research did you do to write The Confusion of Languages?

I always keep a little notebook in my purse and try to jot down the odd thing I see, wherever I might be. Many of the specific images of Jordan in the novel, from the young man in the back of a pickup truck wearing a Jordanian flag as a cape, to the little Bedouin girl in Petra with a Yankees baseball cap over her veil, to the way the sink in the bathroom in my apartment seemed to breathe in and out when you ran the water, to hearing David Gray's "Babylon" play over and over again in a grocery store, to the travel agency sign that read TITANIC: TRAVEL AND TOURISM, and more than I could possibly list here, were lifted directly from that notebook I kept while living in Jordan.

Otherwise I relied on the guidebooks I used (Lonely Planet's Jordan), as well as books I bought in Amman (Dr. Muhammad Ali Akhuli's Women in Islam), and perused the newspaper articles I'd clipped and saved from our time there. I also took an enormous amount of photos to make sure images stayed singed in my mind.

There are two incredible works of nonfiction that informed my writing and that I highly recommend for readers who are curious about the role of women in Islam and the Middle East: Mona Eltahawy's Headscarves and Hymens: Why the Middle East Needs a Sexual Revolution and Geraldine Brooks's Nine Parts of Desire: The Hidden World of Islamic Women.

And of course I am still a part of an embassy community here in Abu Dhabi. So I have all sorts of knowledgeable friends working in different branches of the embassy who kindly let me grill them about what might really happen during the situations I portray in the novel.

Without giving anything away, did you always know how the story would end? Or did the ending change as you wrote each character? The ending came to me at the very beginning, way back in 2011 when I thought I was writing a short story. The ending, for the thousands upon thousands of pages I have written about these lives, has always, always been the same.

What's next for you?

It's exciting not to know. But I'm mulling over some ideas. Ever since I first moved to Amman, I have been curious about the lives of the domestic helpers who play such a large role in every household here. In both Jordan and the United Arab Emirates, and seemingly across the entire Middle East, it's expected that each house has at least one domestic helper (housekeeper or nanny). In America, this is rather rare, but here, it's rare if you don't. There's a vibrant Filipina community in Abu Dhabi, but so much of their work lives are invisible, and even more so invisible is our understanding of the children and families they are supporting with their salaries back in the Philippines. Unfortunately, when you hear or read news about a domestic helper, it is often of neglect and abuse. And expats are not blameless. I'm not sure how this will filter into my writing, but it's something that has been simmering in the back of my mind for a long time.


A Conversation with Siobhan Fallon about her first book, You Know When The Men Are Gone

What led you to write this book?

There is an entire canon of incredible war literature out there but much of it deals with the battlefield rather than the home front. As a military spouse, I know every soldier has a family waiting at home, mothers and children, cousins and friends, all of them worrying, grieving, and hoping their soldier will return to them. Those stories are fascinating to me, all those moments that lead up to a deployment as well as the moments that follow a homecoming, and I wanted to show readers that very specific and somewhat neglected world.

You tell the stories of many different characters, both women and men, mostly at Fort Hood but also in Iraq.  How closely are the characters based on real people?  How much of your own experience is in this book?

I was inspired by issues that I've seen come up again and again when soldiers deploy, but ultimately this is a work of fiction.

Yes, there are echoes of my own experience - since our marriage in 2004, my husband and I have lived in four different states, and are getting ready to move yet again. Also, since 2004, my husband has deployed three times, once to Afghanistan, and twice to Iraq. Which means that when I finished writing this collection in 2010, my husband had spent half of our marriage, three of our six years together, being deployed. When he left for his most recent deployment in 2008, our six month old daughter hadn't even begun to crawl, and when he returned a year later, she was walking, talking, and picking out her own tutus. I think my army spouse experiences, the constant moving around from base to base, the long separations, the children who grow and change while a parent is away, the stress of trying to maintain a healthy marriage when a spouse is in a war zone, might seem strange to the civilian world but are universal challenges faced by all in the military community.

Fort Hood, where your stories are mainly set, is the largest military base in the United States.  Where is it located?  What is the size and scale of it?

Fort Hood was created in 1942, on 340 square miles in central Texas, about 60 miles north of Austin. It is the largest active duty armored post in the United States Armed Services. Right now there are over 40,000 soldiers who work on Fort Hood as infantrymen, cavalrymen, tankers, engineers, mechanics and health care professionals. It is also the home of a division with a long and proud history, the First Calvary, which includes Custer's 7th Cavalry Unit.  So, there are a few traditions you would only find at Fort Hood, such as the First Calvary Horse Calvary Unit, which is the last horse mounted cavalry unit in America, or the way the First Cavalry "dress blue" uniforms include Custer-era hats and spurs. Like other bases, Hood also has its museums with retired tanks and helicopters out front, war memorials, distinctly military named streets like Battalion Avenue, Hell-On-Wheels, Tank Destroyer, or Warrior Way Commissary.

I have lived near quite a few bases, but Fort Hood, to me, is the most all encompassing. Even twenty miles outside of the Fort Hood main gates, in the outlying towns, you see soldiers in their camouflage uniforms grocery shopping or eating at restaurants or mowing their lawns. You see pick-up trucks or Prius with bumper stickers that say, "My other ride is a tank" or "Half of my Heart is in Iraq." In Fort Hood, you never forget that you are living in a military world.

It was a bit of culture shock when my family and I moved here to Monterey and started meeting neighbors who have no association with the military whatsoever. I was so used to having deployment topics as fodder for small talk and suddenly I was in a place where that was no longer a shared experience.

What are some of the physical signs that the men are gone from the base?

One of the most shocking things, especially in a base like Fort Hood, is how empty everything is when a brigade or division deploys. Suddenly there are parking spots available in the front of Wal-Mart, no more lines in the Burger King drive-thru, and tables open on a Friday night at Texas Roadhouse. I think it is a struggle for the local business community to handle the dearth of customers. Suddenly twenty thousand soldiers, who each day needed to eat lunch, buy gas, get a patch sewn unto their uniforms, are gone for an entire year. And that's not including all the families that might move to their home towns when their soldiers deploy. This exodus can be devastating to the mom and pop businesses around a base.

One the more positive ways you know that a brigade is deployed are the billboards that you see everywhere, the "We Support of Troops" or "Come Home Safe" signs in the windows, the flags and the yellow ribbons and military discounts. Local businesses from pizza joints to retirement homes might adopt an army company or battalion and send them care packages or phone cards. I always found that incredibly comforting, how the entire community around Fort Hood seemed aware of the soldiers at war, and did their best to show their support.

What is the Family Readiness Group, and what role did you play in it?

During my husband's most recent deployment to Iraq, I volunteered as a Family Readiness Group leader. The Family Readiness Group is a support network composed of families attached to an army company, a unit of around 160 soldiers. My husband was the company commander who dealt with the soldiers, and, almost by default, I tried to deal with all the questions and issues of the spouses. Officially, my role was to act as an information consultant, telling spouses about services the army offered them, trying to co-ordinate assistance, and giving them authorized news about their soldiers when the soldiers were training or deployed. We also had monthly meetings, holiday parties, made posters and sent packages.  But the most time consuming part of my role, and also the most rewarding, was when I was fielding phone calls, from giving directions to the Tri-care office, to trying to get food pantry supplies to wives who didn't have enough money for Thanksgiving dinner, to finding the phone number for a marriage counselor or chaplain for a spouse afraid that her soldier was cheating. It gave me a tremendous amount of empathy and insight into the lives of soldiers and their families.

Some of the relationships in your book don't survive the separation of war because of adultery, both at home and overseas.  How prevalent is it?

I don't know if adultery actually occurs more often in the military than in the civilian world. But I think the present situation of every-other-year-deployments puts a lot of strain on even the best of marriages. We all know that relationships are hard work, but military spouses have the added stress of being separated for long periods of time, with the husband and wife living in worlds completely at odds with one another: America vs. a third world war zone. A lot can happen in a year apart, especially when communication is difficult at best. And when adultery does happen, well, the army is a fairly small community, a soldier doesn't have much individual privacy, and life on a base can feel a bit like living in a fishbowl, so sometimes word gets out.

On the other hand, some relationships are strengthened by the trial of separation.  Both wives and husbands are able to forgive adultery and other hurts and move on.  Is there anything you've observed that tips things one way or the other?

One of my husband's commanding officers used to say, "Deployments make strong marriages stronger." I think the inverse is also true. Upheaval is intrinsic to military life with the constant moves and readjustments. A deployment naturally amplifies preexisting trouble in a relationship.

How do children, and particularly the children in your stories, react to separation from their soldier parents?

My own daughter was very young during my husband's most recent deployment and she couldn't articulate her feelings when he returned. While he was gone I tried to play a lot of video I had of him so she would be familiar with his voice, and I think that that helped.  And nowadays a lot of people can Skype with their deployed soldiers, even at some of the smaller and far-flung operating bases. There are also amazing tools available to military families, everything from free Sesame Street DVDs about how to help kids handle deployments, to the USO recording soldiers at their forward operating bases reading a book aloud, and then sending both the DVD and the book to the families at home. 

Despite these efforts, I think kids might have the most difficult time; they can't understand why a parent has left them. Kids are incredibly resilient creatures, but no matter how hard the Army or the remaining parent tries to mitigate the effects, the deployed parent is still missing an entire year in a child's life, the birthdays and Christmases, the trips to emergency rooms and school plays. You add up multiple deployments and, well, I think it's a tragedy.

How did you meet your husband?  Did you ever think you'd marry a soldier?

I met my husband at my father's Irish pub. My dad had been in the Army during the Vietnam War and I had been raised right outside of the United States Military Academy of West Point, but I never really dated soldiers or West Point cadets. Their lives seemed so different, so regimented and alien somehow. When my husband and I met, we exchanged email addresses, and then proceeded to write to each other for a few months before our first date. He's a handsome, hunky, funny guy, but his writing and love of literature won me over. After we had dated for a few months, well, the regimented lifestyle of the army didn't scare me anymore; I had never met anyone like him and I would have followed him anywhere.

How did you handle being separated from him during his two tours of duty in Iraq and one in Afghanistan?

I kept busy. I didn't watch the news. I cried a ridiculous amount at weddings. I sent care packages. I adopted too many stray cats. I wrote and wrote and wrote.

There was an incident that occurred while your husband was in Iraq, when you knocked a valve off your sprinkler system.  What happened?  And why was that such a significant incident for you?

During my husband's last deployment, I knocked a valve off my sprinkler system while gardening, causing a fire-hydrant-like geyser I couldn't stop. It was a Sunday afternoon. I called the company who installed my sprinkler. I called the contractor who built my house. I called the water department. Standing in my front yard, dripping wet and covered with mud, no one answered my call. Almost all of my neighbors' husbands had deployed but I remembered there was one house that still had a man inside it, a pilot whose name I later learned was Tim.

Tim answered his door. He followed me down the street, bringing his wrench. He got the valve back on that gushing pipe. A few days later, my neighbors and I were outside, our children playing, and I told them about my soggy lawn. It seemed like each of us had knocked on Tim's door and he had left his family at the dinner table, come into our homes, tried to fix our problems, his only qualification being that he was a man. He never said no. He acted as if it was his duty to care for us while our husbands were away, perhaps hoping we'd watch over his family when it was his turn to go.

When you are a living in a military community, especially when your spouse is deployed, you want to believe that when you need help, someone will be there for you, that there is a shared sense of family. That day with the sprinkler fiasco means so much to me because it proved that this was true, that in a crisis I really could depend on my neighbors.

You describe a sense of self-containment and isolation from the rest of the world at Fort Hood that is typical of most military bases.  Do you think that sense of isolation may have contributed in any way to the incident at Fort Hood that has been so much in the news recently - the mass shooting in November 2009, in which 13 people were killed and another 30 were wounded, allegedly by a U.S. Army Major serving as a psychiatrist?

The consolidation of the larger bases and the closure of the smaller bases, I think, have exacerbated the isolation from larger society that members of the military might feel. With a few scattered super-bases, like Fort Hood or Fort Bragg, rather than small bases all across America, civilians miss out on the daily interactions with the military and vice versa. There becomes this idea of "us" and "them" rather than everyone being in this together. This makes it easier for civilians to see a stereotypical soldier with a gun and a stoic face on the news, rather than a neighborhood dad or mom who coaches soccer and attends town council meetings.

Personally, I don't think this had anything to do with Major Hasan's massacre.  Moreover, he had never deployed so the myriad issues of Post-Traumatic Stress Syndrome also do not apply to him. He was an unstable man with extremist tendencies. While I wish the FBI, the US Army, and Major Hasan's chain of command had identified the warning signs and had acted to prevent his crime, I don't think the Army or Fort Hood contributed to his murdering of thirteen people on November 5, 2009.

Did you personally know anyone who was killed or wounded in that shooting, or members of their families?

No. My family and I moved from Fort Hood to Monterey, California, in late July, 2009.  I was shopping at the commissary at Fort Ord, in Monterey, when the Fort Hood shooting happened. And suddenly my cell phone started ringing non-stop. Spouses who were acquaintances, even the parents of some young soldiers who had been in my husband's company, thought that I was still at Hood and wanted to know if their soldiers were OK. It brought me back to the kind of calls I had gotten when my husband was deployed. Whenever there was an explosion or reported casualty in the vicinity of our soldiers' forward operating base in Iraq, spouses would get, understandably, very anxious until they heard from their soldier. But you never imagine that you would need to fear for your soldier while he was still on American soil, in the safety of his own base, surrounded by fellow American soldiers. That was a horrible, horrible day for the military, to feel like our certain refuge, a very secure army base, could be the site of such terrorism and betrayal.

Do you have a sense of how life has changed on the base since then?

Actually there are very few people at Fort Hood that I know right now. That is one of the strange things about military life, the cyclical nature of our moves. When my husband's battalion returned home to Hood in 2009, most of my friends and their families were packed up and shipped off to different bases across the country, and an entire new wave of people moved in.

There's a sign on the way out of Fort Hood that is says, "You Survived the War, Now Survive the Highways."  What are some of the challenges that face soldiers and their families upon their return, and how are they shown in your stories?

The Army is really striving to help returning soldiers transition back into their lives at home. But it is an enormous task. On the one hand you have the spouse, let's just say wife, and the person she depends on the most is suddenly gone. So she learns how to handle the household for a year. She disciplines the children, pays the bills, gets the oil changed, and mows the grass. She has figured out how to manage on her own, this resiliency feels like an accomplishment, and she thinks her soldier will be proud of her. Then her soldier returns home and it is, of course, amazing for the first couple of weeks. But then he starts paying the bills and doesn't like how she's balanced the check book, or thinks she's been too soft on the kids, or wants to watch 24 instead of Army Wives. There is bound to be conflict. He has returned to the place he has been dreaming about, and suddenly feels like he no longer belongs, that his family doesn't need him. The kids have changed, they have new routines, and perhaps they can't help but resent him. And meanwhile the soldier is dealing with his own problems, the completely different life he himself has led, being surrounded by soldiers twenty-four hours a day, where he had a very specific role to play, maybe he yelled a lot to get things done, maybe he cursed like a sailor, maybe he never had to wash his hands before he ate, not to mention maybe he was constantly in danger, maybe he was wounded, maybe he saw things no one should ever have to see. And this man and woman, who have been apart for a year, leading utterly separate lives, are sleeping next to each other, sharing a bank account and the family car, helping the kiddos with homework. They have to learn to depend on each other again, knowing that in another year, they will probably go through the same cycle of separation. So ostensibly everything should be just great, the soldier is home and whole and safe, and yet there are new issues that must be dealt with, things that seem so small and unworthy after handling suicide car bombers and kidnappings, and yet these things make up daily life.

How often are soldiers on active duty moved from one base to another?  This must make it very difficult to put down even temporary roots.

Ideally you spend about three years at a base. But, depending on other assignments or mandatory professional development courses, it is often less. So yes, it is difficult to put down roots, for the spouses to find jobs outside of the homes, to make friends or find a church or a dentist that they like before they have to pick up and move all over again. But there are also benefits. All the other families have gone through the same thing and are willing to help each other out. And I am not exaggerating when I say that a military base is its own little world - they all have their own daycares, libraries, grocery stores, post offices, shops, schools, hospitals, barber shops. So I can show my military ID and drive through the main gates of Schofield Barracks, Hawaii, or Fort Benning, Georgia, and, no matter where I am, I know I can pretty much find whatever I need. That's comforting. That makes you feel like you are home.

Your husband is a West Point graduate and an Army major.  As an officer's wife, did you feel an extra level of responsibility to the other wives?  Is there any kind of class separation between officers' wives and the enlisted men's wives?

I feel more and more responsibility the longer we stay in the army, not because of my husband's rank but because my experience is something I want to share with younger wives. It can be intimidating when you first become a military spouse or just wash up on the shores of a new post, there are so many things to do: military IDs and security decals for your cars, signing up for the healthcare, attending social events or training classes.

Occasionally, you might come across a spouse who tries to 'wear her soldier's rank' but I don't think it is any different than in the civilian world, where spouses may expect certain deference because of their partner's employment or position. The Army strongly discourages this sort of behavior, and I don't think it happens very often these days.

Your daughter turned three in October 2010.  Was it a difficult decision to have a child while your husband was on active duty in a war zone?  One of your characters regrets not having a child after her husband is killed.  Did you and your husband have similar fears?

I think everyone has those fears and has that conversation with their spouse before a deployment. There is a running joke about among military spouses. We seem to all have "R&R babies" (babies conceived during the two week mid-tour leave during a deployment) or "Deployment babies" (babies conceived almost immediately after a husband has returned from a deployment). You can go to a company or battalion picnic and figure out who has had similar deployment schedules according to the age of their children. Quite a lot of my friends at Fort Hood had children around my daughter's age, which made for great play dates when our husbands all deployed again.

Why do you think so little attention has been paid in fiction to the experiences of the families of our service members during our current wars?

I think that our access to the war in Afghanistan and Iraq has been so immediate, with embedded journalists, blogging soldiers, and a 24 hour news cycle, that there hasn't been the pressing need for fictionalized accounts. And, though almost a decade of America at war in the Middle East is a horribly long time, ten years in terms of fiction is not. There are about ten years between Jonathan Franzen's The Corrections and his latest novel, Freedom. Lorrie Moore's A Gate at the Stairs deals with September 11th and it didn't come out until September 2009. Fiction, especially good fiction, can take a long time. So perhaps there are many more novels and story collections about the experience of military families out there percolating. And perhaps, as soldiers continue to come home, think and talk about their experiences, they and their families will start writing them down in a fictionalized way.

Your book is not political.  But do you think the rest of the country is doing enough to support emotionally and psychologically the families of service members, and the service members themselves?

I think that the Army does its best to create support systems for soldiers and their families, with everything from the Family Readiness Groups to the counselors at Military Life Consultants. At Fort Hood, the military daycare gives the families of deployed soldiers sixteen free hours of daycare a month per child. That's amazing! That's enough time for a doctor's appointment, a hair cut, a couple of grocery store visits, maybe a chick flick matinee. That is a real attempt to alleviate the stress in a spouse's day-to-day life. If I didn't have those sixteen hours, if I wasn't told that not only was it OK to put my daughter in daycare but it was FREE, I would not have been able to write this book.

In regards to the rest of the country, even now, almost ten years into the war, whenever my husband is out in his uniform, he is inevitably thanked for his service. During his deployments, he has received care packages and cards from country clubs, elementary schools, retirement homes, churches, and book clubs. He has helped clothe Afghani orphans and stock a university library in Iraq just from the donations of concerned and generous Americans. That being said, our all-volunteer military represents a small minority of the population of the United States, and they are carrying a very heavy burden, deploying again and again, facing hardship and possible death for long periods of time. So no matter how proud these soldiers are of our country, no matter how much they love their jobs, I think there is only so much they can continue to give, or how much their families will allow them to.

You're currently living in Monterey, California, while your husband attends the Defense Language Institute.  Your family is scheduled to be stationed in the Middle East in the spring of 2011.  What are your feelings about that?  Are you excited? Nervous?

I am incredibly excited about moving to the Middle East. I want a glimpse of the culture we have all been hearing so much about for the past ten years. My family and I will be living in Amman, Jordan, and from what I've read, Jordan is very welcoming of Westerners. King Abdullah, the king of Jordan, was just on The Daily Show with Jon Stewart a few weeks ago, which I think demonstrates that he is quite open-minded. So going to Jordan feels like an adventure. And my husband and I have spent so much time apart, I am really grateful that my daughter and I will able to accompany him.

Now I just have to learn Arabic...



Why did you become a writer?  Was it a lifelong goal?

I've always loved to write. And my family has always been incredibly supportive of my writing. My father is from Leitrim, Ireland. Yeats' grave is near the town where he grew up and, for as long as I can remember, my dad has been giving me things that relate to famous Irish authors: bookmarks with Oscar Wilde quotes, postcards of Brendan Beehan, James Joyce novels he picked up at an odd library sale. My dad also owns an Irish pub, The South Gate Tavern, in my hometown of Highland Falls, New York, and my brother, sister and I have all spent long shifts working there. So there were always plenty of stories in my house, lots of sitting over hot pots of tea talking about the people who came in and out of the bar. I think bartending trained me to observe, listen, and take note of all the different characters.

What writer or writers have had the greatest influence on you?

When I was working on You Know When the Men Are Gone, I read Benjamin Percy's Refresh, Refresh and was completely mesmerized. Percy's title story is about these scrappy teenagers trying desperately to become men. Their dads are deployed and their absence hangs over the action, it creates the momentum, but the reader learns very little about the actual soldiers, instead an echo of the war reverberates in every daily action of the fatherless boys. And in Percy's latest book, The Wilding, he has a character who is a wounded veteran. I admire how Afghanistan and Iraq inform Percy's fiction; he doesn't let the reader forget what is going on in the world and how soldiers are affected. He keeps the dialogue alive. Likewise, in my stories, I'm not as focused on the bombs on an Iraqi street as I am on the small, rippling tragedies that occur in American homes.

Are you working on a new book yet?  Can you tell us anything about it?

I am working on a novel. It's the story of Evie Parker, a young, up-and-coming chef whose husband deploys to Afghanistan shortly after their marriage, leaving her in Oahu, Hawaii. She's a feisty, clever, unreliable narrator who faces many of the issues that my characters in You Know When the Men Are Gone deal with. Evie is almost neurotically aware of right and wrong, but she is really good at making terrible decisions. She works in the competitive world of fine dining and it is easier for her to lose herself in her culinary creations, and perhaps in the company of another angry young chef, than to be the good wife and pine for her deployed husband. And then her husband returns.

What advice would you give to aspiring writers?

Don't give up. Try to say things in a way only you can say them, and then just keep at it until someone notices. And eventually someone will notice. It's been more than ten years since I got my MFA, and there were plenty of times I started to lose faith in my writing. But right now I know all those years of rejection, of writing in my own little praiseless vacuum, were worth it to have ended up with my wonderful literary agent, Lorin Reese, and my extraordinary editor, Amy Einhorn.

What do you hope readers will take away from You Know When the Men Are Gone?

I hope they come away with a new understanding of military families. Military life, especially since 9/11, is so different than civilian life and I wanted to capture the reality of this small portion of society that deals daily with war, the pride and fear and loss that is never far from an Army's family's thoughts. Even the ordinary things that happen, kids doing poorly in school, husbands and wives fighting over bills, seem to take on a different meaning because everything in their lives is heightened by the stress and threat of deployments.

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 Siobhan Fallon at BookBrowse
The Confusion of Languages jacket You Know When the Men Are Gone 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 Siobhan Fallon 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

We recommend 9 similar authors

View all 9 Read-Alikes

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

BookBrowse Book Club

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

Members Recommend

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

The low brow and the high brow

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 06:29 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
1780295340035 ms 1.78029534004E+012 ms 1 /root/website/app_server.cfm
705 ms 705 ms 1 /root/website/author_interviews/full/index.cfm
297 ms 297 ms 1 /root/website/author_interviews/full/dsp_main.cfm
183 ms 183 ms 1 /root/website/app_layout.cfm
169 ms 85 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
144 ms 144 ms 1 /root/website/app_globals.cfm
122 ms 41 ms 3 /root/website/adsystem/adsystem_mod.cfm
107 ms 107 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
44 ms 44 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
44 ms 44 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
42 ms 42 ms 1 /root/website/adzones/AdZone6.cfm
42 ms 42 ms 1 /root/website/adzones/showcase_track.cfm
40 ms 40 ms 1 /root/website/actions/adstatus.cfm
38 ms 38 ms 1 /root/website/adzones/AdZone2.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_active_obc.cfm
31 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
29 ms 10 ms 3 /root/website/queries/qry_get_member_account_types.cfm
29 ms 29 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
25 ms 25 ms 1 /root/website/queries/qry_get_current_competition.cfm
21 ms 21 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
18 ms 18 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
13 ms 3 ms 4 /root/website/actions/act_spider_tracker.cfm
11 ms 11 ms 1 /root/website/act_check_login.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_member_info.cfm
7 ms 7 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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/dsp_wordplay.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/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/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
707 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

get_member_info (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 06:29:00.000
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=39ms, Records=2) in /root/website/actions/adstatus.cfm @ 06:29:00.000
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 @ 06:29:00.000
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=12ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 06:29:00.000
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=17ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 06:29:00.000
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=6ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 06:29:00.000
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 @ 06:29:00.000
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 @ 06:29:00.000
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=5ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 06:29:00.000
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=13ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 06:29:00.000
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=12ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 06:29:00.000
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) = 1982

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 06:29:00.000
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) = 1982

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=2) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 06:29:00.000
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) = 1982
Parameter #2(CF_SQL_INTEGER) = 1982

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

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=6ms, Records=9) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 06:29:00.000
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) = 1982

get_ads (Datasource=bookbrowse_com_new, Time=22ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:29:00.000
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=11ms, Records=1) in /root/website/actions/udfs.cfm @ 06:29:00.000
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) = 3608

get_book_image (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/actions/udfs.cfm @ 06:29:00.000
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) = 2519

get_member_account_types (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:29:00.000
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=50ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:29:00.000
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) = 1149
Parameter #2(CF_SQL_INTEGER) = 1149
Parameter #3(CF_SQL_INTEGER) = 1149

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:29:00.000
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) = 1149

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=39ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:29:00.000
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) = 2815
Parameter #2(CF_SQL_INTEGER) = 2815
Parameter #3(CF_SQL_INTEGER) = 2815

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=60ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:29:00.000
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) = 2815

get_member_account_types (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:29:00.000
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=12ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 06:29:00.000
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=25ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 06:29:00.000
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=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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 @ 06:29:00.000
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=15ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=17ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 06:29:00.000
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 @ 06:29:00.000
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=16ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:29:00.000
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=CFTOKEN=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C; CFID=4090358; CFGLOBALS=urltoken%3DCFID%23%3D4090358%26CFTOKEN%23%3D119be3063a26b25a%2D12B64471%2DEBD5%2DFB76%2D1AF8760D2D32C04C%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2006%3A28%3A59%27%7D%23hitcount%3D9%23timecreated%3D%7Bts%20%272026%2D06%2D01%2006%3A28%3A57%27%7D%23cftoken%3De0c4b3e9dc9f0f41%2D12B63FEA%2DFB2D%2DDBBA%2DA151284E28E9BDF9%23cfid%3D4090357%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/1982/siobhan-fallon
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=4090357
cftoken=e0c4b3e9dc9f0f41-12B63FEA-FB2D-DBBA-A151284E28E9BDF9
hitcount=13
lastvisit={ts '2026-06-01 06:29:00'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 06:28:57'}
urltoken=CFID=4090358&CFTOKEN=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C
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#=4090358&CFTOKEN#=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C#lastvisit={ts '2026-06-01 06:28:59'}#hitcount=9#timecreated={ts '2026-06-01 06:28:57'}#cftoken=e0c4b3e9dc9f0f41-12B63FEA-FB2D-DBBA-A151284E28E9BDF9#cfid=4090357#
CFID=4090358
CFTOKEN=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C
Session Variables:
cfid=4090358
cftoken=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C
sessionid=BOOKBROWSE_4090358_119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C
urltoken=CFID=4090358&CFTOKEN=119be3063a26b25a-12B64471-EBD5-FB76-1AF8760D2D32C04C
URL Parameters:
author_number=1982
siobhan-fallon=
Debug Rendering Time: 20 ms