Excerpt from The Emperor's Children by Claire Messud, plus links to reviews, author biography & more

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

The Emperor's Children by Claire Messud

The Emperor's Children

by Claire Messud
  • BookBrowse Review:
  • Critics' Consensus (7):
  • Readers' Rating (11):
  • First Published:
  • Aug 29, 2006, 448 pages
  • Paperback:
  • Jun 2007, 496 pages
  • Rate this book

About this Book

Print Excerpt

Our Chef Is Very Famous in London

Darlings! Welcome! And you must be Danielle?” Sleek and small, her wide eyes rendered enormous by kohl, Lucy Leverett, in spite of her resemblance to a baby seal, rasped impressively. Her dangling fan earrings clanked at her neck as she leaned in to kiss each of them, Danielle too, and although she held her cigarette, in its mother-of-pearl holder, at arm’s length, its smoke wafted between them and brought tears to Danielle’s eyes.

Danielle didn’t wipe them, for fear of disturbing her makeup. Having spent half an hour putting on her face in front of the grainy mirror of Moira and John’s bathroom, ogling her imperfections and applying vigorous remedial spackle—beneath which her weary, olive-shaped eyes were pouched by bluish bags, the curves of her nostrils oddly red, and her high forehead peeling—she had no intention of revealing to strangers the disintegration beneath her paint.

“Come in, darlings, come in.” Lucy moved behind them and herded the trio toward the party. The Leveretts’ living room was painted a deep purple—aubergine, in local parlance—and its windows were draped with velvet. From the ceiling hung a brutal wrought iron chandelier, like something salvaged from a medieval castle. Three men loitered by the bay window, talking to one another while staring out at the street, their glasses of red wine luminous in the reflected evening light. A long, plump, pillowed sofa stretched the length of one wall, and upon it four women were disposed like odalisques in a harem. Two occupied opposite ends of the divan, their legs tucked under, their extended arms caressing the cushions, while between them one rested her head upon another’s lap, and smiling, eyes closed, whispered to the ceiling while her friend stroked her abundant hair. The whole effect was, for Danielle, faintly cloudy, as if she had walked into someone else’s dream. She kept feeling this, in Sydney, so far from home: she couldn’t quite say it wasn’t real, but it certainly wasn’t her reality.

“Rog? Rog, more wine!” Lucy called to the innards of the house, then turned again to her guests, a proprietorial arm on Danielle’s bicep. “Red or white? He’s probably even got pink, if you’re after it. Can’t bear it myself—so California.” She grinned, and from her crows’ feet, Danielle knew she was forty, or almost.

Two men bearing bottles emerged from the candlelit gloom of the dining room, both slender, both at first glance slightly fey. Danielle took the imposing one in front, in a pressed lavender shirt and with, above hooded eyes, a high, smooth Nabokovian brow, to be her host. She extended a hand. “I’m Danielle.” His fingers were elegant, and his palm, when it pressed hers, was cool.

“Are you now?” he said.

The other man, at least a decade older, slightly snaggletoothed and goateed, spoke from behind his shoulder. “I’m Roger,” he said. “Good to see you. Don’t mind Ludo, he’s playing hard to get.”

“Ludovic Seeley,” Lucy offered. “Danielle—”

“Minkoff.”

“Moira and John’s friend. From New York.”

“New York,” Ludovic Seeley repeated. “I’m moving there next month.”

“Red or white?” asked Roger, whose open shirt revealed a tanned breast dotted with sparse gray hairs and divided by a narrow gold chain.

“Red, please.”

“Good choice,” said Seeley, almost in a whisper. He was—she could feel it rather than see it, because his hooded eyes did not so much as flicker—looking her up and down. She hoped that her makeup was properly mixed in, that no clump of powder had gathered dustily upon her chin or cheek.

The moment of recognition was, for Danielle, instantaneous. Here, of all places, in this peculiar and irrelevant enclave, she had spotted a familiar. She wondered if he, too, experienced it: the knowledge that this mattered. Ludovic Seeley: she did not know who he was, and yet she felt she knew him, or had been waiting for him. It was not merely his physical presence, the long, feline slope of him, a quality at once loose and controlled, as if he played with the illusion of looseness. Nor was it the timbre of his voice, deep and yet not particularly resonant, its Australian inflection so slight as to be almost British. It was, she decided, something in his face: he knew. Although what he knew she could not have said. There were the eyes, a surprising deep and gold-flecked gray, their lines slightly downturned in an expression both mournful and amused, and the particular small furrow that cut into his right cheek when he smiled even slightly. His ears, pinned close to his head, lent him a tidy aspect; his dark hair, so closely shaven as to allow the blue of his scalp to shine through, emphasized both his irony and his restraint. His skin was pale, almost as pale as Danielle’s own, and his nose a fine, sharp stretch of cartilage. His face, so distinctive, struck her as that of a nineteenth-century portrait, a Sargent perhaps, an embodiment of sardonic wisdom and society, of aristocratic refinement. And yet in the fall of his shirt, the line of his torso, the graceful but not unmanly movement of his slender fingers (and yes, discreetly, but definitely there, he had hair on the backs of his hands—she held to it, as a point of attraction: men ought not to be hairless), he was distinctly of the present. What he knew, perhaps, was what he wanted.

“Come on, darling.” Lucy took her by the elbow. “Let’s introduce you to the rest of the gang.”





This, dinner at the Leveretts’, was Danielle’s last evening in Sydney before heading home. In the morning, she would board the plane and sleep, sleep her way back to yesterday, or by tomorrow, to today, in New York. She’d been away a week, researching a possible television program, with the help of her friend Moira. It wouldn’t be filmed for months, if it were filmed at all, a program about the relationship between the Aborigines and their government, the formal apologies and amends of recent years. The idea was to explore the possibility of reparations to African Americans—a high-profile professor was publishing a book about it—through the Australian prism. It wasn’t clear even to Danielle whether this could fly. Could an American audience care less about the Aborigines? Were the situations even comparable? The week had been filled with meetings and bluster, the zealous singing exchanges of her business, the pretense of certainty where in fact there was none at all. Moira firmly believed it could be done, that it should be done; but Danielle was not convinced.

Sydney was a long way from home. For a week, in her pleasant waft of alienation, Danielle had indulged the fantasy of another possible life—Moira, after all, had left New York for Sydney only two years before—and with it, another future. She rarely considered a life elsewhere; the way, she supposed, with faint incredulity, most people never considered a life in New York. From her bedroom in her friends’ lacy tin-roofed row house at the end of a shady street in Balmain, Danielle could see the water. Not the great sweep of the harbor, with its arcing bridge, nor the ruffled seagull’s wings of the opera house, but a placid stretch of blue beyond the park below, rippled by the wake of occasional ferries and winking in the early evening sunlight.

Early autumn in Sydney, it was still bitter at home. Small, brightly colored birds clustered in the jacaranda trees, trilling their joyous disharmonies. In earliest morning, she had glimpsed, against a dawn-dappled shrub in the backyard, an enormous dew-soaked spiderweb, its intricacies sparkling, and poised, at its edge, an enormous furry spider. Nature was in the city, here. It was another world. She had imagined watching her 747 soar away without her, a new life beginning.

But not really. She was a New Yorker. There was, for Danielle Minkoff, only New York. Her work was there, her friends were there—even her remote acquaintances from college at Brown ten years ago were there—and she had made her home in the cacophonous, cozy comfort of the Village. From her studio in its bleached-brick high-rise at Sixth Avenue and Twelfth Street, she surveyed lower Manhattan like a captain at the prow of her ship. Beleaguered and poor though she sometimes felt, or craving an interruption in the sea of asphalt and iron, a silence in the tide of chatter, she couldn’t imagine giving it up. Sometimes she joked to her mother—raised, as she herself had been, in Columbus, Ohio, and now a resident of Florida—that they’d have to carry her out feet first. There was no place like New York. And Australia, in comparison, was, well, Oz.

This last supper in Sydney was a purely social event. Where the Leveretts lived seemed like an area in which one or two ungentrified Aboriginal people might still linger, gray-haired and bleary, outside the pub at the end of the road: people who, pint in hand, hadn’t accepted the government’s apology and moved on. Or perhaps not, perhaps Danielle was merely imagining the area, its residents, as they had once been: for a second glance at the BMWs and Audis lining the curb suggested that the new Sydney (like the new New York) had already, and eagerly, edged its way in.

Moira was friendly with Lucy Leverett, who owned a small but influential gallery down at The Rocks that specialized in Aboriginal art. Her husband, Roger, was a novelist. As John parked the car outside the Leveretts’ large Victorian row house, Moira had explained, “Lucy’s great. She’s done a lot on the art scene here. And if you want to meet Aboriginal artists, to talk to them for the film, she’s your woman.”

“And he?”

“Well”—John had pulled a rueful moue—“his novels are no bloody good—”

“But we like him,” Moira finished firmly.

“I’ll give him this much, he’s got great taste in wine.”

“Roger’s lovely,” Moira insisted. “And it’s true about his books, but he’s very powerful here in Sydney. He could really help you, if you needed him.”

“Roger Leverett?” Danielle thought a moment. “I’ve never heard of him.”

“Not surprised.”

“As in ‘our chef is very famous in London.’ ”

“Come again?”

“There’s a nasty-looking little Chinese restaurant in the East Village with a handwritten sign in the window—a dirty window, too—that says ‘our chef is very famous in London.’ But not in New York, or anywhere else outside of London.”

“And probably not in London either, eh?” John had said, as they approached the Leveretts’ front door.

“Roger Leverett is very famous in Sydney, sweetheart, whatever you say.”





At supper—prawns and quails’ eggs with squid-ink noodles, followed by emu, which closely resembled steak and which she had to force herself to eat—Danielle sat between Roger and a beautiful Asian boy—Ito? Iko?—who was the boyfriend of an older architect named Gary at the other end of the table. Ludovic Seeley sat next to Moira, his arm languidly and familiarly draped over the back of her chair, and he leaned in to speak to her as though confiding secrets. Danielle glanced over every so often, unable to stop herself, but did not once, until the passion fruit sorbet was before them, find him looking her way. When he did, his spectacular eyes seemed again amused, and they did not waver. It was she who lowered her gaze, shifting in her chair and feigning sudden interest in Ito/Iko’s recent trip to Tahiti.

The evening now seemed to her an elaborate theater, the sole purpose of which was meeting Ludovic Seeley. That anyone could care for Lucy or Roger or Gary or Ito/Iko in the way Danielle cared for her friends in New York seemed almost implausible: these people, to her, were actors. Only Ludovic was, in his intimate whisperings and unbroken glances, very real. Whatever that meant. Reality, or rather, facing it, was Danielle’s great credo; although if she were wholly honest, here and now, she believed a little in magic, too.

Roger, beside her, was jovial and solicitous. Mostly, Danielle felt her host was a narcissist, delighted by the sound of his own voice and the humor of his own jokes, and by the pipe he fiddled with and sucked upon between courses. He was generous with the red wine, more so to her and himself than to those farther afield, and he grew more positively loquacious with each glass.

“Been to McLaren Vale? Not this time? When do you leave? Ah, well then. Next time, promise me you’ll get to South Australia, do the wine route. And there’s great scuba diving off the coast. Been scuba diving? No, well, I can see you might be intimidated. I used to do a lot of diving in my day, but you can get yourself in some very nasty situations, very nasty indeed. About twenty years ago—I wasn’t much older than you are now—how old are you? Thirty? Well, you don’t look it, my girl. Such fine skin. It must be those fine Jewish genes—you are Jewish, aren’t you? Yes, well, anyway, the Reef. I was up diving with some mates, this is before Lucy, she’d never let me do it now. I was living up near Brisbane, finishing my second novel—Revelation Road, you probably don’t know it? No, well, I’m not vain about these things. It was a great success at the time. And anyway, this trip out to the Reef was the reward, you know, for a job well done, the editor was jumping up and down in Sydney he was so mad about the manuscript, but I said, screw it, George, I’m entitled to celebrate before I come back, because once you’re in this world you’re in it, aren’t you? So where was I? The Reef, yes. It was my first time out there, by helicopter, of course—first time in a copter, if you can believe it—and we were four blokes . . .”

Roger’s blithe torrent grew murkier to Danielle with each sip of claret, and she pasted her smile—quite genuine; she was enjoying herself, and lord knew it wasn’t effortful—in permanence upon her face. She smiled while slurping the inky noodles, while dissecting the antennaed prawns. She felt as though she smiled even while chewing the rather tough emu fillet, plucking the dense slices from their bed of bloodied polenta. She smiled while glancing at Ludovic Seeley, who did not glance back, and smiled at Moira, at Lucy, at John in turn. When Roger went to fetch the dessert—“I do the wine, my dear, and the clearing up. The fetching and carrying. And I make the meanest risotto you’ll ever taste, but not tonight, not tonight”—Danielle turned to Ito/Iko and learned that he was twenty-two, an apprentice in a fashion house, that he’d known Gary eight months, and that they’d recently had the most fabulous holiday in Tahiti, “very Gauguin, and so sexy. I mean, the people on that island are so sexy, it’s to die.”

“Is that where Captain Cook got killed, in the end?” Danielle asked, feeling very culturally au fait to be dropping the founder’s name.

“Oh no, doll, that was Hawaii. Very different vibe altogether. Totally different.” Ito/Iko flashed a broad smile and fluffed at his hair, which was, she decided, slightly tinted with blue, and glistening in the candlelight. “You haven’t been here very long, have you? Because everyone knows it was Hawaii. I mean, I know it was Hawaii, and I dropped out of school at sixteen.”





After the meal, the party resettled in the living room, where Ito/Iko curled under Gary’s arm like a chick beneath a hen’s wing. Danielle gratefully abandoned her wineglass at the table, and sat sipping water as movement and general conversation buzzed around her in a pleasant fog. She felt a thrill of alarm—of life—when Ludovic Seeley took the armchair to her right.

“What takes you to New York?” she asked.

He leaned in, as she’d seen him do with Moira: intimacy, or the impression of it, was clearly his mode. But he did not touch her. His shirt cuff glowed against the plum velvet of the chair arm. “Revolution,” he said.

“I’m sorry?”

“I’m going to foment revolution.”

She blinked, sipped, attempted silently to invite elucidation. She didn’t want to seem to him unsubtle, unironic, American.

“Seriously? Seriously, I’m going to edit a magazine.”

“What magazine is that?”

“The Monitor.”

She shook her head.

“Of course you haven’t heard of it—I haven’t got there yet. It doesn’t exist yet.”

“That’s a challenge.”

“I’ve got Merton behind me. I like a challenge.” Danielle took this in. Augustus Merton, the Australian mogul. Busy buying up Europe, Asia, North America. Everything in English and all to the right. The enemy.

Lucy, bearing coffee, appeared suddenly, tinily, before them. “He’s done it before, Danielle. He’s a man to be afraid of, our Ludo. He’s got all the politicians and the journos on the run in this town. The True Voice—have you seen it?”

“Oh. Moira told me about it. I mean, she told me about you.”

“We don’t see eye to eye on pretty much anything,” Lucy said with a conciliatory smile at Seeley, touching her delicate hand with its black nail polish to his lavender shoulder. “But my God, this bloke makes me laugh.”

He bowed his head slightly. “A true compliment. And the first step on the road to revolution.”

“And now you’re going to take on New York?”

Danielle’s skepticism evidently made him bristle. “Yes,” he said clearly, his gray eyes, their hoods fully retracted, now firmly and unamusedly upon her. “Yes, I am.”





Danielle rode home in the backseat with her eyes shut for most of the way. She opened them periodically to glimpse flashes of the city, the sulfurous lights on the asphalt and the marine sky. “Roger certainly loves to talk,” she said.

“Did he tell you about his novels? Bore you senseless with unwieldy plots?” Moira asked.

“No, scuba diving. And the wine route. Better than that Asian guy.”

“Gary’s new boyfriend? He seemed sweet.”

“Sweet?” John scoffed. “Sweet?”

“He was sweet. No, he really was. But not very interesting.”

There was a silence, during which Danielle longed to ask about Seeley but did not want to seem to care. Of the evening’s underwater blur, Seeley was all that stuck out.

“Did you talk to Ludo at the end?” asked Moira.

“Ludo, is it now?” John said. “My dear, aren’t we grand?”

“Is he really a big deal?” Danielle hoped her voice was neutral. “He seemed a little creepy, or something.”

“He’s moving to New York, you know,” said Moira. “He’s been hired in to launch a mag—they sacked the first guy, you may have read about it. Merton thought his vision was wrong—Billings, was it? Billington? Buxton, I think. Big scandal. Makes Seeley the chosen boy, plucked from halfway across the world. He’s going sometime very soon.”

“Next month,” Danielle said. “I gave him my e-mail. Not that he’ll need it, but in case he’s at a loose end. Trying to be neighborly.”

“That’s a good one,” John said. “Seeley at a loose end. That I’d like to see.”

“Think he’ll succeed?” Danielle asked.

“He thinks so,” said Moira. “In fact, he knows so. But he doesn’t give much away, so it’s hard to know what he’s really plotting. And it’s hard to know whether he’s running to something or running away. He’s made such a splash here in the past, what is it, five years—Christ, he’s only what? Thirty-three? Thirty-five? A baby!—and he’s got a lot of friends—”

“And a lot of enemies,” said John.

“And I just don’t think there’s any challenge for him here anymore, that’s all. But a ton of hassle. With this kind of backing—jeez, Merton’s choice!—he probably reckons he’ll conquer New York, and then the world.”

“Like Kim Jong Il, eh? Or Saddam Hussein?” said John.

“Well, it might not be as easy as he expects,” said Danielle, thinking herself surprisingly witty in spite of the quantities of red wine. “It may just be a case of ‘our chef is very famous in London.’ ”

“That it may,” John said, obviously satisfied at the thought. “That it may.”

chapter two

Bootie, the Professor

Bootie?” Judy Tubb yelled, in her housecoat at the bottom of the stairs, washed in the dull, pearly light of the reflected snow outside. “Bootie, are you going to come down and help dig us out, or what?”

Met by silence, she set a foot upon the creaking step, her hand on the polished wooden ball at the banister’s base, and started, as loudly as she could, to climb. “I said, Bootie? Did you hear me?”

A door opened and her son ambled into view on the gloomy landing, pushing his glasses up his nose and squinting. His old-fashioned brown flannel pyjamas were rumpled around his soft bulk, and his first pre- occupation seemed to be that his mother not catch sight of his pale and generous belly: he clutched at his pyjama strings and hoisted up the bottoms, revealing instead his oddly slender ankles and his long, hairy toes.

“Have you been sleeping all this time, since breakfast?” Judy spoke sharply but felt a burst of tenderness for her befuddled boy, as he wavered before her, almost six feet tall. “Bootie? Frederick? Are you still asleep?”

“Reading, Ma. I was reading in bed.”

“But there’s two feet of snow in the drive, and it’s still coming down.”

“I know.”

“We’ve got to get out, don’t we.”

“School’s cancelled. You don’t have to go anywhere.”

“Just because I don’t have to teach doesn’t mean I don’t need to go anywhere. And what about you?”

Frederick pushed a fist behind his glasses and rubbed his left eye.

“You’re supposed to be looking for a job, aren’t you? You’re not going to find one lying around in bed.”

“There’s a snowstorm on. Everything is cancelled, not just school. There’s nowhere to go today, and no jobs to get today.” He seemed suddenly solid, even stolid, in his bulk. “Besides, my reading isn’t nothing. It’s work, too. Just because it’s not paid doesn’t mean it’s not work.”

“Please, don’t start.”

“Ask Uncle Murray. Don’t you think he spends his days reading?”

“I don’t know what your uncle does with his time, Bootie, but I’d remind you that he’s well paid for it. Very well paid. And I know that when he was your age, he was in college and he had a job. Maybe two jobs, even. Because Pawpaw and Nana couldn’t afford—”

“I know, Ma. I know. I’m going to finish my chapter. And then if it’s stopped snowing, I’ll shovel the drive.”

“Even if it’s still snowing, Bootie. They’ve plowed the road twice since seven.”

“Don’t call me Bootie,” he said as he retreated back into his bedroom. “It’s not my name.”





Judy Tubb and her son lived in a spacious but crumbling Victorian house on the eastern side of Watertown, off the road to Lowville, in a neighborhood of other similarly sprawling, similarly decrepit buildings. Some had been broken up into apartments, and one, at the end of the street, had been abandoned, its elegant windows boarded over and its porch all but caved in; but that was simply the way of Watertown. It was still a good address, a fine house on a fine square lot at the good end of town, as respectable as it had been twenty years before when Bert and Judy had moved in with their little daughter, Sarah, and Bootie not even on the way.

Born a mile from this house, Judy had lived her whole life in town, except for college and a few years teaching in Syracuse. Watertown was to her as invisible as her skin, and she no longer saw (if she ever had) the derelict storefronts and sagging porches. The grand downtown, once known as Garland City, its stone buildings and central plaza constructed on an imperial scale, impressed her only rarely as forlorn: mostly it seemed, as she drove through it to the high school or to the Price Chopper, of a blind and consoling familiarity. So, too, with their neighborhood, their house: she cleaved to them lovingly, simply because they were hers.

The house itself had steep steps at its front, and a small cement patio with a little balcony overhanging, which opened off the upstairs hallway. The Tubbs had had aluminum siding put on in the early eighties—white, simple—but it had grown grubby and mottled with moss and mud, and was in places dented by fallen gutter pipes or bowed by the work of zealous squirrels or birds who had made their nests between the siding and the exterior wall. The remaining wood trim was painted green, but it had been worn bald in spots and was everywhere cracked and peeling. The snow covered the worst of the building’s indignities (including a rotting patch of brick in the foundation), and softened its outlines, so that the peaked roof—once of slate, now of poorly stapled asphalt sheeting—seemed to rise with a solid confidence into the clouded sky.

Inside, the Tubbs’ home was still elegant—except, perhaps, Bootie’s room, a territory to which Judy laid no claim. Little had been done to the rooms in years—she had not had the courage for even a coat of paint since Bert’s death from pancreatic cancer four years before—and they had about them, perhaps in consequence, a heavy, darkened aspect; but she kept the house clean, its wood polished, its linoleum waxed, even its windows (at least in summer, when the storms were taken down) washed. There was little to be done about the stubborn dottings of mold on the basement wall (she blamed the aluminum siding, after all these years, which kept the house from breathing) or in a patch on the blue bathroom lino behind the toilet. But by and large, Judy considered that all was in fine repair, the old cabinets and wide-planked floors, even the small red-and-blue-lozenged stained-glass window over the front door, which she knew—Bert had discovered it; he loved researching such things—had been ordered from a Sears catalogue all the way back at the turn of the last century.

She loved her house, largely though not only for the history that it held, and she was most partial to the upstairs—the grand, bright bedroom overlooking the street that she had shared with her dear husband, and where, were it not for the hospital, he would have died; the broad hall with its balcony and gleaming banisters; even the faded pink flowered carpet along the floor, with its faint smell of dust, which she knew so intimately that she could locate, in her mind, its gnawed edges, its threadbare patches and its irremovable stains. As she moved from that hallway into her beloved bedroom, worrying about her sullen son (it was the age, she kept telling herself, his and the culture’s), she felt she walked into the light: the two large windows cast a shadowless opalescence onto the sprigged wallpaper, the family photos on top of the bureau. Even her discarded stockings, still carrying from yesterday the shape of her solid limbs, appeared outlined in light, luminous. Her hands and her hair, a grayed cloud, had carried up from the kitchen the smell of coffee, and the vents at her ankles pushed a warm wind around the floor. In spite of Bootie, in spite, in spite, in this moment at least, she felt happy: she was not too old to love even the snow.

Judy Tubb made her bed—tidily, smoothing the bottom sheet and removing the stray gray curls from her pillow, then squaring and tucking the top sheet, the mustard wool blanket. She fussed over the bedspread, its evenness on both sides, the plumpness of the pillows beneath its folds. She had no truck with duvets, flimsy and foreign: she liked the weight of a bed made with blankets, and the work of it. She showered, dried, and dressed in the bathroom in the hall—the house was Victorian, and had only the one bathroom in spite of four bedrooms—and emerged in her favorite blush turtleneck beneath the avocado angora cardigan she had knitted last winter. In truth, she had knitted it for her niece, Marina—God only knew why, because they weren’t close; except that she loved to knit and had already made a dozen sweaters for her daughter and her grandkids. But it wasn’t quite finished in time for Christmas, and somehow she had known, when she opened the gift Marina had sent—a crimson velvet scarf with cutaway flowers in it and silk tasseled fringe, like the shawl of a Victorian madam—she had just known that the sweater wasn’t right. She’d sent a Borders gift card instead, and kept the sweater for herself. As for the scarf, there was nowhere in Watertown, New York, that she could wear it—certainly not to teach Geography to the sophomores and juniors at the high school—so she had wrapped it up in tissue and put it in the back of her dresser drawer. The funny thing was, she loved the cardigan as if it had been a precious gift, and she somehow thought of it as a gift from Marina, which made her think more warmly of the girl after all, and which, in a roundabout way, it was.

As she bundled herself into her parka, her Bean boots, her pink woolly toque (also her own handiwork, a pretty lace pattern with a bobble on top), and took, in her mittened hands, the aluminum shovel from the porch, she worried about Bootie, upstairs in his pajamas like a boy. She wouldn’t ask him again to help with the shoveling—he could perfectly well hear the rhythmic scrape and shuffle of her movements from his window overhead—but she hoped against hope that he might come down of his own accord. Of course if he did come, it would mean another day he hadn’t bathed. She didn’t like to nag him about it (who wanted to be that kind of mother, always picking and finding fault?), but she couldn’t remember hearing the tub run once in the past week. He took only baths, not showers, and those rarely; but when he did he lingered an hour in the cooling water, reading one of his infernal books.

Judy Tubb tackled the snow in the driveway first and, in spite of the delicious cold of the shovel through her mittens, in spite of the cold sting pinkening her cheeks, in spite of the satisfying soreness she felt, almost immediately, in her lower back, she felt her good humor evaporating as she thought again about her boy. Her darling and only. Her prize. What was it now? March, it was March now, and almost Easter. And Bootie had graduated almost a year ago, at the top of his class. She’d never imagined he would still be here, or would be back here; and when, in September, he’d gone off to Oswego, she’d thought that it was the beginning of his life in the wider world. No telling what he could accomplish. And if Bert were still alive, he’d see that his youngest had fulfilled the promise, that all the saving (Bert had been an accountant, and wisely parsimonious) had been for something. For Bootie to shine. It was Sarah who’d given them trouble, pregnant at nineteen and married at twenty, but now she had a good job at the savings and loan and three tow-headed, boisterous kids, and her Tom had proven a good husband and settled into his work running Thousand Islands boat tours out of Alexandria Bay in the summer and plowing on a state contract in the winter. Heck, Tom would probably drive down from the bay and shovel out her drive before her own boy stirred himself to help her. He was a good son-in-law, even if she’d hoped, once, for better.

But Bootie: he was going to be a politician, he’d said, or a journalist like his uncle, or maybe a university professor. That’s what the kids had called him at the high school: the professor. He’d been a chubby boy, and bespectacled, but always respected, even admired, in a funny way. He’d been valedictorian. And then home at Christmas with twenty or thirty extra pounds on him and a fistful of incompletes, saying that college was bullshit, or at least Oswego was bullshit, that his teachers were morons and he wouldn’t go back. She suspected a girl, some girl had broken his heart or embarrassed him—he wasn’t easy with girls, not confident—or else his roommates, two tight lunk-headed athletes with beer on the brain; but Bootie wasn’t telling, or not telling her. And since Christmas he’d spent all his time in his room, reading and doing God knew what on the computer (was it pornography? That would be okay, she could understand it in a young boy, but as a distraction, not an obsession; and if only she knew), or in the grand pillared library downtown, where the heat was always too high and the air smelled funny and where, to be honest, he had to order books from out of town to get anything more serious than Harlequin romances or the Encyclopedia Britannica. Had he looked for a job? Not once until last month, when she gave him an ultimatum, told him he’d have to pay rent one way or another, if he wouldn’t go back to school; so that now he made a big show at breakfast with the classifieds, circling factory jobs and short-order cook positions and suggesting—it was the only time he laughed these days—that he could sell used cars at Loudoun’s Ford & Truck, or wait tables at Annie’s off the interstate.

And now here he was on the porch, no gloves, no hat, ski jacket over his pajamas, wielding the second rusty and old shovel, like a weapon, with the steam of his breath fogging his glasses.

  • 1

Excerpted from The Emperor's Children by Claire Messud Copyright © 2006 by Claire Messud. Excerpted by permission of Knopf, a division of Random House, Inc. 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!

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

Analyzing humor is like dissecting a frog. Few people are interested and the frog dies of it.

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 03:24 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
1780284241067 ms 1.78028424107E+012 ms 1 /root/website/app_server.cfm
277 ms 277 ms 1 /root/website/excerpts/index.cfm
57 ms 57 ms 1 /root/website/app_layout.cfm
47 ms 47 ms 1 /root/website/queries/qry_get_book_by_id.cfm
43 ms 43 ms 1 /root/website/queries/qry_get_discussion_by_id.cfm
37 ms 37 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
35 ms 35 ms 1 /root/website/app_globals.cfm
34 ms 34 ms 1 /root/website/queries/qry_get_liked_by_book_id.cfm
24 ms 12 ms 2 /root/website/adsystem/adsystem_mod.cfm
15 ms 15 ms 1 /root/website/excerpts/dsp_main.cfm
15 ms 15 ms 1 /root/website/queries/qry_get_ezine_by_book_id.cfm
14 ms 14 ms 1 /root/website/adzones/AdZone6.cfm
13 ms 13 ms 1 /root/website/queries/qry_get_active_obc.cfm
13 ms 13 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
11 ms 11 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
10 ms 10 ms 1 /root/website/adzones/showcase_track.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
10 ms 10 ms 1 /root/website/queries/qry_get_free_flag_by_book_id.cfm
9 ms 9 ms 1 /root/website/site/blocks/dsp_top_book_block.cfm
7 ms 7 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
3 ms 1 ms 3 /root/website/actions/act_spider_tracker.cfm
3 ms 3 ms 1 /root/website/actions/adstatus.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_book_awards_by_book_id.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_current_competition.cfm
3 ms 3 ms 1 /root/website/queries/qry_get_reader_reviews_by_book_id.cfm
3 ms 3 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
2 ms 2 ms 1 /root/website/act_check_login.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_categories_by_book_id.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_account_types.cfm
2 ms 2 ms 1 /root/website/queries/qry_get_member_info.cfm
2 ms 2 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
2 ms 2 ms 1 /root/website/site/blocks/membership_advantages.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/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_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
0 ms 0 ms 1 /root/website/site/blocks/act_book_view_tracking.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_readalikes.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
2 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
279 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Exceptions

03:24:01.001 - 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=2ms, Records=1) in /root/website/actions/act_spider_tracker.cfm @ 03:24:01.001
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=2ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 03:24:01.001
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=2ms, Records=2) in /root/website/actions/adstatus.cfm @ 03:24:01.001
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 @ 03:24:01.001
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=2ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 03:24:01.001
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:24:01.001
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=1ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 03:24:01.001
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 @ 03:24:01.001
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=3ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 03:24:01.001
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=4ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 03:24:01.001
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=5ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 03:24:01.001
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 @ 03:24:01.001
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) = 1853

get_media_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=31ms, Records=7) in /root/website/queries/qry_get_book_by_id.cfm @ 03:24:01.001
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) = 1853
Parameter #2(CF_SQL_INTEGER) = 1853
Parameter #3(CF_SQL_INTEGER) = 1853
Parameter #4(CF_SQL_INTEGER) = 1853

get_reader_reviews_by_book_id (Datasource=bookbrowse_com_new, Time=3ms, Records=2) in /root/website/queries/qry_get_reader_reviews_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_book_awards_by_book_id (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_bb_runner_ups (Datasource=bookbrowse_com_new, Time=1ms, Records=0) in /root/website/queries/qry_get_book_awards_by_book_id.cfm @ 03:24:01.001
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) = 1853
Parameter #2(CF_SQL_INTEGER) = 1853

get_liked_by_book_id (Datasource=bookbrowse_com_new, Time=34ms, Records=14) in /root/website/queries/qry_get_liked_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_categories_by_book_id (Datasource=bookbrowse_com_new, Time=2ms, Records=5) in /root/website/queries/qry_get_categories_by_book_id.cfm @ 03:24:01.001
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) = 1853

bb_review (Datasource=, Time=1ms, Records=1) in /root/website/excerpts/index.cfm @ 03:24:01.001
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=4ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 03:24:01.001
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) = 1853

get_arc_idfk_legacy (Datasource=bookbrowse_com_new, Time=4ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 03:24:01.001
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) = 1853

obc_discussions (Datasource=booktalk_new, Time=18ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 03:24:01.001
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) =

searchResults (Datasource=bookbrowse_com_new, Time=14ms, Records=0) in /root/website/queries/qry_get_discussion_by_id.cfm @ 03:24:01.001
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) = 1853

get_ezine_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 03:24:01.001
SELECT a.ezine_type_number
	FROM ezines a
	WHERE a.ezine_number = 1
get_ezine_by_book_id (Datasource=bookbrowse_com_new, Time=13ms, Records=1) in /root/website/queries/qry_get_ezine_by_book_id.cfm @ 03:24:01.001
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) = 1853

check_permalink (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

check_free_ezine (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

check_cat_73 (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_ezine_status (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

check_old_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_ezine_status (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/queries/qry_get_free_flag_by_book_id.cfm @ 03:24:01.001
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) = 1853

get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_book_image (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_book_image (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_coauthor (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/actions/udfs.cfm @ 03:24:01.001
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) = 1853

get_member_account_types (Datasource=bookbrowse_com_new, Time=1ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 03:24:01.001
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=4ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:24:01.001
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=5ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 03:24:01.001
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=6ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
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=6ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 03:24:01.001
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=2ms, Records=4) in /root/website/queries/qry_get_free_newsletters.cfm @ 03:24:01.001
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=3ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
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=2ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=1ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 03:24:01.001
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=FREEACCESSCOUNT=0; CFTOKEN=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0; CFID=4083998; CFGLOBALS=urltoken%3DCFID%23%3D4083998%26CFTOKEN%23%3De93f9c769b47cfea%2D0C0A90C0%2DE51D%2D19FB%2D3F1AD59BE3B52EE0%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2003%3A23%3A56%27%7D%23hitcount%3D20%23timecreated%3D%7Bts%20%272026%2D06%2D01%2003%3A22%3A26%27%7D%23cftoken%3De93f9c769b47cfea%2D0C0A90C0%2DE51D%2D19FB%2D3F1AD59BE3B52EE0%23cfid%3D4083998%23; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%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=/book_number/1853/the-emperors-children
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=4083998
cftoken=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
hitcount=20
lastvisit={ts '2026-06-01 03:23:56'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 03:22:26'}
urltoken=CFID=4083998&CFTOKEN=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
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#=4083998&CFTOKEN#=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0#lastvisit={ts '2026-06-01 03:23:56'}#hitcount=20#timecreated={ts '2026-06-01 03:22:26'}#cftoken=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0#cfid=4083998#
CFID=4083998
CFTOKEN=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
FREEACCESSCOUNT=0
Session Variables:
cfid=4083998
cftoken=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
sessionid=BOOKBROWSE_4083998_e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
urltoken=CFID=4083998&CFTOKEN=e93f9c769b47cfea-0C0A90C0-E51D-19FB-3F1AD59BE3B52EE0
URL Parameters:
book_number=1853
the-emperors-children=
Debug Rendering Time: 11 ms