Abdi Nor Iftin Interview, plus links to author biography, book summaries, excerpts and reviews

Abdi Nor Iftin

Abdi Nor Iftin

An interview with Abdi Nor Iftin

Abdi Nor Iftin, author of the memoir Call Me American talks about his life growing up in war-torn Somalia, what coming to America means to him and his fears for American under President Trump.

How old were you when the civil war started in Somalia, and how did it change your life?

I was six when the civil war erupted; it felt like a doomsday. It spread all over the city very fast and destroyed everything. It was excruciating to see how much damage the guns could do to an entire city. My dad's years of building a beautiful life for our family were destroyed within a day. His basketball trophies and earnings were looted at gunpoint. The house where I was born was reduced to ashes. The war split my family apart; our father ran for his life and disappeared. My siblings, my mother and I wandered in the wilderness, barefoot, without knowing where we were going, and later stayed on the streets with dogs while dodging bullets. We lived everyday like it was our last. It was almost impossible to survive as a child because the war had also brought malnutrition and disease. Every day that passed felt like a year of hell fire. We all prayed for death, but death refused to come to me.

You write about your teacher at the madrassa, Macalin Basbaas, and the "education" offered through his school. What did he and his school represent to you?

Koran is the highest education that one can attain in Somalia. During the civil war Madrassas sprang up on every corner, and to our parents the Madrassa was a place where we learned the most important words in the whole world, those of God, and where we learned good from bad. Macalin Basbaas could do anything our parents could do, and could beat, torture or even kill us. But his goal was to produce a generation of great Koran reciters and to do that he used brutal tactics such as constant beating. The seven years that I attended the Madrassa felt as brutal as living in a war. I desperately needed an escape but there was none. The Koran I learned from Macalin Basbaas saved my life when al-Shabab came to power in 2006. I was quizzed in Koran and asked to recite verses and I was able to answer correctly. If I had not been able to do that, they would have killed me. That was the only time I ever thanked Macalin Basbaas.

Western movies were your entertainment and escape. What did movies like Rambo and Commando mean to you, and what did you learn from them?

Rambo and Commando introduced me to America—the patriotism, the freedom, the strength—and were my motivation to achieve. After watching these movies relentlessly night after night and mouthing the words along with Arnold and Sylvester, I became more ambitious, energetic and persistent, like them. They gave me dreams and hopes for the future. I found an identity through them in the depth of the Somali civil war. I called myself a new nickname, Abdi American. I would walk down the streets of Mogadishu listening to music and dancing. I found a girlfriend and dared to take taboo-breaking trips to the beach. I would imagine myself in sandy and sexy Hollywood movies, holding hands with my girlfriend, standing up to gangs at the beach with my fist high like Arnold, shouting "Get the hell out of here!"  

As al-Shabaab and the Islamists rose to power, how did things change? How did you escape recruitment into the Islamic forces there?

When the Islamists rose to power in Somalia in 2006, they imposed strict moral codes. Everything I adored became a crime, including speaking English and loving America. My personal freedoms diminished, and my adopted and beloved nickname Abdi American almost cost me my life. Sharia law became the law of the land. They pressured me and other young men into submission to join them. Recruitment became mandatory, and I trimmed my hair, stopped speaking English, and stayed hidden, constantly praying for escape.

You filed a series of stories for NPR from Mogadishu and Nairobi – how did that come about, and what did you report? How did you record and file your stories, and was the work dangerous?

Under the constant shelling of al-Shabaab, sitting in the cave I dug under my bed while praying for escape, I recorded my stories on a cellphone device. Excruciating and painful personal stories of my survival in Mogadishu. I talked about the brutal new moral codes in the city and fears of a forceful recruitment. I turned 22 and that was a dangerous age because al-Shabaab preferred that age for recruitment. The stories I dispatched would kill me if al-Shabaab found out. But I knew what I was doing could be one way to escape. My stories aired on radios across the America and doctors, journalists, professionals and citizens from across the United States came to my rescue. They raised funds to get me out of Somalia.   

There has been a lot of discussion of the Diversity Visa Lottery program here in the US recently. Since you have been through it, can you briefly explain what it involves? How long did it take for you to be accepted, and how much longer to actually receive a visa?

The Diversity Visa lottery is one of few ways to immigrate to the U.S permanently. This lottery system allows people from under represented countries to immigrate to the U.S. every year. I was lucky to be one of over 120,000 people that were selected for the fiscal year of 2014 by the United States Citizenship and Immigration Services. But after tough screening and Consular Processing, the United States State Department had to disqualify seventy thousand people as they could only issue fifty thousand visas. It took me two years to put together everything I could for the visa eligibility. Two major requirements for getting a visa were high school diploma or work experience. I did not have either. I had been a refugee my entire life and was living in Kenya with a refugee status. I had been disappointed many times before, but I never gave up. The chance of approving my visa was low, especially coming from a country the U.S considers to harbor terrorism. I collected everything I could: medical and police records, a college transcript, letters from the offices of senators from Maine, Vermont and Chicago, letters from my supporters in the U.S. I was put on Administrative Processing by the State Department, which meant they were checking my name for terrorism-related issues, which took two weeks. Finally, after some calls, my visa was finally issued.

What are some things that surprised you about life in America?

America is more than a country. It feels like a continent. People from all over the world come and live here. My first surprise in America was that all Americans don't look like Arnold Schwarzenegger or Sylvester Stallone. Some people are not even fit and strong. Some people don't even speak English. My greatest freedom ever was driving from Maine, with large white communities and small farm towns, to Boston and New York's skyscrapers and the most diverse communities I have ever seen. I am surprised how huge the country is. I find it a surprise that everyone, despite their color, faith or country of origin, all respect the law of this nation. With the freedom America gave me I rose above the circumstances of being a refugee to become an author, go to school, and work. The hospitality and the mentoring Americans have given me is remarkable. America is the best place to become what we dream to be.

Has living in America affected your worldview/principles/faith/etc? If so, how?

America gave me a space to worship and practice my faith when I need without being forced to do so. I wake up every morning without worrying about being recruited or shot. The only thing I worry about is paying the bills, and keeping my schedule and appointments that I have with people. Unfortunately, I have learned of the existence of racism, hate and xenophobia that some Americans express towards newcomers and immigrants like myself. I was shocked to see that some Americans, including the president of the United States Donald Trump, saw me as less worthy and a threat on American soil. Besides all the goodness and kindness America showed me, there is also bad, and people who don't want me to be here. But whatever the case is, I call America home. I am not here to take anyone's life, money or happiness. I am here to be part of the people, to salute the flag and most importantly to become the American that I have dreamed of being since childhood.

Where is your family today, and how are they doing? Do any of them want to come to the United States? Can they?

My mother and my sister are both living in a two-room house made of corrugated metal walls and roof in Mogadishu. They just repaired the roof after a massive bombing tore it off in March 2018. This bombing also killed a Somali-American, a guy who fled Somalia and built a life in Minnesota but went back to see his city, only to be murdered by the radical Islamists. Gunshots, explosions and targeted assassinations are happening every day in Mogadishu, so mom tells me I am lucky to be in the U.S. and away from that fear. 

My sister's kids are following in my footsteps. They are all going to Madrassa where they spend the entire day reciting Koran and come home at night to sleep. When I call them, I tell them my story about when I was their age. 

Thanks to ex-Team Abdi, now Team Hassan, my brother, his wife and kids had been approved to immigrate to Canada on Monday, May 7th, 2018. He had been denied immigration to the U.S shortly after President Trump announced the Immigration Ban in early 2017. We wrote letters to Timothy Eaton Memorial Church in Toronto to sponsor Hassan, and we raised all the funds needed for the process. The Canadian embassy had a one-on-one interview with Hassan, and they had approved his visa immediately. I am lucky to have Hassan become my next-door neighbor. I can't wait to welcome them in Canada when they arrive in early Fall 2018.

What is your response to Trump's immigration ban? What does this mean for you, personally?

The travel ban is a rejection of everything America stands for—a country that was founded by immigrants and believed in offering the oppressed refuge from violence and persecution from its very start. America is where people want to come and feel safe from terrorists attacking their countries. Before Trump became president, I listened to speeches of previous U.S president to improve my English, but I also smiled listening to them. As a teenager I went to the movies to learn American English, and earned the nickname Abdi American because I could not stop talking about America as a great country. I dared a taboo-breaking trip to the warm ocean of Mogadishu holding my girlfriend's hands, singing in English, and when radical Islamists arrived in Somalia they almost killed me for my American actions, my nickname and I was told not to speak English. I almost got recruited when I fled to Kenya, fearing for my life.

Coming to America saved me. I was happy to come to Maine and call this state home until Trump came to complain and tell his supporters that we immigrants, Somalis and Muslims should not be here. And when he became president he banned Somalis and wants to stop the diversity lottery. It's a disappointment to hear a president of the United States say that. I never thought I would be marching on the streets of America against a U.S president, but because of Trump I found myself being part of the resistance, angry, and frustrated but also fearful of his actions.   

What do you want people to know about refugees? Why is it important that America continue to accept people who, like you, are seeking a better life?

No one chooses to be a refugee; we are forced out of our houses and our countries by conflicts and wars but we all deserve safety and an environment to thrive in. America is a place of hope. A place where every one of every faith, color and belief can thrive. Some of America's biggest minds are immigrants or children of immigrants such as Steve Jobs and Arnold Schwarzenegger. I did not come here to change America and the Americans. I came here to contribute, to make, and to experience.

Unless otherwise stated, this interview was conducted at the time the book was first published, and is reproduced with permission of the publisher. This interview may not be reproduced or reprinted without permission in writing from the copyright holder.

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

Books by this Author

Books by Abdi Nor Iftin at BookBrowse
Call Me American jacket
Membership Advantages
  • Reviews
  • "Beyond the Book" articles
  • Free books to read and review (US only)
  • Find books by time period, setting & theme
  • Read-alike suggestions by book and author
  • Book club discussions
  • and much more!
  • Just $60 for 12 months or $20 for 3 months.
  • More about membership!

Read-Alikes

All the books below are recommended as read-alikes for Abdi Nor Iftin but some maybe more relevant to you than others depending on which books by the author you have read and enjoyed. So look for the suggested read-alikes by title linked on the right.
How we choose readalikes

  • Ayad Akhtar

    Ayad Akhtar

    Ayad Akhtar is a novelist and playwright. His work has been published and performed in over two dozen languages. He is the winner of numerous awards, including the Pulitzer Prize for Drama and an Award in Literature from the ... (more)

    If you enjoyed:
    Call Me American

    Try:
    Homeland Elegies
    by Ayad Akhtar

  • Marcelo Hernandez Castillo

    Marcelo Hernandez Castillo

    Marcelo Hernandez Castillo is the author of Cenzontle, winner of the A. Poulin, Jr. prize (BOA editions 2018), winner of the 2019 Great Lakes Colleges Association New Writers Award in poetry, a finalist for the Northern ... (more)

    If you enjoyed:
    Call Me American

    Try:
    Children of the Land
    by Marcelo Hernandez Castillo

We recommend 13 similar authors


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

BookBrowse Book Club

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

Members Recommend

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

From the moment I picked your book up...

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

Book
Trivia
  • Book Trivia

    Can you name the title?

    Test your book knowledge with our daily trivia challenge!

Wordplay

Solve this clue:

W the C A the M W P

and be entered to win..

Your guide toexceptional          books

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

 


Debugging Information
ColdFusion Server Developer 2021,0,13,330286
Template /author_interviews/full/index.cfm
Time Stamp 01-Jun-26 03:15 PM
Locale en
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 127.0.0.1
Host Name 127.0.0.1


Execution Time

Total Time Avg Time Count Template
1780326906343 ms 1.78032690634E+012 ms 1 /root/website/app_server.cfm
1142 ms 1142 ms 1 /root/website/author_interviews/full/index.cfm
499 ms 499 ms 1 /root/website/author_interviews/full/dsp_main.cfm
287 ms 144 ms 2 /root/website/queries/qry_get_books_by_author_id.cfm
263 ms 263 ms 1 /root/website/app_globals.cfm
215 ms 215 ms 1 /root/website/app_layout.cfm
205 ms 68 ms 3 /root/website/adsystem/adsystem_mod.cfm
137 ms 137 ms 1 /root/website/site/blocks/layout/dsp_right_column.cfm
122 ms 122 ms 1 /root/website/adzones/AdZone2.cfm
84 ms 84 ms 1 /root/website/queries/qry_get_current_competition.cfm
79 ms 79 ms 1 /root/website/queries/qry_get_active_obc.cfm
63 ms 63 ms 1 /root/website/queries/qry_get_books_by_author_id_lite.cfm
55 ms 55 ms 1 /root/website/adzones/AdZone6.cfm
55 ms 18 ms 3 /root/website/site/blocks/membership_advantages.cfm
54 ms 18 ms 3 /root/website/queries/qry_get_member_account_types.cfm
52 ms 52 ms 1 /root/website/queries/qry_get_arcs_for_ad.cfm
52 ms 52 ms 1 /root/website/site/blocks/dsp_border_first_impressions.cfm
36 ms 36 ms 1 /root/website/queries/qry_get_bb_briefs_by_author.cfm
33 ms 33 ms 1 /root/website/queries/qry_get_author_readalikes_by_id.cfm
33 ms 33 ms 1 /root/website/site/blocks/layout/dsp_footer.cfm
31 ms 31 ms 1 /root/website/adzones/showcase_track.cfm
27 ms 27 ms 1 /root/website/site/blocks/layout/dsp_header.cfm
26 ms 26 ms 1 /root/website/site/blocks/dsp_book_giveaway.cfm
25 ms 25 ms 1 /root/website/actions/adstatus.cfm
23 ms 23 ms 1 /root/website/site/blocks/layout/main_menu.cfm
20 ms 20 ms 1 /root/website/act_check_login.cfm
19 ms 19 ms 1 /root/website/queries/qry_get_member_info.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_all_books_by_author_id.cfm
17 ms 17 ms 1 /root/website/queries/qry_get_current_wordplay.cfm
16 ms 4 ms 4 /root/website/actions/act_spider_tracker.cfm
8 ms 8 ms 1 /root/website/queries/qry_get_previous_arcs_for_ad.cfm
1 ms 1 ms 1 /root/website/act_libraryIPLogin.cfm
1 ms 1 ms 1 /root/website/site/blocks/layout/dsp_bottom_block.cfm
0 ms 0 ms 1 /root/website/Application.cfm
0 ms 0 ms 1 /root/website/actions/udfs.cfm
0 ms 0 ms 1 /root/website/banners/ad_594.cfm
0 ms 0 ms 1 /root/website/formurl2attributes.cfm
0 ms 0 ms 1 /root/website/js/fbjavascriptsdk.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_current_ezine.cfm
0 ms 0 ms 1 /root/website/queries/qry_get_free_newsletters.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_border_booktalk.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_header_newsletter.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_top_author_block.cfm
0 ms 0 ms 1 /root/website/site/blocks/dsp_wordplay.cfm
0 ms 0 ms 1 /root/website/site/blocks/email_modal.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/google_tags.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/head.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/header_announcement.cfm
0 ms 0 ms 1 /root/website/site/blocks/layout/main_search.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
1143 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

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

get_member_info (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/queries/qry_get_member_info.cfm @ 15:15:06.006
select 	a.*, 
    		b.member_account_type_name, b.member_account_type_charge, b.member_account_type_charge_frequency,  b.member_account_type_months, 
            c.member_chargetype_name, c.member_chargetype_number, a.member_classification_number, a.member_book_format
	
    from members a, member_account_types b, member_chargetype c
	
    where a.member_account_type_number = b.member_account_type_number
	and a.payment_method_id = c.member_chargetype_number
	and a.member_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 0

adactive (Datasource=bookbrowse_com_new, Time=23ms, Records=2) in /root/website/actions/adstatus.cfm @ 15:15:06.006
SELECT	viewby, section
    FROM	adsystem 
    WHERE	active  = 1 
    AND		start_date <= GETDATE()
    AND 	(viewby = ? OR viewby = 'all')
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = non

get_current_ezine (Datasource=bookbrowse_com_new, Time=0ms, Records=1, Cached Query) in /root/website/queries/qry_get_current_ezine.cfm @ 15:15:06.006
select		top 1 ezine_number, ezine_dt, ezine_image, ezine_brief_description, ezine_introduction
from		ezines
where		ezine_active_flag = 1
and 		ezine_type_number = 4
and			ezine_dt < getdate()
order by 	ezine_dt DESC
get_current_wordplay (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/queries/qry_get_current_wordplay.cfm @ 15:15:06.006
SELECT		a.wordplay_number, a.wordplay_dt, a.wordplay_name, a.wordplay_intro_text, b.wordplay_puzzle_number, b.wordplay_puzzle_question
    FROM		wordplays a 
	INNER JOIN	wordplay_puzzle_mapping c on c.wordplay_number = a.wordplay_number
	INNER JOIN	wordplay_puzzles b on b.wordplay_puzzle_number = c.wordplay_puzzle_number
	WHERE		a.wordplay_number = (	select top 1 a.wordplay_number
                                from wordplays a, wordplay_puzzles b, wordplay_puzzle_mapping c
                                where a.wordplay_number = c.wordplay_number
                                and b.wordplay_puzzle_number = c.wordplay_puzzle_number
                                and a.wordplay_dt < getdate()
                                and a.wordplay_expiration_dt > dateadd(day, -1, getdate())
                                order by a.wordplay_dt asc
                                )
get_ComNo (Datasource=bookbrowse_com_new, Time=49ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:06.006
SELECT 	TOP 1 	x.competition_number, x.bb_briefs_flag
	from			competitions x
	
		WHERE	x.competition_dt <= getdate()
		AND		x.competition_expiration_dt > dateadd(d,-1,getdate())
get_current_competition (Datasource=bookbrowse_com_new, Time=34ms, Records=0) in /root/website/queries/qry_get_current_competition.cfm @ 15:15:06.006
SELECT 	x.competition_number, x.book_number, x.competition_teaser_title, x.competition_teaser_description, x.competition_intro_text, x.competition_expiration_dt, x.bb_briefs_flag, x.competition_full_info_flag, x.competition_type, x.competition_optin,x.competition_optin_text, 
				a.book_title as "title",
				(b.author_first_name + ' ' +  b.author_middle_initial + ' ' + b.author_last_name) as "author",
	            f.edition_publish_dt AS "hardcover_publish_dt", f.edition_jacket_image as "hardcover_jacket_image",
				g.edition_publish_dt AS "paperback_publish_dt", g.edition_jacket_image as "paperback_jacket_image"
	
		FROM 		competitions x
		INNER JOIN	books a on a.book_number = x.book_number
		INNER JOIN	book_author_mapping c on c.book_number = x.book_number
		INNER JOIN	authors b on c.author_number = b.author_number
		LEFT JOIN	editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
		LEFT JOIN	editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1

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

get_previous_arcs_for_ad (Datasource=bookbrowse_com_new, Time=0ms, Records=0, Cached Query) in /root/website/queries/qry_get_previous_arcs_for_ad.cfm @ 15:15:06.006
SELECT 	a.arc_number,a.arc_client_url,a.arc_active_dt, a.arc_off_ad_dt,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publisher, 
		b.ezine_preview_publish_dt, b.ezine_preview_jacket_desc, b.ezine_preview_number_of_pages, b.ezine_preview_bb_comments, b.ezine_preview_isbn13,
		c.ezine_preview_category_name AS "ezine_preview_category",
		(select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) as "reviews",
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating,
 			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,1))) AS numeric(12,1)))from arc_allocator where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS "decrating"

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
INNER JOIN ezine_preview_categories c ON b.ezine_preview_category_number = c.ezine_preview_category_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND getdate() < arc_off_ad_dt

ORDER BY a.arc_on_ad_dt DESC
get_future_obc (Datasource=bookbrowse_com_new, Time=31ms, Records=0) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:06.006
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text, arc_on_ad_dt,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages, ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	
	WHERE 		arc_obc_flag = 1

	AND 		getdate() < arc_on_ad_dt
	
		ORDER BY  	NEWID()
get_active_obc (Datasource=bookbrowse_com_new, Time=22ms, Records=1) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:06.006
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE 		a.arc_obc_flag = 1
	AND			a.arc_active_flag = 0
	AND 		arc_closed_flag = 1
	AND 		getdate() >= arc_on_ad_dt
	AND 		getdate() < arc_off_ad_dt
	ORDER BY  	NEWID()
get_recent_obc (Datasource=bookbrowse_com_new, Time=23ms, Records=4) in /root/website/queries/qry_get_active_obc.cfm @ 15:15:06.006
SELECT 		a.arc_forumidfk, a.discourse_flag, a.arc_promo_text,
				b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_jacket_desc, b.ezine_preview_publisher, ezine_preview_publish_dt, ezine_preview_number_of_pages,  ezine_preview_isbn, ezine_preview_short_summary,
	            b.ezine_preview_bb_author_link, ezine_preview_bb_link,
	            c.book_reading_guide
	
	FROM 		arcs a
	INNER JOIN 	ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number
	LEFT JOIN  	books c on c.book_number = b.ezine_preview_bb_link
	
	WHERE a.arc_number IN (select top 4 arc_number
							from		arcs
							WHERE 		arc_obc_flag = 1
							AND			arc_active_flag = 0
							AND 		arc_closed_flag = 1
							AND 		getdate() > arc_off_ad_dt
							ORDER BY	arc_on_ad_dt DESC)
	ORDER BY  	NEWID()
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=31ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:15:06.006
select	a.book_number, a.book_title, a.book_sub_title, book_short_summary,
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
        left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0 
   		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1 
		
       	where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)

		order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3079

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=31ms, Records=1) in /root/website/queries/qry_get_books_by_author_id_lite.cfm @ 15:15:06.006
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3079

get_all_books_by_author_id (Datasource=bookbrowse_com_new, Time=17ms, Records=1) in /root/website/queries/qry_get_all_books_by_author_id.cfm @ 15:15:06.006
select	a.book_number, 
        		'' AS ezine_preview_number,
                a.book_title, 
                a.book_sub_title, 
				(CASE WHEN f.edition_publish_dt < g.edition_publish_dt OR g.edition_publish_dt IS NULL THEN f.edition_publish_dt
                      ELSE g.edition_publish_dt 
                      END) "publish_dt",
                '' as "jacket"
		
        from 	books a
		inner join book_author_mapping e ON e.book_number = a.book_number
        inner join authors d ON d.author_number = e.author_number
		left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
		left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
		
        where 	d.author_number = ?
        and 	a.book_number IN (	select	distinct b.book_number 
        							from	categories a, category_book_mapping b 
                                    where 	a.category_number = b.category_number 
                                    and 	a.category_active_flag = 1)        
        UNION

		select	'' AS book_number,
        		ezine_preview_number, 
				ezine_preview_title AS "book_title", 
				ezine_preview_subtitle AS "book_sub_title",
                ezine_preview_publish_dt AS "publish_dt",
                ezine_preview_jacket_image as "jacket"
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		ezine_preview_bb_link < 1
        
        order by publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3079
Parameter #2(CF_SQL_INTEGER) = 3079

get_bb_briefs_by_author (Datasource=bookbrowse_com_new, Time=36ms, Records=0) in /root/website/queries/qry_get_bb_briefs_by_author.cfm @ 15:15:06.006
select	ezine_preview_number, 
				ezine_preview_title, 
				ezine_preview_subtitle,
                ezine_preview_publish_dt ,
                ezine_preview_jacket_image
		
        from 	ezine_previews
		
        where 	ezine_preview_bb_author_link = ?
        and		(ezine_preview_bb_link IS NULL
				 or ezine_preview_bb_link < 1)
        and		ezine_number > 0
        
		order by ezine_preview_publish_dt DESC
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3079

get_author_readalikes_by_id (Datasource=bookbrowse_com_new, Time=33ms, Records=13) in /root/website/queries/qry_get_author_readalikes_by_id.cfm @ 15:15:06.006
SELECT		a.author_number,
			CASE	WHEN datalength(a.author_middle_initial) > 0 
					THEN a.author_first_name + ' ' + a.author_middle_initial + ' ' + a.author_last_name
					ELSE a.author_first_name + ' ' + a.author_last_name
					END AS "author_full_name",
			b.book_number, 
			f.book_title as "book",

			CASE	WHEN datalength(e.author_middle_initial) > 0 
					THEN e.author_first_name + ' ' + e.author_middle_initial + ' ' + e.author_last_name
					ELSE e.author_first_name + ' ' + e.author_last_name
					END AS "liked_author_full_name",
			e.author_number as "liked_author_number", 
			g.book_title as "liked_book",
			c.liked_book_number as "liked_book_number" 

FROM		authors a
INNER JOIN	book_author_mapping b ON b.author_number = a.author_number
INNER JOIN	liked c ON c.book_number = b.book_number
INNER JOIN	book_author_mapping d ON d.book_number = c.liked_book_number
INNER JOIN	authors e ON e.author_number = d.author_number
INNER JOIN	books f on f.book_number = b.book_number
INNER JOIN	books g on g.book_number = c.liked_book_number

WHERE		a.author_number = ?

ORDER BY 	e.author_last_name, e.author_first_name
Query Parameter Value(s) -
Parameter #1(cf_sql_integer) = 3079

get_ads (Datasource=bookbrowse_com_new, Time=32ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:06.006
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=87ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:06.006
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone2

get_member_account_types (Datasource=bookbrowse_com_new, Time=24ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:06.006
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_book_image (Datasource=bookbrowse_com_new, Time=16ms, Records=1) in /root/website/actions/udfs.cfm @ 15:15:06.006
select 	f.edition_publish_dt "hardcover_publish_dt", f.edition_jacket_image "hardcover_jacket_image", 
            g.edition_publish_dt "paperback_publish_dt", g.edition_jacket_image "paperback_jacket_image"
    
    from   	books a
	left join editions f on a.book_number = f.book_number and f.edition_paperback_flag = 0
	left join editions g on a.book_number = g.book_number and g.edition_paperback_flag = 1
                    
    where 	a.book_number = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3757

get_member_account_types (Datasource=bookbrowse_com_new, Time=15ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:06.006
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_books_by_author_id (Datasource=bookbrowse_com_new, Time=48ms, Records=2) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:06.006
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2111
Parameter #2(CF_SQL_INTEGER) = 2111
Parameter #3(CF_SQL_INTEGER) = 2111

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=99ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:07.007
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 2111

get_books_by_author_id (Datasource=bookbrowse_com_new, Time=126ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:07.007
select	a.book_number, 
				a.book_title, 
				(CASE WHEN UPPER(LEFT(a.book_title, 2)) = 'A ' THEN SUBSTRING(a.book_title, 3, len(a.book_title) - 2) WHEN UPPER(LEFT(a.book_title, 3)) = 'AN ' THEN SUBSTRING(a.book_title, 4, len(a.book_title) - 3) WHEN UPPER(LEFT(a.book_title, 4)) = 'THE ' THEN SUBSTRING(a.book_title, 5, len(a.book_title) - 4) ELSE a.book_title END) "sort_book_title", 
				a.book_sub_title, 
				a.book_entry_dt, 
				a.book_short_summary, 
				a.book_jacket_info, 
                a.book_excerpt, 
                a.book_reading_guide,
				d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, 
				f.edition_publish_dt "hardcover_publish_dt", f.edition_number_of_pages "hardcover_number_of_pages", f.edition_isbn "hardcover_isbn", f.edition_isbn13 "hardcover_isbn13",f.edition_jacket_image "hardcover_jacket_image",
				g.edition_publish_dt "paperback_publish_dt", g.edition_number_of_pages "paperback_number_of_pages", g.edition_isbn "paperback_isbn", g.edition_isbn13 "paperback_isbn13",g.edition_jacket_image "paperback_jacket_image",
				i.author_info_biography, i.author_info_interview, i.author_info_image, i.author_info_url,
                (select count(c.book_number) as "author_bookcount" from book_author_mapping c where c.author_number = ?) + (select count(e.ezine_preview_number) as "author_bookcount" from ezine_previews e where e.ezine_preview_bb_author_link = ?) as "authorbookcount"
                
		    from books a
            inner join book_author_mapping e ON a.book_number = e.book_number
            inner join authors d ON e.author_number = d.author_number
            inner join author_info i ON d.author_number = i.author_number
            left outer join editions f ON a.book_number = f.book_number and f.edition_paperback_flag = 0
            left outer join editions g ON a.book_number = g.book_number and g.edition_paperback_flag = 1
                        
            where e.author_number = ?
            and a.book_number IN (select distinct b.book_number from categories a, category_book_mapping b where a.category_number = b.category_number and a.category_active_flag = 1)
			
            order by sort_book_title
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3319
Parameter #2(CF_SQL_INTEGER) = 3319
Parameter #3(CF_SQL_INTEGER) = 3319

get_author_by_author_id (Datasource=bookbrowse_com_new, Time=11ms, Records=1) in /root/website/queries/qry_get_books_by_author_id.cfm @ 15:15:07.007
select	d.author_number, d.author_first_name, d.author_middle_initial, d.author_last_name, d.author_pronunciation,
                CASE	WHEN datalength(d.author_middle_initial) > 0 
                        THEN d.author_first_name + ' ' + d.author_middle_initial + ' ' + d.author_last_name
                        ELSE d.author_first_name + ' ' + d.author_last_name
                        END AS "author_full_name",
				i.author_info_number, i.author_number, i.author_info_image, i.author_info_entry_dt,
                i.author_info_url, i.author_info_interview_summary, i.author_info_interview, i.author_info_biography, i.author_info_copyright_info
                		
        from 	authors d, author_info i
		
        where 	d.author_number = ?
        and 	d.author_number = i.author_number
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 3319

get_member_account_types (Datasource=bookbrowse_com_new, Time=11ms, Records=2) in /root/website/queries/qry_get_member_account_types.cfm @ 15:15:07.007
select member_account_type_number, member_account_type_name, member_account_type_charge, member_account_type_charge_frequency, member_account_type_postscript, member_account_type_months, member_account_type_stripe_lookup_key
from member_account_types
where member_account_type_number = (select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 12
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
or member_account_type_number =		(select top 1 member_account_type_number
									from member_account_types
									where member_account_type_months = 3
									and member_account_type_public = 1
									order by member_account_type_charge ASC)
									
order by member_account_type_sort_order ASC
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=16ms, Records=0) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:07.007
SELECT 	top 10 a.arc_number,arc_promo_text,
		b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
		(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
				(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
				 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
				 ELSE 0
				 END)
 			from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

FROM arcs a
INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

WHERE arc_closed_flag = 1
AND arc_obc_flag = 0
AND getdate() >= arc_on_ad_dt
AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1
and getdate() <= dateadd(day,1,a.arc_off_ad_dt)

ORDER BY NEWID()
get_arcs_for_ad (Datasource=bookbrowse_com_new, Time=35ms, Records=3) in /root/website/queries/qry_get_arcs_for_ad.cfm @ 15:15:07.007
SELECT 	top 3 a.arc_number,arc_promo_text,
			b.ezine_preview_number, b.ezine_preview_title, b.ezine_preview_subtitle, b.ezine_preview_jacket_image, b.ezine_preview_author, b.ezine_preview_publish_dt, 
			(select (CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,0))) AS numeric(12,0)))+
					(CASE WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 25 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 50 THEN 0.5
					 WHEN right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) > 50 AND right(CAST(AVG(CAST(arc_allocator_review_rating AS numeric(12,2))) AS numeric(12,2)),2) < 75 THEN -0.5
					 ELSE 0
					 END)
				from arc_allocator	where arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) AS arcrating

	FROM arcs a
	INNER JOIN ezine_previews b ON b.ezine_preview_number = a.ezine_preview_number

	WHERE arc_closed_flag = 1
	AND arc_obc_flag = 0
	AND getdate() >= arc_on_ad_dt
	AND (select count(*) from arc_allocator d where d.arc_number = a.arc_number and arc_allocator_review_approved_flag = 1) > 1

	ORDER BY a.arc_off_ad_dt DESC
get_ads (Datasource=bookbrowse_com_new, Time=18ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
	
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = adzone6

get_type (Datasource=bookbrowse_com_new, Time=23ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 1112

get_quotes (Datasource=bookbrowse_com_new, Time=25ms, Records=1) in /root/website/site/blocks/dsp_book_giveaway.cfm @ 15:15:07.007
select top 1 ezine_number, ezine_quote, ezine_quote_title
	    from ezines
	    where len(ezine_quote_title) > 1
	    order by newid()
get_free_newsletters (Datasource=bookbrowse_com_new, Time=0ms, Records=4, Cached Query) in /root/website/queries/qry_get_free_newsletters.cfm @ 15:15:07.007
SELECT 	*
    FROM 	free_newsletters
get_ads (Datasource=bookbrowse_com_new, Time=10ms, Records=0) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT		a.adid,	adweight
	FROM		adsystem a
	INNER JOIN 	ad_category_mapping b ON b.adid = a.adid
	WHERE		a.section = ?
	AND			a.active  = 1
	AND 		a.start_date <= GETDATE()
		 	AND a.adid NOT IN (?) 
	AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
            

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

get_ads (Datasource=bookbrowse_com_new, Time=5ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT	a.adid,	adweight
        FROM	adsystem a
        WHERE	a.section = ? 
        AND 	a.active  = 1 
        AND		a.start_date <= GETDATE()	
        		AND a.adid NOT IN (?) 
        AND (a.viewby LIKE '%n%' OR a.viewby = 'all')
        AND (select count(*) from ad_category_mapping where datalength(category_number) >= 1 and adid = a.adid) = 0
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = showcase_track
Parameter #2(CF_SQL_INTEGER) = 1112

get_type (Datasource=bookbrowse_com_new, Time=8ms, Records=1) in /root/website/adsystem/adsystem_mod.cfm @ 15:15:07.007
SELECT	a.start_date, a.adid, a.end_date, a.camp_views, a.image_name, a.alt_text, a.views, a.code, a.adsize
        FROM	adsystem a
        WHERE	a.adid = ?
Query Parameter Value(s) -
Parameter #1(CF_SQL_INTEGER) = 594


Scope Variables

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/root/website/author_interviews/full/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br, zstd, deflate
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=upgrade
HTTP_COOKIE=CFID=4105290; CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0; CFCLIENT_BOOKBROWSE=order%3Dp%23member%5Fnumber%3D0%23member%5Factive%5Fflag%3D0%23member%5Flogged%5Fin%5Fflag%3D0%23library%5Fuser%5Fflag%3D0%23view%3Dbooks%23; CFGLOBALS=urltoken%3DCFID%23%3D4105290%26CFTOKEN%23%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23lastvisit%3D%7Bts%20%272026%2D06%2D01%2015%3A15%3A06%27%7D%23hitcount%3D39%23timecreated%3D%7Bts%20%272026%2D06%2D01%2015%3A14%3A56%27%7D%23cftoken%3Da4ce03c981548101%2D2585C53E%2D0CEE%2D484A%2D0B6BB21457807FB0%23cfid%3D4105290%23
HTTP_HOST=dev.bookbrowse.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
LOCAL_ADDR=127.0.0.1
PATH_INFO=/author_number/3079/author/abdi-nor-iftin
PATH_TRANSLATED=/root/website/author_interviews/full/index.cfm
QUERY_STRING=
REMOTE_ADDR=127.0.0.1
REMOTE_HOST=127.0.0.1
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/author_interviews/full/index.cfm
SERVER_NAME=dev.bookbrowse.com
SERVER_PORT=8500
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=
WEB_SERVER_API=
Client Variables:
cfid=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
hitcount=46
lastvisit={ts '2026-06-01 15:15:07'}
library_user_flag=0
member_active_flag=0
member_logged_in_flag=0
member_number=0
order=p
timecreated={ts '2026-06-01 15:14:56'}
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
view=books
Cookie Variables:
CFCLIENT_BOOKBROWSE=order=p#member_number=0#member_active_flag=0#member_logged_in_flag=0#library_user_flag=0#view=books#
CFGLOBALS=urltoken=CFID#=4105290&CFTOKEN#=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#lastvisit={ts '2026-06-01 15:15:06'}#hitcount=39#timecreated={ts '2026-06-01 15:14:56'}#cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0#cfid=4105290#
CFID=4105290
CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
Session Variables:
cfid=4105290
cftoken=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
sessionid=BOOKBROWSE_4105290_a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
urltoken=CFID=4105290&CFTOKEN=a4ce03c981548101-2585C53E-0CEE-484A-0B6BB21457807FB0
URL Parameters:
author=abdi-nor-iftin
author_number=3079
Debug Rendering Time: 26 ms