Philippa Gregory Interview, plus links to author biography, book summaries, excerpts and reviews

Philippa Gregory

Philippa Gregory

An interview with Philippa Gregory

Philippa Gregory answers questions about her life, her writing and specifically about her books depicting the lives of Henry VIII's wives.

In your newest novel, The Boleyn Inheritance, you depict the life of King Henry VIII and his court through the eyes of three very different characters. Why did you choose to narrate this story through multiple voices and why these three women in particular?
I have a great liking for the first person narrative because I think it gets the reader into the head of the character; it’s a very immediate style. I realized that I wanted to tell the story from the point of view of the three women who were so intimately involved in the perils of being Queen of England at this time. Anne of Cleves, the wife that Henry chooses and rejects, Katherine Howard the girl he adores but who is too young to keep herself safe, and the woman who advises them both to their great danger: Lady Rochford, Jane Boleyn.


The Boleyn family utilized scheming and jockeying for favor in the court and in particular, for the favor of King Henry VIII. For Jane Rochford, the last in the Boleyn family, do you believe she knew her fate, the final fate of the Boleyn inheritance, when she went back to court?
Jane’s belief was that the Boleyn inheritance was wealth and fame and she sacrificed her husband George and her sister in law Anne Boleyn to try to retain the family name and fortune when they were found guilty of treason. But as the novel suggests: the Boleyn Inheritance is ultimately the scaffold and death.


Why did Anne of Cleeves survive?
Historians suggest that Anne of Cleves survived by good luck and her own stupidity. They suggest that she was insensitive to the insult of divorce and settled down to be the King’s sister so cheerfully that he forgave her the failure of their marriage. Reading the records with more sympathy, and with a feminist perspective, I suggest that she knew very well how to manage a domestic tyrant: having suffered from a drunk and perhaps delusional father and a powerful brother. I think she understood the dangers of Henry’s temperament before his more familiar court did so. Then, I think she set her sights on simply surviving the dangers that opened before her. She accepted the divorce offer without complaint or much resistance, and she accepted the financial settlement. She was clearly so relieved to be safe and divorced that many commentators remarked on her blooming looks and health when she came back to court for her first Christmas in England and was a chosen favourite of the King and his new Queen: Katherine.

In The Boleyn Inheritance you reintroduce Mary Boleyn and her daughter to the plot. What ultimately happened to them?
These are the Boleyn heirs who really break the curse. Mary Boleyn died of natural causes, an Essex landowner, wife and mother. Her daughter Catherine was a close friend of her cousin (or half-sister) Elizabeth, and went into exile with her protestant husband Francis Knollys during the years of Queen Mary. Catherine and her husband and beautiful daughter Laetitia returned to court in triumph when Elizabeth 1 came to the throne. I describe the scene in The Virgin’s Lover.

The Other Boleyn Girl is being made into a film. What is it like as an author to have the words you wrote on a piece of paper translated into scenes on a cinema screen? What part do you play in the process of adapting your novel into a film?
I have been employed as consultant on the film and so I have been closely in touch with the development of the script. Making a film is such a different process from writing a novel that I have learned to leave it to the film-makers. When I first saw the actors on location there was a haunting moment when it almost seemed as if they were real, really in Tudor England, and we in modern clothes were the illusion. It is extraordinary to see something that I have imagined suddenly become solid and real. To see them in costume, performing a scene, in an ancient setting is almost more powerful than to see them filmed on the screen. It is a magical moment.

When did you first decide that you wanted to be an author?
I had the great good fortune to decide that I would be a professional author when my first completed novel was published and enjoyed great success. It was called Wideacre and is now available in paperback published by Touchstone Books. Before then, I had written as a journalist and as an historian but I had not written fiction. Even now, I am still rather surprised to see the course my career has taken, and am very happy with it.

How do you think being a journalist has helped your fiction writing?
In the early years when it is easy for a new writer to become apprehensive about the task of writing and the length of the research it was very good to have had the training as a journalist where you sit down every day – whether in the mood or not – and write. Also, my training as a journalist taught me to ask the awkward questions – and this pays dividends in historical research too.

What inspires you to write historical fiction?
I love history. In almost any circumstances I always ask ‘but how did it get like this? How did it start?’ These are questions which come naturally and automatically to an historian and that is what, by instinct and training, I am.

How do you choose your subjects and do research for your books?
The subjects come to me when I am working on other things. So far, they have always – as it were – suggested themselves. Their characters strike me or I learn something interesting about their background that intrigues me, and then I research them from that point. Most of my research is book based, the Tudors especially have a huge collection of histories written about them, and I find a lot of interesting material in very old history books. The Victorians were very taken with the Tudors and some of their historians look at aspects of their lives that modern historians neglect. Also, I almost always travel to the sites I describe and I always find that very inspiring and often moving. I read around a lot too – I like to know the specialized history of the period, not just the events and the characters. I like to know about coinage and agriculture and transport…all those things that the reader should not know that I have researched, but they should feel at home in the detail of the Tudor world.

What tips or advice do you have for aspiring writers?
Never write for the market place, you can’t judge it, and you certainly can’t catch up with it. Always write the very best you can about the things that you feel passionate about. You are your first reader, never write down to yourself. If you are writing historical fiction then at least half your time and work should be the research – there is nothing more important than the honest basis of the fiction.

What do you think the impact of book clubs, which are rising in popularity, is on the sales of fiction?
I have special pleasure in talking about book clubs because my own career received a tremendous boost from the support of book club readers all around the country. By recommending my book The Other Boleyn Girl from one group to another, passing it from one reader to another, from one group to another, they generated an enormous buzz about the book which turned it from a relatively small paperback original historical novel into a big publishing sensation. Since then all of my books have been read in book clubs and the response I get from book club readers is one of the greatest pleasures for me as an author.



What would be your perfect day?
My perfect day would start waking up with sun on my face, I would ride my beautiful horse (I never have ridden him by the sea but that would be perfection) lunch with my family in a wonderful restaurant, some theatre in the evening and then going salsa dancing with my husband.

What is your greatest extravagance?
My really great and exciting extravagance is that I travel first class even when I am paying for my own ticket and not on expenses. It has taken twenty years of success for me to let myself do this and I love it.

What is the most exciting thing you ever received through the post?
A love-letter from my husband.

What's your idea of a perfect meal?
Lots of lovely little dishes -like sushi or tapas. I recently went to Yo Sushi! with my daughter Victoria and we had the best of times, eyeing up the revolving dishes and looking forward to the next one.

Do you have a favourite hangover cure?
I used to have more hangovers than I do now, but my favourite in the old days was to sleep as late as possible, take paracetamol and on waking, lots of water and vitamin C, and as soon as bearable a high carb meal.

What vehicle, if any, do you own?
I have the most beautiful XK8 jaguar in black with ivory leather upholstery. It purrs, and so do I.

What was the first job you ever had?
My first job was on The News, Portsmouth, where I was apprenticed as a reporter.

Do you have any irrational fears?
I have an irrational terror of very loud water in unnatural circumstances like hydro electric power stations, lock gates, or mill races. Water alone is OK it is when it is pouring into machinery that I hate the noise and the rush of it.

What is the oldest item of clothing you still wear?
I have a very old and very beloved waterproof jacket by North Face, that I bought nearly ten years ago and it is still snowproof and waterproof and windproof. It's baggy and soft and washes beautifully.

Who do you love?
In alphabetical order (to avoid complaints) my son Adam, my husband Anthony, my stepson Francis my stepson Marc, my stepson Patrick, my stepdaughter Samantha, my daughter Victoria and my stepdaughter also Victoria, my sister and her family, and my friends especially (in alphabetical order) Claire and Tine.

Who, or what, do you hate?
I absolutely refuse to let myself hate anyone, even when I find their behaviour hateful. I think hate sickens the person who is feeling it, I try to forgive and if I cannot, then I make myself forget, or at the least I try not to dwell. The people who are really irritating me at the moment and testing my forgiveness to its saintly limit, know perfectly well who they are, and what they are doing, and if they are reading this then they should know that I wish to God that they would stop doing it and behave like reasonable people.

What newspapers or magazines do you read?
The Times every day, the Sunday Times and the Observer on Sunday, Private Eye occasionally, Vogue at the hairdressers, Hello! very rarely, and in bewilderment.

What would be your desert island book?
I'm sorry to be dull but it would be the works of Shakespeare or Tolstoy, it would be a wonderful opportunity to read from cover to cover.

What is your favourite TV programme?
I'm not very fond of watching television, I used to like Friends and I quite enjoy Will and Grace but there is nothing that I would change my plans for. I often enjoy factual programmes or history programmes but I don't have a viewing schedule.

What was the first record you ever bought?
It was the 59th Street Bridge Song (Feeling Groovy) on a 45" single.

Where do you go to relax?
I love expensive spas like Grayshott Hall in Surrey, but I like to potter in my garden and I like to sit in the stable with my horse. He's a very calming companion. He is so big and so beautiful and so sweet tempered that I can almost feel his aura enveloping me. I am always happy when I am with him.

What is your most annoying habit?
I don't know… if I did know I would try to stop doing it. I think failing to shut cupboard doors in the kitchen probably comes pretty high, sometimes I leave the Marmite out. My children don't like it when I say uh-huh pretending to be listening, when I am not. I am often distracted because I am thinking about other things and so I am forgetful of errands I said that I would run. I imagine that I drive my children mad about my astronomically high standard of table manners but they are mostly too nice to complain.

What is your favourite journey?
There's a great rail journey along the south coast from Bournemouth to Cornwall, and I loved the road that goes from San Francisco to Los Angeles, all the way up that beautiful west coast of America. The drive from Malaga airport to Granada takes you through some pretty fine countryside too, and I used to walk a wonderful walk from God's Bridge on the Pennine Way, to the nearest pub.

What is your ultimate ambition?
I should like to achieve a reliable state of serenity.

Which person has most influenced you?
My husband is a constant and powerful influence in my life, but also my children make a tremendous difference to how I see the world and what I think and feel. The greatest influence before them was my mother who was a powerful independent and lovely woman. The very thought of her still makes me smile.

What is your greatest achievement?
More than ten years ago I gave some money (not very much, only £300) to build a well in a schoolyard in The Gambia, West Africa. It was such a success in terms of making a market garden from what had been a patch of desert, producing food that the children could eat at lunchtime, and a surplus that they could sell for school funds, that I raised money and built 56 other wells. It's a tiny project (me and my friend in The Gambia) but it has made a tremendous difference to thousands of children. I'm very proud of it. If you would like to contribute you can send a cheque to me and I will forward it.

Choose three people, dead or alive, to invite to dinner.
I should like to have dinner with William Cecil (Elizabeth 1st's chief advisor) he is one of the key characters in my novel The Virgin's Lover, probably one of the most skilled politicians this country has ever had. Elizabeth would not have become the Queen she was without him. My second guest would be Dorothy Parker whose wit was delicious and, I suspect, better at the dinner table than on the page, and Danny Kaye for humour and charm.

Do you believe in God?
I don't think I can seriously believe in someone who takes an interest in the world and yet lets it become like it is (yes, I do know the arguments about free choice - but what sort of stupid deal is the free choice experiment? What is the point of it?) I am not sure about how the world started, of course, so that could be a God, and I certainly have an instinctive feeling that someone is watching over me and hears me when I say, in crisis: Please oh! Please let this happen…., and I have a very powerful sense sometimes of holiness, especially in places that have long been centres of worship or are very beautiful … So…actually I don't know.

Do you believe in love at first sight?
In theory, of course not, nonsense (and so on). In fact, I first met my husband 22 years ago and I fell in love with him that evening. We were apart for 15 years and married two years ago. I have to believe in love at first sight, because it happened to me.

Do you know who's number one in the charts?
Not a clue. I don't mind not knowing, either.

Do you support the death penalty?
I don't support the death penalty. I can't help feeling sometimes that some life sentences are such misery, and such crimes so abhorrent that a death sentence would be a merciful and just alternative. But that's an emotional response, not a logical one. I wouldn't vote for the restoration of the death penalty and I would campaign against it.

Do you understand how to work a video recorder?
Yes. I'm not very technical and I get very quickly irritated by technology, but if it is something I need then I make myself understand it. And anyway, they're all a lot easier than they were.

Do you sing in the bath?
Not in the bath, in the shower, and when gardening and pottering about.

What would you like to be your epitaph?
Amazingly fit, incredibly beautiful, beloved by all that knew her, and happy to the end.

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 Philippa Gregory at BookBrowse
The Kingmaker's Daughter jacket Changeling jacket The Lady of the Rivers jacket The Women of the Cousins' War 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 Philippa Gregory 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

  • Vanora Bennett

    Vanora Bennett

    Vanora Bennett became a journalist almost by accident. Having learned Russian and been hired after university by Reuters, she was catapulted out of the classical-music life of her family and straight into the adrenaline-... (more)

    If you enjoyed:
    The Boleyn Inheritance

    Try:
    The Queen's Lover
    by Vanora Bennett

  • Tracy Chevalier

    Tracy Chevalier

    Tracy Chevalier was born in Washington, DC but has lived in England all her adult life. She now has dual citizenship. She has a BA in English from Oberlin College, Ohio and an MA in creative writing from the University of ... (more)

    If you enjoyed:
    The Boleyn Inheritance

    Try:
    The Lady and the Unicorn
    by Tracy Chevalier

We recommend 21 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 low brow and the high brow

Click Here to find out who said this, as well as discovering other famous literary quotes!

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

BookBrowse seeks out and recommends the best in contemporary fiction and nonfiction—books that not only engage and entertain but also deepen our understanding of ourselves and the world around us.

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 09:17 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
1780305442908 ms 1.78030544291E+012 ms 1 /root/website/app_server.cfm
331 ms 331 ms 1 /root/website/author_interviews/full/index.cfm
120 ms 120 ms 1 /root/website/app_layout.cfm
86 ms 86 ms 1 /root/website/app_globals.cfm
80 ms 80 ms 1 /root/website/author_interviews/full/dsp_main.cfm
59 ms 59 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
51 ms 17 ms 3 /root/website/adsystem/adsystem_mod.cfm
50 ms 25 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
45 ms 45 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
42 ms 42 ms 1 /root/website/site/blocks/layout/main_menu.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_active_obc.cfm
26 ms 26 ms 1 /root/website/adzones/AdZone6.cfm
23 ms 23 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
22 ms 22 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
14 ms 14 ms 1 /root/website/adzones/AdZone2.cfm
14 ms 14 ms 1 /root/website/queries/qry_get_current_competition.cfm
12 ms 12 ms 1 /root/website/actions/adstatus.cfm
12 ms 12 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
12 ms 4 ms 3 /root/website/site/blocks/membership_advantages.cfm
11 ms 11 ms 1 /root/website/adzones/showcase_track.cfm
10 ms 3 ms 3 /root/website/queries/qry_get_member_account_types.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
7 ms 7 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
5 ms 5 ms 1 /root/website/act_check_login.cfm
5 ms 1 ms 4 /root/website/actions/act_spider_tracker.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_member_info.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
1 ms 1 ms 1 /root/website/Application.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/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
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
332 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 09:17:22.022
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=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 09:17:22.022
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=11ms, Records=2) in /root/website/actions/adstatus.cfm @ 09:17:22.022
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 @ 09:17:22.022
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=3ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 09:17:22.022
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:17:22.022
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=7ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:17:22.022
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 @ 09:17:22.022
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=8ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 09:17:22.022
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=12ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 09:17:22.022
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=14ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 09:17:22.022
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=3ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 09:17:22.022
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) = 1234

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 09:17:23.023
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) = 1234

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=8ms, Records=11) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 09:17:23.023
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) = 1234
Parameter #2(CF_SQL_INTEGER) = 1234

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=21ms, Records=9) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 09:17:23.023
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) = 1234

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=2ms, Records=21) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 09:17:23.023
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) = 1234

get_ads (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=7ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=4ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:17:23.023
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=2ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:17:23.023
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=33ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:17:23.023
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) = 1444
Parameter #2(CF_SQL_INTEGER) = 1444
Parameter #3(CF_SQL_INTEGER) = 1444

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:17:23.023
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) = 1444

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=8ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 09:17:23.023
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) = 227
Parameter #2(CF_SQL_INTEGER) = 227
Parameter #3(CF_SQL_INTEGER) = 227

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

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:17:23.023
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=11ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:17:23.023
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=10ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:17:23.023
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 @ 09:17:23.023
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=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=4ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=7ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 09:17:23.023
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 @ 09:17:23.023
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
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=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:17:23.023
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFTOKEN=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4093657%26CFTOKEN%23%3D2a0f56c134d069ac%2D18B8D7B3%2DEFA6%2D6A15%2D5FD12B1D4251C289%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2009%3A17%3A22%27%7D%23hitcount%3D146%23timecreated%3D%7Bts%20%272026%2D06%2D01%2009%3A17%3A00%27%7D%23cftoken%3D2a0f56c134d069ac%2D18B8D7B3%2DEFA6%2D6A15%2D5FD12B1D4251C289%23cfid%3D4093657%23; FREEACCESSCOUNT=0; CFID=4093657
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/1234/philippa-gregory-et-al
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=4093657
cftoken=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
hitcount=149
lastvisit={ts '2026-06-01 09:17:23'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 09:17:00'}
urltoken=CFID=4093657&CFTOKEN=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
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#=4093657&CFTOKEN#=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289#lastvisit={ts '2026-06-01 09:17:22'}#hitcount=146#timecreated={ts '2026-06-01 09:17:00'}#cftoken=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289#cfid=4093657#
CFID=4093657
CFTOKEN=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
FREEACCESSCOUNT=0
Session Variables:
cfid=4093657
cftoken=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
sessionid=BOOKBROWSE_4093657_2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
urltoken=CFID=4093657&CFTOKEN=2a0f56c134d069ac-18B8D7B3-EFA6-6A15-5FD12B1D4251C289
URL Parameters:
author_number=1234
philippa-gregory-et-al=
Debug Rendering Time: 10 ms