Bernie McGill Interview, plus links to author biography, book summaries, excerpts and reviews

Bernie McGill
Photo: Peter Nash

Bernie McGill

An interview with Bernie McGill

Bernie McGill talks about her widely-praised debut novel, The Butterfly Cabinet, and answers some revealing "quick questions" about herself.

You've written plays as well as short stories and novels. How has your experience with playwriting (and with watching your plays unfold in front of you) affected your fiction writing?
Writing for the theatre, in my experience at least, is a much more collaborative process than writing fiction. During the making of a theatre piece, there are a number of voices in the room, there's more input from other creative people, all of whom have an investment in the final made thing. When it comes to writing fiction it makes you very aware that the choices you make are your own. I always read my fiction aloud, I need to hear what's being said to gauge its authenticity. I think theatre writing makes you a more spare fiction writer; it makes you aware of how much you can show and how little you need to tell. It makes you realize how redundant most adjectives are and how important nouns and verbs are, the real nuts and bolts of writing. And I think it helps you to focus on what happens. You need to treat your potential reader with the same respect you'd grant an audience member, ask yourself, "Would an audience sit through this?" If the answer's no, then you know what to do. Get the scissors out and start cutting.

You write on your website about gleaning the editorial services of a fussy Annaghmakerrig table lamp at the Tyrone Guthrie Centre, a writer's and artist's retreat. Do you find yourself at the mercy of any other unorthodox editors during the writing process?
There are a number of techniques that we use in the writing groups I work with to "test" your writing, questions such as "Does this passage move the story forward?"; "Where does this incident take us?"; "Is this piece of writing absolutely essential?" I am guilty of being seduced by the poetry of language, I become attached to a piece of writing because it sounds good, but you do have to remind yourself that you're telling a story, that you need to keep the reader with you at all times. My UK editor did a fantastic job on the first draft of The Butterfly Cabinet, and many of her edits could be paraphrased thus: "Beautiful piece of writing, what's the point of it?" I use the second part of that phrase now when I'm writing to help me focus.

Per your website, the original title of The Butterfly Cabinet was The Lepidopterist. Why did you change the title? Were your earlier drafts more focused on Harriet - the lepidopterist - and less on the symbolism of the butterfly cabinet?
The Lepidopterist was always a working title; before that the book was called The Sea Diaries. I always thought it was a little inaccessible as a title; in general I try and avoid Latinate phrases and go for the more direct Anglo-Saxon choice. But it got me through the first draft. Harriet was always the main protagonist of the book, Maddie was invented to act as a foil to her, but she ended up having an important role to play, not just in the telling of the story, but in the story itself. The story is fairly evenly divided up between the two narratives. I think it was my agent who suggested The Butterfly Cabinet as a title, either her or my editor, and I liked it, so we went with it. It changed the book a little - the cabinet became more prominent, and I had to come up with an explanation of how it had ended up in Maddie's possession, but it's fun trying to work those things out.

On your website, you talk about the process by which you decided to relocate your fictional story away from the castle where the real-life inspiration occurred. What parts of the historical record - the newspaper articles about Harriet, the prison details, or the maid work, for example - did you adopt more directly?
It's very hard to say what percentage of the book is fictional and what percentage is more closely tied to fact. In broad terms, the events surrounding the child's death follow the testimonies as related by witnesses at the trial. According to the newspaper reports, the child was put in the wardrobe room by the governess because she had soiled herself. The mother was out of the house at the time, and when she returned she went in to the child, tied her by the hands to a ring on the wall, went out, locked the door, put the key in her pocket, and left her alone for about three hours. When she returned, the child was dead. These events were related by the mother at the inquest that was held in the house the following day. Harriet's backstory is a complete invention, as is her obsession with butterflies, and Maddie is an entirely fictional character, although in some ways, she is a kind of collage, inspired by the servants who gave evidence at the trial. The prison details and the maidservants' work came from reading social histories of the period. I wanted to make those two worlds as authentic as I possibly could. I also visited the National Archive in Dublin to read the original prison records for Grangegorman. It was really strange to see the mother's name there, written by someone who had actually known her, would have dealt with her on a daily basis. That was far more chilling than reading about her in the newspapers. It made it very real to me.

How did you land upon the idea of two narrators (plus a few brief letters from Anna) for your story? Did you ever consider adding more voices?
It was very important to me that we heard Harriet's story. As I said above, she made a statement at the inquest, hours after the child's death, which was recorded and reread on several occasions, and printed in the newspapers. It was a fairly bald, emotionless statement of fact and it makes for very uncomfortable reading. She comes across as a fairly cold individual. But I think that was what intrigued me most. As far as I understand it, the law at the time was such that neither the defendant, nor members of the defendant's immediate family, were permitted to give evidence during a trial, so these printed words by the mother are the only words of hers that we have. I wanted to know what she would have said, had she been given the chance. There were questions I wanted to ask her, and this was the only means I had of having her speak. There was no question in my mind that Harriet should be allowed to talk for herself.

As for Maddie, I was looking around for someone who could offer another version of events, and for a while I became interested in the idea that that other character might be a reporter working on the case. I eventually rejected this idea, though, because I wanted that other person to have an insight into the workings of the household, both before and after the child's death. For a while, I entertained the notion that the other narrator might be Julia, Harriet's sister, but I became more and more drawn to a servant's voice. I wanted someone who would contrast with Harriet in terms of their social standing, their upbringing and education, and who had that duality that servants often had: someone who was an integral member of the household but who could be a witness to events, almost unseen. Other voices do come into the story - Edward's, the children's, the other servants' - but all filtered through Harriet and Maddie. I'm always interested in how people's versions of events will differ from one another, how we all put our own spin on things. That relationship between truth and interpretation is very engaging, I think.

Which character would you most want to be friends with? Why?
I think Peig sounds like a good soul, and Maddie as a young woman would have been fun to know, and you could have had a good old flirt with Alphie. I think Harriet's the kind of woman you would avoid at the school gates but gossip about endlessly with your friends. "Did you hear what she said to Mrs So and So...?" - that kind of thing. She'd be very unapproachable, immaculately turned-out, her domestic life would run like clockwork. You'd never have a good word to say about her but your ears would prick up every time her name was mentioned, which would be often. She'd be much maligned and much spoken about.

How did you originally stumble across the historical research that gave way to Harriet's character? Did you know immediately that you'd found a book idea, or did the idea resurface later in your mind?
I came across the story in a local parish magazine, just a short article about the big house up the road and the mother who'd been imprisoned for the killing of her young daughter. It lodged in my brain. I pass the entrance to the house regularly, and every time I did it sent a shiver up my spine. My own children were fairly young at the time, around five and seven. I couldn't stop thinking about what had happened there, so short a distance from my own home, albeit more than a hundred years before. Around that time, I'd been awarded a grant from the Arts Council of Northern Ireland to write a collection of short stories. I decided to start with this one. My idea was to write about ten stories, roughly ten years apart in time, leading up to the present day, but I couldn't get away from this one story. Everything I wrote led back to it again. I was working with a mentor, a writer named Damian Gorman, and he suggested that there might be scope for a novel. It was a frightening idea, but after a bit of persuasion, I decided to give it a go. The research was quite time-consuming, but I kept coming across aspects of the story that held me - at the time of her imprisonment, the mother was pregnant with her ninth child. The child who died was the only daughter in the family. I'm the youngest of a family of ten children, seven boys and three girls. I'm sure it had some bearing on my interest.

Did the butterfly theme come from historical research or from your own construction of Harriet?
The butterfly theme was an invention of my own. I had read that the mother was a keen and skilled horse rider, a huntswoman, and a renowned horse breaker. This passion of hers seemed to fit very neatly into the image of her as a strict disciplinarian, but I was looking for something a little more poetic. I had been reading about the Victorians, about the legacy of Darwin, the rise in interest in the study of the animal world, the apparent lack of squeamishness around collecting, preserving, studying insects and much larger animals. That image of the collectors' cabinet is, I think, quintessentially of that era. I began to wonder if Harriet was a collector and if so, what that meant. Was she someone who could only appreciate the beauty of the thing when it was still? I thought that if that were true, that that was both chilling and sad, and that seemed to fit with who I thought she was.


You write on your website, of Harriet, "I wasn't trying to justify what she'd done, I didn't particularly want to identify with her, but I did feel compelled to try and understand the motivations of that fictional character she had become." By now, at the end of the writing process, do you feel you understand her motivations? Are there parts of her as a character that you still don't understand?
There are, absolutely, parts of Harriet that I don't understand, that I'm wary of understanding. I did want to get inside her head, but I didn't particularly want to dwell there. It was, as I've said before, a dark place to be. I'm glad I don't have to be there anymore. There are things I admire about her as an individual. When she made the statement at the inquest about locking the door and putting the key in her pocket, she essentially damned herself from her own mouth. She was saying, "I, and I alone, am to blame." She wasn't allowing room for speculation, which is, of course, what caused me to speculate when I was writing the book.

You write in your website bio, "I love the contract that's made between writers and readers/audiences: when people sit down, individually or together, and conspire to believe in what is openly, transparently, not true." What messages or emotions do you hope to convey to your readers in this particular shared conspiracy of belief?
I always look for emotional truth in fiction, for characters that you can believe in, who do things that you may or may not agree with, but which you can understand. I think that's the real joy of fiction and the theatre, and if those made-up people doing made-up things can cause you to look at the world a little differently, be a little more tolerant, a little less judgmental, then I think the art form is doing its job. Sometimes we need a medium like that, or a mirror, or a filter, we need to look at make-believe in order to get a clearer perspective on our own world. I love George Eliot's definition, in The Mill on the Floss, of metaphor: "we can so seldom declare what a thing is, except by saying it is something else." We seem to need to pretend, sometimes, that a thing is something else in order to appreciate what it is. You should always come away from a story or a book or from the theatre a little changed, I think, in your outlook, a little cheered, or a little more enlightened, or a little better informed, or a little more sympathetic, otherwise what's the point?

Do you have any ideas for, or beginnings of, a second novel right now? If not, what do you plan to work on next?
I'm tentatively working on a second novel set on Rathlin, a small inhabited island off the north coast of Ireland. It was the site, in 1898, of some of the first wireless experiments conducted by Marconi's engineers. Even nowadays, the island is occasionally cut off in bad weather. I love the idea that this relatively remote and isolated place, which didn't have electricity until the early 1990s, was the site of such experimental technology at the end of the nineteenth century that people were able to send and receive messages between there and the mainland without the aid of cables or wires. It must have seemed like magic was at work. I'm fascinated by that idea that your words can travel beyond you, specifically in the context of a community that knew all too well what it was to be isolated from the rest of the world.

Before your writing career took off, you worked as a theater manager and events coordinator. Would you consider going back to the theater, or are you firmly and happily entrenched in the writer's path now?
At the moment, I seem to be a fiction writer, but I'd love to write again for the theater. It is a magical place, even, maybe especially, when you know what it looks like from behind the scenes. When I was a student I worked as an usherette in the Queen's Film Theater in Belfast. We used to view the same film six, seven times or more, and even though the film never changed, even though what was showing on the screen was essentially fixed, the experience was never the same twice because the audience took on a different personality for every screening. Imagine how much more exciting it is to experience a theatre piece, often in a different performance space, always in front of a new audience, and where the actors respond directly to the exigencies of that space and those people every time. It is wholly live, it is never, ever the same twice, nor could it possibly be, and that's what's most exciting about it. There are some stories that work better in the theatre, that need to be seen and not told, and when I next find one, that's where I'll take it.

Revealing Questions

How would you describe your life in only 8 words?
family, writing, teaching, reading, researching, eating, cooking, laundry

What is your motto or maxim?
Currently, I'm fond of 'Abandon your story'. It's about allowing yourself to stop writing and allowing other people to start reading your work, which is, after all, the point of the exercise.

How would you describe perfect happiness?
Installed in a little villa in Tuscany or Umbria with a self-cleaning pool, my own tomatoes growing in the garden, a hammock strung between the pines, a never-emptying bottle of prosecco in the fridge, shelves groaning with books, a free trattoria within staggering distance, and family and good friends to share it.

What's your greatest fear?
That harm should come to any of the people I love.

If you could be anywhere in the world right now, where would you choose to be?
Right now, here is good, doing this. But for a few years down the line, see my idea of perfect happiness.

With whom in history do you most identify?
I'm very fond of the boy who said the Emperor wasn't wearing any clothes. I know that, strictly speaking, he's a fictional character, but there have been such people in history too. It's just that their names don't usually get remembered.

Which living person do you most admire?
I'm a big fan of Mary McAleese, the Irish President.

What are your most overused words or phrases?
'Fair play to you, Dolly!' Also: 'What's for you won't go by you.'

What do you regret most?
Nothing, it's all taking you somewhere.

If you could acquire any talent, what would it be?
To play the guitar.

What is your greatest achievement?
My children.

What’s your greatest flaw?
I have too much anxiety about the bad things that could happen.

What’s your best quality?
I'm a very good listener.

If you could be any person or thing, who or what would it be?
A time-traveling companion to Jane Austen, while she was writing, knowing what I know.

What trait is most noticeable about you?
I have big ears.

Who is your favorite fictional hero?
Very difficult. It's a tie, I'd say, between Celie Johnson from The Color Purple and Elinor Dashwood from Sense and Sensibility.

Who is your favorite fictional villain?
Heathcliff

If you could meet any historical character, who would it be and what would you say to him or her?
I'd be interested to meet Emily Davison, the English campaigner for suffragism who threw herself under the King's horse at Ascot in 1913, in protest that women did not have the vote. I'd want to ask her if she'd thought about it fully before she did it, if she was committed to dying for the cause. I'd want to know if she thought it was worth it. I'd like to know what she makes of us all today.

What is your biggest pet peeve?
Politicians delivering bad news who think if they put 'going forward' in the sentence, that everyone listening will be fooled into thinking that the news is good.

What is your favorite occupation, when you’re not writing?
Walking or reading, but not at the same time. I saw a woman on the beach once doing both. I think that's taking multi-tasking far too far.

What's your fantasy profession?
Singer/songwriter/guitar player. (Not one of these. All three of these.)

What 3 personal qualities are most important to you?
Sincerity, humor, intelligence.

If you could eat only one thing for the rest of your days, what would it be?
Pasta.

What are your 5 favorite songs?
Only five? Seriously? Well, for now, because of their associations as well as their stories: Van Morrison's 'In the Garden'; Elbow's 'Starlings'; 'The Waterboys' 'The Whole of the Moon'; Snow Patrol and Martha Wainwright's 'Set the Fire to the Third Bar'; Damien Rice's 'The Blower's Daughter'

Who are your favorite authors?
Margaret Atwood, Pat Barker, A.S. Byatt, Peter Carey, Anne Enright, Claire Keegan, Flannery O'Connor, Andrea Levy, Cormac McCarthy, Anne Michaels, Toni Morrison, Alice Munro, Maggie O'Farrell, Annie Proulx, Alice Sebold, Lionel Shriver, Zadie Smith, Alice Walker, John Banville, Sebastian Barry, Patrick McCabe, Eoin McNamee, Joseph O'Connor, Flann O'Brien.

What are your 5 favorite books of all time?
Alias Grace by Margaret Atwood. I'd spent years at University reading books that were supposed to be good for me. I didn't know that there were books like this - beautifully written books that you would want to read, that told a cracking good story.
Possession by A S Byatt. My friend and I (both English graduates) spent hours talking about how much we adored this book when what we were actually saying was, we really wanted to be Maud Bailey.
Beloved by Toni Morrison. A stunning book, a ghost story told matter-of-fact and an eye-opener as well as an ear-opener when I was in my twenties.
The Butcher Boy by Patrick McCabe. Dark, very dark, and quite, quite brilliant.
At Swim, Two Birds by Flann O'Brien. Very funny, quite anarchic and (first published in 1939), way ahead of its time.

Is there a book you love to reread?
I always think that when I have more time I'll go back and read my favorite books, but I'm too greedy for new books to do that now.

Do you have one sentence of advice for new writers?
Read as much and as widely as you can, books by writers from different cultures and backgrounds to your own as well as those that are more familiar, and write, write, write.

What comment do you hear most often from your readers?
Quite a few people have said to me that they read The Butterfly Cabinet in one sitting. I'm delighted they found it compelling, but I have mixed feelings about that. It took me five years to write!

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 Bernie McGill at BookBrowse
The Butterfly Cabinet 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 Bernie McGill 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

  • A.S. Byatt

    A.S. Byatt

    Dame Antonia Susan Byatt (b. 1936) was born and grew up in Yorkshire, England. She attended Newnham College, Cambridge; Bryn Mawr College, Pennsylvania; and Somerville College, Oxford, where she studied as a postgraduate.... (more)

    If you enjoyed:
    The Butterfly Cabinet

    Try:
    The Children's Book
    by A.S. Byatt

  • 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 Butterfly Cabinet

    Try:
    Remarkable Creatures
    by Tracy Chevalier

We recommend 6 similar authors

View all 6 Read-Alikes

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

BookBrowse Book Club

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

Members Recommend

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

It is a fact of life that any discourse...will always please if it is five minutes shorter than people expect

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 03:15 PM
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
1780326911466 ms 1.78032691147E+012 ms 1 /root/website/app_server.cfm
1057 ms 1057 ms 1 /root/website/author_interviews/full/index.cfm
324 ms 324 ms 1 /root/website/app_layout.cfm
315 ms 315 ms 1 /root/website/author_interviews/full/dsp_main.cfm
257 ms 257 ms 1 /root/website/app_globals.cfm
249 ms 249 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
219 ms 73 ms 3 /root/website/adsystem/adsystem_mod.cfm
211 ms 106 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
118 ms 118 ms 1 /root/website/adzones/AdZone6.cfm
96 ms 96 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
96 ms 96 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
70 ms 70 ms 1 /root/website/queries/qry_get_active_obc.cfm
68 ms 68 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
67 ms 67 ms 1 /root/website/adzones/showcase_track.cfm
54 ms 54 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
53 ms 53 ms 1 /root/website/actions/adstatus.cfm
45 ms 15 ms 3 /root/website/site/blocks/membership_advantages.cfm
44 ms 15 ms 3 /root/website/queries/qry_get_member_account_types.cfm
42 ms 42 ms 1 /root/website/queries/qry_get_current_competition.cfm
41 ms 41 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
35 ms 35 ms 1 /root/website/adzones/AdZone2.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
31 ms 31 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
29 ms 29 ms 1 /root/website/act_check_login.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
29 ms 29 ms 1 /root/website/queries/qry_get_member_info.cfm
27 ms 27 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
26 ms 7 ms 4 /root/website/actions/act_spider_tracker.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/act_libraryIPLogin.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_menu.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1057 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 15:15:11.011
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=27ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:15:11.011
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=51ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:15:11.011
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 @ 15:15:11.011
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=30ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:15:11.011
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=23ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:11.011
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=18ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:11.011
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 @ 15:15:11.011
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=18ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:11.011
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=26ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:11.011
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=23ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:11.011
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=32ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:15:11.011
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) = 2075

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:15:11.011
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) = 2075

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=33ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 15:15:11.011
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) = 2075
Parameter #2(CF_SQL_INTEGER) = 2075

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=28ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 15:15:11.011
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) = 2075

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=41ms, Records=6) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 15:15:11.011
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) = 2075

get_ads (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:11.011
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=16ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:11.011
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=14ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:11.011
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=18ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:11.011
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) = 2605

get_member_account_types (Datasource=bookbrowse_com_new, Time=19ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:11.011
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=69ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:12.012
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) = 1023
Parameter #2(CF_SQL_INTEGER) = 1023
Parameter #3(CF_SQL_INTEGER) = 1023

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

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=96ms, Records=3) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:12.012
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=22ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:12.012
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=6ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:12.012
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=39ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:12.012
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=55ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:12.012
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=63ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:12.012
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=34ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:12.012
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 @ 15:15:12.012
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=26ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:15:12.012
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 @ 15:15:12.012
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=23ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:12.012
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=23ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:12.012
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=17ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:12.012
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=CFID=4105290; CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0; 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%3D4105290%26CFTOKEN%23%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A15%3A11%27%7D%23hitcount%3D68%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A14%3A56%27%7D%23cftoken%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23cfid%3D4105290%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/2075/author/bernie-mcgill
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=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
hitcount=77
lastvisit={ts '2026-06-01 15:15:12'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:14:56'}
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
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#=4105290&CFTOKEN#=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#lastvisit={ts '2026-06-01 15:15:11'}#hitcount=68#timecreated={ts '2026-06-01 15:14:56'}#cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#cfid=4105290#
CFID=4105290
CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
Session Variables:
cfid=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
sessionid=BOOKBROWSE_4105290_a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
URL Parameters:
author=bernie-mcgill
author_number=2075
Debug Rendering Time: 22 ms