Excerpt from The Opposite of Everyone by Joshilyn Jackson, plus links to reviews, author biography & more

Summary |  Excerpt |  Reading Guide |  Discuss |  Reviews |  Beyond the Book |  Readalikes |  Genres & Themes |  Author Bio

The Opposite of Everyone by Joshilyn Jackson

The Opposite of Everyone

by Joshilyn Jackson
  • BookBrowse Review:
  • Critics' Consensus (5):
  • Readers' Rating (72):
  • First Published:
  • Feb 16, 2016, 352 pages
  • Paperback:
  • Oct 2016, 352 pages
  • Rate this book

About this Book

Print Excerpt

That got his attention. Birdwine lived pretty strapped. He put a long, level gaze on me and said, "Will you stop with the muffins and the urgent, breathy letters?"

"Absolutely," I said.

"Actually, send muffins anytime you want. I got no problem with muffins. But you need to stay on your side of town. Have one of your minions email me the files, and use a reasonable title, like 'Here is a case for you.' I'll send you my results back in an email titled 'Here are my results.' How does that sound?"

Shitty and untenable in the long term, actually, but I said, "If that's what it takes to get you back on my team," which was the truth. Just not the whole truth.

I couldn't work with Birdwine at a distance. Not indefinitely. I needed to see him on the regular; his binges happened at random intervals, but the signs of an impending one were cumulative. Today, right now, he could be months from breaking. The eye-rubbing, the little taps at his temple, these could simply be the stress of this unpleasant conversation. He could go in the house and not eye- rub or tap or drink himself into ugly oblivion for weeks and weeks. On the other hand, if the signs repeated and intensified, they were harbingers of an imminent disappearance that could leave me stranded at my deposition.

"Damn, but you're pushy, lady. I'd forgotten that, too," he said, and now he was laughing outright. "Okay. All right. Let's get this clear— I'm not on your team. I'm doing a job for you because you're paying me a stupid amount of money."

"Good enough," I said. It was a foot back in his doorway, and once I had a foot in, well, he was right. I was pretty damn pushy.

"I take it you need a fast turnaround?"

Birdwine asked. His hand, resting flat on the folder, almost covered it. Outside of his physical presence, it was easy to forget how large the gods had framed him: big hands, big feet, long thick thigh bones, massive wrists.

"I have to depo this guy on the twenty- fourth. Right now, I have zero leverage."

"How low can I go?" Birdwine asked, limbo style.

"Low as you like," I said. "This is a straight- up BANK case." BANK was my acronym, and it stood for "both assholes, no kids." BANKs were the best. They were lucrative, and I could fight as dirty as I liked without helpless teenagers or toddlers wandering into the crossfire. When there were kids, or if the client was a dear and tender soul, I had to move carefully, try to minimize the damage.

"Excellent," Birdwine said. He liked low roads just fine, but he shared my soft spot for little pawns caught sideways in divorce. It was another reason we worked so well together. "What am I looking for?"

"Sex," I said, with certainty.

Before I met Bryan Skopes, I knew just by looking at his file that he had more than earned the A in BANK. Sure, he was in the Rotary Club, and he served on the finance committee at his church. He made sure his aging father was well cared for. He no doubt thought of himself as a "good person." Most people do.

But his first wife got no alimony and her child support was a pittance, though she was raising the two daughters he rarely saw. His second wife was fifteen years his junior. She'd worked for him as a receptionist, which further weighted the relationship. I didn't see a "good person." I saw a narcissist with a sex- and- power complex fueled by a genuine disdain for women.

Meeting Skopes in the flesh had both confirmed and lowered my opinion. The stealthy look I'd clocked him running over me— it wasn't like a hungry man with empty pockets gazing at a buffet with no hope of more than a whiff. This had been the eye- flick of a sated gourmand, one who was getting well fed on the regular. That glance had been insulting, but not for having sex in it. It was insulting because he clearly felt entitled to it. He thought he had the upper hand in the negotiations, and that power differential turned him on more than my body. It made the righteous in his indignation ring false.

Our client was an asshole, too, no question. But even assholes deserve fair representation, especially when up against an equal and opposing asshole. In this case, I'd lucked into the lesser of two evils. Daphne was still evil, just lesser. Sure, Bryan Skopes thought of women as commodities, and sure, he had bought Daphne. But to be fair, she'd consented. I couldn't respect her; I didn't like her; it didn't matter. So she had sold herself— well, I was her lawyer. My job was to make Skopes finish paying for her.

"You mean a mistress?"

Birdwine asked. I shook my head. "Don't waste time hunting for a romantic meeting of true minds. Look lower— this guy has got the secret nasty oozing out his pores."

This was how we worked together; I found the weak spots, then I pointed Birdwine straight at them and shot him. Together we had many more hits than misses. If I was right, and if Birdwine could catch him, Skopes would have to dial down the accusing, wounded tone and bring something much more substantial than a car title to the table.

"I'm on it. We done?" Birdwine asked.

"Yeah. Thanks, Birdwine," I said.

"Please, call me Zachary." He gave me the close- lipped version of his smile, bland and insincere.

"Heh, I see what you did there." When he first started working for me, he'd told me only his ex- wife called him by his first name, and she'd remarried ten minutes after their divorce was final. These days she was living down in Florida, too busy squeezing out babies and pretending he was dead to call him anything. "I'll stay out of your way." I didn't add, for now.

He got out. I drove off to get some dinner, my worries about Skopes v. Skopes already fading. If Birdwine stayed sober, then this problem was already solved.

I wasn't sure he would stay sober, though. I became less sure as days passed with no word. Still, I stayed cool. Skopes and his lawyer, Jeremy Anderson, had been playing the delay game for months now. I could delay right back until Birdwine came through or until I found another way to break Skopes.

On February fourteenth, I stayed late researching a tricky precedent. By the time I finished, it was past eleven. I closed my computer down and got out my checkbook. I wrote Cash on the line that said Pay to the order of. My mother's legal name was Karen Vauss, but I had no idea what name Kai was floating in her current incarnation. I signed the check and ripped it from the book.

I put it in an envelope from my personal stationery— plush cream- colored paper with Paula Vauss and the address of my midtown loft engraved in dark burnt brown. I scrawled Kai's PO box number in Austin on the front and sealed it.

I sent her a check on the fifteenth of every month, both a ritual and my only form of communication with my mother for a decade and a half now.

It was my way of asking, Are we square yet?

Cashing it was her answer: You still owe me.

I paused before I threw it in my outbox, even though I had plans to meet up with a guy I knew. We were going to hook up at precisely 12:01, once Valentine's Day was safely over. Still, I lingered. I could let Verona send my paper proxy out with the rest of the mail, let it ask its monthly question, right on schedule. Or I could run it through the shredder.

I toyed with this choice every month. What would Kai do, if it simply didn't come? Silence might settle in between us, and I'd know I'd finally paid enough for nailing her gypsy feet down, stealing almost a decade of her freedom. Silence sounded close enough to peace for me to let it count. Either that, or she'd show up on my doorstep, demanding to cut a pound of flesh out of my body.

Not for the first time, I wondered what would happen if I got more aggressive. What if I mailed Kai a note instead? I pulled a legal pad toward me, then sat staring at it. Minutes passed, and the paper stayed word free. I needed to go home and change and feed Henry before my date. By now he would be marching up and down the stairs from the great room to the lofted bedroom, impatient for his wet food, but still I sat there, staring down at the blank page.

Finally I closed my eyes and felt my hand begin to move the pen against the paper. I wrote out the essential question, blind: What will it take to make us square?

When I looked at the words, I could see they were too blunt, too bald. Worse, they admitted culpability. I scratched them out and wrote instead: You named your kid for Kali, so what the fuck did you expect? You got exactly what you asked for.

That sounded more like me, but it wasn't at all mend- y. Well, making amends was not my forte; any fortes I had lay in the entirely opposite direction. I could break things in a thousand ways— anything from surgical dismantling as meticulous as bomb squad work to wrecking ball–style mass destruction. If I broke a thing, it stayed broke. If I broke one of my things, I lived with pieces or replaced it. I tore the page off and crumpled it up. I shot it at the wastebasket in the corner, and I nailed it for a cool three points. Screw it. I put the check in my outbox and, as always, setting it in motion was a relief. Kai was paid, so for a week or two, I could push her from my mind. Soon enough, she'd creep back in, making me feel faintly itchy until I wrote out her next check.

As I stood to go, I heard the ding of an email landing in my inbox. It was from Birdwine, titled just as he had promised: "Here are my results." Safe bet he wasn't asking me to be his valentine. What else was new? I sat back down and opened it. The body of the email said only, Yep, you called it. There were two attachments.

I opened the first and found a hefty, hefty bill. Heftier than I had expected. The next attachment was a PowerPoint file. I started clicking through the slides.

There was Bryan Skopes, seen from above, but still recognizable. He was good-looking in a blunt- faced, former frat boy way, but with too much scotch and too many fried oysters gathering in the paunches under his eyes and around his waist. He stood in a thicket of evergreen azaleas with a hollow heart. The bushes made a room that was well screened on all sides, but roofless.

The photos had been taken from above, and as far as I could tell, Birdwine had panthered his way very high up into a tree that overhung the thicket. He could have broken his neck, but he got the money shots: Bryan Skopes was not alone. A friend with magenta hair knelt in front of him, her face jammed between his legs. As the images progressed, his spine flexed back and his round, florid face tipped up. His mouth fell open, slack. His eyes were closed, or he might have made eye contact with Birdwine. I grinned at the thought; wouldn't that have been so disconcerting?

Near the end, I came to a slide that made me stop clicking forward through this common, sordid story. In this shot, the girl was still on her knees, but she was looking up at Skopes. Her face was round and smooth, fat- cheeked as a baby's, and the skin under her eyes was unlined and faintly pink. I felt a lemony trickle of something sour and sharp enter my blood. She was so young. Fifteen, maybe.

In the next slide, she was standing while Skopes packed himself away. In the next, their hands were touching, palm to palm as he passed her the money. The sour trickle in my blood became sharper and more acidic. So I was right twice: Skopes was cheating, and he liked his sex with an ugly power differential. This poor kid was so young and fresh she didn't know to get paid first. Another month of street living will fix that, I thought, and for once, being right didn't make me feel good.

I looked at her baby cheeks, her downturned mouth, and it was as if I knew her.

Hell, I could have become her. I knew girls who had become her, back when I was in foster care. Sometimes I still dreamed that I had fallen off the world with them. I would tip into sleep and find myself walking right off Earth's secret, jagged edge. I would hurtle past the world turtle, past Joya who tumbled limp and silent, past Candace who reached for me with needy-greedy eyes. Past everything, into an endless nothing. Not even stars.

I could have ended up exactly like this girl in Birdwine's slides, with her hennaed hair and her cheeks still full of baby fat. I could have spent my days crouched and shivering on my knees for some asshole standing in azaleas, and all at once, going after Bryan Skopes felt personal. I was no longer working only on behalf of Daphne. She was my client, which meant I'd bring my A game, sure—but I wasn't fond. Daphne was standard trophy wife material. Her main interests were grooming and toning so she could be attractive at cocktail receptions. She was blank and selfish and more than a little boring.

I had no doubt that Daphne had driven past plenty of girls like this magenta-haired creature. They were common enough in Atlanta. This kid was one of a thousand strung- out runaways all over the city, unwilling or unready to be salvaged, getting by in whatever way she could.

I felt certain Daphne had never once thought to buy a girl like this a sandwich or offer a ride to a shelter. But I also knew my client had never taken a kid like this into the bushes, used her like a Kleenex, and then handed her a wad of greasy money. I felt myself shifting from professional advocate to my own self, playing for my own stakes. If I had my way entirely, Skopes would go to prison and learn firsthand how hard life could be on the knees.

It wasn't feasible, and not only because it was against my client's interests. This girl he'd used was smoke, already gone. Maybe Birdwine could find her, given time and money, but she wasn't going to testify or press charges. I knew her kind.

So what I had left was hitting Bryan Skopes hard in the money sack, in his misapplied belief in his own good personhood, and most of all, in his gloating love of power over women. I could make him bend over for Daphne and for me. The very idea made my spine feel longer. I could feel myself growing taller. I ran my tongue over my teeth, hungry for next week's scheduled depo. How much had Skopes given to that girl? I wished I could see the money clearly. A couple of twenties? A fifty? I didn't know the going rate, but this I did know: Skopes was going to pay more than he'd ever thought for that one-off in the bushes.

I closed the PowerPoint and forwarded a copy to my partner Nick with a note: Can we get Daphne in here this week? I need to prep her.

I went to PayPal to send Birdwine the full amount of the bill from my own account, instantly, plus a sizable bonus. It would be a paperwork ass-pain to get reimbursed, but I wanted the speed to resonate with him. Usually his invoices had to go through Verona.

In the message box I typed, Thanks for the dirty pictures—better than a box of chocolates, but then I erased it. I barely had him back working for me. It was too soon to try for our old combative- flirty banter. I tried, See why I can't do without you, Birdwine? but that read too personal. After a moment's thought, I changed it to See why I can't do without you, Zachary?

Still too personal; he'd been very clear, in the car. I sent it blank, then started a fresh email with a different case file attached. I typed in, This guy's discovery is BS. He's hiding money. My bet? In something artsy- fartsy like sculpture or wine. Find it? Regular rates. I hit send and waited.

Excerpted from The Opposite of Everyone by Tom Jackson. Copyright © 2016 by Tom Jackson. Excerpted by permission of William Morrow. All rights reserved. No part of this excerpt may be reproduced or reprinted without permission in writing from the publisher.

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!

Beyond the Book:
  The Tridevi in Hinduism

BookBrowse Book Club

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

Members Recommend

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

The low brow and the high brow

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /excerpts/index.cfm
Time Stamp 01-Jun-26 09:21 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
1780305662999 ms 1.780305663E+012 ms 1 /root/website/app_server.cfm
2881 ms 2881 ms 1 /root/website/excerpts/index.cfm
1899 ms 1899 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
227 ms 227 ms 1 /root/website/app_layout.cfm
224 ms 224 ms 1 /root/website/queries/qry_get_book_by_id.cfm
170 ms 170 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
151 ms 151 ms 1 /root/website/app_globals.cfm
108 ms 54 ms 2 /root/website/adsystem/adsystem_mod.cfm
107 ms 107 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
83 ms 83 ms 1 /root/website/queries/qry_get_active_obc.cfm
83 ms 83 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
82 ms 82 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
61 ms 61 ms 1 /root/website/adzones/AdZone6.cfm
53 ms 53 ms 1 /root/website/excerpts/dsp_main.cfm
48 ms 48 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
47 ms 47 ms 1 /root/website/adzones/showcase_track.cfm
38 ms 38 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
37 ms 37 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
35 ms 35 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
30 ms 30 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
27 ms 27 ms 1 /root/website/queries/qry_get_current_competition.cfm
22 ms 22 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
16 ms 16 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
15 ms 15 ms 1 /root/website/actions/adstatus.cfm
11 ms 11 ms 1 /root/website/queries/qry_get_member_account_types.cfm
11 ms 11 ms 1 /root/website/site/blocks/membership_advantages.cfm
7 ms 2 ms 3 /root/website/actions/act_spider_tracker.cfm
6 ms 6 ms 1 /root/website/act_check_login.cfm
5 ms 5 ms 1 /root/website/queries/qry_get_member_info.cfm
5 ms 5 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
4 ms 4 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_current_ezine.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
1 ms 1 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/site/blocks/act_book_view_tracking.cfm
1 ms 1 ms 1 /root/website/site/blocks/dsp_closed_readalikes.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/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_awards.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_btb.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_closed_reviews.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.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
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
2882 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

09:21:05.005 - Expression Exception - in /root/website/site/blocks/dsp_top_book_block.cfm : line 237
	    Variable BOOK_NUMBER is undefined.
	    


SQL Queries

spidercheck (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 09:21:03.003
SELECT	a.bot_number
        FROM	bots a
        WHERE	charindex(a.bot_name, ?) > 0
		OR a.bot_ip = ?
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Parameter #2(cf_sql_varchar) = 127.0.0.1

get_member_info (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 09:21:03.003
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=14ms, Records=2) in /root/website/actions/adstatus.cfm @ 09:21:03.003
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=1ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 09:21:03.003
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=4ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 09:21:03.003
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 @ 09:21:03.003
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=13ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 09:21:03.003
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 09:21:03.003
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=15ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 09:21:03.003
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=46ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 09:21:03.003
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=20ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 09:21:03.003
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_book_by_id (Datasource=bookbrowse_com_new, Time=15ms, Records=1) in /root/website/queries/qry_get_book_by_id.cfm @ 09:21:03.003
SELECT		a.book_number, a.book_title, a.book_sub_title, a.book_url, a.book_entry_dt, a.book_short_summary, a.book_excerpt, a.book_jacket_info, a.book_reading_guide, a.book_copyright_info, a.book_notes,
            	b.author_number, b.author_first_name, b.author_last_name, b.author_middle_initial,
            	f.edition_publish_dt AS "hardcover_publish_dt", f.edition_number_of_pages AS "hardcover_number_of_pages", f.edition_isbn AS "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13", f.edition_jacket_image as "hardcover_jacket_image", f.edition_publisher as "hardcover_publisher",
            	g.edition_publish_dt AS "paperback_publish_dt", g.edition_number_of_pages AS "paperback_number_of_pages", g.edition_isbn AS "paperback_isbn", g.edition_isbn13 "paperback_isbn13", g.edition_jacket_image as "paperback_jacket_image", g.edition_publisher as "paperback_publisher",
            	i.author_info_interview, i.author_info_biography,i.author_info_image,
            	CASE WHEN datalength(author_middle_initial) = 1 THEN author_first_name + ' ' + author_middle_initial + ' ' + author_last_name
            		 ELSE author_first_name + ' ' + author_last_name
            		 END "author_name",
            	CASE WHEN 
					(select count(*) from editions where book_number = 4364) = 1
					AND
					(select count(*) from editions where book_number = 4364 and edition_paperback_flag = 1) = 1
				THEN 1
				ELSE 0
				END AS "po_flag",
				(select count(*) from book_author_mapping m where m.author_number = b.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = b.author_number and ezine_preview_bb_link =0)
				 as 'author_bookcount',
            	(SELECT CAST(AVG(CAST(rating AS decimal(12,0))) AS decimal(12,1))
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) "savrating",
			(SELECT COUNT(rating)
				FROM (
					SELECT reader_review_rating AS rating
					FROM reader_reviews
					WHERE book_number = a.book_number
					AND reader_review_rating > 0
					
					UNION ALL
					
					SELECT reading_list_book_rating AS rating
					FROM reading_lists
					WHERE book_number = CAST(a.book_number AS VARCHAR)
					AND reading_list_book_rating > 0
				) combined_ratings
			) as "savrating_count",
            	(select top 1 media_review_rating from media_reviews where book_number = a.book_number and media_review_type_number = 9) as "bbrating",
            	(select cast(AVG(CAST(media_review_rating AS numeric(12,2)))AS decimal(12,1)) from media_reviews where book_number = a.book_number and media_review_type_number <> 7 and media_review_rating > 0) "scritrating",
				(SELECT COUNT(media_review_rating) FROM media_reviews WHERE book_number = a.book_number AND media_review_type_number <> 7 AND media_review_rating > 0) as "scritrating_count",
            	(select top 1 gg.ezine_number from ezine_edition_mapping aa, editions bb, books cc, ezines gg            	
            	where aa.edition_number = bb.edition_number and bb.book_number = cc.book_number and aa.ezine_number = gg.ezine_number 
            	and cc.book_number = a.book_number and gg.ezine_bbsays_flag = 1 and gg.ezine_active_flag = 1) as "ezine_number",
				cgm.category_number,
				cgya.category_number AS "ya_flag"
				
,(select top 1 publisher_holding_company from publishers where (publisher_imprint like f.edition_publisher OR publisher_imprint like g.edition_publisher) AND publisher_holding_company LIKE 'Harper%') AS "publisher_holding_company"		
        
    FROM		books a 
    INNER JOIN	book_author_mapping c ON c.book_number = a.book_number
    INNER JOIN	authors b ON b.author_number = c.author_number  
    INNER JOIN	author_info i ON i.author_number = b.author_number
    
    LEFT JOIN	editions f ON f.book_number = a.book_number AND f.edition_paperback_flag = 0
    LEFT JOIN	editions g ON g.book_number = a.book_number AND g.edition_paperback_flag = 1
    LEFT JOIN	category_book_mapping cgm on cgm.book_number = a.book_number AND cgm.category_number = 48
    LEFT JOIN	category_book_mapping cgya on cgya.book_number = a.book_number AND cgya.category_number = 40
          
    WHERE 		a.book_number = ?
         
    ORDER BY	c.book_author_mapping_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=209ms, Records=7) in /root/website/queries/qry_get_book_by_id.cfm @ 09:21:03.003
SELECT		a.media_review_number, 
				a.book_number, 
				a.media_review_type_number, 
				a.media_review_title, 
				a.media_review_rating, 
				a.media_review, 
				a.media_review_old,
	
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 (case when dbo.WordCount(c.ezine_review_2) > 0 then dbo.WordCount(c.ezine_review_2) + dbo.WordCount(c.ezine_extras) 
                                                                                    else dbo.WordCount(c.ezine_review) 
                                                                                    end)
                                                                from ezine_edition_mapping c
                                                                INNER JOIN editions d ON (d.edition_number = c.edition_number)
                                                                INNER JOIN ezines e ON e.ezine_number = c.ezine_number
                                                                WHERE d.book_number = ?
                                                                
                                                                ORDER BY e.ezine_number ASC)
	 			ELSE 0 
	 			END  "wordc",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_number
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			ELSE 1
				END "reviewer_number",
				
				CASE WHEN a.media_review_type_number = 9 THEN 	(select top 1 reviewer_first_name + ' ' + reviewer_last_name AS "reviewer_name"
		 														 from ezine_edition_mapping c
		 														 INNER JOIN editions d ON (d.edition_number = c.edition_number)
																 INNER JOIN ezines e ON e.ezine_number = c.ezine_number
																 INNER JOIN reviewers r on r.reviewer_number = c.reviewer_number
		 														 WHERE d.book_number = ?
		 														 AND e.ezine_bbsays_flag = 1
																 ORDER BY d.edition_publish_dt DESC)
	 			END "reviewer_name"
	
	FROM		media_reviews a, media_review_types b
	
	WHERE		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
	AND			a.book_number = ?
	AND			a.media_review_type_number = b.media_review_type_number
	
	ORDER BY	b.media_review_type_sort_order ASC, media_review_rating DESC, media_review_title ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355
Parameter #2(CF_SQL_INTEGER) = 3355
Parameter #3(CF_SQL_INTEGER) = 3355
Parameter #4(CF_SQL_INTEGER) = 3355

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=35ms, Records=32) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 09:21:03.003
select 		a.reader_review_number, a.book_number, a.reader_review_approved_flag, a.reader_review_dt,
				COALESCE(NULLIF(LTRIM(RTRIM(m.discourse_username)), ''), NULLIF(LTRIM(RTRIM(a.reader_review_reviewer_name)), '')) AS reader_review_reviewer_name,
				a.reader_review_reviewer_email_address, a.reader_review_reviewer_from_locale, a.reader_review_recommended, a.reader_review_rating, a.reader_review_title, a.reader_review_description, ISNULL(a.like_count, 0) AS like_count,
    			b.book_title,
    			ISNULL(e.edit_count, 0) AS edit_count,
    			e.last_edit_dt,
    			a.member_number AS review_member_number
    from 		reader_reviews a
    LEFT OUTER JOIN (
    	SELECT reader_review_number, COUNT(*) AS edit_count, MAX(edited_dt) AS last_edit_dt
    	FROM   reader_review_edits
    	GROUP BY reader_review_number
    ) e ON e.reader_review_number = a.reader_review_number
    LEFT OUTER JOIN members m ON m.member_number = a.member_number,
    			books b
    where 		a.book_number IN (select distinct c.book_number from categories a, category_book_mapping b, book_author_mapping c where a.category_number = b.category_number and a.category_active_flag = 1 and b.book_number = c.book_number)
    and 		a.book_number = ?
    and 		a.reader_review_approved_flag = 1
    and 		a.book_number = b.book_number
    

    order by a.reader_review_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 09:21:03.003
select 		c.book_awards_category_number, c.book_awards_category_name, c.book_awards_category_sort_order,
				m.book_awards_mapping_number, m.book_award_dt,
                a.book_award_number, a.book_award_image, a.book_award_name
                
                
	from 		book_awards_mapping m
	inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    inner join	book_awards a on a.book_award_number = c.book_award_number
    
	where 		m.book_number = ?
    
    order by	c.book_awards_category_sort_order ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=13ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 09:21:03.003
select	book_number
    
    from	category_book_mapping a, categories b, top_categories t
    
    where	t.top_category_number = b.top_category_number
    and		b.category_number = a.category_number
    and		t.top_category_number = 9
    and		a.book_number = ?
    and		b.category_visible_flag = 1
	and		a.book_number not in (	select book_number 
    									from 		book_awards_mapping m
													inner join 	book_awards_category c on c.book_awards_category_number = m.book_awards_category_number
    												inner join	book_awards a on a.book_award_number = c.book_award_number
                                    	where m.book_number = ? 
                                    	and a.book_award_number = 7)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355
Parameter #2(CF_SQL_INTEGER) = 3355

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=16ms, Records=4) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 09:21:03.003
SELECT 		b.book_title, b.book_number,
    			c.book_title "referenced_book_title", c.book_number AS "liked_book_number", c.book_short_summary as "liked_short_summary",
            	e.*,
                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 "author_name",
				(select top 1 edition_publish_dt from editions where editions.book_number = c.book_number order by edition_publish_dt DESC) as 'sortdate',
				(select count(*) from book_author_mapping m where m.author_number = d.author_number)
				+
				(select count(*) from ezine_previews where ezine_preview_bb_author_link = d.author_number and ezine_preview_bb_link =0)
				 as 'liked_author_bookcount'
                
	FROM 		liked a
	INNER JOIN	books b ON b.book_number = a.book_number
	INNER JOIN	books c ON c.book_number = a.liked_book_number
	INNER JOIN	book_author_mapping d ON c.book_number = d.book_number
	INNER JOIN	authors e ON d.author_number = e.author_number
    
    WHERE 		a.book_number = ?
    
	ORDER BY 	sortdate desc, c.book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=17ms, Records=5) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 09:21:03.003
select 		distinct a.category_number, a.top_category_number, a.category_name, a.category_description, a.category_meta_keywords, a.category_active_flag, a.category_visible_flag, a.category_member_only_flag, a.category_qry_template, a.category_sort_order, a.category_tag_size,
    			b.*
	
    from 		categories a
	left join	top_categories b on a.top_category_number = b.top_category_number
	left join	category_book_mapping c on c.category_number = a.category_number
	
    where 		a.category_active_flag = 1
    and 		a.category_visible_flag = 1
	and 		c.book_number = ?
	

    order by 	b.top_category_sort_order, b.top_category_name, a.category_sort_order, a.category_name
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

bb_review (Datasource=, Time=0ms, Records=1) in /root/website/excerpts/index.cfm @ 09:21:03.003
SELECT media_review, reviewer_number from get_media_reviews_by_book_id where media_review_type_number = 9
get_arc_idfk (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:21:03.003
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_bb_link = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3355

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:21:03.003
SELECT 		a.arc_forumidfk,a.discourse_flag
    FROM 		arcs a
    INNER JOIN 	ezine_previews e on e.ezine_preview_number = a.ezine_preview_number
    
	
        WHERE 		e.ezine_preview_bb_link = ? 
    AND DATALENGTH(a.arc_forumidfk) > 0 AND arc_obc_flag=1 AND a.discourse_flag = 0
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3355

obc_discussions (Datasource=booktalk_new, Time=1798ms, Records=20) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:21:05.005
SELECT 		t.name,
                m.title, m.body,
                u.username, t.id,
				(SELECT COUNT(*) from booktalk_messages where threadidfk = t.id) AS	"responses"
                
    FROM 		booktalk_forums f
    INNER JOIN	booktalk_threads t on t.forumidfk = f.id
    INNER JOIN	booktalk_messages m on m.posted = t.lastpostcreated
    INNER JOIN	booktalk_users u on u.id = m.useridfk
    
    WHERE 	f.id = ?
    AND 	f.active = 1
	AND		t.active = 1
    
    ORDER BY t.name, t.messages DESC
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 838019D9-C22E-8D70-58E652057F1C29D9

searchResults (Datasource=bookbrowse_com_new, Time=71ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 09:21:05.005
SELECT book_number, post_id, topic_id, blurb, username, topic_title
					FROM DiscourseSearchResults
					
        WHERE 		book_number = ? 
                    AND topic_id IS NOT NULL
Query Parameter Value(s) -
Parameter #1(cf_sql_varchar) = 3355

get_ezine_type (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 09:21:05.005
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 09:21:05.005
SELECT TOP 1  
                a.ezine_short_title, a. ezine_boxed_content_title, a.ezine_boxed_content, a.ezine_review, a.ezine_review_2,
                b.edition_paperback_flag, b.edition_publish_dt, b.edition_isbn,
                c.book_title, c.book_sub_title, c.book_reading_guide, c.book_excerpt, c.book_number,
                e.author_first_name, e.author_middle_initial, e.author_last_name, e.author_number, 
                f.author_info_biography, 
                g.ezine_number, g.ezine_dt, g.ezine_bbsays_flag,
				i.article_category_number, i.article_category_name
		
	FROM    	ezine_edition_mapping AS a 
		
	INNER JOIN 	editions AS b ON (a.edition_number = b.edition_number)
	INNER JOIN 	books AS c ON (b.book_number = c.book_number )
	INNER JOIN 	book_author_mapping AS d ON (c.book_number = d.book_number )
	INNER JOIN 	authors AS e ON (d.author_number = e.author_number )
	INNER JOIN 	author_info AS f ON (e.author_number = f.author_number)
	INNER JOIN 	ezines AS g ON (a.ezine_number = g.ezine_number)
	LEFT JOIN	article_ezine_edition_mapping h ON h.ezine_edition_mapping_number = a.ezine_edition_mapping_number
	LEFT JOIN	article_categories i ON i.article_category_number = h.article_category_number

	WHERE		c.book_number = ?
	AND			g.ezine_bbsays_flag = 1
	AND			g.ezine_active_flag = 1
	
	
	ORDER BY 		g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

check_permalink (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

check_editors_choice (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 	count(*) as "count"
    FROM 	books
    WHERE 	book_number = ?
    AND		book_number IN (SELECT		top 4 a.book_number
                            FROM		editors_choice a 
                            WHERE		editors_choice_dt < getdate()
                            ORDER BY	editors_choice_dt DESC)
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

check_free_ezine (Datasource=bookbrowse_com_new, Time=6ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			ezine_edition_free_review_flag = 1
	AND			dateadd(ww,4,b.ezine_dt) > getdate()
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

check_cat_73 (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 		count(*) as "count"
    FROM    	books AS b
    INNER JOIN 	category_book_mapping AS c ON c.book_number = b.book_number
    WHERE 		b.book_number = ?
	AND			c.category_number = 73
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_ezine_status (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

check_old_ezine (Datasource=bookbrowse_com_new, Time=14ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 		count(*) as "count"
    FROM    	ezine_edition_mapping AS a
    INNER JOIN 	ezines b ON b.ezine_number = a.ezine_number
    INNER JOIN	editions c ON c.edition_number = a.edition_number
    WHERE 		c.book_number = ?
	AND			datediff(mm,b.ezine_dt,getdate()) > 12
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_ezine_status (Datasource=bookbrowse_com_new, Time=18ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 09:21:05.005
SELECT 	top 1 g.ezine_active_flag, ezine_dt, book_title
FROM		ezine_edition_mapping AS a 
INNER JOIN	editions AS b ON (a.edition_number = b.edition_number)
INNER JOIN	books AS c ON (b.book_number = c.book_number)
INNER JOIN	ezines AS g ON (a.ezine_number = g.ezine_number)
WHERE		c.book_number = ?
ORDER BY	g.ezine_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_coauthor (Datasource=bookbrowse_com_new, Time=29ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_coauthor (Datasource=bookbrowse_com_new, Time=21ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_coauthor (Datasource=bookbrowse_com_new, Time=24ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_coauthor (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_book_image (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
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) = 3355

get_book_image (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
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) = 3355

get_coauthor (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/actions/udfs.cfm @ 09:21:05.005
select 		book_number, 
            			CASE	WHEN datalength(d.author_middle_initial) > 1 
				                THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
				                ELSE d.author_first_name + ' ' + d.author_last_name
                        END "author",
                        d.author_number
            from		book_author_mapping e
            inner join	authors d ON e.author_number = d.author_number
            where		e.book_number = ?
			order by	book_author_mapping_number ASC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3355

get_member_account_types (Datasource=bookbrowse_com_new, Time=10ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 09:21:05.005
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=25ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:21:05.005
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=56ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 09:21:05.005
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=30ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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=18ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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=9ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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=21ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 09:21:05.005
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 09:21:05.005
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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=12ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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=14ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 09:21:05.005
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/excerpts/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=4093710; 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%3D4093710%26CFTOKEN%23%3D62a6977aa1d0969e%2D18DB730B%2DF44A%2DC056%2D0ADA11C891474B82%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2009%3A21%3A02%27%7D%23hitcount%3D79%23timecreated%3D%7Bts%20%272026%2D06%2D01%2009%3A20%3A47%27%7D%23cftoken%3D62a6977aa1d0969e%2D18DB730B%2DF44A%2DC056%2D0ADA11C891474B82%23cfid%3D4093710%23; CFTOKEN=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82; FREEACCESSCOUNT=0
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=/book_number/3355/page_number/3/the-opposite-of-everyone
PATH_TRANSLATED=/root/website/excerpts/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/excerpts/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=4093710
cftoken=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
hitcount=96
lastvisit={ts '2026-06-01 09:21:05'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 09:20:47'}
urltoken=CFID=4093710&CFTOKEN=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
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#=4093710&CFTOKEN#=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82#lastvisit={ts '2026-06-01 09:21:02'}#hitcount=79#timecreated={ts '2026-06-01 09:20:47'}#cftoken=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82#cfid=4093710#
CFID=4093710
CFTOKEN=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
FREEACCESSCOUNT=0
Session Variables:
cfid=4093710
cftoken=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
sessionid=BOOKBROWSE_4093710_62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
urltoken=CFID=4093710&CFTOKEN=62a6977aa1d0969e-18DB730B-F44A-C056-0ADA11C891474B82
URL Parameters:
book_number=3355
page_number=3
the-opposite-of-everyone=
Debug Rendering Time: 21 ms