Jo Baker Interview, plus links to author biography, book summaries, excerpts and reviews

Jo Baker
Photo: Ed Marshall/Timeout/Camera Pre

Jo Baker

An interview with Jo Baker

Jo Baker discusses the inspiration for her novel, Longbourn, and how daunting it was to work with Jane Austen's characters.

Is it safe to assume you have long been a fan of Jane Austen and in particular of Pride and Prejudice?

That's pretty safe. In fact, I can't even remember when I first read Pride and Prejudice – it seems like I've always known it. Jane Austen's work was my first real experience of grown-up literature, and I've kept on returning to her work throughout my life; I just love her books – I'm a sucker for all that buttoned-up desire and wish-fulfillment. But also, as a writer, I admire her – the immaculate prose, the deft plotting, the briskness of the characterization. I didn't, though, for a moment consider trying to write like her. It's impossible to do nowadays without shifting into parody – which is something I really did not want.

When did you first get the idea to write Longbourn and was there a specific incident that sparked the idea? Can you talk a bit about how your family history in some ways inspired this book?

As a child, reading Jane Austen, I became aware that if I'd been living at the time, I wouldn't have got to go to the ball. I would've been stuck at home, with the housework.

We've got some battered old silver cutlery at home, which we inherited from my great aunt. She and her sisters had been in service, and she always said the silverware was a gift from her employer when she left—my grandmother maintained, however, that she'd nicked it. Just a couple of generations back, my family were servants.

And so once I was aware of that – of that English class thing – Pride and Prejudice began to read a little differently. I noticed other presences. A footman enters, a housemaid is told to run along and do something. I also began to realize that some things that seemed to just "happen" – notes arriving, carriages being brought round, meals being served – would of course require human agency to make them occur. I became fascinated by these little flickers of activity: I started to see a whole other life going on below the surface of the book.

But Longbourn really began to take shape when I got snagged on the line "the very shoe-roses for Netherfield were got by proxy." It's the week before the ball, the weather is far too bad for the Bennet girls to venture forth, and so they send a servant out to get soaked on their behalf. And that made it really stark for me. A maid has to trudge out in the rain, and get soaked to the skin, just to get these frivolous little decorations for the other women's dancing shoes.

Then, reading Jane Austen's letters, I stumbled across a reference to two sisters whom she employed to do some sewing for her. Their surname was Baker. Okay, it's a common name, but still, the coincidence struck me! It seemed a confirmation of my instincts.

Any hesitation about reimagining a classic? How did you dream up your main characters?

I did hesitate. I hesitated for ages. I'd been thinking about this book for years before I first put pen to paper. That said, I don't really think of it as a "re-imagining". For me it's a "reading" of the classic. I just happen to "read" it a bit more intensively than might be usual, to include some elements that Austen didn't actually write.

I'll admit that Austen was peering over my shoulder while I was writing. Metaphorically speaking. But, again, when it came to characterization, I didn't want to write like her; I wanted to develop characters who could hold their own alongside hers, who would create space for themselves, who would be noticed in a crowded room. On a more personal level, I wanted to write characters who interested me, and kept surprising me. And they did.

The Bennets don't always come off as very sympathetic to their servants. Do you think there was a real divide in terms of those upstairs having any remote idea of the sheer amount of work being done downstairs?

There certainly was a sliding scale of familiarity between servants and their employers. In the poorer households, family members would work alongside their servants, and the relationship could be quite close – a servant would often be thought of as a family member. But the richer and more elite the household, and the more servants there were, the less personal contact there would be between the family and the staff. In the grander houses, lower servants were not expected to make eye contact; it's as if they're not really there – or not fully real, not considered persons in their own right. Everything would be managed through the senior staff. And yet the relationship there is also incredibly intimate, in terms of personal care, nakedness, and the body.

So the Bennets are somewhere in the middle of that scale. Not as aloof and distant as relations between staff and family might be in the grandest houses, like Pemberley, or even Netherfield, but not as informal as they might be between a grocer's family and their maid. Mrs. Bennet is, in her own way, very attached to Mrs. Hill, and entirely dependent on her. But she never once thinks of Mrs. Hill's wellbeing; the very idea would be ridiculous. She is there to perform a function. When it comes down to it, servants are the white goods of their day – the washing machines and dishwashers. One only really gives them any thought at all if they stop working.

I'm sure it was daunting but was it also fun to write this book, to bring to life in your own way all these delicious characters—the Bennets, Mr. Darcy, Wickham, Collins etc.—and have them mingle with your own?

It was. Both things. Daunting and fun. One thing that quickly became apparent as I was writing, was that I began to care a good deal about some of Austen's less prepossessing characters – the embarrassing mother, the gauche sister and the socially inept cousin. We aren't all blessed with confidence and wit and beauty – some of us find ourselves standing alone at the edge of the party, clutching a warm glass of white wine and trying to look like we're having fun – but that doesn't make our feelings and experiences any less valid.

Writing the book was also a chance to examine some of these characters from another angle – Wickham, for example. When you consider the age of the girls he preys upon, from a modern perspective, his behaviour seems more sinister than just fortune-hunting.

What kind of research did you do into what working class/domestic life was like at that time?

The domestic detail in Longbourn was gathered from a lot of sources: history books, contemporary domestic guides and recipes and practical research – like cleaning the floors with tea, which I still do. And some of it just comes out of my lived experience. In the village where I grew up there was an old Georgian vicarage, rather decrepit, that still had all its outbuildings – stables, stores, even a (disused, thankfully) "necessary house" with multiple wooden seats in a row; round the back, in the lower garden, there was a door that opened into the space underneath, so that it could be shoveled out. We used to play in the outhouses and grounds as children – it's all been redeveloped now, but this became Longbourn, when I was writing the book.

I was keen, too, to show that there was more heterogeneity below stairs than we might otherwise realize. Austen herself, living in rural Hertfordshire, mentions in a letter the black servant of a neighboring household; these servants were often freed slaves, brought over from the family's estates in the Caribbean.

This seemed to fit with the Bingleys in Pride and Prejudice, who had been in "Trade" in the north of England. The Triangular Trade – in slaves, and sugar – was the foundation of much of the wealth of the period, and there were centres in several northern ports, particularly Liverpool and my hometown of Lancaster. So that's where that aspect of the book came from.

One of the most striking parts of Longbourn takes place during the Napoleonic war. It's a chilling description of the wartime experience. Why did you choose to tell this part of the story?

There's a throwaway line of Lydia's, when she's filling her sisters in on gossip that they'd missed while Jane was ill at Netherfield: "a private had been flogged." To the family it's not a subject for polite conversation, but I found myself stuck on this line, thinking about what it really meant, about the reality of soldiering in this period. I found myself thinking about not the dashing Militia officers in their scarlet coats, but the ordinary foot-soldiers who came back from the front lines damaged, scarred.

What do you think Jane Austen would make of Longbourn?

I dread to think.

And I'd be terrified to meet her (if such a thing were possible). Aside from the outrage I've committed in writing Longbourn, I have such a massive crush on her, as a writer, that I'd be completely incapacitated by it. I'd be shambolic, stammering and self-conscious, and if she deigned to say anything to me at all, I wouldn't be able to put two words together in reply.

But then I also identify with her. The Letters – which are of course incomplete – really do give an insight into the woman, as well as the writer, and the work. She can be sniffy and irritable, as well as loving and loyal and brilliantly generous – there's a wonderful sequence where she writes warm and supportive letters to her niece, advising her about a novel she has written. But then, when you read on, you come upon another letter to someone else, in which she gripes about the unrealistic niece, the messy book, and the bother of it all. To get these real, honest glimpses of her is brilliant.

So what is next for you? Any other classics you are thinking of taking on?

Moby Dick from the whale's point of view.

Not really.

But I have started work on the next book. I'm really excited about it. It's different from Longbourn in many ways, but there are similar themes – war, exodus, love; finding a place for yourself in an uncaring world.

I've completely fallen for my central characters again.

Jo Baker discusses The Undertow and describes how a piece of family history became the catalyst for her story.


You drew inspiration from your own family story when writing The Undertow. When did you first learn of this family history and what made you decide to turn it into a novel?

I don't think I would ever have come to write the book at all if it wasn't for a piece of family history I stumbled on through a chance encounter in Valetta, Malta, where I was on a writers' residency some years ago. At the time, I was working on my previous book, The Telling.

I used to go to the Barrakka Gardens - a beautiful place on the harbor walls. On one occasion an elderly gentleman struck up a conversation with me. A mine of local information, he was soon pointing out buildings of historical interest, including an old hospital where, he told me, the wounded from Gallipoli had been treated. My great grandfather had served, and died, at Gallipoli - that was all I knew about him. I told the old fellow about this, saying that of course, having died there, my great-grandfather wouldn't have actually been in Malta. But, he told me, the ships refueled and took on supplies there on their way out. I realized that I was standing where my great grandfather may well have stood, ninety years previously, in radically different circumstances. The sense of connectedness, of time, gave me goose bumps.

When I returned home, I started researching my great-grandfather. There was not much known and there were no photographs, but the more I found out, the more fascinated I became, and the more aware of the starkness of his existence. He had grown up in a slum. No wonder he went to sea at fourteen. When he passed through Malta in 1915, he was on his way to die a very nasty, working-class death, trapped in the boiler room of his ship. I also came upon his post-card collection (which appears in the book), which revealed to me something of him as a person. The postcards, selected by him, preserved by his widow and then his son, showed him to be so alive to the world. He didn't just go for the tourist shots - he had, for example, amassed a large collection of pictures of the excavations of Pompeii. He had an artist's or a writer's alertness to the world, I felt, though he never had the slightest chance of realizing that. I, on the other hand, had had the privilege of an Oxbridge education, and had been brought to Malta simply to write. What lay between us, and between the astonishing differences in our life-chances, was simply ninety years. I had to explore that.

The Undertow follows one family through multiple generations, which you describe as a sort of narrative relay, with each character passing the baton to the next. Which time period was your favorite to write about?

Each period had its own pleasures and challenges, but I particularly loved writing the sections set in Battersea in the early part of the century, partly because the streets I'm writing about have disappeared - not just the houses, but the actual layout of the city there, the street-scape. Being close to the docks, the streets were flattened in the Blitz, and then built over after the war. It's a particular pleasure to reconstruct something that no longer exists - out of old maps, daydreams, and from stomping round the remaining neighborhoods in Battersea.

I also loved writing the Malta sections - both the present day and the World War I section. I enjoyed working out the continuities and differences over time. And, when so much of the novel is set in England, it was wonderful to let rip on Mediterranean color and sunshine!

Did you especially identify with any one character? Or were they all connected for you?

I identify with them all; they are all, in different ways, fractured and flawed, but still struggling with what life throws at them. Which is, I think, something everyone can relate to. But I do feel most sympathetic towards Billy, who has the least ability of any of the characters to articulate his emotions.

There are a few links that run throughout all of the narratives - objects that are passed down, the name "William" which each generation shares in some way - and one of them is a sinister figure who comes into the family's life after WWI. Did you always plan to have a "villain" in the story, or did he develop as you went along?

Sully was always there in the Gallipoli section of the story, taunting William, and I always planned for him to return... then he just kept cropping up as I wrote through the later sections. Like a bad penny, as William describes him. I realize now that he represents the dark side of inheritance, the things you don't want to know about your family. For Will, in particular, he is an unwelcome reminder of where he comes from and everything he's trying to leave behind.


This novel was originally published in the UK as The Picture Book. What, for you, is the significance of the US title, The Undertow?

The U.S. title captures - rather nicely I think - one of the novel's main themes: the pull of history. History drags characters under, or side-swipes them out of the course they had foreseen for their lives. At times the undertow is literal - drowning, near drowning, fear of drowning - and at times it is more metaphorical - distractions and diversions, failures, unexpected changes in circumstances.

Each generation of the family experiences war in a different way, but either personal experience or the memory of war is an important part of their lives. Was this a theme you set out to explore, or was it just a product of following a family through the 20th century?

As I was writing the novel, I thought of it as a story of family and war, and a family at war. Even not experiencing war is an issue in the book - Will is seen somehow to be deficient in not having served. I also wanted to think about individuals' experience of the current war - the global War on Terror - in relation to that of the earlier World Wars.

Did you have any particular literary inspirations while writing The Undertow?

Like most writers I read voraciously and promiscuously, and so it's almost impossible to know exactly what leaks through and influences my work, and what just left me impressed and satisfied as a reader. As part of my research I made a point of reading the novels of the period, not just the history - for texture and detail. Of course, because this book ranges over the 20th Century, there were a lot of novels to choose from; but I think readers could notice references (or reactions) to the work of E M Forster, Elizabeth Bowen, Graham Greene, and Kingsley Amis, amongst many others.

I don't know if it was exactly an influence, but I was also going through a full-on literary crush on Cormac McCarthy at the time of writing. His sentences are so lean, so active, and he has this extraordinary ability to convey so much about the emotional state of emotionally-inarticulate people.

What is your writing routine? Do you write at a particular time of day or in a particular place?

The Undertow was written mostly at night. I was juggling a full-time job and two small children so sleep was the only thing I could cut back on. I'd wake at 3 am, go downstairs, and work till 7 am when the kids woke up (known in our house as 'The Sylvia Plath shift'). If it wasn't for insomnia I would never have been able to complete the novel at all.

Obviously, that kind of schedule isn't good in the long term; I was able to quit my day job when I sold the book, and can now work at more reasonable times. I write in a coffee-shop in town; first draft is always with a notepad and fountain pen, then redraft onto computer.

Turning to popular culture for a moment, have you watched the TV series Downton Abbey and do you think that fans of the series will find some similarities in the first sections of The Undertow?

I think readers will find similarities, but very much from a below-stairs point of view. I'm fascinated by the period Downton Abbey explores - a time of massive historical events and the social change that comes with them. The book's focus though, is on the working class experience. They don't have succession to worry about, so much as survival. They start the century with nothing: they have only their lives and their wits to call their own. I think the stakes are higher for them as a result.

What project are you working on now?

I'm very excited about my next book; I don't want to jinx anything, though, so I'm keeping quite quiet about it...

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 Jo Baker at BookBrowse
The Body Lies jacket A Country Road, A Tree jacket The Telling jacket Longbourn 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 Jo Baker 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

  • Annie Barrows

    Annie Barrows

    In addition to co-authoring The Guernsey Literary & Potato Peel Pie Society with her aunt Mary Ann Shaffer, Annie Barrows is the author of the children's series Ivy and Bean, as well as The Magic Half.

    Annie lives in ... (more)

    If you enjoyed:
    Longbourn

    Try:
    The Guernsey Literary and Potato Peel Pie Society
    by Annie Barrows

  • Jillian Cantor

    Jillian Cantor

    Jillian Cantor has a BA in English from Penn State University and an MFA from the University of Arizona. She is the USA Today and internationally bestselling author of eleven novels for teens and adults, which have been ... (more)

    If you enjoyed:
    Longbourn

    Try:
    Beautiful Little Fools
    by Jillian Cantor

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

At times, our own light goes out, and is rekindled by a spark from another person.

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 06:43 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
1780296186628 ms 1.78029618663E+012 ms 1 /root/website/app_server.cfm
698 ms 698 ms 1 /root/website/author_interviews/full/index.cfm
246 ms 246 ms 1 /root/website/author_interviews/full/dsp_main.cfm
221 ms 221 ms 1 /root/website/app_layout.cfm
187 ms 62 ms 3 /root/website/adsystem/adsystem_mod.cfm
171 ms 86 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
159 ms 159 ms 1 /root/website/app_globals.cfm
140 ms 140 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
86 ms 86 ms 1 /root/website/adzones/AdZone6.cfm
75 ms 75 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
74 ms 74 ms 1 /root/website/adzones/showcase_track.cfm
58 ms 58 ms 1 /root/website/queries/qry_get_active_obc.cfm
38 ms 38 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
30 ms 30 ms 1 /root/website/adzones/AdZone2.cfm
30 ms 10 ms 3 /root/website/site/blocks/membership_advantages.cfm
28 ms 9 ms 3 /root/website/queries/qry_get_member_account_types.cfm
24 ms 24 ms 1 /root/website/act_check_login.cfm
24 ms 24 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
23 ms 23 ms 1 /root/website/queries/qry_get_member_info.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
20 ms 20 ms 1 /root/website/queries/qry_get_current_competition.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
16 ms 16 ms 1 /root/website/actions/adstatus.cfm
15 ms 15 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
14 ms 4 ms 4 /root/website/actions/act_spider_tracker.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_all_books_by_author_id.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/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
700 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 06:43:06.006
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=22ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 06:43:06.006
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=16ms, Records=2) in /root/website/actions/adstatus.cfm @ 06:43:06.006
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 06:43:06.006
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=18ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 06:43:06.006
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 06:43:06.006
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 @ 06:43:06.006
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

		WHERE		x.competition_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 06:43:06.006
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=21ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 06:43:06.006
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 @ 06:43:06.006
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 @ 06:43:06.006
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=12ms, Records=2) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 06:43:06.006
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) = 2182

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 06:43:06.006
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) = 2182

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=3ms, Records=5) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 06:43:06.006
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) = 2182
Parameter #2(CF_SQL_INTEGER) = 2182

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=18ms, Records=3) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 06:43:06.006
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) = 2182

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=18ms, Records=20) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 06:43:06.006
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) = 2182

get_ads (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:06.006
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=12ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:06.006
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=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:43:06.006
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_book_image (Datasource=bookbrowse_com_new, Time=9ms, Records=1) in /root/website/actions/udfs.cfm @ 06:43:06.006
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	left join editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
	left join editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1
                    
    where 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2959

get_member_account_types (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:43:06.006
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=28ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:43:06.006
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) = 1587
Parameter #2(CF_SQL_INTEGER) = 1587
Parameter #3(CF_SQL_INTEGER) = 1587

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:43:06.006
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) = 1587

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=99ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:43:07.007
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) = 2739
Parameter #2(CF_SQL_INTEGER) = 2739
Parameter #3(CF_SQL_INTEGER) = 2739

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=20ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 06:43:07.007
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) = 2739

get_member_account_types (Datasource=bookbrowse_com_new, Time=7ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 06:43:07.007
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=26ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 06:43:07.007
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 @ 06:43:07.007
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=24ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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=41ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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=18ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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=13ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 06:43:07.007
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 06:43:07.007
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=27ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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=29ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 06:43:07.007
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; CFID=4090668; CFGLOBALS=urltoken%3DCFID%23%3D4090668%26CFTOKEN%23%3Dbdf3f51bb8b4061c%2D13333C6A%2DF1FA%2D9519%2DBCF741AA2C857E0C%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2006%3A43%3A06%27%7D%23hitcount%3D150%23timecreated%3D%7Bts%20%272026%2D06%2D01%2006%3A42%3A36%27%7D%23cftoken%3Dbdf3f51bb8b4061c%2D13333C6A%2DF1FA%2D9519%2DBCF741AA2C857E0C%23cfid%3D4090668%23; CFTOKEN=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C; FREEACCESSCOUNT=1
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/2182/author/jo-baker
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=4090668
cftoken=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
hitcount=154
lastvisit={ts '2026-06-01 06:43:07'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 06:42:36'}
urltoken=CFID=4090668&CFTOKEN=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
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#=4090668&CFTOKEN#=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C#lastvisit={ts '2026-06-01 06:43:06'}#hitcount=150#timecreated={ts '2026-06-01 06:42:36'}#cftoken=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C#cfid=4090668#
CFID=4090668
CFTOKEN=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
FREEACCESSCOUNT=1
Session Variables:
cfid=4090668
cftoken=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
sessionid=BOOKBROWSE_4090668_bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
urltoken=CFID=4090668&CFTOKEN=bdf3f51bb8b4061c-13333C6A-F1FA-9519-BCF741AA2C857E0C
URL Parameters:
author=jo-baker
author_number=2182
Debug Rendering Time: 26 ms