Jan Moran Interview, plus links to author biography, book summaries, excerpts and reviews

Jan Moran

Jan Moran

An interview with Jan Moran

Jan Moran talks about her fiction and nonfiction books, particularly her first novel Scent of Triumph

Why did you want to become a writer?

As a child, I was an avid reader. Writers were my rock stars! Books were my passport to exotic locales and fascinating characters.

What are some of your favorite locales, objects, or activities that a reader might find in your books?

I often include my favorite locales. Paris, New York, Grasse, London, Hong Kong, Italy, and California are among my favorite places that I like to write about, and perfumery and fashion are twin passions. I'm also a strong advocate of the entrepreneurial path, especially for women.

What's your favorite part of the book?

I have a special place in my heart for Danielle's perfumery journal, which gave me deeper insights into her character, and allowed me to share her interpretation of her work and world events. Each entry appears at the beginning of a chapter, and relates to flowers or perfumery ingredients in that particular chapter, or current events in her world.

For example, the entry for the first chapter is: A rose, the symbol of love, the queen of the perfumer's palette. How then, does the perfume of war intoxicate even the most reasonable of men? Roses are a recurring symbol throughout the book, along with other flowers, such as iris and jasmine, which are all important to the perfumer. The story opens on the days that England and France declare war on Nazi Germany in response to the invasion of Poland.

Other favorite quotes include:

  • Perfume is my memory, the chronicle of my life.
  • Deep within the stench of despair blooms the perfume of hope.
  • Sandalwood, a stalwart of the perfumer's palette. Impervious to termites, matured more than thirty years. A superb fixative, an anchor. Stable, rich, smooth. Important qualities—desirable in men as well.
  • The orchid, queen of exoticism, a mute observer slow to reveal the mysteries of her petals. Would that I had such patience, too.
    • Who are your favorite authors and books?

      Favorite authors include: Kristin Hannah, Barbara Taylor Bradford, Jennifer Crusie, Anita Hughes, Michelle Gable, Barbara Delinsky, Elizabeth Adler, Tatiana de Rosney, and Gerard Macdonald. A Woman of Substance by Barbara Taylor Bradford was an early inspiration, and I adore A Paris Apartment by Michelle Gable. I love Shanghai Girls and others by Lisa See and The Red Queen by Philippa Gregory. And who can forget Leo Tolstoy's Anna Karenina, or War and Peace. There's nothing like a smart, strong-willed heroine. For historical fiction, I also adore Allegra Jordan and Allison Pataki, and for modern series fiction, Melissa Foster and Rebecca Forster are excellent.

      Barbara Taylor Bradford writes with elegance and a designer's eye for detail; Lisa See paints vivid portraits of time and place; Philippa Gregory enchants with historical details. And all of them portray strong, accomplished women.

      Is there a message you want readers to take from your books?


      Hope, triumph over adversity, appreciation of other cultures, belief in your own abilities.

      What inspires your writing?

      Travel always inspires me—I love to explore new cities, countries, and cultures that I can share with readers. Strong female protagonists and entrepreneurs who forge their own paths to success are also a source of inspiration. Finally, I like to learn something fascinating along the way, about history, unusual careers, or interesting people.

      When did your love of perfumery first begin?

      My love of perfumery was seeded by my mother and grandmother, who never left the house without perfume and lipstick. Fortunately, they had excellent taste and were generous with their knowledge.

      What's your advice for authors just starting out?

      Just begin! The journey begins with one step, or in this case, one paragraph or page. Then, edit and revise until you just can't stand it anymore. Be sure to seek professional help for editing.

      Any hidden talents you'd like to share with readers?

      Besides a really good nose? Well, once upon a time I was a ballerina, but now I'm quite good at reading financial statements, too. I've also worked with PR firms representing brands to the media. And I've started several companies. My last company, Scentsa, was sold to Sephora, and shoppers can still use the touch-screens I designed for perfumery and skincare.

      Are your character based on real people? Or imaginary people?

      All of my imaginary characters are jostling for headspace and attention. But there are many real stories of entrepreneurs and survivors that serve as inspiration, too. And remember, no one is safe around a writer!

      When did you begin writing?

      My first volume of poetry: fourth grade. My first novel: seventh grade. Both are, thankfully, forgotten. The UCLA Writers Program in Los Angeles was my next stop along the writing route. The RWA (Romance Writers of America) is also an excellent organization for learning and support.

      What are you working on now?

      Several fiction and nonfiction projects. I have a couple of new novels underway, which will take readers to fabulous international locations and delve into sexy new stories. I'll make announcements on my website, blog, Goodreads, Facebook and Twitter. Stay tuned on www.janmoran.com, where I'll post previews. Better yet, sign up for my newsletter to learn about new books and enter to win Advance Reader Copies and autographed books.

      If you could tell your readers anything, what would it be?

      Never give up!

      Can you tell us something about yourself that people might not know?

      A lot of people might know that I've written earlier nonfiction books on fragrances, Fabulous Fragrances I & II, which grew into the immensely popular Scentsa touch-screen fragrance and skincare finders in Sephora stores around the world, but not many people know that I've also guided the creative effort on a fine perfume, and blended several artisan scents. These incredible experiences helped me breathe life into the character of Danielle Bretancourt, a French perfumer, in Scent of Triumph.

      Are there any modern women who inspire your work?

      In writing Scent of Triumph I was inspired by forward-thinking women entrepreneurs of the twentieth century in beauty and fashion, including Gabrielle "Coco" Chanel, Nina Ricci, Elizabeth Arden, Estée Lauder, Madame Carven, and Mary Kay. These smart, gutsy, entrepreneurial women lived cinematic lives steeped in creative endeavors, along with their share of drama. There are also many modern day female entrepreneurs in today's beauty and fashion industry—think Jo Malone and Bobbi Brown—and thousands of others who support themselves and their families through their efforts and creativity.

      What do you love most about the writing process?

      Creating a world where anything can happen…

      What's your favorite genre?

      I read across genres, but contemporary and historical fiction, epic sagas, mysteries, and biographies are among my favorites.

      What's your favorite place?

      So many! Paris, San Francisco, San Diego, New York, Hong Kong, Copenhagen, London, Sydney, Mammoth Lakes, New Zealand… But I love living in Southern California, and I'm a native Texan (Austin).

      What's your favorite color?

      Has to be RED!

      What other books would you compare Scent of Triumph to?

      It's hard to say, because the book is an original idea. Personally, I like to read a wide range of historical and mainstream fiction, if that helps. Some of my faves are on my Goodreads page. Stop by and say hello. Some other books in which perfumes make a significant appearance include The Perfume Collector, The Book of Lost Fragrances, and Perfume.

      What was the inspiration behind
      Scent of Triumph?

      Scent of Triumph was initially inspired by my love of perfumery, but the main character quickly took charge and began building a business, despite her many setbacks. I was inspired by female entrepreneurs from the early part of the twentieth century, such as Elizabeth Arden, Coco Chanel, Madame Gres, Nina Ricci, Estee Lauder, Eleanor Roosevelt, and many others in the beauty and fashion industries. Family is also vitally important in this story; Danielle's love and devotion to her children is really the root of her ambition, as it is with many female entrepreneurs who wish to create a better life for themselves and their children. She is an ordinary woman, who achieves extraordinary things. Like any one of us can.

      What else about the book might pique the reader's interest?

      Scent of Triumph is a highly emotional story. Readers tell me they get emotionally invested in the main character, Danielle. They pull for her success, they cry with her during her periods of grief, and they fall in love with her lovers.

      What can modern women learn from your protagonist, Danielle Bretancourt?

      The story of Danielle Bretancourt is really the story of a woman's journey on the entrepreneur's path. It's a story of creativity and innovation, and of courage of convictions. Since the story begins in 1939, I had to understand the challenges that faced women at that time, such as the lack of credit or borrowing power for women who wanted to start their own business, among others. While opportunities have improved for women around the world, there are still so many women who suffer from inequalities, lack of knowledge, poor access to capital, and cultural oppression.
      For this story, I drew on memories from my mother, grandmother, and great grandmother – their memories of joy over gaining the right to vote, owning property in their name, and creating their own income. The challenges they faced and overcame inspired me to become an entrepreneur, and to help spread the word today about women's entrepreneurial efforts as a positive economic force for change.

      We love the romantic aspect of Scent of Triumph, so tell us, what is your favorite romantic scent?
      When I was writing Scent of Triumph, I created a cast of characters and imagined, what fragrances they would wear? How would perfume add to their characterization? What would their choices reveal about them? I used fragrances to reveal a character's personality, heritage, or psychological nature. For example, Tabac Blond, and Jicky were considered fairly avant-garde in the first part of the twentieth century, so I gave these fabulous vintage scents to two of the more extravagant characters in the books. Personally, I adore Mitsouko, so this one has a special passage in the book, too.

      If you were casting a movie for Scent of Triumph, who would you cast?

      It's open to interpretation, but here's a start:
      Danielle Bretancourt: Keira Knightley, Audrey Tatou, Emma Stone
      Jonathan Newell-Grey: Chris Hemsworth
      Max von Hoffman: Jude Law
      Cameron Murphy: Ryan Gosling, Ryan Reynolds
      Marie Bretancourt: Meryl Streep, Juliette Binoche
      Erica Evans: Penelope Cruz, Salma Hayek

      How did you come up with the idea for Scent of Triumph?

      I drew on my entrepreneurial experience in the perfume industry to create a vivid, compelling world. Equal parts artist and businesswoman, my gutsy heroine Danielle Bretancourt enchants men and women alike with a magical perfume blended in France and launched in Hollywood, while World War II rages across the continents.
      I'd also like to add that Danielle charts her course through devastating wartime losses and revenge, lustful lovers and loveless marriages, and valiant struggles to reunite her family. Set between privileged lifestyles and gritty realities, Scent of Triumph is one woman's story of courage, spirit, and resilience. So many of us have our own stories of resilience, of fighting for our principles, or for our families—I wanted to write a story that people of any age or circumstance could relate to, a story that would uplift the spirit.

      Who or what inspired you to write this book?

      Scent of Triumph was inspired by my love of perfumery. My creation of Scentsa for Sephora and other work in the fragrance industry also inspired me. The idea for the World War II period was inspired by my parent's memories of their lives during the war, and by accounts from French perfumers and fashion designers who lived through the war.

      How long did it take you to write the first draft of the manuscript?

      For Scent of Triumph, the first draft was written in about a year, but there were many, many rounds of revisions and edits that took several years while I was working full time.

      Is Scent of Triumph only for female readers?


      Not at all. If you visit Amazon or Goodreads, you'll see reviews from many of my male fans. Scent of Triumph resonates with both genders. Entrepreneurial struggles, family, love, and World War II are topics that both men and women can relate to.

      Anything you would like to say to your readers?

      I hope everyone enjoys Scent of Triumph, and I really love to hear from readers. You can always reach me at www.janmoran.com.

      What's the best fan letter you've received?

      They're ALL the best! I cherish (and save!) every letter I receive, and am so touched when people take time out their busy day to write to me. I love it when people share memories or places they've visited, or stories of a perfume that touched their soul—perhaps one that a beloved family member once wore. What an incredible honor to receive an email or a handwritten letter—especially today.

      Where do you dream of traveling?

      As a young girl, books were my magic passport to faraway lands. As an adult, so many of these travel dreams have come true, but I still dream of visiting Brazil, Argentina, Bora Bora, Russia, and Africa. Recently, I visited France and Denmark, two countries that stole my heart.

      Where did the idea come from for your books?

      Many of my ideas stem from my personal experience, although my books are not autobiographical. But in both Scent of Triumph and my next book you will learn about places I've lived and traveled (such as Paris, Beverly Hills, New York, Italy), the work I've done in perfume and beauty, period fashions, history, and more. I don't like to drop designer names or labels simply for the sake of doing so, but I will when it's germane to characterization, setting, or historical reference. I also like to include details about what it's like to create a product, run a business, and obtain funding–keys aspects of any entrepreneur's experience. My characters are quite entrepreneurial; of course, that stems from my own experience as well.

      In what genres do you write?

      Scent of Triumph
      is historical fiction with strong romantic elements. My nonfiction books include the Fabulous Fragrances series. My next books will be historical and contemporary fiction.

      You've created products, started companies, and have been at the helm of several ventures. Any advice for entrepreneurs?

      Plenty. Make sure you have a passion for what you do. Instill excellence in every part of your product, company, and training. And remember, customer service is paramount.

      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 Jan Moran at BookBrowse
Scent of Triumph 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!

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...

Men are more moral than they think...

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 07:31 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
1780299103964 ms 1.78029910396E+012 ms 1 /root/website/app_server.cfm
624 ms 624 ms 1 /root/website/author_interviews/full/index.cfm
256 ms 256 ms 1 /root/website/app_layout.cfm
170 ms 57 ms 3 /root/website/adsystem/adsystem_mod.cfm
170 ms 170 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
159 ms 159 ms 1 /root/website/author_interviews/full/dsp_main.cfm
128 ms 128 ms 1 /root/website/app_globals.cfm
102 ms 51 ms 2 /root/website/queries/qry_get_member_account_types.cfm
102 ms 51 ms 2 /root/website/site/blocks/membership_advantages.cfm
95 ms 95 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
94 ms 94 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
64 ms 64 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
59 ms 59 ms 1 /root/website/adzones/AdZone6.cfm
58 ms 58 ms 1 /root/website/adzones/showcase_track.cfm
54 ms 54 ms 1 /root/website/adzones/AdZone2.cfm
51 ms 51 ms 1 /root/website/queries/qry_get_active_obc.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
18 ms 18 ms 1 /root/website/actions/adstatus.cfm
18 ms 18 ms 1 /root/website/queries/qry_get_current_competition.cfm
16 ms 4 ms 4 /root/website/actions/act_spider_tracker.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
13 ms 13 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
12 ms 12 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
10 ms 10 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_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_ezine.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_border_booktalk.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/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
625 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 07:31:43.043
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=9ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 07:31:43.043
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

adactive (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/actions/adstatus.cfm @ 07:31:44.044
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 @ 07:31:44.044
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=7ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 07:31:44.044
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=9ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 07:31:44.044
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=8ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 07:31:44.044
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 @ 07:31:44.044
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=16ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 07:31:44.044
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=19ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 07:31:44.044
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=15ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 07:31:44.044
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=17ms, Records=0) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 07:31:44.044
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) = 2613

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 07:31:44.044
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) = 2613

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 07:31:44.044
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) = 2613
Parameter #2(CF_SQL_INTEGER) = 2613

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 07:31:44.044
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) = 2613

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=11ms, Records=0) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 07:31:44.044
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) = 2613

get_ads (Datasource=bookbrowse_com_new, Time=33ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
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=19ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
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=77ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 07:31:44.044
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_member_account_types (Datasource=bookbrowse_com_new, Time=23ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 07:31:44.044
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=72ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 07:31:44.044
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 @ 07:31:44.044
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=15ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
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=22ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
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=12ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 07:31:44.044
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=1ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 07:31:44.044
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
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 @ 07:31:44.044
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 07:31:44.044
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; FREEACCESSCOUNT=1; CFGLOBALS=urltoken%3DCFID%23%3D4091581%26CFTOKEN%23%3D7970d3b80a2b3233%2D14EFCC60%2DE546%2D11AC%2D97BB103C84E82CEA%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2007%3A31%3A43%27%7D%23hitcount%3D281%23timecreated%3D%7Bts%20%272026%2D06%2D01%2007%3A31%3A09%27%7D%23cftoken%3Dede2c8343503a538%2D14EFAEC0%2DD19D%2D5A38%2D52EC12170BC1F55E%23cfid%3D4091575%23; CFTOKEN=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA; CFID=4091581
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/2613/jan-moran
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=4091575
cftoken=ede2c8343503a538-14EFAEC0-D19D-5A38-52EC12170BC1F55E
hitcount=285
lastvisit={ts '2026-06-01 07:31:44'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 07:31:09'}
urltoken=CFID=4091581&CFTOKEN=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA
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#=4091581&CFTOKEN#=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA#lastvisit={ts '2026-06-01 07:31:43'}#hitcount=281#timecreated={ts '2026-06-01 07:31:09'}#cftoken=ede2c8343503a538-14EFAEC0-D19D-5A38-52EC12170BC1F55E#cfid=4091575#
CFID=4091581
CFTOKEN=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA
FREEACCESSCOUNT=1
Session Variables:
cfid=4091581
cftoken=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA
sessionid=BOOKBROWSE_4091581_7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA
urltoken=CFID=4091581&CFTOKEN=7970d3b80a2b3233-14EFCC60-E546-11AC-97BB103C84E82CEA
URL Parameters:
author_number=2613
jan-moran=
Debug Rendering Time: 22 ms