Min Jin Lee Interview, plus links to author biography, book summaries, excerpts and reviews

Min Jin Lee
Photo: Elena Seibert

Min Jin Lee

An interview with Min Jin Lee

Min Jin Lee discussed Pachinko, her epic family saga of a Korean-Japanese family

What initially inspired you to write this novel? Why did you choose to focus on Korea and Japan during a time of war?
I learned about the Korean-Japanese people nearly thirty years ago when I was in college. I didn't know anything about this community, which had its origins during the Japanese colonial occupation of Korea from 1910 to1945. As a history major and as an immigrant, I was curious about the Korean diaspora, resulting from the invasions and destabilization of the once-unified nation. However, what really moved me to write this novel and to rewrite it so many times were the compelling stories of individuals who struggled to face historical catastrophes. Although the history of kings and rulers is unequivocally fascinating, I think that we are also hungry for the narrative history of ordinary people, who lack connections and material resources. The modern Korean is informed by the legacy of the Japanese occupation, World War II, the Cold War, and the Korean War as well as Confucianism, Buddhism, Communism, and Christianity. All these topics are reflected in this book, because they interest me, but I wanted to explore and better understand how common people live through these events and issues. These wars and ideas loom large in our imagination, but on a daily basis, such events and beliefs are illustrated concretely from moment to moment.

What was the process of writing such a long family saga like? Did you begin with that intention and a map of how the characters' lives would play out, or did you work it out as you wrote?
I wrote a draft of this novel between the years 1996 and 2004, and it was called Motherland; an eponymous excerpt of it was published in The Missouri Review in 2002. But after I wrote the whole manuscript, I knew there was something wrong with it as a novel draft. Consequently, Motherland became the second novel manuscript I put aside, because it didn't match the vision I had of the work in my mind. I was also working on Free Food for Millionaires, and although it was my third novel manuscript, Free Food for Millionaires became my first published novel in 2007. That same year, I moved to Japan with my family. In Tokyo and Osaka, I interviewed many Korean-Japanese. Through that process of gathering oral histories, I felt compelled to discard my earlier draft. In terms of plot, in my initial draft, I had started the book in the late 1970s; after my interviews, I realized that the story had to begin in 1910, and my character Sunja moves from Korea to Japan in 1933. To put it mildly, this was a traumatic realization, because I had to change everything and start again. I wrote a new outline with new characters, and Motherland became Pachinko. After I got over my initial shock of having to throw away a whole manuscript, I returned to my desk and wrote new chapter outlines. In short, I do work with outlines and maps, but I am in the habit of throwing away my outlines and maps when necessary. I don't work very efficiently.

Why did you choose for the narrator's perspective to switch from character to character, rather than focusing on one person's experience?
Both Free Food for Millionaires and Pachinko are written in an omniscient point of view. In both works, there is a narrator who knows the viewpoints of each character at all times. In Western literature, omniscient narration was the popular style in the nineteenth century, and it is my favorite point of view for community narratives. In both novels, I wasn't interested in only one or two main characters. This bias may arise from my personality. I am normally interested in the minor characters as well as the major ones. In realistic fiction and especially in a book-length work, characters cannot exist alone, and certainly they are never in a vacuum. Naturally, the interplay of characters in setting and time affects both plot and characterization. There are major plot lines, but minor plot lines should offer critical support to the story. If history so often fails to represent all of us, it is not because historians are not interested, but because historians often lack the primary documents of so-called minor characters in history. Interestingly, women have become at best the minor characters in history—although we represent half the human race—because we have left so few primary documents in nearly all cultures and civilizations. Also, poor and middle-class men of all races and cultures—although their lives were so often tragically sacrificed in war and labor—are often minor characters in history, because they too did not leave sufficient written evidence of their lives. I am drawn to novel writing using the omniscient point of view because this allows me to imagine and reveal the minds as well as the behaviors of all characters when necessary. For the kinds of books I want to write, I need an omniscient narrator. That said, I love to read first-person (singular and plural), second-person (singular and plural), and third-person limited (fixed or shifting) points of view. The twenty-first-century author has a lot of choices.

Did you consciously shift the narrative tone as you switched perspectives?
I think my narrator's tone (by "tone," I mean the attitude the narrator has toward the subject) does not shift much. More than anything, I wanted very much for the tone to be fair. There are remarkable narrators in great works of fiction that are wry (Pride and Prejudice), sarcastic and unreliable (Lolita), opinionated and high-minded (Jane Eyre), humble and curious (David Copperfield), and intellectual and world-weary (Middlemarch). "Fair" seems like such a simple word, but I think because my subject matter is so troubling and controversial, I wanted my narrator to be as objective as possible. Above all, I wanted the narrator to be sympathetic to every character's plight. I will be forty-eight years old in November 2016, and as I get older, it is easier for me to imagine and appreciate many more perspectives—perspectives I may have disliked when I was much younger. Especially for this book, I wanted my narrator to be fair to each perspective because the Korean-Japanese are so seldom written about in English. I find that in life, even the most unsympathetic person has a clear delineation of his motives, however complex and unappealing, but to him, there is a moral clarity to his actions. I think part of my job as a storyteller is to recognize the congruity or incongruity of his motives and behavior and somehow still be fair to the character and to the reader. I think, especially here, if the narrator is fair, then the reader can decide what happened and what she feels about the story.

Which authors do you admire?
I adore nineteenth-century writers Bronte, Eliot, Trollope, Dickens, Flaubert, Tolstoy, and Balzac. I also love Sinclair Lewis, Theodore Dreiser, Sherwood Anderson, William Faulkner, Edith Wharton, Ernest Hemingway, Zora Neale Hurston, Mark Twain, Tanizaki, Henry James, James Baldwin, and Ralph Ellison. As for modern living writers, I very much admire Lynn Ahrens, Lan Samantha Chang, Alexander Chee, Junot Díaz, Robin Marantz Henig, Kazuo Ishiguru, Colson Whitehead, Haruki Murakami, David Henry Hwang, Meg Wolitzer, Maxine Hong Kingston, Hilton Als, Simon Winchester, Chang-rae Lee, David Mitchell, Toni Morrison, Alice Munro, Gary Shteyngart, William Trevor, and Erica Wagner. The writings of Cynthia Ozick, Shelley Fisher Fishkin, Audre Lorde, Vivian Gornick, bell hooks, James Baldwin, and Virginia Woolf continue to encourage me to write more honestly and to dwell on subjects that matter to me.

In many ways, Sunja's plight is the catalyst for much of the book's plot. What is your relationship with her character? What inspired her creation?
From 2007 to 2011, I interviewed many Korean-Japanese men and women, and a great many of them mentioned a first-generation matriarch who sacrificed much of her life for the next generation, which ultimately led me to Sunja and her world. To earn money, first-generation Korean women in Japan worked in open markets, raised pigs in their homes, picked and traded rags and scrap metal, manufactured bootleg alcohol, farmed, and sold homemade goods from carts, among other things. Back then as well as today, the poorest women sold homemade goods in the open market, because they did not have much capital to invest. By selling boiled corn, tteokbokki, confections, sweet rice cakes, or gimbap in stalls or from carts, market women supported their families. Later, I met women peddlers in the open markets in Osaka and Tokyo. It is not easy to sell things in an open market, exposed to the elements as well as to be vulnerable to any person who wants to approach you. Also, then as well as today, market women often work in societies where women have less legal protections, rights, and significantly less socio-economic power.

I was born in Seoul and lived there until I was seven, and in my childhood I was keenly aware of the old women who sold snacks in the open markets and on street corners when I went food shopping with my mother. They were also vivid because they wore traditional clothing, in stark contrast to the modern Koreans of Seoul. When I visited South Korea as a college student in the late 1980s and many times later as an adult, I saw these women again in the markets and in the streets, almost unchanged in their expressions except for their clothes and hair.

Finally, my parents became small business owners when they immigrated to the United States. The daughter of a well-known minister and the headmaster of an orphanage school in Busan, my mother grew up very sheltered in a privileged home. A former music major at Yonsei University, she taught piano in our home when we lived in Seoul. When we moved to New York, she worked alongside my father in their cramped, under-heated wholesale jewelry shop in Manhattan, which was robbed and burgled on numerous occasions. She was on her feet most of the day dealing with customers. On weekends and school holidays, my sisters and I took turns working with our parents at the store. In college, I worked part-time selling clothes and shoes in retail shops. I continue to feel a strong connection with anyone who has worked in sales or in the service industry.

Is it easy for you to write your characters' deaths, or do you have a strong sentimental attachment to them?
My characters are very real to me, and I speculate that this must be true for most writers. Also, as a reader, I am very attached to characters in books. When Lily Bart dies in The House of Mirth, I wept and wept. Years later, I read Elaine Showalter's brilliant essay "The Death of the Lady (Novelist)" where she posits that Lily's death represents the death of the "perfect lady" who no longer belongs in an era of "vulgarity, boorishness, and malice." Showalter argues cogently that Lily has to die, because her aspiration for the ideals of a perfect lady no longer made sense and that the author Wharton was also shedding an outdated role as a "lady novelist": "In deciding that a Lily cannot survive, that the lady must die to make way for the modern woman who will work, love and give birth, Wharton was also signaling her own rebirth as the artist." I mention Showalter's insightful analysis of a formative work in my reading and writing life because she taught me a larger idea beyond death as a plot element or death as the expiration of a life. It is possible that characters need to die for the author to make her moral point, for the author himself to regenerate by letting go of an ideal identity, or for the world to recognize the necessity of certain ideas and ideals to die. Certain characters die in Pachinko, and to me, their deaths were both natural to the plot and necessary symbolically. To me, the deaths were painfully inevitable; and to be clear, dear reader, each death broke me.

Much of this novel deals with the pressures of being a first-generation immigrant, or having dual cultural identities. How much of this was informed by your own experiences? What effects do you think war has on individuals and society?
Consciously or unconsciously, being a first-generation immigrant informs my point of view and interests. Regardless of one's identity, all of us live in an information era where we are continually made to feel physically vulnerable to the political instability and violence around the globe in real time. Consequently, most of the developed world has growing factions in each nation, which want to raise the drawbridge and batten down the hatches. Out of fear, many of us want to retreat, and this makes some sense. Fair or no, immigration is considered in the context of economic scarcity, fear of terrorism, wars and geopolitical conflicts, which may be incipient stages of informal proxy wars. Whatever their cause, all such anxieties and conflicts affect individuals and societies and their movement patterns. Naturally, the movement of people changes the culture of the people around them, and the culture of the people around them affects the migrant people.

As for me, I lived just a few blocks away from the World Trade Center during the September 11, 2001, attacks, and my family and I had to be evacuated for a time. My family and I were residing in Tokyo during the Tohoku Earthquake on March 11, 2011. I have been changed by these events, and these events inform my work and the way I approach crises.

Unfortunately, every one of us is vulnerable to manmade and natural disasters, small and great. According to the United Nations High Commissioner of Refugees (UNHCR), there are over 65 million refugees in the world, which is about 1 out of every 113 people on earth. When my father was sixteen years old, he lost his family in the Korean War. The war and the memory of being a war refugee was not spoken of often, but these events lingered in the air of my childhood home. I think this kind of trauma is an unspoken legacy for many first- and second-generation immigrants in the United States and elsewhere. My father, a teenage war refugee from Wonsan, became a South Korean migrant worker in Busan, then a college-educated businessman in Seoul. He immigrated to the United States and became a small business owner. He is now a naturalized American citizen, a retiree, and a member of the AARP who also enjoys recreational deep-sea fishing. He has lived many lives away from his birthplace. Most immigrants are like this. Many of my friends and their families have been directly affected by the Holocaust, World War II, the Korean War, the Vietnam War, the collapse of the Soviet Union, and the suffering inflicted by military dictatorships in the Americas and in African nations. Today, all of us live in an era of vast income, educational and information inequality. However, what we also witness each day is how many ordinary people resist the indignities of life and history with grace and conviction by taking care of their families, friends, neighbors, and communities while striving for their individual goals. We cannot help but be interested in the stories of people that history pushes aside so thoughtlessly.

Why did you choose to title your novel Pachinko?
Pachinko is a kind of vertical pinball game played by adults in Japan. Although gambling is formally illegal there, Pachinko bypasses this prohibition by allowing the player to win prizes, called keihin, which are exchanged outside the premises of the Pachinko parlor for cash. What is little known outside of Japan is that as of 2015, Pachinko generates revenues of about 19 trillion yen, which is about $190 billion U.S. at the current exchange rate, or about twice the export revenues of the Japanese car industry. Yes, this includes Nissan, Toyota, and Honda. The game started out in the early part of the twentieth century in tiny stalls with itinerant operators at local festivals. After World War II, Pachinko was played in parlors for prizes like soap or cigarettes, which were exchanged elsewhere for cash. Today, many parlors issue tokens or cards embedded with valuable metals, which are exchanged for cash only a few steps away from the parlor. There are about 12,000 parlors officially registered in Japan, and 11 million Japanese play Pachinko regularly, or about one out of every seven Japanese adults. Although ethnic Japanese may have started the Pachinko business, over its near century presence in Japan, a great number of ethnic Koreans have operated Pachinko parlors and have been involved in the keihin business and the manufacture of the machines. Despite the strict regulatory involvement of the police and government authorities in the past twenty-five-plus years, the Japanese continue to view the Pachinko industry and the people involved with suspicion and hostility. I mention all this here because nearly every Korean-Japanese person I met in Japan had some historical connection or social connection with the Pachinko business—one of the very few businesses in which Koreans could find employment and have a stake. For example, if I interviewed an American-educated Korean-Japanese person who worked in the finance industry as an executive for a Western investment bank, he may have a relative who worked briefly in a parlor, or an uncle who lost everything in a failed Pachinko business. Also, nearly every Korean-Japanese I interviewed had some close or distant connection to the yakiniku (Korean barbecue, or galbi) business. In short, Korean-Japanese had to participate in small businesses, which were often given outsider or inferior status, because it was not possible to find work elsewhere. For me, the Pachinko business and the game itself serve as metaphors for the history of Koreans in Japan—a people caught in seemingly random global conflicts—as they win, lose, and struggle for their place and for their lives.

Female beauty, and how it can persist or fade with age, is such a recurring observation in your novel. Why?
One form of power, however fleeting, for anyone, is physical beauty. Unfortunately, for women, beauty is often expected in addition to whatever other attributes that may be needed or that may already exist. In many societies, females are often privileged or punished proportionately for their beauty or lack thereof. Without entering into a larger discussion of the intersection of beauty and age, as well as the impossible external requirements of physical beauty for women of all ages, I guess, I would like to discuss something more obvious in this work. In Pachinko, I wanted to reflect how a poor young woman's unconventional beauty, unknown even to herself, can be magnetic and resilient. In the West, there is a disjuncture between the reification and the excessive valuation of certain aspects of so-called Asian female beauty (Asian skincare products being perceived as superior; the commodification of Asian hair, which is sold expensively for extensions; or the hypersexualization of Asian women in pornography, which I have discussed in Free Food for Millionaires) and the utter lack of ratification or acknowledgment of realistic Asian female beauty in mainstream media (the sheer absence of Asian female fashion models of varying appearances, mainstream actresses, or any major roles in film and television). There is even a grosser lack of recognition of Asian male beauty or sexual attractiveness. Scholars like David Eng have argued effectively that there is an established practice of a kind of racial castration of Asian men in Western media and literature. Orientalism, the objectification or erasure of Asian beauty and distortion of Asian sexuality deny Asian humanity. I treat all of these issues in my writings. That said, another cultural travesty is the sheer absence of realistic beauty of working-class women of all races in mainstream media, including novels and stories. In Pachinko, I am acknowledging the physicality and beauty of working-class immigrant women.

I grew up in Elmhurst, Queens, and now live in Harlem. All my life, I have been surrounded by all kinds of women who work in menial and middle-class jobs, who lack the resources to join gyms, color their hair, buy cosmetics and skincare, go to dermatologists and plastic surgeons, polish their nails, eliminate unwanted hair, buy expensive clothing, eat less cheap carbohydrates and eat more lean proteins to be slim…the list goes on. Conventional physical beauty takes time, money, and effort, and it is expensive for all women, but it is cruelly so for women without resources. Every study points to the fact that attractive people also earn more money and have higher social status. Needless to say, it is a perpetual loop of economic gender cruelty to require women to pay for their physical upkeep and then to punish them financially for not keeping up when they don't have the funds. However, the reality is that despite what the media says, there are many women in history and in life who are not conventionally attractive yet who are very appealing. So I wanted to write about the woman that I see on the subway or waiting for the bus in the winter wearing a threadbare coat, or the woman who works as a cashier at an H-Mart—women who are too heavy or wrinkled or gray-haired or improperly dressed by the standards of television, movies, or fashion magazines and now social media sharing apps which commend filters to alter our already insecure images. I am interested in the physicality of women who live their daily struggles with integrity; their beauty captivates those who know them.

Do you think you have certain themes that you gravitate toward as a writer?
My subjects are history, war, economics, class, sex, gender, and religion. I think my themes are forgiveness, loss, desire, aspiration, failure, duty, and faith.

How did your experience writing Pachinko differ from your first novel, Free Food for Millionaires?
I wrote Free Food for Millionaires exclusively in New York City. I grew up in Queens, went to high school in the Bronx, and my parents had a small wholesale jewelry business on 30th Street and Broadway in Manhattan's Koreatown. Both my sisters live in Brooklyn, and my parents now live in New Jersey. I went to college in Connecticut. Needless to say, I know the tri-state area fairly well. Although I had written a draft of this novel in New York, I wrote the new rough draft almost entirely in Tokyo during the years 2007–2011, and I rewrote the drafts between 2011 and 2015 in New York. In Tokyo, I was researching, interviewing, and writing all the time; I was also profoundly homesick and melancholy in a way I had never been before. I missed my family and my friends deeply, and I felt cut off from everyone back home. I enjoyed living in Tokyo very much, but it was difficult, too. Living in Tokyo, I missed America very much; I yearned for the openness, hospitality, and optimism of Americans. I missed the ease of conversation that Americans can have with strangers. In New York, I am more guarded and private, but in Tokyo, I felt a kind of intense and immediate kinship with my fellow Americans. The epigram for Book III comes from Benedict Anderson's Imagined Communities, where he writes of a "horizontal comradeship" which must be necessarily imagined in a nation. I felt this horizontal comradeship strongly with Americans when I lived abroad. I had lost my birthplace once when I moved from Seoul to New York as a child, and living as an adult expatriate in Japan reminded me again of what my characters who lost their birthplace experienced in Pachinko. On a funny note, one of the things I did to overcome my intense homesickness for America, which allowed me to write the new rough draft of Pachinko, was to bake all the time. It was curious, because I have always cooked and baked, but never as much as I did in Tokyo. In my four years in Japan, I was baking the Cook's Illustrated Chocolate Sour Cream Bundt Cake on a dangerously regular basis. I don't know why, but to me, that amazing cake tastes like home.

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 Min Jin Lee at BookBrowse
Pachinko jacket Free Food for Millionaires 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 Min Jin Lee 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

  • Jade Chang

    Jade Chang

    Jade Chang has covered arts and culture as a journalist and editor. She is the recipient of a Sundance Fellowship for Arts Journalism, the AIGA/Winterhouse Award for Design Criticism, and the James D. Houston Memorial ... (more)

    If you enjoyed:
    Pachinko

    Try:
    The Wangs vs. the World
    by Jade Chang

  • Catherine Chung

    Catherine Chung

    Catherine Chung was born in Evanston, IL during a furious blizzard that dropped over 20 inches of snow on the ground and wreaked havoc all over Chicago. Writing has been her life-long passion, but as an undergraduate she ... (more)

    If you enjoyed:
    Pachinko

    Try:
    The Tenth Muse
    by Catherine Chung

We recommend 15 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...

The whole problem with the world is that fools and fanatics are always so certain of themselves, and wiser people ...

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 02:04 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
1780279491491 ms 1.78027949149E+012 ms 1 /root/website/app_server.cfm
587 ms 587 ms 1 /root/website/author_interviews/full/index.cfm
178 ms 178 ms 1 /root/website/app_layout.cfm
172 ms 172 ms 1 /root/website/author_interviews/full/dsp_main.cfm
157 ms 157 ms 1 /root/website/app_globals.cfm
138 ms 138 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
118 ms 39 ms 3 /root/website/adsystem/adsystem_mod.cfm
90 ms 45 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
60 ms 60 ms 1 /root/website/act_check_login.cfm
60 ms 60 ms 1 /root/website/adzones/AdZone6.cfm
60 ms 60 ms 1 /root/website/queries/qry_get_member_info.cfm
51 ms 51 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
41 ms 41 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
40 ms 40 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
35 ms 12 ms 3 /root/website/site/blocks/membership_advantages.cfm
33 ms 11 ms 3 /root/website/queries/qry_get_member_account_types.cfm
32 ms 32 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
30 ms 30 ms 1 /root/website/adzones/AdZone2.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_active_obc.cfm
30 ms 30 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
29 ms 29 ms 1 /root/website/adzones/showcase_track.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_competition.cfm
13 ms 13 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/actions/adstatus.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_bb_briefs_by_author.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.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
1 ms 1 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
588 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=7ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 02:04:51.051
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=59ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 02:04:51.051
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=6ms, Records=2) in /root/website/actions/adstatus.cfm @ 02:04:51.051
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 @ 02:04:51.051
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=4ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 02:04:51.051
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:04:51.051
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 02:04:51.051
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 @ 02:04:51.051
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=4ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 02:04:51.051
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=10ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 02:04:51.051
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 @ 02:04:51.051
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=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:04:51.051
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) = 2901

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=37ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 02:04:51.051
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) = 2901

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

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 02:04:51.051
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) = 2901

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=12ms, Records=15) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 02:04:51.051
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) = 2901

get_ads (Datasource=bookbrowse_com_new, Time=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:51.051
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=8ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:51.051
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=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:04:51.051
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 @ 02:04:51.051
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) = 3524

get_member_account_types (Datasource=bookbrowse_com_new, Time=8ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:04:51.051
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=9ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 02:04:51.051
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) = 2870
Parameter #2(CF_SQL_INTEGER) = 2870
Parameter #3(CF_SQL_INTEGER) = 2870

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

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

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=15ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 02:04:51.051
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=16ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:04:51.051
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=21ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 02:04:51.051
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=35ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:51.051
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 @ 02:04:51.051
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=11ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:52.052
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=31ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 02:04:52.052
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 @ 02:04:52.052
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:52.052
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=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:52.052
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 02:04:52.052
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=FREEACCESSCOUNT=0; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFID=4081714; CFTOKEN=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570; CFGLOBALS=urltoken%3DCFID%23%3D4081714%26CFTOKEN%23%3D2a924bade4f75045%2D09433153%2D98D1%2D651F%2DA9219B3D7F200570%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2002%3A04%3A51%27%7D%23hitcount%3D40%23timecreated%3D%7Bts%20%272026%2D06%2D01%2002%3A04%3A44%27%7D%23cftoken%3D2a924bade4f75045%2D09433153%2D98D1%2D651F%2DA9219B3D7F200570%23cfid%3D4081714%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/2901/author/min-jin-lee
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=4081714
cftoken=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
hitcount=42
lastvisit={ts '2026-06-01 02:04:52'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 02:04:44'}
urltoken=CFID=4081714&CFTOKEN=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
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#=4081714&CFTOKEN#=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570#lastvisit={ts '2026-06-01 02:04:51'}#hitcount=40#timecreated={ts '2026-06-01 02:04:44'}#cftoken=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570#cfid=4081714#
CFID=4081714
CFTOKEN=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
FREEACCESSCOUNT=0
Session Variables:
cfid=4081714
cftoken=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
sessionid=BOOKBROWSE_4081714_2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
urltoken=CFID=4081714&CFTOKEN=2a924bade4f75045-09433153-98D1-651F-A9219B3D7F200570
URL Parameters:
author=min-jin-lee
author_number=2901
Debug Rendering Time: 24 ms