SELECT *, Rec_Price + ((1-Rec_Check7)*0.4*Rec_Price) - (Rec_Price * Rec_Discount/100) AS finalprice FROM records WHERE Rec_Page_ID = 293 AND Rec_Page_Content = 0 AND Rec_Title <> '' AND Rec_Active = 0 AND Rec_Check4=0 AND Rec_Discount<=0 Order by Rec_Order ASC, Rec_DateStart Desc