/* 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