/* BookQuery 66.248.200.2 */ SELECT acc.Account_Site , acc.Pen_Name , acc.Bookstore_Image_Available , acc.PB_ISBN , acc.HC_ISBN , e2obt.bookstore_override , acc.date_uploaded , e2obt.retail_price , e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE e2obt.retail_price > 0 AND( ( acc.Payment_Problem_Status NOT LIKE '%TERMINATED%' AND acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' AND acc.Payment_Problem_Status NOT LIKE '%TOM PROJECT%' AND acc.Payment_Problem_Status NOT LIKE '%ON HOLD%' AND acc.Payment_Problem_Status NOT LIKE '%TEST PROJECT%' /*AND acc.Payment_Problem_Status NOT LIKE '%EDITORIAL%'*/ AND acc.Payment_Problem_Status NOT LIKE '%ANTHOLOGY PROJECT%' ) OR( acc.Payment_Problem_Status IS NULL ) ) AND DATE(e2obt.date_uploaded) IS NOT NULL #AND DATE(e2obt.date_uploaded) <= DATE_SUB(CURDATE() , INTERVAL 3 DAY) AND( ( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program_Upgrade LIKE '%Best%' OR acc.Program_Upgrade LIKE '%Elite%' OR acc.Program_Upgrade LIKE '%Debut%' OR acc.Program_Upgrade LIKE '%Tribute%' OR acc.Program_Upgrade LIKE '%Showcase%' OR acc.Program_Upgrade LIKE '%Premier%' OR acc.Bookstore_Page_Order_Recd IS NOT NULL ) ) OR( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program LIKE '%Premium%' OR acc.Program LIKE '%Best%' OR acc.Program LIKE '%Elite%' OR acc.Program LIKE '%Tribute%' OR acc.Program LIKE '%Debut%' OR acc.Program LIKE '%Showcase%' OR acc.Program LIKE '%Premier%' OR acc.Program LIKE '%Editor%Choice%' ) ) OR( acc.Program_Order_Date <= '2007-12-31' ) ) AND acc.Bookstore_Active = 1 /* AND ( acc.Imprint LIKE 'Xulon Press' OR acc.Imprint LIKE 'Renovate Publishing' OR acc.Imprint = '' OR acc.Imprint IS NULL ) */ AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) /*AND acc.short_run IS NULL*/ AND acc.Account_Site = 'Al's Aussie Adventures A to Zed' AND (e2obt.binding != 'EB' AND e2obt.binding != 'AB') ORDER BY acc.Account_Site = 'Al's Aussie Adventures A to Zed' DESC, acc.projectid ASC, e2obt.binding DESC, e2obt.date_uploaded DESC Error - Exception in query /* BookQuery 66.248.200.2 */ SELECT acc.Account_Site , acc.Pen_Name , acc.Bookstore_Image_Available , acc.PB_ISBN , acc.HC_ISBN , e2obt.bookstore_override , acc.date_uploaded , e2obt.retail_price , e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE e2obt.retail_price > 0 AND( ( acc.Payment_Problem_Status NOT LIKE '%TERMINATED%' AND acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' AND acc.Payment_Problem_Status NOT LIKE '%TOM PROJECT%' AND acc.Payment_Problem_Status NOT LIKE '%ON HOLD%' AND acc.Payment_Problem_Status NOT LIKE '%TEST PROJECT%' /*AND acc.Payment_Problem_Status NOT LIKE '%EDITORIAL%'*/ AND acc.Payment_Problem_Status NOT LIKE '%ANTHOLOGY PROJECT%' ) OR( acc.Payment_Problem_Status IS NULL ) ) AND DATE(e2obt.date_uploaded) IS NOT NULL #AND DATE(e2obt.date_uploaded) <= DATE_SUB(CURDATE() , INTERVAL 3 DAY) AND( ( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program_Upgrade LIKE '%Best%' OR acc.Program_Upgrade LIKE '%Elite%' OR acc.Program_Upgrade LIKE '%Debut%' OR acc.Program_Upgrade LIKE '%Tribute%' OR acc.Program_Upgrade LIKE '%Showcase%' OR acc.Program_Upgrade LIKE '%Premier%' OR acc.Bookstore_Page_Order_Recd IS NOT NULL ) ) OR( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program LIKE '%Premium%' OR acc.Program LIKE '%Best%' OR acc.Program LIKE '%Elite%' OR acc.Program LIKE '%Tribute%' OR acc.Program LIKE '%Debut%' OR acc.Program LIKE '%Showcase%' OR acc.Program LIKE '%Premier%' OR acc.Program LIKE '%Editor%Choice%' ) ) OR( acc.Program_Order_Date <= '2007-12-31' ) ) AND acc.Bookstore_Active = 1 /* AND ( acc.Imprint LIKE 'Xulon Press' OR acc.Imprint LIKE 'Renovate Publishing' OR acc.Imprint = '' OR acc.Imprint IS NULL ) */ AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) /*AND acc.short_run IS NULL*/ AND MATCH(acc.Account_Site) AGAINST('+(Al's*)+(Aussie*)+(Adventures*)+(A*)+(to*)+(Zed*)') AND (e2obt.binding != 'EB' AND e2obt.binding != 'AB') ORDER BY MATCH(acc.Account_Site) AGAINST('+(Al's*)+(Aussie*)+(Adventures*)+(A*)+(to*)+(Zed*)') DESC, acc.projectid ASC, e2obt.binding DESC, e2obt.date_uploaded DESC Error - Exception in query SELECT acc.Account_Site, acc.Pen_Name, acc.Bookstore_Image_Available, acc.PB_ISBN, acc.HC_ISBN, e2obt.bookstore_override, e2obt.date_uploaded, e2obt.retail_price, e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id #INNER JOIN e2_ordered_book_types e2obt ON acc.PB_ISBN = e2obt.isbn WHERE e2obt.bookstore_override = 1 AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) AND (acc.Account_Site like '%Al's%' AND acc.Account_Site like '%Aussie%' AND acc.Account_Site like '%Adventures%' AND acc.Account_Site like '%A%' AND acc.Account_Site like '%to%' AND acc.Account_Site like '%Zed%') ORDER BY date_uploaded DESCError - Exception in query /* BookQuery 66.248.200.2 */ SELECT acc.Account_Site , acc.Pen_Name , acc.Bookstore_Image_Available , acc.PB_ISBN , acc.HC_ISBN , e2obt.bookstore_override , acc.date_uploaded , e2obt.retail_price , e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE e2obt.retail_price > 0 AND( ( acc.Payment_Problem_Status NOT LIKE '%TERMINATED%' AND acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' AND acc.Payment_Problem_Status NOT LIKE '%TOM PROJECT%' AND acc.Payment_Problem_Status NOT LIKE '%ON HOLD%' AND acc.Payment_Problem_Status NOT LIKE '%TEST PROJECT%' /*AND acc.Payment_Problem_Status NOT LIKE '%EDITORIAL%'*/ AND acc.Payment_Problem_Status NOT LIKE '%ANTHOLOGY PROJECT%' ) OR( acc.Payment_Problem_Status IS NULL ) ) AND DATE(e2obt.date_uploaded) IS NOT NULL #AND DATE(e2obt.date_uploaded) <= DATE_SUB(CURDATE() , INTERVAL 3 DAY) AND( ( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program_Upgrade LIKE '%Best%' OR acc.Program_Upgrade LIKE '%Elite%' OR acc.Program_Upgrade LIKE '%Debut%' OR acc.Program_Upgrade LIKE '%Tribute%' OR acc.Program_Upgrade LIKE '%Showcase%' OR acc.Program_Upgrade LIKE '%Premier%' OR acc.Bookstore_Page_Order_Recd IS NOT NULL ) ) OR( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program LIKE '%Premium%' OR acc.Program LIKE '%Best%' OR acc.Program LIKE '%Elite%' OR acc.Program LIKE '%Tribute%' OR acc.Program LIKE '%Debut%' OR acc.Program LIKE '%Showcase%' OR acc.Program LIKE '%Premier%' OR acc.Program LIKE '%Editor%Choice%' ) ) OR( acc.Program_Order_Date <= '2007-12-31' ) ) AND acc.Bookstore_Active = 1 /* AND ( acc.Imprint LIKE 'Xulon Press' OR acc.Imprint LIKE 'Renovate Publishing' OR acc.Imprint = '' OR acc.Imprint IS NULL ) */ AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) /*AND acc.short_run IS NULL*/ AND acc.Account_Site = 'Al's Aussie Adventures A to Zed' AND (e2obt.binding != 'EB' AND e2obt.binding != 'AB') ORDER BY acc.Account_Site = 'Al's Aussie Adventures A to Zed' DESC, acc.projectid ASC, e2obt.binding DESC, e2obt.date_uploaded DESC LIMIT 0,40Error - Exception in query /* BookQuery 66.248.200.2 */ SELECT acc.Account_Site , acc.Pen_Name , acc.Bookstore_Image_Available , acc.PB_ISBN , acc.HC_ISBN , e2obt.bookstore_override , acc.date_uploaded , e2obt.retail_price , e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE e2obt.retail_price > 0 AND( ( acc.Payment_Problem_Status NOT LIKE '%TERMINATED%' AND acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' AND acc.Payment_Problem_Status NOT LIKE '%TOM PROJECT%' AND acc.Payment_Problem_Status NOT LIKE '%ON HOLD%' AND acc.Payment_Problem_Status NOT LIKE '%TEST PROJECT%' /*AND acc.Payment_Problem_Status NOT LIKE '%EDITORIAL%'*/ AND acc.Payment_Problem_Status NOT LIKE '%ANTHOLOGY PROJECT%' ) OR( acc.Payment_Problem_Status IS NULL ) ) AND DATE(e2obt.date_uploaded) IS NOT NULL #AND DATE(e2obt.date_uploaded) <= DATE_SUB(CURDATE() , INTERVAL 3 DAY) AND( ( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program_Upgrade LIKE '%Best%' OR acc.Program_Upgrade LIKE '%Elite%' OR acc.Program_Upgrade LIKE '%Debut%' OR acc.Program_Upgrade LIKE '%Tribute%' OR acc.Program_Upgrade LIKE '%Showcase%' OR acc.Program_Upgrade LIKE '%Premier%' OR acc.Bookstore_Page_Order_Recd IS NOT NULL ) ) OR( acc.Program_Order_Date >= '2008-01-01' AND( acc.Program LIKE '%Premium%' OR acc.Program LIKE '%Best%' OR acc.Program LIKE '%Elite%' OR acc.Program LIKE '%Tribute%' OR acc.Program LIKE '%Debut%' OR acc.Program LIKE '%Showcase%' OR acc.Program LIKE '%Premier%' OR acc.Program LIKE '%Editor%Choice%' ) ) OR( acc.Program_Order_Date <= '2007-12-31' ) ) AND acc.Bookstore_Active = 1 /* AND ( acc.Imprint LIKE 'Xulon Press' OR acc.Imprint LIKE 'Renovate Publishing' OR acc.Imprint = '' OR acc.Imprint IS NULL ) */ AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) /*AND acc.short_run IS NULL*/ AND MATCH(acc.Account_Site) AGAINST('+(Al's*)+(Aussie*)+(Adventures*)+(A*)+(to*)+(Zed*)') AND (e2obt.binding != 'EB' AND e2obt.binding != 'AB') ORDER BY MATCH(acc.Account_Site) AGAINST('+(Al's*)+(Aussie*)+(Adventures*)+(A*)+(to*)+(Zed*)') DESC, acc.projectid ASC, e2obt.binding DESC, e2obt.date_uploaded DESC LIMIT 0,40Error - Exception in query SELECT acc.Account_Site, acc.Pen_Name, acc.Bookstore_Image_Available, acc.PB_ISBN, acc.HC_ISBN, e2obt.bookstore_override, e2obt.date_uploaded, e2obt.retail_price, e2obt.binding FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id #INNER JOIN e2_ordered_book_types e2obt ON acc.PB_ISBN = e2obt.isbn WHERE e2obt.bookstore_override = 1 AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND ( acc.Imprint NOT LIKE 'Crown Oak%' AND acc.Imprint NOT LIKE 'Townhall%' AND acc.Imprint NOT LIKE 'Evangelical Press%' OR acc.Imprint = '' OR acc.Imprint IS NULL) AND (acc.Account_Site like '%Al's%' AND acc.Account_Site like '%Aussie%' AND acc.Account_Site like '%Adventures%' AND acc.Account_Site like '%A%' AND acc.Account_Site like '%to%' AND acc.Account_Site like '%Zed%') ORDER BY date_uploaded DESC LIMIT 0,40Error - Exception in query Christian Author Bookstore - Xulon Press Publishing

Search By Book Title

No results found matching your criteria.

Search By Price Range

Select the price range for better search

Search by Topic

Browse By New Releases