SELECT e2_book_project_id as projectid FROM e2_ordered_book_types WHERE isbn = '9781615795079\'Error - Exception in query /* BookDetail */ SELECT acc.Contact_ID, acc.Pen_Name, acc.Account_Site, acc.Subtitle, acc.PB_ISBN AS `ISBN`, acc.PB_Retail_Price AS `Price`, e2obt.final_page_count AS `Pages`, e2obt.Trim_Size AS `Dimensions`, acc.BISAC_Code_1_Description AS `Category 1`, acc.BISAC_Code_2_Description AS `Category 2`, acc.BISAC_Code_3_Description AS `Category 3`, acc.Book_Summary, Bio AS `Author Bio`, acc.Afterpress_Status, acc.Bookstore_Image_Available, acc.Author_Image_Available, acc.Contact_ID, acc.Bookstore_Active, acc.HC_ISBN, acc.HC_Retail_Price, acc.video_trailer_url, e2obt.publication_date, /* CASE WHEN CURDATE() <= e2obt.publication_date THEN 'No' ELSE 'Yes' END AS valid_publication_date */ CASE WHEN CURDATE() <= DATE_SUB(e2obt.publication_date, INTERVAL 1 DAY) THEN 'No' ELSE 'Yes' END AS valid_publication_date FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE isbn = '9781615795079\' AND acc.Bookstore_Active = 1 AND ( ( /* (acc.Imprint like 'Xulon Press' or acc.Imprint='' or acc.Imprint IS NULL) */ ( 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.Payment_Problem_Status NOT LIKE '%TERMINATED%' and acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' and acc.Payment_Problem_Status NOT LIKE '%TEST%') OR (acc.Payment_Problem_Status IS NULL) ) ) /*AND acc.short_run IS NULL*/ AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND e2obt.Date_Uploaded IS NOT NULL OR e2obt.bookstore_override = 1 )Error - Exception in query /* VideoDetail */ SELECT acc.video_trailer_url FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id INNER JOIN xulonpress.eorders ON e2obt.e2_book_project_id = eorders.projectid WHERE e2obt.isbn = '9781615795079\' AND ( ( /* (acc.Imprint like 'Xulon Press' or acc.Imprint='' or acc.Imprint IS NULL) */ ( 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.Payment_Problem_Status NOT LIKE '%TERMINATED%' and acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' and acc.Payment_Problem_Status NOT LIKE '%TEST%') OR (acc.Payment_Problem_Status IS NULL) ) ) AND acc.expanded_distribution LIKE 'No' AND acc.imprint_brand_id = 1 AND e2obt.Date_Uploaded IS NOT NULL OR e2obt.bookstore_override = 1 ) #AND eorders.PartNo LIKE 'FV%' AND eorders.qbglcode = 'Defer Rev Video Trailers' AND acc.video_trailer_url IS NOT NULL AND eorders.work_completed_date IS NOT NULL; Error - Exception in query SELECT acc.projectid, Bookstore_Image_Available, PB_ISBN, HC_ISBN FROM accounts acc INNER JOIN e2_ordered_book_types e2obt ON acc.projectid = e2obt.e2_book_project_id WHERE acc.Contact_ID = '' AND e2obt.ISBN IS NOT NULL AND ISBN != '9781615795079\' AND acc.Bookstore_Active = 1 AND ( ( acc.Payment_Problem_Status NOT LIKE '%TERMINATED%' AND acc.Payment_Problem_Status NOT LIKE '%CANCELLED%' AND acc.Payment_Problem_Status NOT LIKE '%TEST%' ) OR ( acc.Payment_Problem_Status IS NULL ) ) AND e2obt.Date_Uploaded IS NOT NULL GROUP BY acc.projectid ORDER BY e2obt.Date_Uploaded DESCError - Exception in query SELECT gdusa_award FROM e2_ordered_book_types WHERE isbn = '9781615795079\'Error - Exception in query